Docker install

Hi Anton!

For a small test, I want to setup a traccar installation in docker. A while ago you planned to switch to docker as the normal distribution, but later decided not to use docker. Will the docker still be updated or do you plan to stop that? Can we upgrade the docker to a new version if the docker image is updated? (Ofcourse will the database and config files be out of the docker container) but will the upgrade scripts work?

Thank you for your work and this awesome piece of software!

Anton Tananaev6 years ago

Docker is still supported and should be supported in future:

https://github.com/traccar/traccar-docker

Dev4 years ago

Hi Anton

I am trying to make image from dockerfile "https://github.com/dev1983/gps/blob/master/Dockerfile" modified for traccar.xml for mysql.
https://github.com/dev1983/gps/blob/master/traccar.xml.
created image from above ; https://hub.docker.com/repository/docker/dev1983/gps/traccar
i am using my mysql on diff pod : https://github.com/dev1983/gps/blob/master/mysql-traccar.yaml
But ... I getting error ;;;

master $ kubectl logs traccar-869c8df444-rn6ps
Exception in thread "main" java.lang.RuntimeException: liquibase.exception.DatabaseException: Table 'DATABASECHANGELOG'already exists [Failed SQL: (1050) CREATE TABLE mysql.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, `DESCRIPTION` VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL)]
        at org.traccar.Main.run(Main.java:152)
        at org.traccar.Main.main(Main.java:104)
Caused by: liquibase.exception.DatabaseException: Table 'DATABASECHANGELOG' already exists [Failed SQL: (1050) CREATE TABLE mysql.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, `DESCRIPTION` VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL)]
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:402)        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:59)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:131)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:111)
        at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:284)
        at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1232)
        at liquibase.Liquibase.clearCheckSums(Liquibase.java:1458)
        at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:310)
        at org.traccar.database.DataManager.<init>(DataManager.java:90)
        at org.traccar.Context.init(Context.java:292)
        at org.traccar.Main.run(Main.java:110)

Not able to under stand why I am getting this error; I deleted mysql db and recreated but same error..
Please help on it.

Regards
Dev