ReportServer Forum

gaeilgeganeagla

Member

Registered: 2017-03-29

Issue with first time reportserver install

I have followed the guide on manual installing on ubuntu and have gotten to the last section where I run the
tail -f /var/log/tomcat7/reportserver.2017-03-29.log

It just seems to lag and doesn't do anything after the schema has been validated.

Mar 29, 2017 9:10:54 AM net.datenwerke.rs.EnvironmentValidator startup
INFO:

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

Version: RS3.0.2-5855 2016-05-29-17-55-24
Code Version: 2016-05-29-17-55-24
Java Version: Oracle Corporation OpenJDK 64-Bit Server VM 24.121-b00 (1.7)
VM Args: -Djava.util.logging.config.file=/var/lib/tomcat7/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.awt.headless=true -Xmx4g -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/opt/reportserver -Djava.endorsed.dirs=/usr/share/tomcat7/endorsed -Dcatalina.base=/var/lib/tomcat7 -Dcatalina.home=/usr/share/tomcat7 -Djava.io.tmpdir=/tmp/tomcat7-tomcat7-tmp
rs.configdir: /opt/reportserver (OK)

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.PostgreSQLDialect (OK)
hibernate.connection.driver_class: org.postgresql.Driver (OK)
hibernate.connection.url: jdbc:postgresql://localhost/reportserver (OK)
hibernate.connection.username: reportserver
hibernate.connection.password: **********
hibernate.default_schema:

Connection Test: OK
Schema Version: RS3.0-8

Mar 29, 2017 9:10:54 AM net.datenwerke.rs.EnvironmentValidator startup
INFO: Validating database schema...
Mar 29, 2017 9:11:25 AM net.datenwerke.rs.EnvironmentValidator hibernateValidateSchema
INFO: Schema validation completed
packet_write_wait: Connection to MYIPADDRESS port 22: Broken pipe

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Issue with first time reportserver install

Hi gaeilgeganeagla,

have you restarted your tomcat instance? the connection to your address port 22 seems to be broken. Where did you set this port ?
Also, I noticed your are using openjdk. Could you try with the standard jdk ? Did you set AUTHBIND?
Are all the steps in the guide working, only reportserver is not starting?

Could you try with the Linux Bitnami installer?

Cheers,
Eduardo

gaeilgeganeagla

Member

Registered: 2017-03-29

Re: Issue with first time reportserver install

Hi gaeilgeganeagla,

have you restarted your tomcat instance? the connection to your address port 22 seems to be broken. Where did you set this port ?
Also, I noticed your are using openjdk. Could you try with the standard jdk ? Did you set AUTHBIND?
Are all the steps in the guide working, only reportserver is not starting?

Could you try with the Linux Bitnami installer?

Cheers,
Eduardo

Hi Eduardo,
I have reset multiple times. Yeah so what happens is that it seems to hang after
INFO: schema validation completed

Authbind is set to yes.
I will try a different java version now.
Yeah so I get to the last section which says to restart tomcat and then tail run the log

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Issue with first time reportserver install

Hi gaeilgeganeagla,

I would start with the simplest installation possible, and then progressively add features to your installation, since you are having problems with the manual installation.
Also, please check that your tomcat instance only contains reportserver, and not other applications, since this can cause problems because of tomcat not properly isolating the application libraries.

I would recommend these steps:
1. Download the binaries.
2. Install tomcat with the standard installation, use it with the standard java sdk.
3. Drop your database previously used.
4. Create/populate your database using the given script in the ddl directory of the download file. E.g. execute reportserver-RS3.0.2-5855-schema-PostgreSQL_CREATE.sql for PostgreSQL.
5. Change your persistence.properties file to point to your database.
6. Copy the binaries-download file to your tomcat webapps, rename it to "reportserver"
7. Start your tomcat and check http://localhost:8080/reportserver

This should work.

Cheers,
Eduardo