Unable to connect Microsoft azure Mysql database

Arvind5 years ago

i am trying to install Traccar with Microsoft azure managed mysql database. when i created localhost mysql database it is working fine but as i tried to connect with Azure mysql database wich is remote mysql. it failed to load service. here is error:

● traccar.service - traccar
   Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Thu 2019-06-13 12:37:43 UTC; 1s ago
  Process: 21610 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FAILURE)
 Main PID: 21610 (code=exited, status=1/FAILURE)

Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
Jun 13 12:37:43 gpsvm traccar[21610]:         at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2046)
Jun 13 12:37:43 gpsvm traccar[21610]:         ... 22 more
Jun 13 12:37:43 gpsvm systemd[1]: traccar.service: Main process exited, code=exited, status=1/FAILURE
Jun 13 12:37:43 gpsvm systemd[1]: traccar.service: Failed with result 'exit-code'.
Arvind5 years ago

I solved the problem
Thanks Anton for this project