The requested URL was not found on this server on report server linux

kiranmaie · 2023-08-01 12:51:56

we did report server installation using wget https://downloads.bitnami.com/files/sta … taller.run . we installed JDBC and all the necessary steps but showing error
The requested URL not found on this server.

eduardo · 2023-08-01 16:59:57

Hi kiranmaie,

pls note RS 3.7.1 is a very old version which is not further supported.
For Bitnami problems pls contact Bitnami directly, e.g. here: https://github.com/bitnami/containers/issues

Regards,
Eduardo

kiranmaie · 2023-08-02 09:22:50

created fresh installation using link https://reportserver.net/en/tutorials/i … -practice/ installed latest version ReportServer 4.6.1-6096 on ubuntu version 22.04 but still installtion is not succeded we see plain html only text in background as report server text and script errors from html in dev tools. unable to attach image here.

eduardo · 2023-08-02 16:35:16

Hi kiranmaie,

for a first installation, you can just install tomcat, make sure it works (open http://localhost:8080) and then copy your reportserver binaries to your tomcat webapps directory. Then you can open it like this (http://localhost:8080/ROOT or http://localhost:8080/reportserver), depending where you copied the binaries.

For a production environment you can perform a manual installation as shown in the tutorial:
https://reportserver.net/en/tutorials/i … -practice/

Regards,
Eduardo

kiranmaie · 2023-08-03 05:43:35

Hi Eduardo,
yes we tried all the steps as per https://reportserver.net/en/tutorials/i … -practice/ .we can see home page is loading but netting username and password in the screen . after that we tried executing sudo chown tomcat:tomcat -R /opt/reportserverenterprise-3.7.1.6052-0/apache-tomcat/ but still the issue is same. please help us to resolve this . below is the log from tomcat

03-Aug-2023 05:31:15.433 INFO [Thread-11] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-80"]
03-Aug-2023 05:31:15.434 INFO [Thread-11] org.apache.catalina.core.StandardService.stopInternal Stopping service [Catalina]
03-Aug-2023 05:31:15.445 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
03-Aug-2023 05:31:15.446 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ROOT] appears to have started a thread named [org.apache.commons.vfs2.cache.SoftRefFilesCache$ReleaseThread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.20/java.lang.Object.wait(Native Method)
java.base@11.0.20/java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:155)
org.apache.commons.vfs2.cache.SoftRefFilesCache$ReleaseThread.run(SoftRefFilesCache.java:54)
03-Aug-2023 05:31:15.447 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ROOT] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->3004m9ax1emk33u1d8zpgm|469a6af0]-AdminTaskTimer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.20/java.lang.Object.wait(Native Method)
java.base@11.0.20/java.util.TimerThread.mainLoop(Timer.java:553)
java.base@11.0.20/java.util.TimerThread.run(Timer.java:506)
03-Aug-2023 05:31:15.448 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ROOT] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->3004m9ax1emk33u1d8zpgm|469a6af0]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.20/java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
03-Aug-2023 05:31:15.449 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ROOT] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->3004m9ax1emk33u1d8zpgm|469a6af0]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.20/java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
03-Aug-2023 05:31:15.449 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ROOT] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->3004m9ax1emk33u1d8zpgm|469a6af0]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.20/java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
03-Aug-2023 05:31:15.450 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesObjectStreamClassCaches Failed to clear soft references from ObjectStreamClass$Caches for web application [ROOT]
java.lang.ClassCastException: class java.io.ObjectStreamClass$Caches$1 cannot be cast to class java.util.Map (java.io.ObjectStreamClass$Caches$1 and java.util.Map are in module java.base of loader 'bootstrap')
at org.apache.catalina.loader.WebappClassLoaderBase.clearCache(WebappClassLoaderBase.java:2325)
at org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesObjectStreamClassCaches(WebappClassLoaderBase.java:2300)
at org.apache.catalina.loader.WebappClassLoaderBase.clearReferences(WebappClassLoaderBase.java:1669)
at org.apache.catalina.loader.WebappClassLoaderBase.stop(WebappClassLoaderBase.java:1597)
at org.apache.catalina.loader.WebappLoader.stopInternal(WebappLoader.java:463)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5515)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1401)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at org.apache.catalina.core.ContainerBase.stopInternal(ContainerBase.java:986)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1401)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at org.apache.catalina.core.ContainerBase.stopInternal(ContainerBase.java:986)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardService.stopInternal(StandardService.java:497)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardServer.stopInternal(StandardServer.java:979)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.startup.Catalina.stop(Catalina.java:849)
at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:996)
03-Aug-2023 05:31:15.467 WARNING [Thread-11] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesObjectStreamClassCaches Failed to clear soft references from ObjectStreamClass$Caches for web application [ddl]
java.lang.ClassCastException: class java.io.ObjectStreamClass$Caches$1 cannot be cast to class java.util.Map (java.io.ObjectStreamClass$Caches$1 and java.util.Map are in module java.base of loader 'bootstrap')
at org.apache.catalina.loader.WebappClassLoaderBase.clearCache(WebappClassLoaderBase.java:2325)
at org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesObjectStreamClassCaches(WebappClassLoaderBase.java:2300)
at org.apache.catalina.loader.WebappClassLoaderBase.clearReferences(WebappClassLoaderBase.java:1669)
at org.apache.catalina.loader.WebappClassLoaderBase.stop(WebappClassLoaderBase.java:1597)
at org.apache.catalina.loader.WebappLoader.stopInternal(WebappLoader.java:463)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5515)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1401)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at org.apache.catalina.core.ContainerBase.stopInternal(ContainerBase.java:986)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1412)
at org.apache.catalina.core.ContainerBase$StopChild.call(ContainerBase.java:1401)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
at org.apache.catalina.core.ContainerBase.stopInternal(ContainerBase.java:986)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardService.stopInternal(StandardService.java:497)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.core.StandardServer.stopInternal(StandardServer.java:979)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257)
at org.apache.catalina.startup.Catalina.stop(Catalina.java:849)
at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:996)
03-Aug-2023 05:31:15.471 INFO [Thread-11] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-80"]
03-Aug-2023 05:31:15.474 INFO [Thread-11] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-80"]
03-Aug-2023 05:31:16.365 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.58 (Ubuntu)
03-Aug-2023 05:31:16.367 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jan 6 1970 15:09:28 UTC
03-Aug-2023 05:31:16.367 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.58.0
03-Aug-2023 05:31:16.368 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
03-Aug-2023 05:31:16.370 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 5.19.0-1025-aws
03-Aug-2023 05:31:16.370 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
03-Aug-2023 05:31:16.378 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-11-openjdk-amd64
03-Aug-2023 05:31:16.379 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 11.0.20+8-post-Ubuntu-1ubuntu122.04
03-Aug-2023 05:31:16.379 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Ubuntu
03-Aug-2023 05:31:16.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /var/lib/tomcat9
03-Aug-2023 05:31:16.381 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/share/tomcat9
03-Aug-2023 05:31:16.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.net=ALL-UNNAMED
03-Aug-2023 05:31:16.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED
03-Aug-2023 05:31:16.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/jdk.internal.reflect=ALL-UNNAMED
03-Aug-2023 05:31:16.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang.invoke=ALL-UNNAMED
03-Aug-2023 05:31:16.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djavax.net.ssl.trustStoreType=JKS
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF-8
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED
03-Aug-2023 05:31:16.399 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx4g
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF8
03-Aug-2023 05:31:16.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Drs.configdir=/opt/reportserver
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/var/lib/tomcat9
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/share/tomcat9
03-Aug-2023 05:31:16.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/tmp
03-Aug-2023 05:31:16.407 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.31] using APR version [1.7.0].
03-Aug-2023 05:31:16.408 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [true].
03-Aug-2023 05:31:16.409 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
03-Aug-2023 05:31:16.415 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 3.0.2 15 Mar 2022]
03-Aug-2023 05:31:17.022 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
03-Aug-2023 05:31:17.052 SEVERE [main] org.apache.catalina.util.LifecycleBase.handleSubClassException Failed to initialize component [Connector[HTTP/1.1-80]]
org.apache.catalina.LifecycleException: Protocol handler initialization failed
at org.apache.catalina.connector.Connector.initInternal(Connector.java:1049)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:556)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:1042)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.startup.Catalina.load(Catalina.java:724)
at org.apache.catalina.startup.Catalina.load(Catalina.java:746)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:305)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:475)
Caused by: java.net.BindException: Address already in use
at java.base/sun.nio.ch.Net.bind0(Native Method)
at java.base/sun.nio.ch.Net.bind(Net.java:459)
at java.base/sun.nio.ch.Net.bind(Net.java:448)
at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:227)
at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:273)
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:228)
at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1213)
at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1226)
at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:603)
at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:80)
at org.apache.catalina.connector.Connector.initInternal(Connector.java:1046)
... 13 more
03-Aug-2023 05:31:17.057 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [1073] milliseconds
03-Aug-2023 05:31:17.203 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
03-Aug-2023 05:31:17.204 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.58 (Ubuntu)]
03-Aug-2023 05:31:17.248 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/lib/tomcat9/webapps/ddl]
03-Aug-2023 05:31:18.802 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars 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.
03-Aug-2023 05:31:18.884 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/var/lib/tomcat9/webapps/ddl] has finished in [1,635] ms
03-Aug-2023 05:31:18.888 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/lib/tomcat9/webapps/ROOT]
03-Aug-2023 05:31:31.320 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.58 (Ubuntu)
03-Aug-2023 05:31:31.321 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jan 6 1970 15:09:28 UTC
03-Aug-2023 05:31:31.322 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.58.0
03-Aug-2023 05:31:31.322 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
03-Aug-2023 05:31:31.322 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 5.19.0-1025-aws
03-Aug-2023 05:31:31.322 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
03-Aug-2023 05:31:31.322 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-11-openjdk-amd64
03-Aug-2023 05:31:31.323 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 11.0.20+8-post-Ubuntu-1ubuntu122.04
03-Aug-2023 05:31:31.323 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Ubuntu
03-Aug-2023 05:31:31.323 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /var/lib/tomcat9
03-Aug-2023 05:31:31.324 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/share/tomcat9
03-Aug-2023 05:31:31.347 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.net=ALL-UNNAMED
03-Aug-2023 05:31:31.347 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED
03-Aug-2023 05:31:31.347 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/jdk.internal.reflect=ALL-UNNAMED
03-Aug-2023 05:31:31.348 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang.invoke=ALL-UNNAMED
03-Aug-2023 05:31:31.348 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED
03-Aug-2023 05:31:31.348 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djavax.net.ssl.trustStoreType=JKS
03-Aug-2023 05:31:31.348 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF-8
03-Aug-2023 05:31:31.349 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
03-Aug-2023 05:31:31.349 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
03-Aug-2023 05:31:31.349 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
03-Aug-2023 05:31:31.349 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED
03-Aug-2023 05:31:31.349 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED
03-Aug-2023 05:31:31.350 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
03-Aug-2023 05:31:31.350 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties
03-Aug-2023 05:31:31.350 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
03-Aug-2023 05:31:31.350 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
03-Aug-2023 05:31:31.350 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx4g
03-Aug-2023 05:31:31.351 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseConcMarkSweepGC
03-Aug-2023 05:31:31.352 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF8
03-Aug-2023 05:31:31.352 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Drs.configdir=/opt/reportserver
03-Aug-2023 05:31:31.353 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
03-Aug-2023 05:31:31.353 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
03-Aug-2023 05:31:31.354 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
03-Aug-2023 05:31:31.354 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
03-Aug-2023 05:31:31.354 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/var/lib/tomcat9
03-Aug-2023 05:31:31.354 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/share/tomcat9
03-Aug-2023 05:31:31.355 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/tmp
03-Aug-2023 05:31:31.364 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.31] using APR version [1.7.0].
03-Aug-2023 05:31:31.364 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [true].
03-Aug-2023 05:31:31.365 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
03-Aug-2023 05:31:31.369 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 3.0.2 15 Mar 2022]
03-Aug-2023 05:31:31.999 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
03-Aug-2023 05:31:32.039 SEVERE [main] org.apache.catalina.util.LifecycleBase.handleSubClassException Failed to initialize component [Connector[HTTP/1.1-80]]
org.apache.catalina.LifecycleException: Protocol handler initialization failed
at org.apache.catalina.connector.Connector.initInternal(Connector.java:1049)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:556)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:1042)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:136)
at org.apache.catalina.startup.Catalina.load(Catalina.java:724)
at org.apache.catalina.startup.Catalina.load(Catalina.java:746)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:305)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:475)
Caused by: java.net.BindException: Address already in use
at java.base/sun.nio.ch.Net.bind0(Native Method)
at java.base/sun.nio.ch.Net.bind(Net.java:459)
at java.base/sun.nio.ch.Net.bind(Net.java:448)
at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:227)
at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:273)
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:228)
at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1213)
at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1226)
at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:603)
at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:80)
at org.apache.catalina.connector.Connector.initInternal(Connector.java:1046)
... 13 more
03-Aug-2023 05:31:32.045 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [1094] milliseconds
03-Aug-2023 05:31:32.161 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
03-Aug-2023 05:31:32.162 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.58 (Ubuntu)]
03-Aug-2023 05:31:32.175 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/lib/tomcat9/webapps/ddl]
03-Aug-2023 05:31:33.761 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars 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.
03-Aug-2023 05:31:33.825 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/var/lib/tomcat9/webapps/ddl] has finished in [1,650] ms
03-Aug-2023 05:31:33.826 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/lib/tomcat9/webapps/ROOT]
03-Aug-2023 05:31:49.665 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars 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.
03-Aug-2023 05:32:44.672 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/var/lib/tomcat9/webapps/ROOT] has finished in [70,846] ms
03-Aug-2023 05:32:44.681 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [72634] milliseconds

