Add data source mysql 8+

SuiteCRM Forum - English Language SuiteCRM Analytics
1

Hello

I’m trying to add MySQL v8 as data source

image
image942×772 35.8 KB

But it seems like support only 5.7?

in tomcat logs I found
rom Pool
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

and directory tomcat/lib has mysql-connector-java-5.1.17.jar

so is it impossible to adding support MySQL 8+
In this directory, I download the newest mysql-java connector v 8.0.24
but I’m not sure where I need to define a new driver?

Is anybody try to connect MySQL 8+?

also even though installing and setting data-integration was completely successful but in WEB analityc it seems like no data in dashboards…

image
image1888×845 33.6 KB

2

Hey there! We don’t officially support MySQL 8 just yet but we can still take a look. Can you run a dashboard and send us the tomcat/logs/catalina.out?

Thanks

3

Hi

Sorry for a long answer
Maybe my log can help

SEVERE [http-nio-8080-exec-8] com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to response: 501
 javax.ws.rs.WebApplicationException: pt.webdetails.cda.dataaccess.QueryException: Unknown connection
        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:169)
        at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:140)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
        at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
        at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
        at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)


Caused by: pt.webdetails.cda.connections.InvalidConnectionException: pt.webdetails.cda.connections.sql.JndiConnection: Found SQLException: [ java.sql.SQLException ] - PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory ob>
        at pt.webdetails.cda.connections.sql.JndiConnection.getInitializedConnectionProvider(JndiConnection.java:68)
        at pt.webdetails.cda.dataaccess.SqlDataAccess.getDataFactory(SqlDataAccess.java:62)
        at pt.webdetails.cda.dataaccess.PREDataAccess.getDataFactory(PREDataAccess.java:65)
        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:107)
        ... 100 more
Caused by: java.sql.SQLException: PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory object for jndi name SuiteCRMAnalytics for reason Cannot create PoolableConnectionFactory (Unknown initial character set index '255' re>
        at org.pentaho.reporting.platform.plugin.connection.PentahoJndiDatasourceConnectionProvider.createConnection(PentahoJndiDatasourceConnectionProvider.java:122)
        at pt.webdetails.cda.connections.sql.JndiConnection.getInitializedConnectionProvider(JndiConnection.java:63)
        ... 103 more

23-Apr-2021 13:40:18.949 SEVERE [http-nio-8080-exec-1] com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to response: 501
 javax.ws.rs.WebApplicationException: pt.webdetails.cda.dataaccess.QueryException: Unknown connection
        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:169)
        at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:140)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)


Caused by: pt.webdetails.cda.connections.InvalidConnectionException: pt.webdetails.cda.connections.sql.JndiConnection: Found SQLException: [ java.sql.SQLException ] - PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory ob>
        at pt.webdetails.cda.connections.sql.JndiConnection.getInitializedConnectionProvider(JndiConnection.java:68)
        at pt.webdetails.cda.dataaccess.SqlDataAccess.getDataFactory(SqlDataAccess.java:62)
        at pt.webdetails.cda.dataaccess.PREDataAccess.getDataFactory(PREDataAccess.java:65)
        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:107)
        ... 100 more
Caused by: java.sql.SQLException: PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory object for jndi name SuiteCRMAnalytics for reason Cannot create PoolableConnectionFactory (Unknown initial character set index '255' re>
        at org.pentaho.reporting.platform.plugin.connection.PentahoJndiDatasourceConnectionProvider.createConnection(PentahoJndiDatasourceConnectionProvider.java:122)
        at pt.webdetails.cda.connections.sql.JndiConnection.getInitializedConnectionProvider(JndiConnection.java:63)
        ... 103 more

23-Apr-2021 13:40:18.949 SEVERE [http-nio-8080-exec-10] com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to response: 501
 javax.ws.rs.WebApplicationException: pt.webdetails.cda.dataaccess.QueryException: Unknown connection
        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:169)
        at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:140)
        at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)


Caused by: pt.webdetails.cda.connections.InvalidConnectionException: pt.webdetails.cda.connections.sql.JndiConnection: Found SQLException: [ java.sql.SQLException ] - PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory ob>
        at pt.webdetails.cda.connections.sql.JndiConnection.getInitializedConnectionProvider(JndiConnection.java:68)
        at pt.webdetails.cda.dataaccess.SqlDataAccess.getDataFactory(SqlDataAccess.java:62)
        at pt.webdetails.cda.dataaccess.PREDataAccess.getDataFactory(PREDataAccess.java:65)
        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:107)
        ... 99 more
Caused by: java.sql.SQLException: PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory object for jndi name SuiteCRMAnalytics for reason Cannot create PoolableConnectionFactory (Unknown initial character set index '255' re>
        at org.pentaho.reporting.platform.plugin.connection.PentahoJndiDatasourceConnectionProvider.createConnection(PentahoJndiDatasourceConnectionProvider.java:122)
        at pt.webdetails.cda.connections.sql.JndiConnection.getInitializedConnectionProvider(JndiConnection.java:63)
        ... 102 more

23-Apr-2021 13:40:18.950 SEVERE [http-nio-8080-exec-9] com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to response: 501
 javax.ws.rs.WebApplicationException: pt.webdetails.cda.dataaccess.QueryException: Unknown connection
        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:169)
        at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:140)
        at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
4