Problem upgrading from 3.17 to 4.3

Juan Márquez 7 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 Tananaev 7 years ago

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

Juan Márquez 7 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árquez 7 years ago
Anton Tananaev 7 years ago

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

Juan Márquez 7 years ago

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

Ernesto Vallejo 7 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árquez 7 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 Vallejo 7 years ago

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