kiranmaie · 2023-08-03 12:37:32

Hi Eduardo,
one more issue to set up LDAP in linux server where report server installed to execute [ldaptest filter] we need to open REPORT SERVER TERMINAL RIGHT ? how to open this terminal on linux as it's linux not windows how to open and execute these LDAP steps?
please let me know as soon as possible. it's urgent.

kiranmaie · 2023-08-03 12:47:08

Hi Eduardo,
we did fresh installation as well on the new linux server with no errors we got this message INFO [Thread-13] net.datenwerke.gf.service.lateinit.LateInitStartup$1.run Startup completed after the step : $ tail -f /var/lib/tomcat9/logs/reportserver.DATE.log .But while loading report server we see nothing loading with null error .we see below data in localhost log file.

10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/js/codemirror-5.65.2/mode/css/css.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/js/codemirror-5.65.2/addon/edit/matchbrackets.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/js/codemirror-5.65.2/mode/php/php.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /reportserver/reportserver.nocache.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/js/codemirror-5.65.2/mode/groovy/groovy.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/js/codemirror-5.65.2/mode/properties/properties.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/js/codemirror-5.65.2/mode/htmlmixed/htmlmixed.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /reportserver/11045F8A4B2A639C1E20849305322FF0.cache.js HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /reportserver/reset.css HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /resources/font-awesome-4.4.0/fonts/fontawesome-webfont.woff2?v=4.4.0 HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /reportserver/rstheme HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /reportserver/fileServerAccess?path=/resources/public/hostpage-extra.js&noredirect&_=1691065588455 HTTP/1.1" 404 793
10.207.5.128 - - [03/Aug/2023:12:26:28 +0000] "GET /reportserver/version?style=banner HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:26:29 +0000] "POST /reportserver/base_datasource HTTP/1.1" 404 792
10.207.5.128 - - [03/Aug/2023:12:26:30 +0000] "POST /reportserver/security_lostpassword HTTP/1.1" 404 798
10.207.5.128 - - [03/Aug/2023:12:26:30 +0000] "POST /reportserver/homepage HTTP/1.1" 404 785
10.207.5.128 - - [03/Aug/2023:12:26:38 +0000] "GET /index.html HTTP/1.1" 200 4485
10.207.5.128 - - [03/Aug/2023:12:26:38 +0000] "GET /reportserver/fileServerAccess?path=/resources/public/hostpage-extra.js&noredirect&_=1691065598539 HTTP/1.1" 404 793
10.207.5.128 - - [03/Aug/2023:12:26:38 +0000] "GET /reportserver/version?style=banner HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:26:38 +0000] "GET /reportserver/rstheme HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:26:40 +0000] "POST /reportserver/base_datasource HTTP/1.1" 404 792
10.207.5.128 - - [03/Aug/2023:12:26:40 +0000] "POST /reportserver/security_lostpassword HTTP/1.1" 404 798
10.207.5.128 - - [03/Aug/2023:12:26:40 +0000] "POST /reportserver/homepage HTTP/1.1" 404 785
10.207.5.128 - - [03/Aug/2023:12:30:56 +0000] "GET /index.html HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:30:57 +0000] "GET /reportserver/version?style=banner HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:30:57 +0000] "GET /reportserver/fileServerAccess?path=/resources/public/hostpage-extra.js&noredirect&_=1691065857246 HTTP/1.1" 404 793
10.207.5.128 - - [03/Aug/2023:12:30:57 +0000] "GET /reportserver/rstheme HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:30:58 +0000] "POST /reportserver/base_datasource HTTP/1.1" 404 792
10.207.5.128 - - [03/Aug/2023:12:30:59 +0000] "GET /index.html HTTP/1.1" 304 -
10.207.5.128 - - [03/Aug/2023:12:30:59 +0000] "POST /reportserver/security_lostpassword HTTP/1.1" 404 798
10.207.5.128 - - [03/Aug/2023:12:30:59 +0000] "POST /reportserver/homepage HTTP/1.1" 404 785
10.207.5.128 - - [03/Aug/2023:12:31:01 +0000] "POST /reportserver/base_datasource HTTP/1.1" 404 792
10.207.5.128 - - [03/Aug/2023:12:31:02 +0000] "POST /reportserver/security_lostpassword HTTP/1.1" 404 798
10.207.5.128 - - [03/Aug/2023:12:31:02 +0000] "POST /reportserver/homepage HTTP/1.1" 404 785
10.207.5.128 - - [03/Aug/2023:12:31:02 +0000] "GET /reportserver/fileServerAccess?path=/resources/public/hostpage-extra.js&noredirect&_=1691065860102 HTTP/1.1" 404 793
10.207.5.128 - - [03/Aug/2023:12:31:02 +0000] "GET /reportserver/version?style=banner HTTP/1.1" 404 784
10.207.5.128 - - [03/Aug/2023:12:31:02 +0000] "GET /reportserver/rstheme HTTP/1.1" 404 784

