Toolpack Install Common Validation
Applies to version(s) v2.5 to v2.9
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.
If you are unable to connect to a remote mysql server, verify the mysql configuration file and comment out the bind-address line.
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=
'';
Apply the changes mysql> FLUSH PRIVILEGES;
It is also possible you are not connected to the appropriate account. There may be multiple users of the same type (i.e. root), but they may not have the same privileges. Therefore, some commands will be rejected (For more information about MySQL users and privileges read the article 'Securing the Initial MySQL Accounts' ): mysql -u root -h localhost -p mysql -u root -h 127.0.0.1 -p mysql -u root -h tl-sol10i32-01 -p
SELinux (Linux system only)
Check that SELinux is disable. sestatus
If enable, see SELinux_management for disabling instructions.
Database (HA system 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:
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/[[System_Id|[SystemId]]]/[MajorVersion]/toolpack.ini notepad C:\TelcoBridges\toolpack\setup[[System_Id|[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
Validate the parameters:
Variables related to networking [[System_Id|TBX_GW_PORT]] = 12358 <--- Should be the same as the [[System_Id|[SystemId]]] [[Gateway_Address|TBX_GW_ADDRESS_0]] = 10.2.0.69 <--- Needs to be set if there is more than 1 network interface. [[Gateway_Address|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 = ODBC <--- Needs to be set to ODBC. TBDB_DB_NAME = toolpack_0 <--- Can be a different value, but typically toolpack_0. TBDB_ODBC_DRIVER = MySQL <--- Needs to be set to "MySQL" for Linux, or "MYSQL ODBC 3.51 Driver" for Windows platforms
Variables related to database server configuration TBDB_SERVER_PRI = 10.2.0.69/10.2.1.69 <--- Primary host database server: Address(es) of the server running the master configuration database. 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(es) (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
Last updated
Was this helpful?