BridgeGate Server

How to manually setup the BridgeGate MySql database

11 views July 24, 2019 admin 0

Below are the instructions to configure your Windows / Linux servers.

Unzip the BridgeGate installation zip file that was downloaded from www.BridgeGateDev.com.

Install BridgeGate on your Windows based machine.

In the \bridgegate\mysql folder, you will find the following three files:

usergrant.sql
db.sql
db_data.sql

Once you have MySQL or MariaDB installed on your RedHat or CentOS machine, perform the following on the Linux server.

Update /etc/my.cnf

Ensure the following is in the my.cnf file:

[mysqld]

lower_case_table_names=1

default_time_zone=EST5EDT

Execute the following:

# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p

EXPECT:

Warning: Unable to load ‘/usr/share/zoneinfo/leapseconds’ as time zone. Skipping it.

Warning: Unable to load ‘/usr/share/zoneinfo/tzdata.zi’ as time zone. Skipping it.

Execute the above mentioned scripts in the following order:

usergrant.sql
db.sql
db_data.sql

This creates a clean BridgeGate database. Portal admin user / password combination is admin / admin.

On the Windows BridgeGate machine:

Edit the \bridgegate\conf\bridgegate.xml file

<DATABASE_CONNECTION_POOL ACQUIRE_INCREMENT=”2″ AUTO_COMMIT_ON_CLOSE=”false” CHECKOUTTIME=”600″ DRIVER=”com.mysql.jdbc.Driver” IDLETIME=”600″ IDLE_TEST_PERIOD=”300″ JDBCURL=”jdbc:mysql://localhost/bridgegate?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull” MAXCONN=”300″ MAX_STATEMENTS=”0″ MINCONN=”10″ PASSWORD=”ENC3AMq%2BPLK4Q%2Bzvhu2oJhQvw%3D%3D” USERNAME=”bridgegate”/>

Update localhost with the IP Address of the Linux DB Server.

Restart the BridgeGate service

At this point, the MySQL service on the Windows machine can be stopped and set to disabled. It can also be removed by executing \bridgegate\bin\mysql-remove.bat as an Administrator.

Was this helpful?