traccar tables in mysql

saikrupa20126 years ago

In this link given:
Configuration parameters for MySQL (replace [HOST], [DATABASE], [USER], [PASSWORD] with appropriate values; for local database use "localhost" as HOST):
so i changed traccar.xml as:

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

*Note! Traccar will create tables for you, but you need to create database with selected name by yourself. *

phpmyadmin link
y my test table still empty?

Anton Tananaev6 years ago

Have you checked logs?

saikrupa20126 years ago

using this : (https://www.traccar.org/linux/) started traccar .

[ec2-user@ip-172-31-33-114 ~]$ less /opt/traccar/logs

total 2048
drwxr-xr-x.  2 root root   4096 Feb  6 06:50 ./
drwxr-xr-x. 11 root root    200 Feb  5 13:26 ../
-rw-rw-rw-.  1 root root    832 Feb  6 07:28 tracker-server.log
-rw-r--r--.  1 root root   1563 Jan 19 20:41 tracker-server.log.20180119
-rw-r--r--.  1 root root   1142 Jan 22 17:07 tracker-server.log.20180122
-rw-r--r--.  1 root root  12355 Jan 23 06:47 tracker-server.log.20180123
-rw-r--r--.  1 root root 142045 Jan 24 23:59 tracker-server.log.20180124
-rw-r--r--.  1 root root 523514 Jan 25 23:59 tracker-server.log.20180125
-rw-r--r--.  1 root root 529457 Jan 26 23:59 tracker-server.log.20180126
-rw-r--r--.  1 root root 199925 Jan 27 23:00 tracker-server.log.20180127
-rw-r--r--.  1 root root   2241 Jan 28 17:09 tracker-server.log.20180128
-rw-r--r--.  1 root root   7322 Jan 29 23:52 tracker-server.log.20180129
-rw-r--r--.  1 root root 108566 Jan 30 22:04 tracker-server.log.20180130
-rw-r--r--.  1 root root  86149 Jan 31 22:25 tracker-server.log.20180131
-rw-r--r--.  1 root root  44396 Feb  1 23:59 tracker-server.log.20180201
-rw-r--r--.  1 root root 172025 Feb  2 23:42 tracker-server.log.20180202
-rw-r--r--.  1 root root  21295 Feb  3 23:05 tracker-server.log.20180203
-rw-r--r--.  1 root root 117545 Feb  4 20:50 tracker-server.log.20180204
-rw-r--r--.  1 root root    102 Feb  5 13:26 tracker-server.log.20180205
-rw-r--r--.  1 root root   3401 Jan 19 20:31 wrapper.log.20180119
-rw-r--r--.  1 root root   3872 Jan 23 06:33 wrapper.log.20180123
-rw-r--r--.  1 root root  17571 Jan 24 23:31 wrapper.log.20180124
-rw-r--r--.  1 root root   4301 Jan 25 22:15 wrapper.log.20180125
-rw-r--r--.  1 root root   1829 Jan 26 16:30 wrapper.log.20180126
-rw-r--r--.  1 root root    616 Jan 28 17:08 wrapper.log.20180128
-rw-r--r--.  1 root root    472 Feb  5 13:26 wrapper.log.20180205
-rw-rw-rw-.  1 root root  35694 Feb  6 07:28 wrapper.log.20180206
-rw-rw-rw-.  1 root root      0 Feb  6 07:28 wrapper.log.20180206.lck

which log to check and what is command on linux to check that log

saikrupa20126 years ago

checked log; wrapper.log.20180206

WARNING|wrapper|Service traccar|18-02-06 06:50:39|YAJSW: yajsw-stable-12.11
WARNING|wrapper|Service traccar|18-02-06 06:50:39|OS   : Linux/3.10.0-693.11.6.el7.x86_64/amd64
WARNING|wrapper|Service traccar|18-02-06 06:50:39|JVM  : Oracle Corporation/1.7.0_161//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.161-2.6.12.0.el7_4.x86_64/jre/64
INFO|wrapper|Service traccar|18-02-06 06:50:39|exec:/bin/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.45.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.2.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.13.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/jetty-proxy-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-client-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.2.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.13.jar:/opt/traccar/lib/poi-3.16.jar:/opt/traccar/lib/poi-ooxml-3.16.jar:/opt/traccar/lib/poi-ooxml-schemas-3.16.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.04.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/commons-collections4-4.1.jar:/opt/traccar/lib/ical4j-2.0.4.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/threetenbp-1.3.3.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=728507386917192121 -Dwrapper.teeName=728507386917192121$1517899839414 -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|18-02-06 06:50:39|posix_spawn pid 2381
INFO|wrapper|Service traccar|18-02-06 06:50:39|started process 2381
INFO|wrapper|Service traccar|18-02-06 06:50:39|started process with pid 2381
INFO|2381/0|Service traccar|18-02-06 06:50:41|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|2381/0|Service traccar|18-02-06 06:50:42|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|2381/0|Service traccar|18-02-06 06:50:47|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|2381/0|Service traccar|18-02-06 06:50:47|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.database.DataManager.initDatabase(DataManager.java:133)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.database.DataManager.<init>(DataManager.java:86)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.Context.init(Context.java:333)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.Main.main(Main.java:35)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at java.lang.reflect.Method.invoke(Method.java:606)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2381/0|Service traccar|18-02-06 06:50:47|Caused by: java.sql.SQLException: null,  message from server: "Host '18.218.198.78' is not allowed to connect to this MariaDB server"
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	... 28 more
INFO|2381/0|Service traccar|18-02-06 06:50:47|java.lang.reflect.InvocationTargetException
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at java.lang.reflect.Method.invoke(Method.java:606)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2381/0|Service traccar|18-02-06 06:50:47|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|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.database.DataManager.initDatabase(DataManager.java:133)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.database.DataManager.<init>(DataManager.java:86)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.Context.init(Context.java:333)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at org.traccar.Main.main(Main.java:35)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	... 6 more
INFO|2381/0|Service traccar|18-02-06 06:50:47|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	... 12 more
INFO|2381/0|Service traccar|18-02-06 06:50:47|Caused by: java.sql.SQLException: null,  message from server: "Host '18.218.198.78' is not allowed to connect to this MariaDB server"
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
FINEST|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
FINEST|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
FINEST|2381/0|Service traccar|18-02-06 06:50:47|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
FINEST|2381/0|Service traccar|18-02-06 06:50:47|	... 28 more
INFO|wrapper|Service traccar|18-02-06 06:50:47|waitpid 2381 59136
INFO|wrapper|Service traccar|18-02-06 06:50:47|exit code posix process: 59136 application: 231
WARNING|wrapper|Service traccar|18-02-06 07:28:24|YAJSW: yajsw-stable-12.11
WARNING|wrapper|Service traccar|18-02-06 07:28:24|OS   : Linux/3.10.0-693.11.6.el7.x86_64/amd64
WARNING|wrapper|Service traccar|18-02-06 07:28:24|JVM  : Oracle Corporation/1.7.0_161//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.161-2.6.12.0.el7_4.x86_64/jre/64
INFO|wrapper|Service traccar|18-02-06 07:28:25|exec:/bin/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.45.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.2.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.13.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/jetty-proxy-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-client-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.2.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.13.jar:/opt/traccar/lib/poi-3.16.jar:/opt/traccar/lib/poi-ooxml-3.16.jar:/opt/traccar/lib/poi-ooxml-schemas-3.16.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.04.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/commons-collections4-4.1.jar:/opt/traccar/lib/ical4j-2.0.4.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/threetenbp-1.3.3.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=-6184163415147162673 -Dwrapper.teeName=-6184163415147162673$1517902104948 -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|18-02-06 07:28:25|posix_spawn pid 2635
INFO|wrapper|Service traccar|18-02-06 07:28:25|started process 2635
INFO|wrapper|Service traccar|18-02-06 07:28:25|started process with pid 2635
INFO|2635/0|Service traccar|18-02-06 07:28:26|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|2635/0|Service traccar|18-02-06 07:28:27|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|2635/0|Service traccar|18-02-06 07:28:32|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|2635/0|Service traccar|18-02-06 07:28:32|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.database.DataManager.initDatabase(DataManager.java:133)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.database.DataManager.<init>(DataManager.java:86)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.Context.init(Context.java:333)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.Main.main(Main.java:35)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at java.lang.reflect.Method.invoke(Method.java:606)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2635/0|Service traccar|18-02-06 07:28:32|Caused by: java.sql.SQLException: null,  message from server: "Host '18.218.198.78' is not allowed to connect to this MariaDB server"
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	... 28 more
INFO|2635/0|Service traccar|18-02-06 07:28:32|java.lang.reflect.InvocationTargetException
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at java.lang.reflect.Method.invoke(Method.java:606)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2635/0|Service traccar|18-02-06 07:28:32|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|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.database.DataManager.initDatabase(DataManager.java:133)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.database.DataManager.<init>(DataManager.java:86)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.Context.init(Context.java:333)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at org.traccar.Main.main(Main.java:35)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	... 6 more
INFO|2635/0|Service traccar|18-02-06 07:28:32|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	... 12 more
INFO|2635/0|Service traccar|18-02-06 07:28:32|Caused by: java.sql.SQLException: null,  message from server: "Host '18.218.198.78' is not allowed to connect to this MariaDB server"
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
INFO|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
FINEST|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
FINEST|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
FINEST|2635/0|Service traccar|18-02-06 07:28:32|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
FINEST|2635/0|Service traccar|18-02-06 07:28:32|	... 28 more
INFO|wrapper|Service traccar|18-02-06 07:28:32|waitpid 2635 59136
INFO|wrapper|Service traccar|18-02-06 07:28:32|exit code posix process: 59136 application: 231
Anton Tananaev6 years ago

Have you tried reading logs before posting them here? The error is pretty clear.

saikrupa20126 years ago

sorry iam new to this...okay the i tried spotting error: "Host '18.218.198.78' is not allowed to connect to this MariaDB server". i will try with MySql server?

Anton Tananaev6 years ago

The problem is with your database permissions.

saikrupa20126 years ago

thanks anton!had to change the privileges .got it!:)