Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can´t get GPS Data #520

Closed
Mindreader12345 opened this issue Feb 12, 2016 · 7 comments
Closed

Can´t get GPS Data #520

Mindreader12345 opened this issue Feb 12, 2016 · 7 comments

Comments

@Mindreader12345
Copy link

Hello,

anybody can help me to solve my Problem ?
I have Traccar 3.3 with Traccar web UI for Raspi 2.
Problem is: I receive Data from GPS but the Position doesn´t appear in Screen.
My Tracker Server Log:

2016-02-12 17:14:41 INFO: [59D7FB6A] connected
2016-02-12 17:14:41 DEBUG: [59D7FB6A: 5055 < 217.250.164.96] HEX: 474554202f3f69643d3335343433363035363838353639302674696d657374616d703d31343535323233393230266c61743d35322e3534323430323432266c6f6e3d31332e33393834383931392673706565643d302e302662656172696e673d302e3026616c7469747564653d3132322e3526626174743d34312e3020485454502f312e310d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420352e302e323b20485443204f6e65204275696c642f4c5258323247290d0a486f73743a206d696e647265616465722e64796e70632e6f72673a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a0d0a
2016-02-12 17:14:41 WARN: Table "DEVICE" not found; SQL statement:
SELECT * FROM device; [42102-190] - JdbcSQLException (... < QueryBuilder:61 < *:131 < DataManager:231 < *:122 < *:142 < BaseProtocolDecoder:47 < ...)
2016-02-12 17:15:25 INFO: [59D7FB6A] disconnected
2016-02-12 17:15:25 INFO: [EB05E743] disconnected

Anybody knows where the Problem is or can be !?

Thank you ...

@vitalidze
Copy link
Owner

Looks like you have updated configuration file incorrectly. Moreover for 3.3 please read #510 and #519

@gsiotas
Copy link
Contributor

gsiotas commented Feb 12, 2016

Have you followed the installation instructions from here: http://traccar.litvak.su/installation.html
From this Warning:

SELECT * FROM device; [42102-190] - JdbcSQLException (... < QueryBuilder:61 < *:131 < DataManager:231 < *:122 < *:142 < BaseProtocolDecoder:47 < ...)

I can see that you haven't correctly modified: traccar.xml

EDIT: Vitaly beat me! :)

@Mindreader12345
Copy link
Author

Now I have installed everything new.
I followed Instructions from http://traccar.litvak.su/installation.html.

Do I need to follow Instruction for

**4.1) Specific to v3.1 of traccar

download jetty-jndi-9.2.13.v20150730.jar and put it to the lib folder in traccar installation folder

Add following line to the service configuration file (located in conf/wrapper.conf of traccar installation folder):** 

too ???

Now my Server Log say:

2016-02-13 00:28:53  INFO: [7C78BDB1] connected
2016-02-13 00:28:53 DEBUG: [7C78BDB1: 5055 < 217.250.164.96] HEX: 474554202f3f69643d3335343433363035363838353639302674696d657374616d703d31343535333139373333266c61743d35322e3534323338323333266c6f6e3d31332e33393837373636332673706565643d302e302662656172696e673d302e3026616c7469747564653d39302e3539393939383437343132313126626174743d33342e3020485454502f312e310d0a557365722d4167656e743a2044616c76696b2f322e312e3020284c696e75783b20553b20416e64726f696420352e302e323b20485443204f6e65204275696c642f4c5258323247290d0a486f73743a206d696e647265616465722e64796e70632e6f72673a353035350d0a436f6e6e656374696f6e3a204b6565702d416c6976650d0a4163636570742d456e636f64696e673a20677a69700d0a0d0a
2016-02-13 00:28:53 DEBUG: [7C78BDB1: 5055 > 217.250.164.96] HEX: 485454502f312e3120323030204f4b0d0a0d0a
2016-02-13 00:28:53  INFO: [7C78BDB1] disconnected
2016-02-13 00:28:53  WARN: NULL not allowed for column "DEVICEID"; SQL statement:
INSERT INTO positions (device_id, protocol, serverTime, time, valid, latitude, longitude, altitude, speed, course, address, other)
    VALUES (?, ?, CURRENT_TIMESTAMP(), ?, ?, ?, ?, ?, ?, ?, ?, ?); [23502-190] - JdbcSQLException (... < QueryBuilder:431 < DataManager:307 < DefaultDataHandler:27 < ...)
2016-02-13 00:28:53  INFO: [7C78BDB1] id: 1, time: 2016-02-13 00:28:53, lat: 52.54238, lon: 13.39878, speed: 0.0, course: 0.0

@vitalidze
Copy link
Owner

Do I need to follow Instruction for

**4.1) Specific to v3.1 of traccar

No, you don't need it. It is for 3.1 version only.

Now my Server Log say:

For this one you should take solution from #510 and #519

@Mindreader12345
Copy link
Author

Sorry,
I try to take Solution from #510 and #519, but I don´t understand
"drop Positions table from database".

What or how should I do that and where ?

@vitalidze
Copy link
Owner

'drop' means delete that table. You need to connect to database somehow and run the DROP TABLE positions query. Another option is to delete the whole database and then let all tables to be re-created by the web UI mod.

@Mindreader12345
Copy link
Author

Ok, I think I have it.
Device is visible in traccar and it seems to be running.
Thank you very much Vitali.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants