Toolpack Installation:toolpack validate common 2-3
From TBwiki
Revision as of 15:56, 22 May 2009 by 10.0.0.157 (Talk)
Contents |
MySQL Configuration
- Connect to mysql using tbdb:
mysql -u tbdb -p
- Verify the user list
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/[TbxGwPort]/[MajorVersion]/toolpack.ini notepad C:\TelcoBridges\toolpack\setup\[TbxGwPort]\[MajorVersion]\toolpack.ini
- Example:
cat /lib/tb/toolpack/setup/12358/2.3/toolpack.ini notepad C:\TelcoBridges\toolpack\setup\12401\2.3\toolpack.ini
- Validate the parameters:
# Variables related to networking TBX_GW_PORT = 12358 <--- Should be the same as the TbxGwPort 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.
service iptables stop