Here is MysqL status:
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>
Active: active (running) since Sat 2022-08-20 05:49:29 UTC; 23h ago
Main PID: 3819 (mysqld)
Status: "Server is operational"
Tasks: 51 (limit: 2281)
Memory: 398.1M
CGroup: /system.slice/mysql.service
└─3819 /usr/sbin/mysqld
Aug 20 05:49:27 vps-a9965426 systemd[1]: Starting MySQL Community Server...
Aug 20 05:49:29 vps-a9965426 systemd[1]: Started MySQL Community Server.
Have you had older version of database with data before doing this?
Here the traccar properties file:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>
<entry key="config.default">./conf/default.xml</entry>
<entry key='web.port'>8082</entry>
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost/'THE DATABASE'?allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>'The USER'</entry>
<entry key='database.password'>'THE PASSEWORD'</entry>
</properties>
hi Rhamean!!
It is a new installation, the DB is empty
Hi dear Rick97160,
You need to create an empty database first and name it with something like 'TraccarDB', and the mysql user should have granted to the database.
if you don't mind i suggest you to set these configs first:
create database TraccarDB;
create user 'trackuser'@'localhost' identified with mysql_native_password by 'Password#123';
grant all privileges on *.* to 'trackuser'@'localhost' with grant option;
flush privileges;
exit;
<!-- <entry key='database.driver'>org.h2.Driver</entry>-->
<!-- <entry key='database.url'>jdbc:h2:./target/database</entry>-->
<!-- <entry key='database.user'>sa</entry>-->
<!-- <entry key='database.password'></entry>-->
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost/TraccarDB?allowPublicKeyRetrieval=true&serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='web.enable'>true</entry>
<entry key='web.port'>8082</entry>
<entry key='database.user'>trackuser</entry>
<entry key='database.password'>Password#123</entry>
sudo systemctl stop traccar
sudo systemctl disable traccar
sudo rm /etc/systemd/system/traccar.service
sudo systemctl daemon-reload
sudo rm -R /opt/traccar
Now you are good to go to install again.
unfortunately some part of my reply is missing after submit, I write them again
...privileges on *.*
to 'trackuser'@...
and you need to disable or remove the lines as below in debug.xml file:
<entry key='database.driver'>org.h2.Driver</entry>
<entry key='database.url'>jdbc:h2:./target/database</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'></entry>
grant all privileges on [star].[star] to 'trackuser'@'localhost' with grant option;
Ok Thank you, i'll try and I come back to you...!!
Hi Rhamean,
I have a problem to test your advice...
I don't have the file : debug.xml !!!
You are right. Sorry it was my bad. I meant traccar.xml.
debug.xml is used for development of source code.
The path is here: /opt/traccar/conf/traccar.xml
Hi Rhamean, I tried what you advised me, still nothing....I can't launch traccar !!
Hello community!!!
I installed the latest version of traccar on ubuntu 20.04, but when launching the web page, my screen remains white..
If anyone can give me a hand, thank you!!
Here is the traccar log file: