Traccar Site Can't be reached Error on AWS and Mysql

I have installed Traccar on AWS running ubuntu and mysql. With default database (h2) connection it runs smooth.

Problem starts when I want to use mysql database :

My database config for mysql looks like this:

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://ec2-18-221-87-200.us-east-2.compute.amazonaws.com:3306/dbname?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>usrname</entry> 
<entry key='database.password'>passwrd</entry>

When i save the changes and restart tracccar I get;
WARNING: traccar may have failed to start.

Part of My Log file looks like:

STATUS | wrapper  | 2017/09/21 13:12:07 | Launching a JVM...
INFO   | jvm 1    | 2017/09/21 13:12:07 | WrapperManager: Initializing...
INFO   | jvm 1    | 2017/09/21 13:12:08 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
INFO   | jvm 1    | 2017/09/21 13:12:08 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.1 [built 16-June-2015 00:06:36 -0700; debug? true; trace: 10]
INFO   | jvm 1    | 2017/09/21 13:12:08 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1br9tip9q19nt9t2wx92h2|4d7437d8, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1br9tip9q19nt9t2wx92h2|4d7437d8, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/akili?useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode='', maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp: 
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"user" (
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error:         id INT PRIMARY KEY AUTO_INCREMENT,
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error:         name VARCHAR(128) NO' at line 1
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.getInstance(Util.java:383)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at org.traccar.database.QueryBuilder.executeUpdate(QueryBuilder.java:412)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:181)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.<init>(DataManager.java:64)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at org.traccar.Context.init(Context.java:98)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at org.traccar.Main.main(Main.java:26)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at java.lang.reflect.Method.invoke(Method.java:498)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2017/09/21 13:12:09 | WrapperSimpleApp Error: 	at java.lang.Thread.run(Thread.java:748)
STATUS | wrapper  | 2017/09/21 13:12:11 | <-- Wrapper Stopped
STATUS | wrapper  | 2017/09/21 13:14:34 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2017/09/21 13:14:34 | Java Service Wrapper Community Edition 64-bit 3.5.26
STATUS | wrapper  | 2017/09/21 13:14:34 |   Copyright (C) 1999-2014 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2017/09/21 13:14:34 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2017/09/21 13:14:34 | 
STATUS | wrapper  | 2017/09/21 13:14:34 | Launching a JVM...
INFO   | jvm 1    | 2017/09/21 13:14:34 | WrapperManager: Initializing...
INFO   | jvm 1    | 2017/09/21 13:14:35 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
INFO   | jvm 1    | 2017/09/21 13:14:35 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.1 [built 16-June-2015 00:06:36 -0700; debug? true; trace: 10]
INFO   | jvm 1    | 2017/09/21 13:14:35 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1br9tip9q19nwf5buithiw|4d7437d8, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1br9tip9q19nwf5buithiw|4d7437d8, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/akili?useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode='', maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp: 
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"user" (
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error:         id INT PRIMARY KEY AUTO_INCREMENT,
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error:         name VARCHAR(128) NO' at line 1
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.getInstance(Util.java:383)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at org.traccar.database.QueryBuilder.executeUpdate(QueryBuilder.java:412)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:181)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.<init>(DataManager.java:64)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at org.traccar.Context.init(Context.java:98)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at org.traccar.Main.main(Main.java:26)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at java.lang.reflect.Method.invoke(Method.java:498)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2017/09/21 13:14:35 | WrapperSimpleApp Error: 	at java.lang.Thread.run(Thread.java:748)
STATUS | wrapper  | 2017/09/21 13:14:37 | <-- Wrapper Stopped
STATUS | wrapper  | 2017/09/21 13:15:29 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2017/09/21 13:15:29 | Java Service Wrapper Community Edition 64-bit 3.5.26
STATUS | wrapper  | 2017/09/21 13:15:29 |   Copyright (C) 1999-2014 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2017/09/21 13:15:29 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2017/09/21 13:15:29 | 
STATUS | wrapper  | 2017/09/21 13:15:29 | Launching a JVM...
INFO   | jvm 1    | 2017/09/21 13:15:29 | WrapperManager: Initializing...
INFO   | jvm 1    | 2017/09/21 13:15:30 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
INFO   | jvm 1    | 2017/09/21 13:15:30 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.1 [built 16-June-2015 00:06:36 -0700; debug? true; trace: 10]
INFO   | jvm 1    | 2017/09/21 13:15:30 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1br9tip9q19nxlhbsn4ph|24a0b5d4, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1br9tip9q19nxlhbsn4ph|24a0b5d4, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/akili?useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode='', maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp: 
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"user" (
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error:         id INT PRIMARY KEY AUTO_INCREMENT,
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error:         name VARCHAR(128) NO' at line 1
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.Util.getInstance(Util.java:383)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at org.traccar.database.QueryBuilder.executeUpdate(QueryBuilder.java:412)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:181)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.<init>(DataManager.java:64)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at org.traccar.Context.init(Context.java:98)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at org.traccar.Main.main(Main.java:26)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at java.lang.reflect.Method.invoke(Method.java:498)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2017/09/21 13:15:30 | WrapperSimpleApp Error: 	at java.lang.Thread.run(Thread.java:748)
STATUS | wrapper  | 2017/09/21 13:15:32 | <-- Wrapper Stopped

