Hi evere body.
I installed traccar 3.5 on my linux vps and it works fine.
When I had to move my database from old server to another server I encountered a problem.
after I installed traccar 3.5 database table created then pid is displayed on the screen.
but it does not work.
this is tracker log file content.
2017-07-12 15:42:05 INFO: Operating system name: Linux version: 2.6.32-642.11.1.el6.x86_64 architecture: amd64
2017-07-12 15:42:05 INFO: Java runtime name: Java HotSpot(TM) 64-Bit Server VM vendor: Oracle Corporation version: 25.131-b11
2017-07-12 15:42:05 INFO: Memory limit heap: 530mb non-heap: 0mb
2017-07-12 15:42:05 INFO: Character encoding: UTF-8 charset: UTF-8
2017-07-12 15:42:05 INFO: Version: 3.5-SNAPSHOT
2017-07-12 15:42:07 INFO: Starting server...
wrapper file
STATUS | wrapper | 2017/07/12 15:42:04 | --> Wrapper Started as Daemon
STATUS | wrapper | 2017/07/12 15:42:04 | Java Service Wrapper Community Edition 64-bit 3.5.28
STATUS | wrapper | 2017/07/12 15:42:04 | Copyright (C) 1999-2016 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper | 2017/07/12 15:42:04 | http://wrapper.tanukisoftware.com
STATUS | wrapper | 2017/07/12 15:42:04 |
STATUS | wrapper | 2017/07/12 15:42:05 | Launching a JVM...
INFO | jvm 1 | 2017/07/12 15:42:05 | WrapperManager: Initializing...
INFO | jvm 1 | 2017/07/12 15:42:05 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
INFO | jvm 1 | 2017/07/12 15:42:05 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
INFO | jvm 1 | 2017/07/12 15:42:06 | INFO 7/12/17 3:42 PM: liquibase: Clearing database change log checksums
INFO | jvm 1 | 2017/07/12 15:42:06 | INFO 7/12/17 3:42 PM: liquibase: Successfully acquired change log lock
INFO | jvm 1 | 2017/07/12 15:42:06 | INFO 7/12/17 3:42 PM: liquibase: Creating database history table with name: tona_gps.DATABASECHANGELOG
INFO | jvm 1 | 2017/07/12 15:42:06 | INFO 7/12/17 3:42 PM: liquibase: Successfully released change log lock
INFO | jvm 1 | 2017/07/12 15:42:06 | INFO 7/12/17 3:42 PM: liquibase: Successfully acquired change log lock
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: Reading from tona_gps.DATABASECHANGELOG
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Table users created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Unique constraint added to users(email)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Table devices created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Unique constraint added to devices(uniqueid)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Table user_device created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Foreign key constraint added to user_device (userid)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Foreign key constraint added to user_device (deviceid)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Index user_device_user_id created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Table positions created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Foreign key constraint added to positions (deviceid)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Index position_deviceid_fixtime created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: Table server created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: New row inserted into server
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: New row inserted into users
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author: ChangeSet /opt/traccar/data/changelog-3.3.xml::changelog-3.3::author ran successfully in 110ms
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Table groups created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Table user_group created
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Foreign key constraint added to user_group (userid)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Foreign key constraint added to user_group (groupid)
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Columns groupid(INT) added to devices
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Column users.language dropped
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Column server.language dropped
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Null constraint dropped from users.map
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Default value dropped from users.map
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Null constraint dropped from users.distanceunit
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Default value dropped from users.distanceunit
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Null constraint dropped from users.speedunit
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Default value dropped from users.speedunit
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Columns twelvehourformat(BOOLEAN) added to users
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: Columns twelvehourformat(BOOLEAN) added to server
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: /opt/traccar/data/changelog-master.xml: /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author: ChangeSet /opt/traccar/data/changelog-3.5.xml::changelog-3.5::author ran successfully in 257ms
INFO | jvm 1 | 2017/07/12 15:42:07 | INFO 7/12/17 3:42 PM: liquibase: Successfully released change log lock
INFO | jvm 1 | 2017/07/12 15:42:07 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1j817v9pf4dgrzg9iam1|1e6af1b, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1j817v9pf4dgrzg9iam1|1e6af1b, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/tona_gps?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode='', maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
INFO | jvm 1 | 2017/07/12 15:42:07 | [WrapperSimpleAppMain] INFO org.eclipse.jetty.util.log - Logging initialized @2365ms
INFO | jvm 1 | 2017/07/12 15:42:07 | [WrapperSimpleAppMain] INFO org.eclipse.jetty.server.Server - jetty-9.2.15.v20160210
INFO | jvm 1 | 2017/07/12 15:42:08 | [WrapperSimpleAppMain] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@3fcc7e69{/api,null,AVAILABLE}
INFO | jvm 1 | 2017/07/12 15:42:08 | [WrapperSimpleAppMain] INFO org.eclipse.jetty.server.ServerConnector - Started ServerConnector@15022515{HTTP/1.1}{0.0.0.0:8082}
INFO | jvm 1 | 2017/07/12 15:42:08 | [WrapperSimpleAppMain] INFO org.eclipse.jetty.server.Server - Started @3207ms
I'd appreciate you if you can help me.
Hi evere body.
I installed traccar 3.5 on my linux vps and it works fine.
When I had to move my database from old server to another server I encountered a problem.
after I installed traccar 3.5 database table created then pid is displayed on the screen.
but it does not work.
this is tracker log file content.
wrapper file
I'd appreciate you if you can help me.