Linux Installation Instructions

 
Author
Message
SysAider
1
 
Hi,
I have a trouble with installing SysAid,
I am using Tomcat 8 (TOMCAT_VERSION 8.0.39)
Oracle Java 8 (java version "1.8.0_111" Java(TM) SE Runtime Environment (build 1.8.0_111-b14))
and ubuntu 14.04

This is a clean install in a container, would you be able identify what the problem is? Thank you!

so far as I can see there are many duplicates error of :
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sysaid.schedule_task' doesn't exist

This is the last output when i run init-sysaid.sh


And this is the output of the log


SysAider
1
 
Hi,

We are facing connection problems.
We have made manual connection to mysql and it is running well
Any idea ?

Regards

Frederic

Checking connection....
initSysAid is initializing log4j
Initializing log4j with: /usr/share/tomcat/webapps/sysaid/WEB-INF/log4j.properties
log4j:WARN No appenders could be found for logger (com.ilient).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Mar 01, 2018 5:05:17 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'ilient'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:875)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1712)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:122
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:32
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:27
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:144)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
at com.ilient.sql.TomcatConnectionPool.getConnection(Unknown Source)
at com.ilient.server.DBConnection.getConn(Unknown Source)
at com.ilient.server.DBConnection.getConn(Unknown Source)
at com.ilient.server.CheckConf.setAndCheckConf(Unknown Source)
at com.ilient.server.CheckConf.main(Unknown Source)

Error while checking connection: Exception while checking configuration: Unknown database 'ilient'


SysAid Community Manager Product Team
4874
 
Hi Frederic,

Please contact our customer support team for further investigation.

Thanks,
Danny
SysAider
1
 
I'm having issue in installing SysAid

Validating license .....
initSysAid is initializing log4j
Initializing log4j with: /tomcat/sysaid/webapps/sysaid/WEB-INF/log4j.properties
log4j:WARN No appenders could be found for logger (com.ilient).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
FATAL:

# java -version
java version "10.0.1" 2018-04-17
Java(TM) SE Runtime Environment 18.3 (build 10.0.1+10)
Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10.0.1+10, mixed mode)

# uname -mrs
Linux 3.10.0-693.21.1.el7.x86_64 x86_64

Could you please guide me.