Sysaid-free installation error

 
Author
Message
SysAider
3
 
Hi guys,

Please help me out, I'm installing sysaid-free and I'm encountering these errors.

2017-10-20 14:42:11,857 [main] FATAL com.ilient - Exception in sql statement:
#
# Table structure for table `messages`
#

CREATE TABLE messages (
account_id varchar(32) NOT NULL default '',
user_name varchar(64) NOT NULL default '',
sent_time datetime NOT NULL default '0000-00-00 00:00:00',
sender varchar(64) default NULL,
recv_flag int(11) NOT NULL default '0',
msg mediumtext,
msgid varchar(64),
service_request_id int,
display_to_user char(1) default 'Y',
PRIMARY KEY (account_id,user_name,sent_time)
)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'sent_time'
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:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:97
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:161
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549)
at com.ilient.server.AccountMap.runScript(Unknown Source)
at com.ilient.server.AccountMap.newAccount(Unknown Source)
at com.ilient.server.InitAccount.initAccount(Unknown Source)
at com.ilient.server.InitAccount.main(Unknown Source)
2017-10-20 14:42:16,417 [main] ERROR com.ilient - Error on AccountMap
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ilient.schedule_task' doesn't exist
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:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:97
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:161
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549)
at com.ilient.server.AccountMap.newAccount(Unknown Source)
at com.ilient.server.InitAccount.initAccount(Unknown Source)
at com.ilient.server.InitAccount.main(Unknown Source)
2017-10-20 14:42:19,639 [SysAid TaskProcess] ERROR com.ilient - Exception
java.sql.SQLException: Driver:org.apache.derby.jdbc.ClientDriver@27130041 returned null for URL:jdbc:derby:default
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:296)
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.<init>(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.c.a.run(Unknown Source)

Hope you can help me guys, thanks!
SysAid Community Manager Product Team
4490
 
Hi gmb07,

Which version of SysAid are you trying to install? Is it for Windows or Linux?

Thanks,
Danny
SysAider
3
 
I'm installing sysaid_free v8.5 in ubuntu 16.04, thanks!

This message was edited 1 time. Last update was at Oct. 24, 2017 12:59 AM

SysAid Community Manager Product Team
4490
 
This is a highly outdated version of SysAid. I suggest downloading the latest Free version if possible, or even better - using Free Cloud. You can find those here.

Cheers,
Danny
SysAider
3
 
Sorry, my mistake it is not v8.5, it's v14.1 from the Install.txt. I just downloaded the new version last October 20. If use cloud sysaid, is it still free?

This message was edited 1 time. Last update was at Oct. 24, 2017 05:05 AM

SysAid Community Manager Product Team
4490
 
Correct. 14.1 is also not the latest version
SysAider
1
 
I have the same error, when I download from the link you posted though it gives me an .exe file rather than a one I can use for linux?