0 votes
1 view

Installed Knowage-7_2_16_CE on my Mac 10.15 laptop using local MySQL 8.0.23.  Install went fine and it created the knowage databases and tables in the local database.  However, when trying to log into go to localhost:8080/knowage I get a HTTP Status 404 - Not Found Page.

HTTP Status 404 – Not Found


Type Status Report

Message /knowage/jsp/spago/jspError.jsp

Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.


Apache Tomcat/8.5.43

In looking through the logs it looks like it cannot make a connection to the MySQL database.  The connection information in the server.xml file looks correct - it was the same connection information used by the installer to create the databases and tables to begin with.  The MySQL database is running.

Not sure how to troubleshoot this issue now.  Any suggestions?

Here is some additional information from the logs as well as the Java version on my Mac.

java version "1.8.0_181"

Java(TM) SE Runtime Environment (build 1.8.0_181-b13)

Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode)

Here are entries from the knowage.log file

[http-nio-8080-exec-7] 02 Feb 2021 06:46:38,675 ERROR it.eng.spagobi.commons.utilities.HibernateSessionManager.getDialect:169 - Error determining Hibernate's dialect

javax.naming.NamingException: Unexpected exception resolving reference [Root exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.]

    at org.apache.naming.NamingContext.lookup(NamingContext.java:856)

...   

    at java.lang.Thread.run(Thread.java:748)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

    at sun.reflect.GeneratedConstructorAccessor145.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

    ...

    at org.apache.naming.NamingContext.lookup(NamingContext.java:839)

    ... 55 more

Caused by: java.lang.NullPointerException

    at com.mysql.jdbc.ConnectionImpl.getServerCharset(ConnectionImpl.java:2983)

    at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1873)

...   

    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2265)

    ... 77 more

[http-nio-8080-exec-7] 02 Feb 2021 06:46:38,677 ERROR it.eng.spagobi.commons.MetadataDatabaseConfigurationRetriever.loadConfigurations:95 - Impossible to get configuration

java.lang.NullPointerException

    at java.util.Hashtable.put(Hashtable.java:460)

    at java.util.Properties.setProperty(Properties.java:166)

    at org.hibernate.cfg.Configuration.setProperty(Configuration.java:2081)

    at it.eng.spagobi.commons.utilities.HibernateSessionManager.determineDialect(HibernateSessionManager.java:131)

  ...

    at java.lang.Thread.run(Thread.java:748)

Here are the entries from the localhost.2021-02-02.log file:

Brads-MacBook-Pro Knowage-Server-CE % cat logs/localhost.2021-02-02.log

02-Feb-2021 04:38:19.073 INFO [localhost-startStop-11] org.apache.catalina.core.ApplicationContext.log ContextListener: contextInitialized()

02-Feb-2021 04:38:19.073 INFO [localhost-startStop-11] org.apache.catalina.core.ApplicationContext.log SessionListener: contextInitialized()

02-Feb-2021 04:38:19.074 INFO [localhost-startStop-11] org.apache.catalina.core.ApplicationContext.log ContextListener: attributeAdded('StockTicker', 'async.Stockticker@4fd5ab0a')

02-Feb-2021 04:38:43.346 INFO [localhost-startStop-9] org.apache.catalina.core.ApplicationContext.log QuartzInitializer: Quartz Initializer Servlet loaded, initializing Scheduler...

02-Feb-2021 04:38:43.357 INFO [localhost-startStop-9] org.apache.catalina.core.ApplicationContext.log QuartzInitializer: Quartz Scheduler failed to initialize: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'quartz': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/knowage' javax.naming.NamingException: Unexpected exception resolving reference [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/knowage' javax.naming.NamingException: Unexpected exception resolving reference]]

02-Feb-2021 04:38:43.357 SEVERE [localhost-startStop-9] org.apache.catalina.core.StandardContext.loadOnStartup Servlet [QuartzInitializer] in web application [/knowage] threw load() exception

    java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/knowage' javax.naming.NamingException: Unexpected exception resolving reference

        at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)

        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:662)

...       

        at java.lang.Thread.run(Thread.java:748)

02-Feb-2021 07:06:05.683 INFO [localhost-startStop-22] org.apache.catalina.core.ApplicationContext.log SessionListener: contextDestroyed()

02-Feb-2021 07:06:05.683 INFO [localhost-startStop-22] org.apache.catalina.core.ApplicationContext.log ContextListener: contextDestroyed()

Any help would be greatly appreciated.

Environment Knowage-7_2_16-CE-Installer-Unix, Mac OS 10.15, Tomcat 8.5.43, Chrome 88, MySQL 8.0.23
asked Feb 3, 2021 in Standard by bkarnafelsc (120 points) | 1 view
Hi,

did you check if the context.xml datasource link is correct according to this https://knowage-suite.readthedocs.io/en/7.2/installation-guide/manual-installation.html ?

It seems to be a context ds link name error.

Regards,

Matteo

Please log in or register to answer this question.

1,553 questions
1,017 answers
2,037 comments
2,567 users