Qnap Traccar Server

Hi,

I have a Qnap TS-470-RP server.
I have Traccar 3.4 working on it without any problems.
The database is on MySQL on the same server.

When I try to upgrade to 3.5 or 3.6 it will not work.
It seems that the database is not updating and is read-only.

Can someone help out please?

Mitch

How are you updating it? How did you determine that it's read-only? And why is it read-only?

Hi Anton,

thank you for your reply.

I did the update "on-the-top-of-the-old-one".
I downloaded the "traccar_3.5_x86.qpkg" and the traccar_3.6_x86.qpkg file from the QNAP forum, like I did with version 3.4: https://forum.qnap.com/viewtopic.php?t=109928

As I told earlier, Traccar version 3.3 and 3.4 are working fine.
The problem started with the new folder "groups", I think.
The database in MySql is of cause not read only, but behaves like that. This means that when I put a new device, user, or group in it, I get a pop up with a mistake. I do not see any reason why, because I tried with a new database, and I used the database that worked with 3.4.

I tried now with a brand new database, and when I want to add a new group I get this reply:

Table 'gpsdb3.groups' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:435 < DataManager:463 < GroupResource:59 < ...)
And in fact, there is no table "groups" in the database.
And when I add a new user in it, I get this one:
Unknown column 'groupId' in 'field list' - MySQLSyntaxErrorException (... < QueryBuilder:435 < DataManager:389 < DeviceResource:60 < ...)

I thought that Traccar is adding all tables and fields itself into the database.

And one more thing: when I try to change for example the standart Traccar user (admin), and I give new values in, I do not see any changes after aknowledgement. In the database no values has been changed.

What can I do?

Thanks for you help!

Mitch

Just one more thing: I did the MySql changes like described here:
https://www.traccar.org/mysql/

It worked fine for version 3.4.
It connects with these values to the database in 3.6. It adds the same tables like for 3.4, but no more.
And new changements in Traccar are accepted like changements in "Server", but it does not write into the database.
When I edit it manually in the database, no problem, it is showing up in Traccar with the new values.

Thank you

Mitch

What you are using is not an official package, so I would recommend to contact author. I guess it doesn't update database schema properly.

If you want to update database manually, you can take a look at changelogs:

https://github.com/tananaev/traccar/tree/master/schema

Hi Anton,
it seems that the problem is in version 3.5 and 3.6 itself, exactly in the creation of the tables in the database.
And I do not know why, but I tried to get closer to a solution.

1. I tried to install Traccar 3.6 as a windows 64 bit installation on a windows 10.
   No problems when I use the H2 build-in database.

2. The problem starts when I try to connect this (the same) windows installation to a MySql database.
   It behaves like a in a qnap installation. There is a connection to the database, and the tables are installed, but only the ones like in version 3.4.

3. I tried to run then from a windows 7 and windows 10 system and to connect Traccar then to a MySql database.
   Same issue. The tables are installed like for version 3.4, but no further tables (like"groups", etc) needed in 3.5 or 3.6..

4. Then I tried the same thing with a binding to a Postgres database.
   Same issue. The tables are installed, but only the tables needed until version 3.4.

5. All toghether the behavior was the same in a windows installation and a Qnap installation.

So, my conclusion: since version 3.5 it is not possible to install Traccar to a MySql database nor on a Postgres database.
It works only on a H2 database so far since version 3.5.
It shows in the database that there is only the changelog until version 3.3.

Does it help for you to find a solution to this problem?

Regards

Mitch

That's nonsense. I have 4 demo servers that all run latest Traccar with MySQL database. Many other people also use MySQL setup without any issues.

Hi Anton,

so what do you propose now as a next step?
Or what have I done wrong to have this problem even on different systems?

Thank you for helping me!
(I like Traccar, and I need it to show in my blog where my crew and I are sailing at the moment...)

Mitch

I can take a look at your Windows installation. I guess you are doing something wrong there.

Let's try another way to solve the problem.

There must be a problem in updating the database.

I have a brand new Traccar version 3.6 installed in a fresh database.
In the DATABASECHANGELOG I see in the last row "changelog-3.3".
I think I should read here "changelog-3.6"?

Traccar seams to work find beside the missing tables in the database, and MySQL seam to work fine as well as I have no problems with other application.

What could be the problem here?
And is there another possibility to update in an automatic way the database and the tables of Traccar?

Thank you for your help!

Mitch

I guess the problem is missing database changelog files.

FOUND THE SOLUTION!!!

It is as simple as it can be:
In the conf traccar.xml or on the port IP-Adress:12542 you have to change

<entry key='database.changelog'>/opt/traccar/data/db.changelog-master.xml</entry>
by
<entry key='database.changelog'>/opt/traccar/schema/changelog-master.xml</entry>

It was the location of the master changelog!!!

Now version 3.6 works fine, without any issues.
All tables in MySql are in, no missing. The changelog shows now 3,3, 3,5 and 3.6.

The only thing that needs improvement is the Traccar mod here:
http://traccar.litvak.su/installation.html
It seems that there are problems to work with Traccar version 3.6.
The server has difficulties to write back the configuration.
And there is a "time out session" problem after 1 minute or so.
But no rush, I will find out myself.

Best

Mitch

The Litvak's mod is another unofficial project. I'm sure author will update instructions to work with version 3.6, but I would recommend to stick with official version.

Hi, can anyone explain how to install traccar server and run it on Qnap Server. Short instruction would be very nice !

I think the forum link in earlier comment would be the best place to look for this information.