I have port 3306 open by the way.
So,
What am I doing wrong?Help please

Anton Tananaev8 years ago

Looks like you are using some ancient version of Traccar. You need to upgrade.

Ommy Jay8 years ago

Okay, so I did the upgrade to version 3.13, am getting:
Problem accessing /. Reason:

 Could not initialize class java.nio.file.FileSystems$DefaultFileSystemHolder

My Log file:

INFO|wrapper|Service traccar|17-09-22 08:38:31|exit code posix process: 59136 application: 0
WARNING|wrapper|Service traccar|17-09-22 08:38:48|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-09-22 08:38:48|OS   : Linux/4.4.0-1022-aws/amd64
WARNING|wrapper|Service traccar|17-09-22 08:38:48|JVM  : Oracle Corporation/1.8.0_131//usr/lib/jvm/java-8-openjdk-amd64/jre/64
INFO|wrapper|Service traccar|17-09-22 08:38:48|exec:"java" "-classpath" "/opt/traccar/wrapperApp.jar:/opt/traccar/tracker-server.jar:/opt/traccar/lib/log4j-1.2.17.jar:/opt/traccar/lib/joda-time-2.9.9.jar:/opt/traccar/lib/h2-1.4.196.jar:/opt/traccar/lib/mysql-connector-java-5.1.42.jar:/opt/traccar/lib/postgresql-42.1.1.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.0.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.12.jar:/opt/traccar/lib/slf4j-api-1.7.21.jar:/opt/traccar/lib/netty-3.10.6.Final.jar:/opt/traccar/lib/async-http-client-1.9.40.jar:/opt/traccar/lib/slf4j-simple-1.7.25.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.22.v20170606.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-io-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-security-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-webapp-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-xml-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-jndi-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-util-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-server-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-common-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-api-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jersey-container-servlet-2.25.1.jar:/opt/traccar/lib/jersey-container-servlet-core-2.25.1.jar:/opt/traccar/lib/javax.inject-2.5.0-b32.jar:/opt/traccar/lib/jersey-common-2.25.1.jar:/opt/traccar/lib/javax.annotation-api-1.2.jar:/opt/traccar/lib/jersey-guava-2.25.1.jar:/opt/traccar/lib/hk2-api-2.5.0-b32.jar:/opt/traccar/lib/hk2-utils-2.5.0-b32.jar:/opt/traccar/lib/aopalliance-repackaged-2.5.0-b32.jar:/opt/traccar/lib/hk2-locator-2.5.0-b32.jar:/opt/traccar/lib/javassist-3.20.0-GA.jar:/opt/traccar/lib/osgi-resource-locator-1.0.1.jar:/opt/traccar/lib/jersey-server-2.25.1.jar:/opt/traccar/lib/jersey-client-2.25.1.jar:/opt/traccar/lib/jersey-media-jaxb-2.25.1.jar:/opt/traccar/lib/validation-api-1.1.0.Final.jar:/opt/traccar/lib/javax.ws.rs-api-2.0.1.jar:/opt/traccar/lib/jersey-media-json-jackson-2.25.1.jar:/opt/traccar/lib/jersey-entity-filtering-2.25.1.jar:/opt/traccar/lib/jackson-jaxrs-base-2.8.4.jar:/opt/traccar/lib/jackson-core-2.8.4.jar:/opt/traccar/lib/jackson-databind-2.8.4.jar:/opt/traccar/lib/jackson-jaxrs-json-provider-2.8.4.jar:/opt/traccar/lib/jackson-module-jaxb-annotations-2.8.4.jar:/opt/traccar/lib/jackson-annotations-2.8.4.jar:/opt/traccar/lib/liquibase-core-3.5.3.jar:/opt/traccar/lib/snakeyaml-1.17.jar:/opt/traccar/lib/mail-1.4.7.jar:/opt/traccar/lib/activation-1.1.jar:/opt/traccar/lib/jxls-2.4.0.jar:/opt/traccar/lib/commons-jexl-2.1.1.jar:/opt/traccar/lib/commons-beanutils-1.9.2.jar:/opt/traccar/lib/jcl-over-slf4j-1.7.12.jar:/opt/traccar/lib/logback-core-1.1.3.jar:/opt/traccar/lib/jxls-poi-1.0.12.jar:/opt/traccar/lib/poi-3.14.jar:/opt/traccar/lib/poi-ooxml-3.14.jar:/opt/traccar/lib/poi-ooxml-schemas-3.14.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.03.jar:/opt/traccar/lib/velocity-1.7.jar:/opt/traccar/lib/commons-collections-3.2.1.jar:/opt/traccar/lib/commons-lang-2.4.jar:/opt/traccar/lib/velocity-tools-2.0.jar:/opt/traccar/lib/commons-digester-1.8.jar:/opt/traccar/lib/commons-chain-1.1.jar:/opt/traccar/lib/commons-logging-1.1.jar:/opt/traccar/lib/servlet-api-2.3.jar:/opt/traccar/lib/commons-validator-1.3.1.jar:/opt/traccar/lib/dom4j-1.1.jar:/opt/traccar/lib/oro-2.0.8.jar:/opt/traccar/lib/sslext-1.2-0.jar:/opt/traccar/lib/struts-core-1.3.8.jar:/opt/traccar/lib/antlr-2.7.2.jar:/opt/traccar/lib/struts-taglib-1.3.8.jar:/opt/traccar/lib/struts-tiles-1.3.8.jar:/opt/traccar/lib/ical4j-2.0.0.jar:/opt/traccar/lib/commons-collections4-4.0.jar:/opt/traccar/lib/groovy-all-2.3.2.jar:/opt/traccar/lib/bndlib-2.3.0.jar:/opt/traccar/lib/org.osgi.core-4.3.1.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/ch-smpp-5.0.9.jar:/opt/traccar/lib/ch-commons-util-6.0.2.jar:/opt/traccar/lib/ch-commons-charset-3.0.2.jar" "-Dfile.encoding=UTF-8" "-Xrs" "-Dwrapper.service=true" "-Dwrapper.console.visible=false" "-Dwrapper.port=15003" "-Dwrapper.key=-7930075055823660205" "-Dwrapper.teeName=-7930075055823660205$1506069528010" "-Dwrapper.tmp.path=/opt/traccar/tmp" "-Djna_tmpdir=/opt/traccar/tmp" "-Dwrapper.config=/opt/traccar/conf/wrapper.conf" "-Dwrapper.visible=false" "-Dwrapper.pidfile=/run/wrapper.traccar.pid" "org.rzo.yajsw.app.WrapperJVMMain" 
INFO|wrapper|Service traccar|17-09-22 08:38:48|posix_spawn pid 23824
INFO|wrapper|Service traccar|17-09-22 08:38:48|started process 23824
INFO|wrapper|Service traccar|17-09-22 08:38:48|started process with pid 23824
INFO|23824/0|Service traccar|17-09-22 08:38:49|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|23824/0|Service traccar|17-09-22 08:38:50|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|23824/0|Service traccar|17-09-22 08:38:50|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|23824/0|Service traccar|17-09-22 08:38:51|INFO 9/22/17 8:38 AM: liquibase: Clearing database change log checksums
INFO|23824/0|Service traccar|17-09-22 08:38:51|INFO 9/22/17 8:38 AM: liquibase: Successfully acquired change log lock
INFO|23824/0|Service traccar|17-09-22 08:38:51|INFO 9/22/17 8:38 AM: liquibase: Successfully released change log lock
INFO|23824/0|Service traccar|17-09-22 08:38:51|INFO 9/22/17 8:38 AM: liquibase: Successfully acquired change log lock
INFO|23824/0|Service traccar|17-09-22 08:38:53|INFO 9/22/17 8:38 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|23824/0|Service traccar|17-09-22 08:38:53|INFO 9/22/17 8:38 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO|23824/0|Service traccar|17-09-22 08:38:53|INFO 9/22/17 8:38 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8-dropuniquetoken::author: Change set changelog-3.8::changelog-3.8-dropuniquetoken::author failed, but failOnError was false.  Error: Constraint "UK_USER_TOKEN" not found; SQL statement:
INFO|23824/0|Service traccar|17-09-22 08:38:53|ALTER TABLE PUBLIC.users DROP CONSTRAINT uk_user_token [90057-196] [Failed SQL: ALTER TABLE PUBLIC.users DROP CONSTRAINT uk_user_token]
INFO|23824/0|Service traccar|17-09-22 08:38:53|INFO 9/22/17 8:38 AM: liquibase: Successfully released change log lock
INFO|23824/0|Service traccar|17-09-22 08:38:53|[main] INFO org.eclipse.jetty.util.log - Logging initialized @5313ms
INFO|23824/0|Service traccar|17-09-22 08:38:54|java.lang.reflect.InvocationTargetException
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|23824/0|Service traccar|17-09-22 08:38:54|Caused by: org.jboss.netty.channel.ChannelException: Failed to bind to: 0.0.0.0/0.0.0.0:5044
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.bootstrap.ServerBootstrap.bind(ServerBootstrap.java:272)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.traccar.TrackerServer.start(TrackerServer.java:117)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.traccar.ServerManager.start(ServerManager.java:81)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.traccar.Main.main(Main.java:38)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	... 6 more
INFO|23824/0|Service traccar|17-09-22 08:38:54|Caused by: java.net.BindException: Address already in use
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.nio.ch.Net.bind0(Native Method)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.nio.ch.Net.bind(Net.java:433)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.nio.ch.Net.bind(Net.java:425)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.channel.socket.nio.NioServerBoss$RegisterTask.run(NioServerBoss.java:193)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.channel.socket.nio.AbstractNioSelector.processTaskQueue(AbstractNioSelector.java:391)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:315)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.channel.socket.nio.NioServerBoss.run(NioServerBoss.java:42)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
INFO|23824/0|Service traccar|17-09-22 08:38:54|	at java.lang.Thread.run(Thread.java:748)
INFO|wrapper|Service traccar|17-09-22 08:38:55|waitpid 23824 59136
INFO|wrapper|Service traccar|17-09-22 08:38:55|exit code posix process: 59136 application: 0

