got following errors in wrapper .log file

suraj shrestha7 years ago
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)


INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2038)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	... 28 more
INFO|wrapper|Service traccar|18-03-23 13:34:50|waitpid 28891 59136
INFO|wrapper|Service traccar|18-03-23 13:34:50|exit code posix process: 59136 application: 0
Anton Tananaev7 years ago

Why did you cut out part of the stack trace? In fact you removed the most important parts.

suraj shrestha7 years ago

freshly installed traccar and tried to configure in mysql database but it didnt worked .
the wrapper log shows:-

WARNING|wrapper|Service traccar|18-03-23 13:34:41|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|18-03-23 13:34:41|OS   : Linux/2.6.32-431.1.2.0.1.el6.x86_64/amd64
WARNING|wrapper|Service traccar|18-03-23 13:34:41|JVM  : Oracle Corporation/1.7.0_111//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.111.x86_64/jre/64
INFO|wrapper|Service traccar|18-03-23 13:34:42|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.44.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.1.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/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=4085695424612588087" "-Dwrapper.teeName=4085695424612588087$1521826481810" "-Dwrapper.tmp.path=/opt/traccar/tmp" "-Djna_tmpdir=/opt/traccar/tmp" "-Dwrapper.config=/opt/traccar/conf/wrapper.conf" "-Dwrapper.visible=false" "-Dwrapper.pidfile=/var/run/wrapper.traccar.pid" "org.rzo.yajsw.app.WrapperJVMMain" 
INFO|wrapper|Service traccar|18-03-23 13:34:42|posix_spawn pid 28891
INFO|wrapper|Service traccar|18-03-23 13:34:42|started process 28891
INFO|wrapper|Service traccar|18-03-23 13:34:42|started process with pid 28891
INFO|28891/0|Service traccar|18-03-23 13:34:43|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|28891/0|Service traccar|18-03-23 13:34:44|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|28891/0|Service traccar|18-03-23 13:34:49|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|28891/0|Service traccar|18-03-23 13:34:49|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2097)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2022)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.database.DataManager.initDatabase(DataManager.java:127)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.database.DataManager.<init>(DataManager.java:80)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.Context.init(Context.java:281)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.Main.main(Main.java:35)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at java.lang.reflect.Method.invoke(Method.java:606)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|28891/0|Service traccar|18-03-23 13:34:49|Caused by: java.sql.SQLException: Access denied for user 'nuzatechweb'@'127.0.0.1' (using password: YES)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2038)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	... 28 more
INFO|28891/0|Service traccar|18-03-23 13:34:49|java.lang.reflect.InvocationTargetException
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at java.lang.reflect.Method.invoke(Method.java:606)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|28891/0|Service traccar|18-03-23 13:34:49|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|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.database.DataManager.initDatabase(DataManager.java:127)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.database.DataManager.<init>(DataManager.java:80)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.Context.init(Context.java:281)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at org.traccar.Main.main(Main.java:35)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	... 6 more
INFO|28891/0|Service traccar|18-03-23 13:34:49|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2097)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2022)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	... 12 more
INFO|28891/0|Service traccar|18-03-23 13:34:49|Caused by: java.sql.SQLException: Access denied for user 'nuzatechweb'@'127.0.0.1' (using password: YES)
INFO|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2191)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2038)
FINEST|28891/0|Service traccar|18-03-23 13:34:49|	... 28 more
INFO|wrapper|Service traccar|18-03-23 13:34:50|waitpid 28891 59136
INFO|wrapper|Service traccar|18-03-23 13:34:50|exit code posix process: 59136 application: 0
Anton Tananaev7 years ago

Error messages are pretty self-explanatory:

Access denied for user 'nuzatechweb'@'127.0.0.1' (using password: YES)
suraj shrestha7 years ago

while accessing the database using same user it logs in

suraj shrestha7 years ago
<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>

<properties>

    <!--

    This is the main configuration file. All your configuration parameters should be placed in this file.

    Default configuration parameters are located in the "default.xml" file. You should not modify it to avoid issues
    with upgrading to a new version. Parameters in the main config file override values in the default file. Do not
    remove "config.default" parameter from this file unless you know what you are doing.

    For list of available parameters see following page: https://www.traccar.org/configuration-file/

    -->

   <!-- <entry key="config.default">./conf/default.xml</entry>

    <entry key='database.driver'>org.h2.Driver</entry>
    <entry key='database.url'>jdbc:h2:./data/database</entry>
    <entry key='database.user'>sa</entry>
    <entry key='database.password'></entry>
-->
<entry key="config.default">./conf/default.xml</entry>

   

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

**this what i have configured in traccar.xml file

Anton Tananaev7 years ago

Error message comes directly from your database. Your user doesn't have correct permissions.

suraj shrestha7 years ago

i have given all privileges to the respective user on the database so while login using the username and paswword i can easily access the database

Adam7 years ago

connect to your database and run...

use mysql;
select host, user from user where user = 'nuzatechweb';

I'm guessing that your user is only allowed from 'localhost' and the client is trying to connect from 127.0.0.1.. and they are not the same...