Can not log my position since 3.3
I also replace and add this to my conf file
<entry key='database.driver'>com.mysql.jdbc.Driver</entry> <entry key='database.url'>jdbc:mysql://127.0.0.1:3306/nametable?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=ANSI_QUOTES</entry> <entry key='database.user'>user</entry> <entry key='database.password'>pass</entry>
I also give the correct username, password and table
One more info,
I installed traccar then I modified the conf file for traccar web ui before lunching the web page.
(I have not install traccar 3.3, then lunch the page then install traccar web)
same problem for me .. if you find the solution ...
I drop the table positions, I stop and start traccar, refesh my page and now it's work.
Why should I drop the table positions to make it working?
Cheers
how drop you the table positions ?
have you a commande line ?
Kind regards
JuVeNaL
You need some database tool. If you are using default H2 database, you can use H2 console. The easier option is to remove whole database as a file if you don't have any valuable data there.
i did all but still same problem ... and nothing on the log file ...
Can you send me you traccar.xml file to compare ?
Kind regards
JuVeNaL
What do you mean by nothing? If the log is completely empty, it means server doesn't run at all. Then you need to check wrapper log file.
no i will say ..no error that show the issue
i find a error see here
2016-02-15 07:24:46 INFO: Memory limit heap: 58mb non-heap: 0mb
2016-02-15 07:24:46 INFO: Character encoding: UTF-8 charset: UTF-8
2016-02-15 07:24:46 INFO: Version: 3.2-SNAPSHOT
2016-02-15 07:25:25 WARN: Column "DEVICE_ID" not found; SQL statement:
SELECT id, protocol, device_id AS deviceId, serverTime, time AS deviceTime, time AS fixTime,
valid, latitude, longitude, altitude, speed, course, address, other AS attributes
FROM positions WHERE id IN (SELECT latestPosition_id FROM devices); [42122-190] - JdbcSQLException (... < QueryBuilder:61 < *:131 < DataManager:323 < ConnectionManager:55 < ...)
2016-02-15 07:25:27 INFO: Starting server...
2016-02-15 07:26:52 INFO: [3BC517D0] connected
2016-02-15 07:26:52 DEBUG: [3BC517D0: 8082 < 192.168.0.1] HEX: 474554202f3f69643d3737353930352674696d657374616d703d31343535353231323038266c61743d35302e3730383335333735266c6f6e3d342e31303630363138312673706565643d302e302662656172696e673d302e3026616c7469747564653d3131382e3026626174743d33342e3020485454502f312e310d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420352e302e313b20534d2d4e39313046204275696c642f4c5258323243290d0a486f73743a2076642d686f6d652e64796e646e732e6f72673a383038320d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a0d0a
2016-02-15 07:26:55 WARN: Unknown device - 775905 (192.168.0.1)
2016-02-15 07:27:34 INFO: [7B060194] connected
2016-02-15 07:27:34 DEBUG: [7B060194: 8082 < 192.168.0.1] HEX: 474554202f3f69643d3737353930352674696d657374616d703d31343535353231323038266c61743d35302e3730383335333735266c6f6e3d342e31303630363138312673706565643d302e302662656172696e673d302e3026616c7469747564653d3131382e3026626174743d33342e3020485454502f312e310d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420352e302e313b20534d2d4e39313046204275696c642f4c5258323243290d0a486f73743a2076642d686f6d652e64796e646e732e6f72673a383038320d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a0d0a
2016-02-15 07:27:34 WARN: Unknown device - 775905 (192.168.0.1)
2016-02-15 07:28:20 INFO: [0635B539] connected
what is the problem ?
Did you corretcly save your device with the Unique identifier?
it should be the EMEI.
i use the unique ID generated bu TRACCAR android ..
Thanks for you help .. i appreciate
Correct me if I am wrong, from your domaine http://your domaine.com:8082/
you have to create a devise. Edit it.
I would control that under the field 'Unique identifiy' the ID is the same than your unique ID generated...
It's how I did, excpeted I ma using my own module with a EMEI SIM card.
In my point of view it look like if you have wrongly create your devise on the web site
The only thin that i set as information is the name and "unique identify" that is generated by traccar android client .. i need to set other to test ?
My impression is that my traccar.xml file is not good
by this modification ... but i check .. and recheck i don't find what is miss ..
Can you copy the content of your traccar.xml to compare ?
Kind regards
JuVeNaL
Good day,
I update traccar 3.2 to 3.3 and I also installed traccar web ui.
I folowed that procedure
http://traccar.litvak.su/installation.html
For my traccar 3.3 I also applay the specification for 3.2 and I am not sure if I did it well.
Since when I copy past that URL
http://bipme.dyndns.org:5055/?id=865067020424381&valid=1&lat=46.201251&lon=6.102916&speed=2.41&altitude=434.03&heading=311.609985&batt=70&desc=GPS%20localisation×tamp=2016-02-14%2011:17:21
there is no new entrie in the positions table.
I check my log and I can see that message "WARN: Field 'deviceId' doesn't have a default value"
Here us my log:
Did I missed something?
Cheers