#1 2020-06-16 15:24:15

zuera
Member
Registered: 2020-06-16

Error connecting to database server

Hi!

I'm trying to install ReportServer manually on a virtual machine. I installed and configured Centos 7, Java, Apache Tomcat, Mysql... and finally ReportServer. I also used the sql scripts to create ReportServer database. Everything looked ok until I tried to access ReportServer from the web browser, and I got the following error message:

   _____                       _    _____                         
|  __ \                     | |  / ____|                         
| |__) |___ _ __   ___  _ __| |_| (___   ___ _ ____   _____ _ __
|  _  // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \  __/ |_) | (_) | |  | |_ ____) |  __/ |   \ V /  __/ |   
|_|  \_\___| .__/ \___/|_|   \__|_____/ \___|_|    \_/ \___|_|   
            | |                                                   
            |_|                                                   

Version: RS3.1.1-6020 2020-01-28-16-18-55
Code Version: 2020-01-28-16-14-09
Java Version: Oracle Corporation OpenJDK 64-Bit Server VM 25.252-b09 (1.8)
VM Args: -Djava.util.logging.config.file=/opt/tomcat/latest/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.security.egd=file:///dev/urandom -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Xms512M -Xmx1024M -XX:+UseParallelGC -Dignore.endorsed.dirs= -Dcatalina.base=/opt/tomcat/latest -Dcatalina.home=/opt/tomcat/latest -Djava.io.tmpdir=/opt/tomcat/latest/temp
rs.configdir: Not Configured

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

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


I know that apparently the issue is related to the database connection, but I can connect to the database via CLI without any trouble using the username and password defined on persitance.properties file. I have tried creating specific usernames for it, but the error is the same. I also checked Catalina.out file to see if there is additional information about why it's failing, but basically the content is the same.

Any idea of what could be the issue, or where to continue looking on?

Best regards

P.S. I saw there is a thread of a user with a similar error, but he was using docker, so I don't think the situation applies here (besides, he didn't seem to find a solution either).

Offline

#2 2020-06-17 13:32:56

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Error connecting to database server

Hi zuera,

what version of mysql exactly are you trying to connect to?

Did you check the tomcat logs for eventually more information ?

Regards,
Eduardo

Offline

#3 2020-07-03 07:57:34

zuera
Member
Registered: 2020-06-16

Re: Error connecting to database server

eduardo wrote:

Hi zuera,

what version of mysql exactly are you trying to connect to?

Did you check the tomcat logs for eventually more information ?

Regards,
Eduardo

Hi Eduardo,

Sorry for the delay replying. Yes I checked them, but they didn't say anything relevant. In any case, we managed to solve it by changing the jdbc driver to a different version.

Best regards

Last edited by zuera (2020-07-03 07:57:46)

Offline

Board footer

Powered by FluxBB