one more tomcat log is below

2023-08-03 10:09:49.248 UTC [9220] reportserver@reportserver ERROR: relation "rs_schemainfo" does not exist at character 15
2023-08-03 10:09:49.248 UTC [9220] reportserver@reportserver STATEMENT: SELECT * FROM RS_SCHEMAINFO WHERE KEY_FIELD = 'schemaversion' ORDER BY ENTITY_ID DESC
2023-08-03 10:09:49.401 UTC [9221] reportserver@reportserver ERROR: relation "rs_schemainfo" does not exist at character 15
2023-08-03 10:09:49.401 UTC [9221] reportserver@reportserver STATEMENT: SELECT * FROM RS_SCHEMAINFO WHERE KEY_FIELD = $1 ORDER BY ENTITY_ID DESC
2023-08-03 10:09:49.448 UTC [9222] reportserver@reportserver ERROR: relation "rs_schemainfo" does not exist at character 15
2023-08-03 10:09:49.448 UTC [9222] reportserver@reportserver STATEMENT: SELECT * FROM RS_SCHEMAINFO WHERE KEY_FIELD = $1 ORDER BY ENTITY_ID DESC
2023-08-03 10:28:18.779 UTC [9230] reportserver@reportserver LOG: could not receive data from client: Connection reset by peer
2023-08-03 10:28:18.779 UTC [9232] reportserver@reportserver LOG: could not receive data from client: Connection reset by peer
2023-08-03 10:28:18.779 UTC [9231] reportserver@reportserver LOG: could not receive data from client: Connection reset by peer
2023-08-03 10:28:18.779 UTC [9228] reportserver@reportserver LOG: could not receive data from client: Connection reset by peer
2023-08-03 10:28:18.779 UTC [9229] reportserver@reportserver LOG: could not receive data from client: Connection reset by peer

