You are not logged in.
Pages: 1
Hi all,
Sorry if this has been discussed yet, but I might have a problem.(surely I`m doing something wrong)
So, I have deployed RS on a ubuntu machine with a MS SQL database.
By the looks one the tomcat logs, this should work:
[2024-04-09 13:04:04] [info] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2024-04-09 13:04:04] [info] WARNING: An illegal reflective access operation has occurred
[2024-04-09 13:04:04] [info] WARNING: Illegal reflective access by net.datenwerke.rs.configservice.service.configservice.LibDirClasspathHelper (file:/var/lib/tomcat9/webapps/ROOT/WEB-INF/lib/reportserver.jar) to method java.net.URLClassLoader.addURL(java.net.URL)
[2024-04-09 13:04:04] [info] WARNING: Please consider reporting this to the maintainers of net.datenwerke.rs.configservice.service.configservice.LibDirClasspathHelper
[2024-04-09 13:04:04] [info] WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
[2024-04-09 13:04:04] [info] WARNING: All illegal access operations will be denied in a future release
[2024-04-09 13:04:07] [info] 13:04:07.583 INFO n.datenwerke.rs.EnvironmentValidator -
[2024-04-09 13:04:07] [info] #015
[2024-04-09 13:04:07] [info] message repeated 3 times: [ #015]
[2024-04-09 13:04:07] [info] _____ _ _____
[2024-04-09 13:04:07] [info] | __ \ | | / ____|
[2024-04-09 13:04:07] [info] | |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
[2024-04-09 13:04:07] [info] | _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
[2024-04-09 13:04:07] [info] | | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
[2024-04-09 13:04:07] [info] |_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
[2024-04-09 13:04:07] [info] | |
[2024-04-09 13:04:07] [info] |_|
[2024-04-09 13:04:07] [info] #015
[2024-04-09 13:04:07] [info] Version: RS4.6.3-6104 2024-03-20-14-57-05
[2024-04-09 13:04:07] [info] Code Version: 2023-12-07-11-58-55
[2024-04-09 13:04:07] [info] Java Version: Ubuntu OpenJDK 64-Bit Server VM 11.0.22+7-post-Ubuntu-0ubuntu222.04.1 (11)
[2024-04-09 13:04:07] [info] 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=/var/lib/tomcat9/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=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 -Djava.io.tmpdir=/tmp
[2024-04-09 13:04:07] [info] Max memory: 1.97 GB
[2024-04-09 13:04:07] [info] Groovy Version: 4.0.20
[2024-04-09 13:04:07] [info] JVM Locale: en_US
[2024-04-09 13:04:07] [info] JVM user language: en
[2024-04-09 13:04:07] [info] JVM user country: US
[2024-04-09 13:04:07] [info] JVM user timezone: Europe/Bucharest
[2024-04-09 13:04:07] [info] JVM file encoding: UTF8
[2024-04-09 13:04:07] [info] JVM server time: 2024-04-09T13:04:05.515811+03:00[Europe/Bucharest]
[2024-04-09 13:04:07] [info] Operation system: Linux 6.5.0-18-generic (amd64)
[2024-04-09 13:04:07] [info] rs.configdir: /opt/reportserver (OK)
[2024-04-09 13:04:07] [info] #015
[2024-04-09 13:04:07] [info] ### DB Config ###
[2024-04-09 13:04:07] [info] hibernate.dialect: net.datenwerke.rs.utils.hibernate.SQLServer2008Dialect (OK)
[2024-04-09 13:04:07] [info] hibernate.connection.driver_class: com.microsoft.sqlserver.jdbc.SQLServerDriver (OK)
[2024-04-09 13:04:07] [info] hibernate.connection.url: jdbc:sqlserver://192.168.1.99;encrypt=false;databaseName=reportserver (OK)
[2024-04-09 13:04:07] [info] hibernate.connection.username: sa
[2024-04-09 13:04:07] [info] hibernate.default_schema:
[2024-04-09 13:04:07] [info] #015
[2024-04-09 13:04:07] [info] Connection Test: OK
[2024-04-09 13:04:07] [info] Schema Version: RS3.0-26
[2024-04-09 13:04:07] [info] #015
[2024-04-09 13:04:07] [info] ### Internal datasource metadata ###
[2024-04-09 13:04:07] [info] Database name: Microsoft SQL Server
[2024-04-09 13:04:07] [info] Database version: 16.00.4115
[2024-04-09 13:04:07] [info] Driver name: Microsoft JDBC Driver 12.6 for SQL Server
[2024-04-09 13:04:07] [info] Driver version: 12.6.1.0
[2024-04-09 13:04:07] [info] JDBC major version: 4
[2024-04-09 13:04:07] [info] JDBC minor version: 3
[2024-04-09 13:04:07] [info] JDBC URL: jdbc:sqlserver://192.168.1.99:1433;connectRetryInterval=10;connectRetryCount=1;maxResultBuffer=-1;sendTemporalDataTypesAsStringForBulkCopy=true;delayLoadingLobs=true;useFmtOnly=false;useBulkCopyForBatchInsert=false;cancelQueryTimeout=-1;sslProtocol=TLS;calcBigDecimalPrecision=false;useDefaultJaasConfig=false;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;datetimeParameterType=datetime2;sendTimeAsDatetime=true;replication=false;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;iPAddressPreference=IPv4First;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;lastUpdateCount=true;useFlexibleCallableStatements=true;useDefaultGSSCredential=false;prepareMethod=prepexec;encrypt=false;disableStatementPooling=true;databaseName=reportserver;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;
[2024-04-09 13:04:07] [info] JDBC username: sa
[2024-04-09 13:04:07] [info] #015
[2024-04-09 13:04:07] [info] ### SSL ###
[2024-04-09 13:04:07] [info] Supported SSL protocols: TLSv1.3, TLSv1.2, TLSv1.1, TLSv1, SSLv3, SSLv2Hello
[2024-04-09 13:04:07] [info] Default SSL protocols: TLSv1.3, TLSv1.2
[2024-04-09 13:04:07] [info] Enabled SSL protocols: TLSv1.3, TLSv1.2
[2024-04-09 13:04:07] [info] 13:04:07.644 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...
[2024-04-09 13:04:15] [info] 13:04:15.975 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
[2024-04-09 13:04:15] [info] 13:04:15.976 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
[2024-04-09 13:04:15] [info] 13:04:15.976 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
[2024-04-09 13:04:15] [info] 13:04:15.976 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
[2024-04-09 13:04:15] [info] 13:04:15.976 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
[2024-04-09 13:04:15] [info] 13:04:15.976 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
[2024-04-09 13:04:15] [info] 13:04:15.976 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
[2024-04-09 13:04:15] [info] 13:04:15.977 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
[2024-04-09 13:04:15] [info] 13:04:15.977 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
[2024-04-09 13:04:15] [info] 13:04:15.977 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
[2024-04-09 13:04:15] [info] 13:04:15.977 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.License
[2024-04-09 13:04:15] [info] 13:04:15.977 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.License
[2024-04-09 13:04:15] [info] 13:04:15.977 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
[2024-04-09 13:04:15] [info] 13:04:15.978 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
[2024-04-09 13:04:21] [info] 13:04:21.436 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile scheduler/scheduler.cf could not be loaded. Default values are in effect.
[2024-04-09 13:04:21] [info] 13:04:21.444 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
[2024-04-09 13:04:21] [info] 13:04:21.447 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
[2024-04-09 13:04:22] [info] 13:04:22.019 INFO n.d.r.s.s.saiku.ThinQueryServiceImpl - loaded thinqueryservice
[2024-04-09 13:04:22] [info] 13:04:22.020 INFO n.d.r.s.s.saiku.ThinQueryServiceImpl - loaded thinqueryservice
[2024-04-09 13:04:22] [info] 13:04:22.638 INFO n.d.r.c.s.i.RemoteMessageServiceImpl - Loading messages...
[2024-04-09 13:04:34] [info] 13:04:34.072 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
[2024-04-09 13:04:43] [info] 13:04:43.111 INFO n.d.r.c.s.j.h.ReportServerExtenderHooker - Start loading ReportServer extensions.
[2024-04-09 13:04:43] [info] 13:04:43.123 INFO n.d.r.c.s.EnvironmentAfterStartupInformation -
[2024-04-09 13:04:43] [info] #015
[2024-04-09 13:04:43] [info] Application Server: Apache Tomcat/9.0.58 (Ubuntu)
[2024-04-09 13:04:43] [info] #015
[2024-04-09 13:04:43] [info] ### PAM Configuration ###
[2024-04-09 13:04:43] [info] Static PAM configuration: net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
[2024-04-09 13:04:43] [info] Finalized PAM configuration: class net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
[2024-04-09 13:04:43] [info] #015
[2024-04-09 13:04:44] [info] 13:04:44.612 INFO n.d.r.s.s.search.SearchServiceImpl - Rebuilding search index...
[2024-04-09 13:04:45] [info] 13:04:45.613 INFO n.d.g.s.lateinit.LateInitStartup - Startup completed
[2024-04-09 13:04:47] [info] Deployment of web application directory [/var/lib/tomcat9/webapps/ROOT] has finished in [57,919] ms
[2024-04-09 13:04:47] [info] Deploying web application directory [/var/lib/tomcat9/webapps/pkg]
[2024-04-09 13:04:48] [info] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2024-04-09 13:04:48] [info] Deployment of web application directory [/var/lib/tomcat9/webapps/pkg] has finished in [734] ms
[2024-04-09 13:04:48] [info] Deploying web application directory [/var/lib/tomcat9/webapps/licenses]
[2024-04-09 13:04:49] [info] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2024-04-09 13:04:49] [info] Deployment of web application directory [/var/lib/tomcat9/webapps/licenses] has finished in [678] ms
[2024-04-09 13:04:49] [info] Deploying web application directory [/var/lib/tomcat9/webapps/reportserver]
[2024-04-09 13:04:49] [info] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2024-04-09 13:04:49] [info] Deployment of web application directory [/var/lib/tomcat9/webapps/reportserver] has finished in [579] ms
[2024-04-09 13:04:49] [info] Deploying web application directory [/var/lib/tomcat9/webapps/ddl]
[2024-04-09 13:04:50] [info] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2024-04-09 13:04:50] [info] Deployment of web application directory [/var/lib/tomcat9/webapps/ddl] has finished in [566] ms
[2024-04-09 13:04:50] [info] Deploying web application directory [/var/lib/tomcat9/webapps/resources]
[2024-04-09 13:04:50] [info] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2024-04-09 13:04:50] [info] Deployment of web application directory [/var/lib/tomcat9/webapps/resources] has finished in [568] ms
[2024-04-09 13:04:50] [info] Starting ProtocolHandler ["http-nio-8080"]
[2024-04-09 13:04:50] [info] Server startup in [61205] milliseconds
But when I try to open the page I`m getting this:
"ReportServer
null
null
404 <!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body>
HTTP Status 404 – Not Found
<hr class="line" /><p>Type Status Report</p><p>Message The requested resource [/reportserver/base_datasource] is not available</p><p>Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.</p><hr class="line" />
Apache Tomcat/9.0.58 (Ubuntu)
</body></html> Statuscode: 404 EncodedResponse: <!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body>
HTTP Status 404 – Not Found
<hr class="line" /><p>Type Status Report</p><p>Message The requested resource [/reportserver/base_datasource] is not available</p><p>Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.</p><hr class="line" />
Apache Tomcat/9.0.58 (Ubuntu)
</body></html>
null
null
404 <!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body>
HTTP Status 404 – Not Found
<hr class="line" /><p>Type Status Report</p><p>Message The requested resource [/reportserver/base_datasource] is not available</p><p>Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.</p><hr class="line" />
Apache Tomcat/9.0.58 (Ubuntu)
</body></html>
null
null
404 <!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body>
HTTP Status 404 – Not Found
<hr class="line" /><p>Type Status Report</p><p>Message The requested resource [/reportserver/security_lostpassword] is not available</p><p>Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.</p><hr class="line" />
Apache Tomcat/9.0.58 (Ubuntu)
</body></html> Statuscode: 404 EncodedResponse: <!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body>
HTTP Status 404 – Not Found
<hr class="line" /><p>Type Status Report</p><p>Message The requested resource [/reportserver/security_lostpassword] is not available</p><p>Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.</p><hr class="line" />
Apache Tomcat/9.0.58 (Ubuntu)
</body></html>
"
Can someone give me a hint where I should look for the issue?
Thanks!
Offline
Hi,
At first glance the logs look fine.
The only thing that strikes out to me are the first warning lines
------------------------------
[2024-04-09 13:04:04] [info] WARNING: An illegal reflective access operation has occurred
[2024-04-09 13:04:04] [info] WARNING: Illegal reflective access by net.datenwerke.rs.configservice.service.configservice.LibDirClasspathHelper (file:/var/lib/tomcat9/webapps/ROOT/WEB-INF/lib/reportserver.jar) to method java.net.URLClassLoader.addURL(java.net.URL)
[2024-04-09 13:04:04] [info] WARNING: Please consider reporting this to the maintainers of net.datenwerke.rs.configservice.service.configservice.LibDirClasspathHelper
[2024-04-09 13:04:04] [info] WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
[2024-04-09 13:04:04] [info] WARNING: All illegal access operations will be denied in a future release
--------------------------
These I am not familiar with.
Generally speaking. Clearing the browser cache often resolves issues.
If no error messages occure in the ReportServer log when opening the site, it might be a tomcat issue.
Kind regards,
Adrian
Offline
Pages: 1