Traccar 4.1 and MariaDB

José Germán 7 years ago

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

Anton Tananaev 7 years ago

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

José Germán 7 years ago

OK thanks!
I will test and report the results

José Germán 7 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 Tananaev 7 years ago

Both issues are already fixed in the code.

Peter Flower 7 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 Tananaev 7 years ago

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