Toolpack Validate Common

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:

   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

• Validate the parameters:

 # 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         = 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