Traccar 4.3 Server Problem with Raspberry Pi Zero

Hi Anton, thanks for your reply.

traccar logs read.

pi@raspberrypi:~ $ sudo cat /opt/traccar/logs/tracker-server.log
2021-04-07 00:00:05 ERROR: Main method error - Could not acquire change log lock.  Currently locked by 192.168.1.14 (192.168.1.14) since 4/6/21 9:19 AM - LockException (... < DataManager:310 < *:90 < Context:299 < Main:137 < ...)
2021-04-07 00:00:28  INFO: HikariPool-1 - Starting...
2021-04-07 00:00:33  INFO: HikariPool-1 - Start completed.
2021-04-07 00:00:45  INFO: Clearing database change log checksums
2021-04-07 00:00:47  INFO: Waiting for changelog lock....
2021-04-07 00:00:57  INFO: Waiting for changelog lock....
2021-04-07 00:01:07  INFO: Waiting for changelog lock....
2021-04-07 00:01:17  INFO: Waiting for changelog lock....
2021-04-07 00:01:27  INFO: Waiting for changelog lock....
2021-04-07 00:01:37  INFO: Waiting for changelog lock....
2021-04-07 00:01:47  INFO: Waiting for changelog lock....
2021-04-07 00:01:57  INFO: Waiting for changelog lock....
2021-04-07 00:02:07  INFO: Waiting for changelog lock....
2021-04-07 00:02:17  INFO: Waiting for changelog lock....
2021-04-07 00:02:27  INFO: Waiting for changelog lock....
2021-04-07 00:02:37  INFO: Waiting for changelog lock....
2021-04-07 00:02:47  INFO: Waiting for changelog lock....

not too sure what to make of that.

Regards
Dean

Use search.

Ok so ive found

update DATABASECHANGELOGLOCK
set locked = 0

However, im not sure how to execute this command.

Do I need to execute it from within mysql?

Thanks, im a n00b

Depends on what database you are using.

Cool, going to be one of those situations where im tracing my tail with errors. Deleted both my .db files and restarted traccar with the following error

2021-04-07 00:56:29  INFO: Marking ChangeSet: changelog-3.16::changelog-3.16::author ran despite precondition failure due to onFail='MARK_RAN':                                   ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-3.17::changelog-3.3-admin::author ran despite precondition failure due to onFail='MARK_RAN':                              ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-3.17::changelog-3.17::author ran despite precondition failure due to onFail='MARK_RAN':                                   ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-4.0::changelog-4.0-pre::author ran despite precondition failure due to onFail='MARK_RAN':                                 ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-4.0::changelog-4.0-common::author ran despite precondition failure due to onFail='MARK_RAN':                              ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-4.0::changelog-4.0-pg::author ran despite precondition failure due to onFail='MARK_RAN':                                  ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-4.0::changelog-4.0::author ran despite precondition failure due to onFail='MARK_RAN':                                     ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-4.0::changelog-4.0-renaming::author ran despite precondition failure due to onFail='MARK_RAN':                            ./schema/changelog-master.xml : Not precondition failed
2021-04-07 00:56:30  INFO: Marking ChangeSet: changelog-4.1::changelog-4.1-mssql::author ran despite preconditio

Question, do I need mysql installed?

Thanks

Ok I can get the server running and web server up by running

java -jar tracker-server.jar conf/traccar.xml

I assume we can use gpsd with traccar