eduardo · 2023-08-03 22:42:16

Hi kiranmaie,

relation "rs_schemainfo" does not exist at character 15

--> Did you execute your DDLs for creating the tables ? As I recommended, pls start with a basic installation in tomcat, and only copy your files and run your create.sql ddls, found in your ddls directory.

Regards,
Eduardo

kiranmaie · 2023-08-04 12:57:11

Hi Eduardo,
we are able to see RS_ACE BUT it says missing table. below is the log .please help us to resolve this problem. we have been working on this
report server installation for many days.

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

Version: RS4.6.1-6096 2023-07-20-22-02-42
Code Version: 2023-06-28-14-00-36
Java Version: Ubuntu OpenJDK 64-Bit Server VM 11.0.20+8-post-Ubuntu-1ubuntu122.04 (11)
VM Args: --add-opens=java.base/java.net=ALL-UNNAMED --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/jdk.internal.reflect=ALL-UNNAMED --add-opens=java.base/java.lang.invoke=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED -Djavax.net.ssl.trustStoreType=JKS -Dfile.encoding=UTF-8 -Djava.awt.headless=true --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 -Xmx4g -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
Max memory: 3.98 GB
Groovy Version: 4.0.13
JVM Locale: en
JVM user language: en
JVM user country: null
JVM user timezone: Etc/UTC
JVM file encoding: UTF8
JVM server time: 2023-08-04T11:16:59.694494Z[Etc/UTC]
Operation system: Linux 5.19.0-1029-aws (amd64)
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.default_schema: reportserver

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

### Internal datasource metadata ###
Database name: PostgreSQL
Database version: 14.8 (Ubuntu 14.8-0ubuntu0.22.04.1)
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
Schema-validation: missing table [RS_ACE]

/###################

postgres=# \c reportserver
You are now connected to database "reportserver" as user "postgres".
reportserver=# SELECT * FROM RS_ACE;
entity_id | accesstype | n | entity_version | acl_id | folk_id
-----------+------------+---+----------------+--------+---------
3766 | 0 | 1 | 1 | 55 | 3765
3768 | 0 | 1 | 1 | 19 | 3765
3770 | 0 | 1 | 1 | 53 | 3765
3772 | 0 | 1 | 1 | 51 | 3765
3774 | 0 | 1 | 1 | 35 | 3765
3776 | 0 | 1 | 1 | 41 | 3765
3778 | 0 | 1 | 1 | 37 | 3765
3780 | 0 | 1 | 1 | 29 | 3765
3782 | 0 | 1 | 1 | 21 | 3765
3784 | 0 | 1 | 1 | 43 | 3765
3786 | 0 | 1 | 1 | 49 | 3765
3788 | 0 | 1 | 1 | 23 | 3765
3790 | 0 | 1 | 1 | 25 | 3765
3792 | 0 | 1 | 1 | 27 | 3765
3794 | 0 | 1 | 1 | 57 | 3765
3796 | 0 | 1 | 1 | 45 | 3765
3798 | 0 | 1 | 1 | 39 | 3765
3801 | 0 | 1 | 1 | 47 | 3765
3803 | 0 | 1 | 1 | 31 | 3765
3805 | 0 | 1 | 1 | 33 | 3765
3807 | 0 | 1 | 1 | 59 | 3765
3809 | 0 | 1 | 1 | 61 | 3765
3811 | 0 | 2 | 1 | 39 | 3765
3815 | 0 | 1 | 1 | 3814 | 3765
3818 | 0 | 1 | 1 | 3817 | 3765
3821 | 0 | 1 | 1 | 3820 | 3765
3824 | 0 | 1 | 1 | 3823 | 3765
3827 | 0 | 1 | 1 | 3826 | 3765
3830 | 0 | 2 | 1 | 55 | 3829
3832 | 0 | 2 | 1 | 51 | 3829
3834 | 0 | 2 | 1 | 27 | 3829
3837 | 0 | 3 | 1 | 39 | 3829
3860 | 0 | 2 | 1 | 3817 | 3829
3880 | 0 | 2 | 1 | 3820 | 3829
3899 | 0 | 2 | 1 | 3826 | 3829
(35 rows)

