Problem with Traccar 3 and mysql

witul9 years ago

Hi,

new installation, traccar server 3.0, it's work.

The problem is with the use mysql database.
I add the device, but do not add GPS position.
Does not update positionId cell in a table device and not the following entry in the table positions.
With a database of H2 everything works well.

Please help me :(

Anton Tananaev9 years ago

Are there any errors in the log file (tracker-server.log)?

witul9 years ago
  1. rebasing of h2 for mysql
  2. restart the server
  3. login admin / admin
  4. Adding a device test with identifier 123456
  5. Configuration and launch client

Logs for these operations
http://wklej.se/14a1

edit:

Important!
after the restart service web interface is not working.
the client can not send data (connnection faild)
the logs do not see anything.

wrapper.log
http://wklej.se/5750

Anton Tananaev9 years ago

Looks like you removed database.checkTable parameter from the config. You need to put it back.

Also, try to disable reverse geocoder as there seems to be some problems with address value.

witul9 years ago

I have this conf:


<!-- DATABASE CONFIG -->
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://127.0.0.1:3306/gpstracker?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8</entry>
<entry key='database.user'>xxxxxx</entry>
<entry key='database.password'>yyyyyyyyyyyyyyyy</entry>
<entry key=’database.checkTable’>traccar</entry>

But not working

root@host:~# /opt/traccar/bin/traccar start
Starting traccar...
Waiting for traccar......
WARNING: traccar may have failed to start.

Geocoder works ok (if using the h2 database everything is ok)
But I switched off in case.

Anton Tananaev9 years ago

Check wrapper.log for more detailed information about the problem.

demian9 years ago

I had some problems with the version in master in mysql because the user table was quoted with double quotes ( " ). I had to change it to backticks ( ` ) (which seemed to work with h2 database also). Perhaps this is the problem here also.

I can send you a pull request tomorrow with that change if you like.

Anton Tananaev9 years ago

Double quotes is an SQL standard. MySQL supports it as well, you just need to enable ANSI_QUOTES.

See following page for more details:
https://www.traccar.org/mysql/