Using existing mysql database on new server
I put mysql credentials in traccar.xml and debug.xml. Tables are created successfully, everything is working fine but in logs this "Not precondition failed" message is showing up, is it a problem or not coz All is working fine....
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2019-10-31 12:20:54 INFO: HikariPool-1 - Starting...
2019-10-31 12:20:54 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2019-10-31 12:20:55 INFO: HikariPool-1 - Start completed.
2019-10-31 12:20:55 INFO: Clearing database change log checksums
2019-10-31 12:20:56 INFO: SELECT COUNT(*) FROM traccar.DATABASECHANGELOGLOCK
...
2019-10-31 12:22:16 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.0-renaming', 'author', 'changelog-4.0', NOW(), 27, '8:90aedfa378aa717f8d8ae541f97b87b2', 'renameTable newTableName=tc_attributes, oldTableName=attributes; renameTable newTableName=tc_calendars, oldTableName=calendars; renameTable newTableName=tc_commands, oldTableName=commands; renameTable newTableName=tc_device_attribute, oldTableName...', '', 'MARK_RAN', NULL, NULL, '3.8.0', '2504658470')
2019-10-31 12:22:16 INFO: Marking ChangeSet: changelog-4.1::changelog-4.1-mssql::author ran despite precondition failure due to onFail='MARK_RAN':
./schema/changelog-master.xml : DBMS Precondition failed: expected mssql, got mysql
2019-10-31 12:22:16 INFO: INSERT INTO traccar.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('changelog-4.1-mssql', 'author', 'changelog-4.1', NOW(), 28, '8:b148f52efe9c6a3e74a56e33e257a3e2', 'sql; sql; sql; sql', '', 'MARK_RAN', NULL, NULL, '3.8.0', '2504658470')
2019-10-31 12:22:16 INFO: Successfully released change log lock
2019-10-31 12:22:16 INFO: Logging initialized @82861ms to org.eclipse.jetty.util.log.Slf4jLog
2019-10-31 12:22:17 INFO: Operating system name: Linux version: 4.15.0-66-generic architecture: amd64
2019-10-31 12:22:17 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Private Build version: 25.222-b10
2019-10-31 12:22:17 INFO: Memory limit heap: 3541mb non-heap: 0mb
2019-10-31 12:22:17 INFO: Character encoding: UTF-8 charset: UTF-8
2019-10-31 12:22:17 INFO: Version: null
2019-10-31 12:22:17 INFO: Starting server...
2019-10-31 12:22:17 INFO: jetty-9.4.20.v20190813; built: 2019-08-13T21:28:18.144Z; git: 84700530e645e812b336747464d6fbbf370c9a20; jvm 1.8.0_222-8u222-b10-1ubuntu1~18.04.1-b10
2019-10-31 12:22:18 INFO: Started o.t.w.@3db663d0{/,null,AVAILABLE}
2019-10-31 12:22:18 INFO: DefaultSessionIdManager workerName=node0
2019-10-31 12:22:18 INFO: No SessionScavenger set, using defaults
2019-10-31 12:22:18 INFO: node0 Scavenging every 660000ms
2019-10-31 12:22:18 INFO: Started o.e.j.s.ServletContextHandler@363c32cc{/,null,AVAILABLE}
2019-10-31 12:22:18 INFO: Started ServerConnector@126be319{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2019-10-31 12:22:18 INFO: Started @84569ms
@Malkit:- we are facing same issue , can you please provide your email ID to discuss the solution.