facing problem when we use remote Mysql database

Satish verma5 years ago

Hi any one can help me..?

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>
<entry key="config.default">./conf/default.xml</entry>
 <entry key='web.port'>8082</entry>
<entry key='geocoder.enable'>false</entry>
<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://148.72.149.121: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'>xyz</entry> 
<entry key='database.password'>password</entry>
<entry key='server.timeout'>120</entry>
</properties>

error logs......

root@usve266861:/opt/traccar/conf# tail -f /opt/traccar/logs/tracker-server.log                                                                    2019-09-19 14:30:47  INFO: HikariPool-1 - Starting...
2019-09-19 14:32:23 ERROR: HikariPool-1 - Exception during pool initialization. - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - MySQLNonTransientConnectionException (... < DataManager:139 < *:89 < Context:382 < Main:110 < ...)
2019-09-19 14:32:23 ERROR: Main method error - Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up. - PoolInitializationException (... < DataManager:139 < *:89 < Context:382 < Main:110 < ...)
2019-09-19 14:32:41  INFO: HikariPool-1 - Starting...
2019-09-19 14:34:16 ERROR: HikariPool-1 - Exception during pool initialization. - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - MySQLNonTransientConnectionException (... < DataManager:139 < *:89 < Context:382 < Main:110 < ...)
2019-09-19 14:34:16 ERROR: Main method error - Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up. - PoolInitializationException (... < DataManager:139 < *:89 < Context:382 < Main:110 < ...)
2019-09-19 14:36:36  INFO: HikariPool-1 - Starting...
2019-09-19 14:38:12 ERROR: HikariPool-1 - Exception during pool initialization. - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - MySQLNonTransientConnectionException (... < DataManager:139 < *:89 < Context:382 < Main:110 < ...)
2019-09-19 14:38:12 ERROR: Main method error - Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up. - PoolInitializationException (... < DataManager:139 < *:89 < Context:382 < Main:110 < ...)
2019-09-19 14:41:20  INFO: HikariPool-1 - Starting...
Diego Marchesini5 years ago

Can you do a telnet to the sql server?

Omar Asim5 years ago

You sql database settings are invalid, please check them again.

Are you sure your database name is the IP you mentioned because usually it is localhost.

Check if traccar schema has been created.

Satish verma5 years ago

Yes! we not able to do telnet also with port 3306.
As per your hint we have checked our CSF and we got ( 3306 Port is not allow in CSF).

After allow port 3306 in CSF Remote mysql is working fine ...

Thanks for your quick support..

Omar Asim5 years ago

No problem ! Glad I was helpful. :)