You are not logged in.
I have deployed reportserver on the following architecture:
reportserver: Version: RS4.6.1-6094
Apache Tomcat/9.0.76
Java Version: 11.0.19+7-LTS
The status of tomcat is active, as is that of postgress. Everything seems to be normal, but when I try to access reportserver via the browser, I get no display. I simply get the message "The connection has timed out". Need help please.
Offline
Hello anonimo,
please check the directory for Tomcat logs and analyze the potential error.
Can you see something like this in your log (catalina.out)?
_____ _ _____ ______ _ _
| __ \ | | / ____| | ____| | | (_)
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __ | |__ _ __ | |_ ___ _ __ _ __ _ __ _ ___ ___
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__| | __| | '_ \| __/ _ \ '__| '_ \| '__| / __|/ _ \
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ | | |____| | | | || __/ | | |_) | | | \__ \ __/
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_| |______|_| |_|\__\___|_| | .__/|_| |_|___/\___|
| | | |
|_| |_|
Version: RS4.6.1-6094 2023-06-28-14-00-36
Code Version: 2023-05-26-13-10-32
Java Version: Ubuntu OpenJDK 64-Bit Server VM 11.0.19+7-post-Ubuntu-0ubuntu118.04.1 (11)
VM Args: --add-opens=java.base/java.net=ALL-UNNAMED --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED --add-exports=java.base/java.net=ALL-UNNAMED --add-opens=java.base/jdk.internal.
reflect=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.c
oncurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED -Djava.util.logging.config.file=/usr/local/tomcat9/conf/logging.properties -Djava.util.logging.manager=org.apa
che.juli.ClassLoaderLogManager -Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom -Dfile.encoding=UTF8 -Drs.configdir=/opt/reportserver -Djava.awt.headless=true -Djavax.
net.ssl.trustStoreType=JKS -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -
Xms512M -Xmx4048M -XX:+UseParallelGC -Xmx4048m -Dignore.endorsed.dirs= -Dcatalina.base=/usr/local/tomcat9 -Dcatalina.home=/usr/local/tomcat9 -Djava.io.tmpdir=/usr/local/tomcat9/temp
Max memory: 3.51 GB
Groovy Version: 4.0.12
JVM Locale: en_US
JVM user language: en
JVM user country: US
JVM user timezone: Europe/Berlin
JVM file encoding: UTF8
JVM server time: 2023-07-10T08:32:22.58995+02:00[Europe/Berlin]
Operation system: Linux 5.4.0-150-generic (amd64)
rs.configdir: /opt/reportserver (OK)
### 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?useJDBCCompliantTimezoneShift=true&serverTimezone=UTC (OK)
hibernate.connection.username: reportserver
hibernate.default_schema:
Connection Test: OK
Schema Version: RS3.0-26
Best regards,
Tobias
Offline
Hello Tobias,
Thank you so much for your feedback. I really appreciate it.
yes, indeed I had checked in the file catalina.out. I got almost the same result as you. Please have a look.
_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|
Version: RS4.6.1-6094 2023-06-28-14-00-36
Code Version: 2023-05-26-13-10-32
Java Version: Azul Systems, Inc. OpenJDK 64-Bit Server VM 11.0.19+7-LTS (11)
VM Args: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED -Djava.util.logging.config.file=/opt/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.awt.headless=true -Xmx2g -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/opt/reportserver -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dignore.endorsed.dirs= -Dcatalina.base=/opt/tomcat -Dcatalina.home=/opt/tomcat -Djava.io.tmpdir=/opt/tomcat/temp
Max memory: 1.91 GB
Groovy Version: 4.0.12
JVM Locale: en_US
JVM user language: en
JVM user country: US
JVM user timezone: Africa/Lome
JVM file encoding: UTF-8
JVM server time: 2023-07-03T14:39:58.370662Z[Africa/Lome]
Operation system: Linux 3.10.0-327.13.1.el7.x86_64 (amd64)
rs.configdir: Not Configured
### 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.default_schema:
Connection Test: OK
Schema Version: RS3.0-26
### Internal datasource metadata ###
Database name: PostgreSQL
Database version: 9.2.24
Driver name: PostgreSQL JDBC Driver
Driver version: 42.6.0
JDBC major version: 4
JDBC minor version: 2
JDBC URL: jdbc:postgresql://localhost/reportserver
JDBC username: reportserver
### SSL ###
Supported SSL protocols: TLSv1.3, TLSv1.2, TLSv1.1, TLSv1, SSLv3, SSLv2Hello
Default SSL protocols: TLSv1.3, TLSv1.2
Enabled SSL protocols: TLSv1.3, TLSv1.2
14:39:59.766 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...
14:40:07.586 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.License
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.License
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
14:40:07.587 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
14:40:07.588 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
14:40:07.589 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
14:40:11.956 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile scheduler/scheduler.cf could not be loaded. Default values are in effect.
14:40:11.959 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
14:40:11.961 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
14:40:12.316 INFO n.d.r.s.s.saiku.ThinQueryServiceImpl - loaded thinqueryservice
14:40:12.316 INFO n.d.r.s.s.saiku.ThinQueryServiceImpl - loaded thinqueryservice
14:40:12.587 INFO n.d.r.c.s.i.RemoteMessageServiceImpl - Loading messages...
14:40:22.918 INFO n.d.r.c.s.i.RemoteMessageServiceImpl - Available locales: de, hi, lo, pt, lt, hr, lv, hu, zh-CN, hy, uk, id, mk, mn, af, uz, ms, el, mt, en, is, it, my, es, et, eu, vi, ja, ne, ro, nl, no, ru, be, fi, bg, keys, fr, bn, jw, bs, ka, si, sk, sl, ga, gd, ca, sq, sr, kk, km, sv, ko, zh-TW, ta, cs, th, lb, tl, pl, da, tr
03-Jul-2023 14:41:43.990 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/ROOT] has finished in [118,755] ms
03-Jul-2023 14:41:43.991 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/docs]
03-Jul-2023 14:41:44.012 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/docs] has finished in [20] ms
03-Jul-2023 14:41:44.012 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/examples]
03-Jul-2023 14:41:44.223 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/examples] has finished in [210] ms
03-Jul-2023 14:41:44.223 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/host-manager]
03-Jul-2023 15:08:27.777 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/host-manager] has finished in [1,603,553] ms
03-Jul-2023 15:08:27.778 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/webapps/manager]
03-Jul-2023 15:08:27.822 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/webapps/manager] has finished in [44] ms
03-Jul-2023 15:08:27.839 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
03-Jul-2023 15:08:27.916 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [1722774] milliseconds
15:16:00.728 INFO n.d.r.i.ExecutePackagedScriptsTask - Executing package scripts from: /opt/tomcat/webapps/ROOT/pkg
15:16:01.140 INFO n.d.r.i.ExecutePackagedScriptsTask - Executing package: /opt/tomcat/webapps/ROOT/pkg/baseconfig-RS4.6.1-6094-2023-06-28-14-00-36.zip
15:16:30.981 INFO n.d.r.c.s.j.h.ReportServerExtenderHooker - Start loading ReportServer extensions.
15:16:30.991 INFO n.d.r.c.s.EnvironmentAfterStartupInformation -
Application Server: Apache Tomcat/9.0.76
### PAM Configuration ###
Static PAM configuration: net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
Finalized PAM configuration: class net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
OpenJDK 64-Bit Server VM warning: You have loaded library /opt/tomcat/libj2v8_linux_x86_64.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
15:16:33.432 INFO n.d.r.s.s.search.SearchServiceImpl - Rebuilding search index...
15:16:33.729 INFO n.d.g.s.lateinit.LateInitStartup - Startup completed
Offline
Hello anonimo,
your log says:
15:16:00.728 INFO n.d.r.i.ExecutePackagedScriptsTask - Executing package scripts from: /opt/tomcat/webapps/ROOT/pkg
15:16:01.140 INFO n.d.r.i.ExecutePackagedScriptsTask - Executing package: /opt/tomcat/webapps/ROOT/pkg/baseconfig-RS4.6.1-6094-2023-06-28-14-00-36.zip
What is your subdirectory in /opt/tomcat/webapps/ROOT/ ?
Or, in other words, did you unzip the ReportServer files here /opt/tomcat/webapps/ROOT/pkg/baseconfig-RS4.6.1-6094-2023-06-28-14-00-36 ?
Then your URL could be
http://localhost/pkg/baseconfig-RS4.6.1-6094-2023-06-28-14-00-36/
or maybe
http://localhost:8080/pkg/baseconfig-RS4.6.1-6094-2023-06-28-14-00-36/
There are several posts here in the forum with similar problems and solutions. Have a look here:
https://forum.reportserver.net/viewtopic.php?id=1190
https://forum.reportserver.net/viewtopic.php?id=2797
Offline
Hello Administrator,
Thank you very much for your feedback.
I did the extraction using the following command:
unzip reportserver.zip -d /opt/tomcat/webapps/ROOT/
Here is an ls -lr content of the folder.
[root@hle41reportsrv01 ~]# ls /opt/tomcat/webapps/ROOT/ -lr
total 156
drwxr-xr-x. 6 tomcat tomcat 96 Jul 10 10:30 WEB-INF
drwxr-xr-x. 9 tomcat tomcat 4096 Jun 28 14:47 resources
-rw-r--r--. 1 tomcat tomcat 4485 Jun 28 14:47 ReportServer.html
drwxr-xr-x. 4 tomcat tomcat 8192 Jun 28 14:47 reportserver
drwxr-xr-x. 2 tomcat tomcat 4096 Jun 28 14:47 pkg
drwxr-xr-x. 2 tomcat tomcat 42 Jun 28 14:47 META-INF
-rw-r--r--. 1 tomcat tomcat 32426 Jun 28 14:47 license.txt
drwxr-xr-x. 2 tomcat tomcat 4096 Jun 28 14:47 licenses
-rw-r--r--. 1 tomcat tomcat 78180 Jun 28 14:47 libraries.html
-rw-r--r--. 1 tomcat tomcat 5430 Jun 28 14:47 favicon.ico
drwxr-xr-x. 2 tomcat tomcat 4096 Jun 28 14:47 ddl
and an ls -lr of the folder .../pkg
[root@hle41reportsrv01 ~]# ls /opt/tomcat/webapps/ROOT/pkg/ -lr
total 544
-rw-r--r--. 1 tomcat tomcat 490027 Jun 28 14:47 demobuilder-RS4.6.1-6094-2023-06-28-14-00-36.zip
-rw-r--r--. 1 tomcat tomcat 63193 Jun 28 14:47 baseconfig-RS4.6.1-6094-2023-06-28-14-00-36.zip
Last edited by anonimo (2023-07-10 13:44:18)
Offline
When trying to attend
http://192.168.10.100:8080/pkg/baseconf … -14-00-36/
or
http://192.168.10.100/pkg/baseconfig-RS … -14-00-36/
I still have no display in the browser
Offline
Your directory structure looks correct, everything is directly in the ROOT directory. This should not be the problem. So the ReportServer should be reachable.
If you tried to access the Tomcat via http://192.168.10.100:8080/...
firewall or network settings may be the problem.
Please try to access the ReportServer locally on the same system where the Tomcat is running to exclude firewall or network problems.
In the file server.xml you can find the settings under which port the ReportServer should be reachable.
So it can be this URL
http://localhost:8080
or this
http://localhost
Offline
Hi, Tobias,
I finally solved the problem. For my case being on Linux centos 7, the firewall was enabled by default, which prevented traffic.
There are two possible solutions:
- either disable the firewall (a viable solution if you're in a development environment)
systemctl stop firewalld
- or configure the firewall to allow traffic on port 8080 (if you're in a production environment).
Thank you very much for taking the time to help me. I am extremely grateful
Offline
