Postgres database config ignored

Mouhamed3 years ago

Hello, I'm trying to configure the server to use postgresql as database. I've provided the credentials in the traccar.xml file as shown in the docs.

    <entry key='database.driver'>org.postgresql.Driver</entry>
    <entry key='database.url'>jdbc:postgresql://localhost:5432/traccar</entry>
    <entry key='database.user'>postgres</entry>
    <entry key='database.password'>passer123</entry>

But the server log shows that it started with h2, and the postgres database itself is empty

    2022-12-01 19:08:36  INFO: HikariPool-1 - Starting...
    2022-12-01 19:08:37  INFO: HikariPool-1 - Added connection conn0: url=jdbc:h2:./target/database user=SA
    2022-12-01 19:08:37  INFO: HikariPool-1 - Start completed.

Thanks for your time

Anton Tananaev3 years ago

The database connection details are taken from the config file, so if you still get H2, it means it's still in the config. Maybe you forgot to save the file. Maybe you forgot to remove H2 from the config. Maybe you changed the wrong file. You need to double check everything carefully.

Mouhamed3 years ago

Forgot to mention I'm building from source and finally found out that debug.xml file was given as config file and passed traccar.xml by command line instead. It's working thanks a lot.