Anton Tananaev8 years ago

You have a port conflict with some other process in the system. Port is 5044.

Ommy Jay8 years ago

So, I fixed the port...thanks! But the problem is still there...works smooth with h2 database but when I switch to mysql db site cant be reached.

Here is mysql db connection:

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://18.221.87.200:3306/dbname?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>usrnam</entry> 
<entry key='database.password'>password</entry>

And My Log looks:

INFO|wrapper|Service traccar|17-09-22 10:45:37|posix_spawn pid 26931
INFO|wrapper|Service traccar|17-09-22 10:45:37|started process 26931
INFO|wrapper|Service traccar|17-09-22 10:45:37|started process with pid 26931
INFO|26931/0|Service traccar|17-09-22 10:45:38|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|26931/0|Service traccar|17-09-22 10:45:39|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|26931/0|Service traccar|17-09-22 10:45:44|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|26931/0|Service traccar|17-09-22 10:45:44|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2029)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.database.DataManager.initDatabase(DataManager.java:120)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.Context.init(Context.java:221)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.Main.main(Main.java:35)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|26931/0|Service traccar|17-09-22 10:45:44|Caused by: java.sql.SQLException: null,  message from server: "Host '18.221.87.200' is not allowed to connect to this MySQL server"
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2045)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	... 28 more
INFO|26931/0|Service traccar|17-09-22 10:45:44|java.lang.reflect.InvocationTargetException
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|26931/0|Service traccar|17-09-22 10:45:44|Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.database.DataManager.initDatabase(DataManager.java:120)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.database.DataManager.<init>(DataManager.java:75)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.Context.init(Context.java:221)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at org.traccar.Main.main(Main.java:35)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	... 6 more
INFO|26931/0|Service traccar|17-09-22 10:45:44|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2029)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	... 12 more
INFO|26931/0|Service traccar|17-09-22 10:45:44|Caused by: java.sql.SQLException: null,  message from server: "Host '18.221.87.200' is not allowed to connect to this MySQL server"
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
FINEST|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
FINEST|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194)
FINEST|26931/0|Service traccar|17-09-22 10:45:44|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2045)
FINEST|26931/0|Service traccar|17-09-22 10:45:44|	... 28 more
INFO|wrapper|Service traccar|17-09-22 10:45:45|waitpid 26931 59136
INFO|wrapper|Service traccar|17-09-22 10:45:45|exit code posix process: 59136 application: 0

Anton Tananaev8 years ago

The error is pretty clear. Traccar is not able to access the database using provide parameters. Please read log yourself before asking for help.

Ommy Jay8 years ago

Yeah, I see...it was a permission issue.Thanks for helping.