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

hMobile
Member
Registered: 2018-03-27
Posts: 26

Something goes wrong manual install Linux

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

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 719

Re: Something goes wrong manual install Linux

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

Offline

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

hMobile
Member
Registered: 2018-03-27
Posts: 26

Re: Something goes wrong manual install Linux

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

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 719

Re: Something goes wrong manual install Linux

Hi Rom,

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

Regards,
Eduardo

Offline

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

hMobile
Member
Registered: 2018-03-27
Posts: 26

Re: Something goes wrong manual install Linux

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

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 719

Re: Something goes wrong manual install Linux

Hi Rom,

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

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

Regards,
Eduardo

Offline

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

hMobile
Member
Registered: 2018-03-27
Posts: 26

Re: Something goes wrong manual install Linux

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

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 719

Re: Something goes wrong manual install Linux

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

Offline

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

hMobile
Member
Registered: 2018-03-27
Posts: 26

Re: Something goes wrong manual install Linux

Write down!

Thanks,

Cheers,

Rom

Offline

Board footer

Powered by FluxBB