ReportServer Forum

eike.welk

Member

Registered: 2017-10-12

Problems connecting to MySQL

I have problems to connect to a MySQL database.

I have installed Report Server Enterprise (64 bit) with the installer from Bitnami.

If I test the connection to a MySQL database I get the following error:

net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc:mysql://192.168.1.52:3306/dw_synjob with user: etl. java.sql.SQLException: Unknown system variable 'language'
<br>    at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:57)
...
...

What am I doing wrong?

jalbrecht

Administrator

Registered: 2016-10-21

Re: Problems connecting to MySQL

Hi Eike,

which versions are you on ?

- RS supposingly  3.0.2 ?
- Mysql Server ?
- for the records: check mysql connector version in \Bitnami\reportserverenterprise-3.0.2-6\apache-tomcat\webapps\reportserver\WEB-INF\lib folder (should be mysql-connector-java-5.1.38)

The bug is new to us and points to a mysql error in mysql-connector in conjunction woth older mysql database versions. See https://bugs.mysql.com/bug.php?id=77665.

Looking forward to hearing from you.

wbr jan

eike.welk

Member

Registered: 2017-10-12

Re: Problems connecting to MySQL

Hello Jan!

Thank you very much for your fast replies.

The MySQL installation might indeed be fairly old.

Eike.