INFO | jvm 1 | 7 11:38:29 | INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, odometerKM, heading, altitude, rawData, creationTime, address)
I really require an advice asap, my traccar service is running, but when im trying. => /opt/traccar/logs/tracker-server.log /opt/traccar/logs/wrapper.log.20140327 <= Everything looks good in logs as well, however when I try to access. VALUES UNIX_TIMESTAMP(:time), 0, :latitude, :longitude, :speed, :odometer, :course, :altitude, '', UNIX_TIMESTAMP(NOW()), :address) INSERT INTO EventData (accountID, deviceID, timestamp, statusCode, latitude, longitude, speedKPH, odometerKM, heading, altitude, rawData, creationTime, address) SELECT := accountID, := deviceID FROM Device WHERE imeiNumber = :device_id
#WHERE ARE THE TRACCAR LOGS UPDATE#
UPDATE Device SET lastValidLatitude = :latitude, lastValidLongitude = :longitude, lastGPSTimestamp = UNIX_TIMESTAMP(:time), lastUpdateTime = UNIX_TIMESTAMP(NOW()) WHERE imeiNumber = :device_id SELECT deviceID AS id, uniqueID AS imei FROM Device I tried to modify traccar.cfg and here is what it looks like Varies with device 500.000++ GPS Tracker & Mileage Log Varies with device. I need odometer values or distance travelled in opengts via traccar dcs. Vi /usr/local/etc/nginx/conf.d/Īccess_log /var/log/ Įrror_log /var/log/ have integrated opengts with traccar to use traccar as dcs server for Noran device. Include /usr/local/etc/nginx/conf.d/*.conf # Load config files from the /etc/nginx/conf.d directory log file for me while I have created the logs folder at the root. #* And strip down the config file and add the include statement at the end to make it easier to handle various server blocks: * Create a configuration directory to make managing individual server blocks easier Jdbc:mysql://127.0.0.1:3306/traccardb?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=ANSI_QUOTESĮcho 'traccar_enable="YES"' > /etc/rc.confĮcho 'nginx_enable="YES"' > /etc/rc.conf
#* And modify the database configuration: Vi /usr/local/www/traccar/conf/traccar.xml Sed -i '' -e 's/\/opt/\/usr\/local\/www/g' /usr/local/www/traccar/conf/traccar.xml Start_cmd="/usr/sbin/daemon -p $pidfile -u $traccar_user $command $command_args > $traccar_stdout 2> $traccar_stderr" Required_files="$traccar_root/conf/traccar.xml" : $Ĭommand_args="-jar $traccar_root/tracker-server.jar $traccar_root/conf/traccar.xml" # Add the following lines to /etc/rc.conf to enable `traccar': Sh n -noexec -target /usr/local/www/traccar GRANT ALL PRIVILEGES ON `traccardb`.* TO Then quit out of the mysql interface: #* And create the database traccardb and make the traccaruser the owner:ĬREATE DATABASE IF NOT EXISTS `traccardb` #* Then create the user traccaruser for the databaseĬREATE USER IDENTIFIED BY 'SuperSecretPassword' * Change the ownership of the traccar directory to traccar user:Ĭhown traccar:traccar /usr/local/www/traccarĮcho 'mysql_enable="YES"' > /etc/rc.conf Traccar is owned by Traccar Limited 5 and was founded in 2009. Pw useradd traccar -c Traccar -m -d /home/traccar -g traccar -s /bin/sh
#WHERE ARE THE TRACCAR LOGS INSTALL#
Pkg install openjdk-jre maven3 mysql-connector-java git unzip Updated by Daniel Curtis over 7 years ago This is a guide for installing the Traccar GPS tracking server on FreeBSD 9.
0 kommentar(er)
