Getting the error 'Alert: can't load Database Config' while opening TAC

Problem Description

The connection to TAC fails with the following error message:

WARN HibernatePersistenceAdapter - The database "jdbc:mysql://localhost:3306/talend_administrator?noDatetimeStringSync=true" is currently unreachable.

 

Solution

  1. Increase the wait_timeout variable in your MySQL database settings file, my.ini (Windows) or my.cnf (Linux). For example, in Linux modify the value in the /etc/my.cnf file with the following:
    wait_timeout=2814400
  2. Then restart the MySQL database.
  3. Add the hibernate properties in MySQL-Default master and staging in the Talend MDM database settings file jboss-4.2.2.GA\bin\datasources.xml, as follows:
    <datasource name="MySQL-Default"> 
    <master> 
    <type>RDBMS</type> 
    <rdbms-configuration>
    ... 
    <properties> 
    <property name="connection.autoReconnect">true</property> 
    <property name="connection.autoReconnectForPools">true</property> 
    <property name="connection.is-connection-validation-required">true</property> 
    <property name="hibernate.c3p0.acquire_increment">1</property> 
    <property name="hibernate.c3p0.idle_test_period">0</property> 
    <property name="hibernate.c3p0.timeout">0</property> 
    <property name="hibernate.c3p0.validate">true</property> 
    </properties> 

     

Version history
Revision #:
3 of 3
Last update:
‎05-29-2018 11:51 AM
Updated by:
 
Contributors