MySQL DB unreachable

Jose Miguel4 years ago

Hi,
I think that the docker container for unRaid is not working correctly. The main webpage cannot open and is flooding the log with this message:

2020-03-28 21:53:23  INFO: Operating system name: Linux version: 4.19.56-Unraid architecture: amd64
2020-03-28 21:53:23  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: IcedTea version: 25.212-b04
2020-03-28 21:53:23  INFO: Memory limit heap: 491mb non-heap: 0mb
2020-03-28 21:53:23  INFO: Character encoding: UTF-8 charset: UTF-8
2020-03-28 21:53:23  INFO: Version: 4.8
2020-03-28 21:53:23  INFO: Starting server...
2020-03-28 21:53:23  INFO: jetty-9.4.26.v20200117; built: 2020-01-17T12:35:33.676Z; git: 7b38981d25d14afb4a12ff1f2596756144edf695; jvm 1.8.0_212-b04
2020-03-28 21:53:23  INFO: Started o.t.w.@7a2fce12{/,null,AVAILABLE}
2020-03-28 21:53:23  INFO: DefaultSessionIdManager workerName=node0
2020-03-28 21:53:23  INFO: No SessionScavenger set, using defaults
2020-03-28 21:53:23  INFO: node0 Scavenging every 600000ms
2020-03-28 21:53:24  INFO: Started o.e.j.s.ServletContextHandler@446c8c72{/,null,AVAILABLE}
2020-03-28 21:53:24  INFO: Started ServerConnector@78525ef9{HTTP/1.1,[http/1.1]}{0.0.0.0:8082}
2020-03-28 21:53:24  INFO: Started @4892ms
2020-03-28 21:55:50  INFO: HikariPool-1 - Starting...
2020-03-28 21:55:50  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-03-28 21:56:02 ERROR: HikariPool-1 - Exception during pool initialization. - Host is unreachable (Host unreachable) - NoRouteToHostException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-03-28 21:56:02 ERROR: Main method error - Host is unreachable (Host unreachable) - NoRouteToHostException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-03-28 21:56:06  INFO: HikariPool-1 - Starting...
2020-03-28 21:56:06  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-03-28 21:56:19 ERROR: HikariPool-1 - Exception during pool initialization. - Host is unreachable (Host unreachable) - NoRouteToHostException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-03-28 21:56:19 ERROR: Main method error - Host is unreachable (Host unreachable) - NoRouteToHostException (... < DataManager:139 < *:89 < Context:292 < Main:110 < ...)
2020-03-28 21:56:23  INFO: HikariPool-1 - Starting..

I am trying to connect traccar with an mySQL database, and this is my traccar.xml file:

<?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>

    <!--

    This is the main configuration file. All your configuration parameters should be placed in this file.

    Default configuration parameters are located in the "default.xml" file. You should not modify it to avoid issues
    with upgrading to a new version. Parameters in the main config file override values in the default file. Do not
    remove "config.default" parameter from this file unless you know what you are doing.

    For list of available parameters see following page: https://www.traccar.org/configuration-file/

    -->
    <!--
    <entry key='database.driver'>org.h2.Driver</entry>
    <entry key='database.url'>jdbc:h2:./data/database</entry>
    <entry key='database.user'>sa</entry>
    <entry key='database.password'></entry>
    -->
    
    <entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry> 
    <entry key='database.url'>jdbc:mysql://192.168.1.200: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'>traccar</entry>

</properties>

Thanks in advance,
BR

chuflo3264 years ago

Hola esa IP (192.168.1.200) es de tu localhost?, o es otro host?

Jose Miguel4 years ago

Es otro host