BridgeGate Server

No active database was found – time zone issue

104 views June 19, 2018 admin 0

If you are running BridgeGate on a mysql or mariadb on Linux and you don’t have a time_zone set mysql will not allow bridgegate to connect.   You will get the following exception in the server.log

ERROR [com.oidev.bridgegate.db.SchemaMigratorUtil] com.oidev.bridgegate.BridgeGateException: No active database was found. Please check the database server status.

To resolve this load the time_zones into mysql and set a default time zone in the my.cnf file

Below are the shell commands.

shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p

Add the follow to /etc/my.cnf

[mysqld] lower_case_table_names=1 default_time_zone=EST5EDT

Was this helpful?