In the wizard, answer prompted questions as follows:Įnter current password for root (enter for none): ENTER Secure the installation of MariaDB: $ sudo mariadb-secure-installation Start the MariaDB service: $ sudo systemctl start rvice $ sudo add-apt-repository 'deb focal main' Use commands listed below to install MariaDB 10.6, the current stable version of MariaDB, on the Ubuntu 20.04 LTS system: $ sudo apt-get install software-properties-common dirmngr apt-transport-https -y Traccar needs to work with a Database Management System (DBMS), such as MariaDB, MySQL, or PostgreSQL. Having the server instance up and running again, log in as traccar from an SSH terminal for follow-on work.īe aware that the tasks mentioned above are for beginners only, and more security measures are at your discretion. Update and then restart the system: # apt update Set default firewall rules with UFW: # ufw default deny # echo 'traccar ALL=(ALL) NOPASSWD: ALL' tee -a /etc/sudoers.d/designated # echo '/swap none swap defaults 0 0' > /etc/fstabĬreate a normal user named traccar with sudo privileges: # useradd -ms /bin/bash traccar Log in to your server instance as root from an SSH terminal, and then perform basic tasks as follows to harden the system.Ĭreate a swap file: # fallocate -l 2g /swap Perform Basic Tasks on the Server Instance See detailed instructions on managing DNS through Vultr in this Vultr tutorial. To ease public access, you need to set up DNS records through your domain hosting service provider, pointing domain names (an apex domain name and one or more subdomain names) to the IPv4 address of your server.įor example, if you are hosting the apex domain name on Vultr, set up DNS records as follows to point and to the IPv4 address of your server in the DNS tab of the Vultr control panel: Entry #1 Say its public IPv4 address is 203.0.113.100.Ī registered domain name for public access. PrerequisitesĪ fresh Vultr Ubuntu 20.04 LTS server instance with at least 2GB of memory. This tutorial explains how to set up a Traccar server on a Vultr Ubuntu 20.04 LTS server instance in a production environment. Providing detailed device location history, map routes, and reports as required. Sending alerts via the web, email, and Short Message Service (SMS) when abnormal conditions are detected, and Tracking various types of GPS devices in real-time, INSERT INTO EventData VALUES UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, 0, :speed, :course, 0, '', 0, '', '', '', 0, 0, 0, '0000000001', UNIX_TIMESTAMP(NOW())) Ħ7111 Query /* mysql-connector-java-5.1.14 ( Revision: $ ) */SELECT Query SHOW COLLATIONĦ7111 Query SET character_set_results = NULLĦ7111 Query SET sql_mode='STRICT_TRANS_TABLES'Ĭentos 5.5 圆4, mysql-connector-java-5.1.14, mysql 5.0.Traccar is a free and open-source Global Positioning System (GPS) tracking system that is capable of: SELECT := accountID, := deviceID FROM Device WHERE imeiNumber = :device_id UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id device_id - Integer time - Date valid - Boolean latitude - Double longitude - Double speed - Double course - Double SELECT imeiNumber AS id, imeiNumber AS imei FROM Device WHERE imeiNumber <> ''jdbc:mysql://localhost/gts?allowMultiQueries=true gps id - Integer imei - String
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |