Something goes wrong manual install Linux

hMobile · 2018-04-05 12:25:04

Hi,

Hope this is no a duplicate post...

Installing manually in a new Debian (out of net install), added tomcat8, mysql-server, and the zip from ReportServer.

Follow the instructions... and...

*****************
ReportServer encountered an error while validating its environment. Please check the server log files for additional information.
_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|

Version: RS3.0.3-6002 2017-12-09-12-26-19
Code Version: 2017-12-08-10-49-15
Java Version: Oracle Corporation OpenJDK 64-Bit Server VM 25.162-b12 (1.8)
VM Args: -Djava.util.logging.config.file=/var/lib/tomcat8/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.awt.headless=true -XX:+UseConcMarkSweepGC -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dcatalina.base=/var/lib/tomcat8 -Dcatalina.home=/usr/share/tomcat8 -Djava.io.tmpdir=/tmp/tomcat8-tomcat8-tmp
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: root
hibernate.connection.password: *************
hibernate.default_schema:

Connection Test: Failed (Access denied for user 'root'@'localhost')
*************

So almost everything is ok, but Hibernate can't connect. Of course I set a pass for 'root'@'localhost' and I wrote it to persistence.properties and restert tomcat.

So I'm doing something wrong...

(como decimos en español: seguro que estoy pisando el cable)
(as we say in Spanish: sure I'm stepping on the cable)

Thanks in advance to all the people in the forum!

Rom

eduardo · 2018-04-05 12:43:49

Hola Rom,

which persistence.properties file are you using? where is it located? Looking at your logs it should be in WEB-INF/classes/persistence.properties
Is this correct? and is your user root and password there?

If yes, I think it is a mysql issue. Do you have mysql installed in another machine as reportserver? If yes: did you allow remote access for the root user root: https://stackoverflow.com/questions/112 … -all-hosts

Saludos,
Eduardo

hMobile · 2018-04-05 13:02:29

Hi Eduardo,

Yes it is in the standard path: /var/lib/tomcat8/webapps/reportserver/WEB-INF/classes/persistence.properties and has uncommented lines for:

hibernate.connection.username=root
hibernate.connection.password='secretosecreto' <-- (Is there need for single quotes?)

and three lines for mysql connection.

Mysql is in the same host, so 'root'@'localhost' must work... but...

Thanks!

Rom

eduardo · 2018-04-05 13:11:42

Hi Rom,

no, no single quotes, so:
hibernate.connection.password=secretosecreto

Regards,
Eduardo

hMobile · 2018-04-05 13:15:22

Upsss! the problem is in the mysql config... But where?

If I use a non root user in Linux and try to gain access:

mysql -u root -p
type in the pass
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

... working to find it.

Rom

eduardo · 2018-04-05 13:31:10

Hi Rom,

yes, you have to be able to connect to mysql first

After that, you can write the user and password in the persistence.properties (without quotes!)

Regards,
Eduardo

hMobile · 2018-04-05 13:54:14

Eduardo,

First of all, thanks for your support.

SOLVED!!!

I don't know the real reason, maybe some security restrictions...

Solution:

Open mysql as Linux root,

CREATE USER 'reportserver'@'localhost';
SET PASSWORD FOR 'reportserver'@'localhost' = PASSWORD('secretosecreto'); <-- Here YES, single quotes
GRANT ALL PRIVILEGES ON reportserver.* TO 'reportserver'@'localhost';
FLUSH PRIVILEGES;

(exit)

Edit /var/lib/tomcat8/webapps/reportserver/WEB-INF/classes/persistence.properties:

hibernate.connection.username=reportserver
hibernate.connection.password=secretosecreto

# service tomcat8 restart

And that's all folks!

No so hard dude!

Now starting next battle...

Rom

eduardo · 2018-04-05 14:10:18

Hi Rom,

I'm glad it worked.
Please take note that the WEB-INF/classes/persistence.properties file will be overriden every time you install a new version of reportserver. For testing environment this is no issue, but for production I would recommend you to install the external configuration directory: https://reportserver.net/en/guides/conf … ion-Files/

"By default the external configuration files are located in WEB-INF/classes and thus within the web-apps folder. It is advisable to move these files to an external location as this allows easier upgrades to future versions. For a detailed description of how to use an external configuration dir see Chapter 5."

Here the details:
https://reportserver.net/en/guides/conf … Configdir/

And here the details on manually installing on ubuntu: https://reportserver.net/en/tutorials/i … -practice/

As I said, for testing you can use the default configuration directory, but for a "real" installation I would recommend to install the external configuration dir.

Regards,
Eduardo

hMobile · 2018-04-05 14:12:34

Write down!

Thanks,

Cheers,

Rom

ReportServer Forum

#1 2018-04-05 12:25:04

Something goes wrong manual install Linux

#2 2018-04-05 12:43:49

Re: Something goes wrong manual install Linux

#3 2018-04-05 13:02:29

Re: Something goes wrong manual install Linux

#4 2018-04-05 13:11:42

Re: Something goes wrong manual install Linux

#5 2018-04-05 13:15:22

Re: Something goes wrong manual install Linux

#6 2018-04-05 13:31:10

Re: Something goes wrong manual install Linux

#7 2018-04-05 13:54:14

Re: Something goes wrong manual install Linux

#8 2018-04-05 14:10:18

Re: Something goes wrong manual install Linux

#9 2018-04-05 14:12:34

Re: Something goes wrong manual install Linux

Board footer