ReportServer Forum

vaibhav

Member

Registered: 2018-12-31

Connection Test: Failed (Could not create connection to database serve

Hi,

This is new setup. I am trying to start ReportServer, facing issue with connection.

Error Message:
Connection Test: Failed (Could not create connection to database server)

Connection:
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.MySQLDialect (OK)
hibernate.connection.driver_class: com.mysql.jdbc.Driver (OK)
hibernate.connection.url: jdbc:mysql://localhost:3306/reportserver (OK)
hibernate.connection.username: root
hibernate.connection.password: ********
hibernate.default_schema:

Setting
JAVA_OPTS="$JAVA_OPTS -Djava.awt.headless=true -Xmx4g  -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8"

persistence.properties
# MySQL
hibernate.dialect=net.datenwerke.rs.utils.hibernate.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://127.0.0.1:3306/reportserver?useSSL=true

MySQL Version
docker mysql with latest tag as 5.7.* was giving some error
MySQL on docker is running fine , able to connect using MySQL Workforce and able to create table and add row, so no issue with permission

Last edited by vaibhav (2018-12-31 03:57:16)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Connection Test: Failed (Could not create connection to database serve

Hi vaibhab,

could you please try with a 5.7 installation? What problems were you having with this?

How did you install reportserver? Manually or using bitnami ? Which reportserver version exactly do you have (rsversion.properties)

Further, please post the complete error stack.

Regards,
Eduardo

vaibhav

Member

Registered: 2018-12-31

Re: Connection Test: Failed (Could not create connection to database serve

I have tried with a local installation, it works fine.
What i am trying to do is create a docker image for Reportserver community version and and mysql and then try to connect them. Mysql version is 5.7 and reportserver version is the ReportServer 3.0.5. When I perform the same steps as the local installation,  it seems to have some connectivity issue. My docker images seem to be able to work properly. Do you have any documentation on installation on docker images

I am performing a manual installation here. Please direct me to the file where i would get the error stack, i would post the same,

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Connection Test: Failed (Could not create connection to database serve

Hi vaibhav,

were you able to create the reportserver docker image?

The logs should be in your tomcat installation inside the logs directory. There you should check for any errors.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Connection Test: Failed (Could not create connection to database serve

Hi,

good news! We are working on official docker images for reportserver. We are doing this together with Bitnami, similar as the Bitnami installers you already know.

More details can be found here: https://forum.reportserver.net/viewtopic.php?pid=6050

Feedback would be great

Regards,
Eduardo