You are not logged in.
Pages: 1
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
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
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
Pages: 1