Profile

Ok, I have solved. It was not a problem of a connector, I apologize to all you. The fact is that the on the new database Mysql 8 we changed the password of the user that executes query. I changed it on the file kettle.proporties on my pc, but not on the server. On the server there is this file:  / ...

Really now I've seen that also using the driver: mysql-connector-java-5.1.49.jar The connection between the pentaho server and Mysql 8 works. That is I can create a datasource and test that the connection works. Only the schedulations of jobs that execute query on Mysql 8 fail. The execution of the ...

Hi Andrew,                      "I've been connecting to MySQL 8 databases for the past three years.  I just confirmed it works in 9.2 and 9.3" this is good news, so there is hope :-) But are you using the Mysql driver or the generic driver? And the MySQL user uses the protocol "mysql_native_password" ...

Hi, is there an official procedure to update Pentaho 9.2 to Pentaho 9.3? I mean the Pentaho CE. Thank you very much Claudio B. ------------------------------ Claudio Battaglino ------------------------------

Thank you Andrew for your reply. I didn't know that xactions were deprecated. So which is the right way to schedule jobs on a Pentaho server 9.2? Clearing the cache doesn't solve the problem and I have only one MySQL-connector-java-8.0.29.jar. in the tomcat/lib directory. I've tried to use a generic ...

Hi, Id like to configure LDAP authentication on Pentahon Server 9.2 CE but I cant see the Authentication menu. Should I enable it somewhere?       Thank you   Claudio

Hi, I have a dashboard that has an Olap selector that drives the content of some charts. These charts use as datasource a query done with mdx over mondrianJndi. In this case the condition is: WHERE $(academicYearFilterParameter)   Now, in the same dashboard, I have a table that uses as datasource a query ...