how to put the tracer to record in an existing external MYSQL database.

Hello friends, I have a doubt, I already have a traccar running on a VPS UBUNTU server 20.04 machine and I would like to record in another external bank.

this model below did not smoke, I need help.
this model below did not smoke, I need help.

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql:http://222.222.222.22: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'>user</entry>
    <entry key='database.password'>senha</entry>
Anton Tananaev2 years ago

It should work as long your MySQL is accessible by that address. Check that MySQL is configured correctly and the port is open.

yes it is, I have another application running

just to clarify!

the traccar is in a machine and the bank in another machine

Anton Tananaev2 years ago
  1. What's the error you're getting?
  2. Have you tried using MySQL command line tool? Try and provide a screenshot.

this one showing this error in the tracer log

2022-12-18 20:46:59 ERROR: Main method error - Driver com.mysql.jdbc.Driver claims to not accept jdbcUrl, jdbc:mysql:http://222.222.22.22:3306/traccar?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode='' - RuntimeException (... < DataManager:130 < *:89 < Context:290 < Main:120 < ...)
Anton Tananaev2 years ago

Why do you have http there? Where did you get that URL from?