Problem upgrading from 3.17 to 4.3

Juan Márquez5 years ago

Hi Anton,

I have carefully read documentation to upgrade the Traccar version of my server. But as the table names changed from 4.1 version, I mean in my actual version they look like: users, devices, positions, ... but in the 4.3 version, they have changed to: tc_users, tc_devices, tc_positions

I have a problem when trying to login, as system tells me that table 'users' doesn't exist, that is obvious because the table now is tc_users. So system keeps associating old tables to the new version. How can I fix this, in order to call the right tables?

Thanks.

Anton Tananaev5 years ago

Obviously you haven't followed the steps correctly. Have you upgraded default.xml config file?

Juan Márquez5 years ago

What do you mean by upgrading? I am using the one that was generated through installation.

Here are some message logs:

2019-02-26 23:48:28  INFO: Successfully released change log lock
2019-02-26 23:48:28  INFO: Logging initialized @14713ms to org.eclipse.jetty.util.log.Slf4jLog
2019-02-26 23:48:29  INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will always be preferred to avoid potential system instability.
2019-02-26 23:48:31  INFO: Operating system name: Linux version: 2.6.32-042stab127.2 architecture: amd64
2019-02-26 23:48:31  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 11.0.2-ojdkbuild+9
2019-02-26 23:48:31  INFO: Memory limit heap: 1024mb non-heap: 0mb
2019-02-26 23:48:31  INFO: Character encoding: ANSI_X3.4-1968 charset: US-ASCII
2019-02-26 23:48:31  INFO: Version: 4.3-SNAPSHOT
2019-02-26 23:48:31  INFO: Starting server...
2019-02-26 23:48:31  WARN: Failed to find a usable hardware address from the network interfaces; using random bytes: 37:a2:db:20:88:6a:e5:2c
2019-02-26 23:48:31  INFO: jetty-9.4.14.v20181114; built: 2018-11-14T21:20:31.478Z; git: c4550056e785fb5665914545889f21dc136ad9e6; jvm 11.0.2-ojdkbuild+9
2019-02-26 23:48:32  INFO: Started o.t.w.@7c5f29c6{/,null,AVAILABLE}
2019-02-26 23:48:32  INFO: DefaultSessionIdManager workerName=node0
2019-02-26 23:48:32  INFO: No SessionScavenger set, using defaults
2019-02-26 23:48:32  INFO: node0 Scavenging every 660000ms
2019-02-26 23:48:35  INFO: Started o.e.j.s.ServletContextHandler@5d74507c{/,null,AVAILABLE}
2019-02-26 23:48:35  INFO: Started ServerConnector@6574c029{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2019-02-26 23:48:35  INFO: Started @21463ms

Thanks for your help, system crashed, it doesn't event start traccar service.

Juan Márquez5 years ago
Anton Tananaev5 years ago

If you are using default config, it will never try to access users table, so something doesn't add up.

Juan Márquez5 years ago

How can I troubleshoot this? I tried installing many times, I rebooted server, I don't know what else do :'(

Ernesto Vallejo5 years ago

Hi, If you allow me access to your server I can help you out with it. I have migrated a few like this.

Juan Márquez5 years ago

Thanks Anton and Ernesto for your help. I made the upgrade from the manual installation file, just made a bash to start .jar from startup and that was the solution. If you want, give your email because I could need your help in the soon future.

Thanks.

Ernesto Vallejo5 years ago

good to know, if I can be of help please email me @ evallgar@hotmail.com or evallgar@gmail.com. Be glad to