Traccar Mysql

David3 years ago

Buenas tardes, tengo ubunto 20.04 instalado con Taccar.
Quiero cambiar la base de datos h2 a la mysql.
Para eso tengo instalada mysql 8.0.23
Genere un usuario traccar con permiso de root.
Cuando en el archivo de configuracion ¨Traccar` tengo la siguiente configuracion:

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key = 'database.url'> jdbc: mysql: // 127.0.0.1:3306/ traccar ? serverTimezone = UTC & amp; useSSL = false & amp; allowMultiQueries = true & amp; autoReconnect = true & amp; useUnicode = yes & amp; characterEncoding = UTF- 8 & amp; sessionVariables = sql_mode = '' </entry>
    <entry key = 'database.user'> traccar </entry>
    <entry key='database.password'> **** </entry>

Registro de error de database:

2021-03-23T19:19:15.045512Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-03-23T19:19:15.178059Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-03-23T19:19:15.249446Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-03-23T19:19:15.249624Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-03-23T19:19:15.275012Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23-0ubuntu0.20.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).

Registro de log traccar:

2021-03-22 23:06:19  INFO: Version: 4.11
2021-03-22 23:06:19  INFO: Starting server...
2021-03-22 23:06:20  INFO: jetty-9.4.33.v20201020; built: 2020-10-20T23:39:24.803Z; git: 1be68755656cef678b79a2ef1c2ebbca99e25420; jvm 11.0.8+10-LTS
2021-03-22 23:06:20  INFO: Started o.t.w.@527d48db{/,null,AVAILABLE}
2021-03-22 23:06:20  INFO: DefaultSessionIdManager workerName=node0
2021-03-22 23:06:20  INFO: No SessionScavenger set, using defaults
2021-03-22 23:06:20  INFO: node0 Scavenging every 600000ms
2021-03-22 23:06:21  INFO: Started o.e.j.s.ServletContextHandler@7bd7d71c{/,null,AVAILABLE}
2021-03-22 23:06:21  INFO: Started ServerConnector@23cbbd07{HTTP/1.1, (http/1.1)}{0.0.0.0:8082}
2021-03-22 23:06:21  INFO: Started @7335ms
2021-03-22 23:06:21  INFO: Health check enabled with period 480000

Que estoy haciendo mal ?

RichardG3 years ago

Was Traccar working with the default H2 database?

What's up with all the white space in your parameters?

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key = 'database.url'> jdbc: mysql: // 127.0.0.1:3306/ traccar ? serverTimezone = UTC & amp; useSSL = false & amp; allowMultiQueries = true & amp; autoReconnect = true & amp; useUnicode = yes & amp; characterEncoding = UTF- 8 & amp; sessionVariables = sql_mode = '' </entry>
    <entry key = 'database.user'> traccar </entry>
    <entry key='database.password'> **** </entry>
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://127.0.0.1:3306/traccar?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>****</entry>