eduardo · 2023-08-07 17:25:32

Hi kiranmaie,

you are accessing your DB with two different users:
1. reportserver access:
username: reportserver
this user cannot see the tables
2. terminal access:
username: postgres
this user can see the tables

so it seems to be a permission issue with your "reportserver" user, which cannot see the tables.

Regards,
Eduardo

kiranmaie · 2023-08-10 07:53:35

hi eduardo,
i am able to see ldap configuration in the report server but AD authentications is not working . when I tried to test ldaptest filter command in report server terminal it's throwing command not found .bwlow is the ldap configuration in report server.

<?xml version="1.0" encoding="UTF-8"?>
<!--
ReportServer Configuration File
filename: sso/ldap.cf

Configures LDAP
-->
<configuration>
<provider>
<host>http://ldap.isshgdc1.issnet.iss-shipping.com</host>
<port>389</port>
</provider>
<security>

<encryption>none</encryption>
<principal>CN=SVC_ReportServer,DC=issnet,DC=iss-shipping,DC=com</principal>
<credentials>0a>59Fgy}3UL</credentials>
</security>
<base>OU=Data Centre,OU=Service Accounts,DC=issnet,DC=iss-shipping,DC=com</base>
<filter>(|(objectClass=organizationalUnit)(objectClass=user)(objectClass=group))</filter>
<externalDir>/usermanager/external</externalDir>
<writeProtection>true</writeProtection>
<includeNamespace>false</includeNamespace>
<logResultingTree>false</logResultingTree>
<attributes>
<objectClass>objectClass</objectClass>
<guid>entryUUID</guid>
<organizationalUnit>
<objectClass>organizationalUnit</objectClass>
<name>name</name>
</organizationalUnit>
<group>
<objectClass>group</objectClass>
<name>name</name>
<member>member</member>
</group>
<user>
<objectClass>inetOrgPerson</objectClass>
<firstname>Gopi</firstname>
<lastname>Srinivasan</lastname>
<username>GSrinivasan</username>
<mail>Gopi.srinivasan@iss-shipping.com</mail>
</user>
<additional>

</additional>
</attributes>
</configuration>

eduardo · 2023-08-10 18:13:48

Hi kiranmaie,

pls open a new thread for unrelated questions. LDAP and RS not starting are two completely different topics.

Regards,
Eduardo

ReportServer Forum

#1 2023-08-01 12:51:56

The requested URL was not found on this server on report server linux

#2 2023-08-01 16:59:57

Re: The requested URL was not found on this server on report server linux

#3 2023-08-02 09:22:50

Re: The requested URL was not found on this server on report server linux

#4 2023-08-02 16:35:16

Re: The requested URL was not found on this server on report server linux

#5 2023-08-03 05:43:35

Re: The requested URL was not found on this server on report server linux

#6 2023-08-03 12:37:32

Re: The requested URL was not found on this server on report server linux

#7 2023-08-03 12:47:08

Re: The requested URL was not found on this server on report server linux

#8 2023-08-03 22:42:16

Re: The requested URL was not found on this server on report server linux

#9 2023-08-04 12:57:11

Re: The requested URL was not found on this server on report server linux

#10 2023-08-07 17:25:32

Re: The requested URL was not found on this server on report server linux

#11 2023-08-10 07:53:35

Re: The requested URL was not found on this server on report server linux

#12 2023-08-10 18:13:48

Re: The requested URL was not found on this server on report server linux

Board footer