Toolpack Installation:toolpack validate common A
From TBwiki
(Difference between revisions)
(→Verify toolpack.ini) |
|||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| + | '''<big>Applies to version(s) v2.5 to v2.9</big>''' | ||
| + | {{DISPLAYTITLE:Toolpack Install Common Validation}} | ||
| + | |||
== MySQL Configuration == | == MySQL Configuration == | ||
*Connect to mysql using tbdb: | *Connect to mysql using tbdb: | ||
| Line 106: | Line 109: | ||
:Windows | :Windows | ||
Control Panel -> Windows Firewall | Control Panel -> Windows Firewall | ||
| + | |||
| + | [[Category:Revise on Major]] | ||
Latest revision as of 14:33, 6 May 2016
Applies to version(s) v2.5 to v2.9
Contents |
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
