Traccar 4.1 and MariaDB

José Germán6 years ago

Hello Anton!
Is Traccar 4.1 compatible with mariadb 10.3.xx or 10.2.xx?
regards

Anton Tananaev6 years ago

I haven't tried, but I don't see why it wouldn't work.

José Germán6 years ago

OK thanks!
I will test and report the results

José Germán6 years ago

Results:
1.- I can not start traccar 4.1 with MariaDBx64 version (10.3.10 or 10.2.18)
Configurations used:
Alternative 1:

<entry key='config.default'>./conf/default.xml</entry>	
<entry key='database.driverFile'>./lib/mariadb-java-client-2.3.0.jar</entry>
<entry key='database.driver'>org.mariadb.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mariadb://127.0.0.1:3306/traccar?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>userDB</entry>
<entry key='database.password'>passwordDB</entry>

Alternative 2:

<entry key='config.default'>./conf/default.xml</entry>
<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>userDB</entry>
<entry key='database.password'>passwordDB</entry>

neither of them works!

2.- I tried using Mysql version 8.0.12.0. The server started and I added a couple of devices. It seemed to walk everything as it should, but the problem arose when I wanted to add a custom map .... for google maps it does not work.
Configurations used:

<entry key='config.default'>./conf/default.xml</entry>
<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>userDB</entry>

all right up here!

The problem: custom maps do not work
Parameters for Custom Map:
Map Layers: Custom Maps
Bing Maps key: my key xxxxx
Custom Map: https://mt0.google.com/vt/lyrs=m&hl=en&x={x}&y={y}&z={z}&s=Ga

Conclusion:
I will have to continue working with the previous versions

Anton Tananaev6 years ago

Both issues are already fixed in the code.

Peter Flower6 years ago

Hi Anton
Keeping in mind that with the 4.1 appears some bugs, are you going to upload a new release?

Best Regards
Peter

Anton Tananaev6 years ago

Yes, I plan to do next release in a couple of weeks, so we have a more polished stable version.