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&useUnicode=true&characterEncoding=UTF-8&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.