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&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&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...
Can you do a telnet to the sql server?
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.
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..
No problem ! Glad I was helpful. :)
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&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&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......