SRV_TRACCAR
Co je to TRACAR?
Traccar is a free and open source modern GPS tracking system.
Převzato z: https://www.traccar.org
Odkazy ke studiu:
Návod na instalaci
Prerekvizity: Mít nainstalovaný SQL server návod například zde: https://intranet.rs-kovarik.cz/srv_sql_traccar
1) Založíme nový LXC container
dle tohoto návodu: https://intranet.rs-kovarik.cz/srvtemplate Místo SRV_TEMPLATE zadat jméno SRV_TRACCAR
2) Připojíme se k serveru přes terminál
ssh připojení k Turiisu a pak přes lxc-attach
Příkazy:
lxc-attach SRV_TRACCAR
3) Instalace Java
Příkazy:
apt update
apt install default-jdk
4) Stažení a rozbalení instalačního souboru pro Traccar
Příkazy:
wget https://github.com/traccar/traccar/releases/download/v4.6/traccar-linux-arm-4.6.zip -O traccar.zip
unzip traccar.zip
5) Instalace
Příkazy:
./traccar.run
6) Konfigurace
V souboru /opt/traccar/conf/traccar.xml nastavíme připojení k databázi.
nano /opt/traccar/conf/traccar.xml
Příklad konfigurace může vypadat následovně:
<?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'>9090</entry>
<!--
This is the main configuration file. All your configuration parameters should be placed in this file.
Default configuration parameters are located in the "default.xml" file. You should not modify it to avoid issues
with upgrading to a new version. Parameters in the main config file override values in the default file. Do not
remove "config.default" parameter from this file unless you know what you are doing.
For list of available parameters see following page: https://www.traccar.org/configuration-file/
-->
<!--
<entry key='database.driver'>org.h2.Driver</entry>
<entry key='database.url'>jdbc:h2:./data/database</entry>
<entry key='database.user'>sa</entry>
<entry key='database.password'></entry>
-->
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://IP_SQL_SERVER:3306/traccar?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>USERNAME</entry>
<entry key='database.password'>PASSWORD</entry>
<entry key='mail.smtp.host'>smtp.server.cz</entry>
<entry key='mail.smtp.port'>465</entry>
<entry key='mail.smtp.ssl.enable'>true</entry>
<entry key='mail.smtp.from'>traccar@rs-kovarik.cz</entry>
<entry key='mail.smtp.auth'>true</entry>
<entry key='mail.smtp.username'>traccar@rs-kovarik.cz</entry>
<entry key='mail.smtp.password'>password</entry>
<entry key='geocoder.enable'>true</entry>
<entry key='geocoder.type'>google</entry>
<entry key='geocoder.key'>google_key</entry>
<entry key='notificator.types'>web,mail,firebase</entry>
<entry key='notificator.firebase.key'>firebase_key</entry>
<entry key='web.url'>gps.rs-kovarik.cz</entry>
7) Crontab
Příkazy:
crontab -e
vložíme tam úlohu po rebootu
@reboot java -jar /opt/traccar/tracker-server.jar /opt/traccar/conf/traccar.xml
Uložíme crontab a restartujeme server.
8) GUI
Po restartu je traccar dostupný na http://your_ip:9090.
Můžeme jej zpřístupnit ven přes proxy server, který jem zpracovával zde: https://intranet.rs-kovarik.cz/srv_proxy96279
9) Traccar SQL nastavení pro české znaky
Příkazy:
mysql -uroot
ALTER DATABASE traccar CHARACTER SET utf8 COLLATE utf8_czech_ci;
use traccar;
ALTER TABLE tc_calendars CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_commands CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_device_attribute CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_device_command CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_device_driver CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_device_geofence CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_device_maintenance CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_device_notification CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_devices CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_drivers CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_events CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_geofences CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_group_attribute CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_attributes CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_group_command CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_group_driver CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_group_geofence CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_group_maintenance CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_group_notification CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_maintenances CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_notifications CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_positions CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_servers CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_statistics CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_attribute CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_calendar CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_command CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_device CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_driver CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_geofence CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_group CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_maintenance CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_notification CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_user_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;
ALTER TABLE tc_users CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;