Help in installing SuiteCRM-Analytics

Greetings,

I am trying to install SuiteCRM Analytics using the below links:

  1. Data Integration - https://docs.suitecrm.com/admin/suitecrm-analytics/scrm-data-integration/
  2. Web Analytics - https://docs.suitecrm.com/admin/suitecrm-analytics/scrm-analytics/

It did get connected with mysql and all tables got created in the db.

When I try to run analytics on browser, it shows file structure instead of login page. I guess I missed something while installing.
Please help.

Below are server details:
OS - Ubuntu 18.04
PHP - 7.2.24
SuiteCRM - version 7.11.4

Thanks,
Shantanu Agnihotri

Hi,
Is there who can help?

Thanks,
Shantanu

@ivyis usually has the best advice!

Hi @ivyis,

Can you please help me with this issue?

Thanks.
Shantanu

Hi @sagnihotri

Im not sure what you mean when you say you are seeing the file structure. Can you screenshot what you mean please?

PFA

What happens if you go directly to the server? For example, http://YOUR IP:8080/suitecrmanalytics/ ? Also can you attached the tomcat/logs/catalina.out log

Here is what I get when I access the URL -

Below are the catalina.out logs -

Blockquote
NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
OpenJDK 64-Bit Server VM warning: Ignoring option MaxPermSize; support was removed in 8.0
11-Feb-2020 10:25:38.264 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.34
11-Feb-2020 10:25:38.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Sep 4 2018 22:28:22 UTC
11-Feb-2020 10:25:38.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.34.0
11-Feb-2020 10:25:38.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
11-Feb-2020 10:25:38.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.15.0-70-generic
11-Feb-2020 10:25:38.270 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
11-Feb-2020 10:25:38.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-11-openjdk-amd64
11-Feb-2020 10:25:38.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 11.0.6+10-post-Ubuntu-1ubuntu118.04.1
11-Feb-2020 10:25:38.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Ubuntu
11-Feb-2020 10:25:38.271 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /var/www/html/analytics_server/tomcat
11-Feb-2020 10:25:38.272 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /var/www/html/analytics_server/tomcat
11-Feb-2020 10:25:38.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
11-Feb-2020 10:25:38.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
11-Feb-2020 10:25:38.274 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
11-Feb-2020 10:25:38.275 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/var/www/html/analytics_server/tomcat/conf/logging.properties
11-Feb-2020 10:25:38.275 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
11-Feb-2020 10:25:38.275 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
11-Feb-2020 10:25:38.275 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
11-Feb-2020 10:25:38.276 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
11-Feb-2020 10:25:38.276 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms2048m
11-Feb-2020 10:25:38.276 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx6144m
11-Feb-2020 10:25:38.276 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m
11-Feb-2020 10:25:38.277 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.client.gcInterval=3600000
11-Feb-2020 10:25:38.277 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dsun.rmi.dgc.server.gcInterval=3600000
11-Feb-2020 10:25:38.277 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=utf8
11-Feb-2020 10:25:38.278 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -DDI_HOME=/var/www/html/analytics_server/pentaho-solutions/system/kettle
11-Feb-2020 10:25:38.278 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
11-Feb-2020 10:25:38.278 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/var/www/html/analytics_server/tomcat
11-Feb-2020 10:25:38.278 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/var/www/html/analytics_server/tomcat
11-Feb-2020 10:25:38.279 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/var/www/html/analytics_server/tomcat/temp
11-Feb-2020 10:25:38.279 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib]
11-Feb-2020 10:25:38.384 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“http-nio-8080”]
11-Feb-2020 10:25:38.410 SEVERE [main] org.apache.catalina.core.StandardService.initInternal Failed to initialize connector [Connector[HTTP/1.1-8080]]
org.apache.catalina.LifecycleException: Failed to initialize component [Connector[HTTP/1.1-8080]]
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:112)
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:552)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:875)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
at org.apache.catalina.startup.Catalina.load(Catalina.java:632)
at org.apache.catalina.startup.Catalina.load(Catalina.java:655)
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:309)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
Caused by: org.apache.catalina.LifecycleException: Protocol handler initialization failed
at org.apache.catalina.connector.Connector.initInternal(Connector.java:995)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
… 12 more
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:455)
at java.base/sun.nio.ch.Net.bind(Net.java:447)
at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:227)
at java.base/sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:80)
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:219)
at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1087)
at org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:265)
at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:581)
at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:68)
at org.apache.catalina.connector.Connector.initInternal(Connector.java:993)
… 13 more
11-Feb-2020 10:25:38.414 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“ajp-nio-8009”]
11-Feb-2020 10:25:38.418 SEVERE [main] org.apache.catalina.core.StandardService.initInternal Failed to initialize connector [Connector[AJP/1.3-8009]]
org.apache.catalina.LifecycleException: Failed to initialize component [Connector[AJP/1.3-8009]]
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:112)
at org.apache.catalina.core.StandardService.initInternal(StandardService.java:552)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:875)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
at org.apache.catalina.startup.Catalina.load(Catalina.java:632)
at org.apache.catalina.startup.Catalina.load(Catalina.java:655)
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:309)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:492)
Caused by: org.apache.catalina.LifecycleException: Protocol handler initialization failed
at org.apache.catalina.connector.Connector.initInternal(Connector.java:995)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:107)
… 12 more
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:455)
at java.base/sun.nio.ch.Net.bind(Net.java:447)
at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:227)
at java.base/sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:80)
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:219)
at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:1087)
at org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:265)
at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:581)
at org.apache.catalina.connector.Connector.initInternal(Connector.java:993)
… 13 more
11-Feb-2020 10:25:38.420 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1121 ms
11-Feb-2020 10:25:38.527 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
11-Feb-2020 10:25:38.527 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.34
11-Feb-2020 10:25:38.547 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/www/html/analytics_server/tomcat/webapps/pentaho-style]
11-Feb-2020 10:25:39.393 INFO [localhost-startStop-1] 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.
11-Feb-2020 10:25:39.456 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/var/www/html/analytics_server/tomcat/webapps/pentaho-style] has finished in [909] ms
11-Feb-2020 10:25:39.456 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/www/html/analytics_server/tomcat/webapps/sw-style]
11-Feb-2020 10:25:39.897 INFO [localhost-startStop-1] 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.
11-Feb-2020 10:25:39.901 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/var/www/html/analytics_server/tomcat/webapps/sw-style] has finished in [445] ms
11-Feb-2020 10:25:39.901 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/var/www/html/analytics_server/tomcat/webapps/suitecrmanalytics]
11-Feb-2020 10:25:39.909 WARNING [localhost-startStop-1] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property ‘docbase’ to ‘webapps/suitecrmanalytics/’ did not find a matching property.
11-Feb-2020 10:26:04.838 INFO [localhost-startStop-1] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = SuiteCRM Ignoring unknown property: value of “SuiteCRM” for “description” property
11-Feb-2020 10:26:05.101 INFO [localhost-startStop-1] 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.
[Server@6a7fc6fe]: [Thread[localhost-startStop-1,5,main]]: checkRunning(false) entered
[Server@6a7fc6fe]: [Thread[localhost-startStop-1,5,main]]: checkRunning(false) exited
[Server@6a7fc6fe]: Initiating startup sequence…
[Server@6a7fc6fe]: Server socket opened successfully in 29 ms.
[Server@6a7fc6fe]: [Thread[HSQLDB Server @6a7fc6fe,5,main]]: Database [index=0, db=file:…/…/data/hsqldb/quartz, alias=quartz] did not open: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@8b86e4f4[file =/var/www/html/analytics_server/data/hsqldb/quartz.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-02-11 10:26:15 heartbeat - read: -4124 ms.
[Server@6a7fc6fe]: [Thread[HSQLDB Server @6a7fc6fe,5,main]]: Database [index=1, db=file:…/…/data/hsqldb/hibernate, alias=hibernate] did not open: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@f11817c5[file =/var/www/html/analytics_server/data/hsqldb/hibernate.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2020-02-11 10:26:25 heartbeat - read: -4375 ms.

Looks like you’re running Java 11. The documentation states you need to use Java 8. Give that a try

Changing Java 11 to Java 8 did the trick. Thanks.

Glad you got it working

please help me with the SuiteCRM Web Analytics not able to open the using IP address issue