Toolpack Installation:toolpack validate common 2-3

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.

• 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/[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         = 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