can not see Real time movement on web interface traccar version 3.7

bjoseph7 years ago

hi Anton,

I have a challenge here, i have installed traccar v3.9, now instead of using a standard HS database , am using mysql database. I went into /opt/traccar/conf/traccar.xml and changed the configurations to the ones below, of course using my username, password and database name.

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://[127.0.0.1]:3306/[DATABASE]?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>[USER]</entry> 
<entry key='database.password'>[PASSWORD]</entry>

when i run the traccar server v3.9 is starts perfectly, but the Web UI doest open.
NOTE. when i revert back to the standard HS database everything works fine including the Web UI and adding tracers, accounts.
PROBLEM IS WHEN AM USING TRACCAR SERVER V3.9 with mysql database nothing works.

I will appreciate for your advice.

Thanks in advance.

Anton Tananaev7 years ago

If you have a problem, you should always check logs.

bjoseph7 years ago

Hello Anton,

regarding traccar server v 3.9 mysql error

java.sql.SQLException: Access denied for user 'user1'@'localhost' (using password: NO)

HAVE CREATED A NEW USER AND GRANTED PRIVILEGES STILL ACCESS DENIED.
PLEASE SEE THE LOGS BELOW. AM REALLY STACK.

INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2163)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2088)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:508)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  ... 12 more
INFO|2499/0|Service traccar|17-04-28 14:03:06|Caused by: java.sql.SQLException: Access denied for user 'user2'@'localhost' (using password: NO)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
INFO|2499/0|Service traccar|17-04-28 14:03:06|  ... 26 more
INFO|wrapper|Service traccar|17-04-28 14:03:06|waitpid 2499 59136
INFO|wrapper|Service traccar|17-04-28 14:03:06|exit code posix process: 59136 application: 0

Thanks in advance

Anton Tananaev7 years ago

The problem is still the same. You haven't properly configured user access.

bjoseph7 years ago

thanks Anton let me look carefully will update you.