MySQL Configuration
- Connect to mysql using tbdb:
mysql -u tbdb -h [MyHostName] -p
- If you cannot connect to MySQL, it is possible that the host name is not set properly. Try an IP Address instead.
mysql> select * from mysql.user;
+----------------+------+------------------+-------------+-------------+
| Host | User | Password | Select_priv | Insert_priv |
+----------------+------+------------------+-------------+-------------+
| localhost | root | 68d4f47c49a579c9 | Y | Y |
| tl-sol10i32-01 | root | | Y | Y |
| 127.0.0.1 | root | | Y | Y |
| localhost | | | N | N |
| tl-sol10i32-01 | | | N | N |
| % | tbdb | 68d4f47c49a579c9 | Y | Y |
+----------------+------+------------------+-------------+-------------+
6 rows in set (0.00 sec)
- Remove the 'empty' users, in the previous example the 4th and 5th user should be remove.
mysql> DELETE FROM mysql.user where user='';
Database HA user only
- Connect to the mysql on secondary host, from the primary host.
mysql -u tbdb -p -h [SecondaryHostNameOrIp]
- Example:
mysql -u tbdb -p -h tl-centos64-03
- Verify the slave state of the mysql server
show slave status \G
- Result:
If toolpack was never started, it should be empty.
Otherwise should include:
Master_Host: 10.2.0.69 <--- Primary host database server: Can be hostname or ip address.
Master_User: tbdb <--- Primary host MySQL username: Should be tbdb.
Master_Port: 3306 <--- Primary host MySQL port: Should be 3306 unless specified otherwise in the installer
Connect_Retry: 60
Master_Log_File: mysqld-bin.000001 <--- Should be the same value as the master status, see below.
- Connect to the mysql on primary host
mysql -u tbdb -p
- Verify the master state of the mysql server
show master status \G
- Result:
If toolpack was never started, it should be empty.
Otherwise should include:
File: mysqld-bin.000001 <--- Should be the same value as the slave status, see above.
Position: 84685442
Binlog_Do_DB:
Verify toolpack.ini
- Open the toolpack.ini file
cat /lib/tb/toolpack/setup/[SystemId]/[MajorVersion]/toolpack.ini
notepad C:\TelcoBridges\toolpack\setup\[SystemId]\[MajorVersion]\toolpack.ini
- Example:
cat /lib/tb/toolpack/setup/12358/2.3/toolpack.ini
notepad C:\TelcoBridges\toolpack\setup\12401\2.3\toolpack.ini
# Variables related to networking
TBX_GW_PORT = 12358 <--- Should be the same as the [SystemId]
TBX_GW_ADDRESS_0 = 10.2.0.69 <--- Needs to be set if there is more than 1 network interface.
TBX_GW_ADDRESS_1 = 10.2.1.69 <--- Needs to be set if there is more than 1 network interface.
TBX_PRIMARY_HOST = 1 <--- Primary host needs to be set to TRUE or 1, secondary host needs to be set to FALSE or 0.
# Variables related to database access driver
TBDB_DRIVER = OTLODBC <--- Needs to be set to OTLODBC.
TBDB_DB_NAME = toolpack_0 <--- Can be a different value, but typically toolpack_0.
TBDB_ODBC_DRIVER = MySQL <--- Needs to be set to MySQL.
# Variables related to database server configuration
TBDB_SERVER_PRI = 10.2.0.69 <--- Primary host database server: Can be hostname or ip address (localhost, 127.0.0.1 not accepted), Ignore on the secondary host.
TBDB_UID_PRI = tbdb <--- Primary host MySQL username: Should be tbdb, Ignore on the secondary host.
TBDB_PWD_PRI = tbdbpw <--- Primary host MySQL password: Needs to be the right password (default: tbdbpw), Ignore on the secondary host.
TBDB_PORT_PRI = 3306 <--- Primary host MySQL port: Should be 3306 unless specified otherwise in the installer, Ignore on the secondary host.
TBDB_SERVER_SEC = <--- Secondary host database server: Can be hostname or ip address (localhost, 127.0.0.1 not accepted), Ignore on the secondary host.
TBDB_UID_SEC = <--- Secondary host MySQL username: Should be tbdb, Ignore on the secondary host.
TBDB_PWD_SEC = <--- Secondary host MySQL password: Needs to be the right password (default: tbdbpw), Ignore on the secondary host.
TBDB_PORT_SEC = <--- Secondary host MySQL port: Should be 3306 unless specified otherwise in the installer, Ignore on the secondary host.
Firewall
- Shutdown the firewall, for testing only.
- Red Hat base Linux
service iptables stop
- Windows
Control Panel -> Windows Firewall