Toolpack Installation:toolpack validate common A - Revision history

Lucas Trottier at 19:33, 6 May 2016

2016-05-06T19:33:25Z

Lucas Trottier at 19:18, 6 May 2016

2016-05-06T19:18:23Z

Lucas Trottier: moved Toolpack Installation:toolpack validate common 2-5 to Toolpack Installation:toolpack validate common A: Remove version

2016-05-06T19:16:26Z

moved Toolpack Installation:toolpack validate common 2-5 to Toolpack Installation:toolpack validate common A: Remove version

Atremblay: /* Verify toolpack.ini */

2010-06-16T18:40:09Z

Verify toolpack.ini

Cbilodeau: update mysql link

2010-06-16T18:35:06Z

update mysql link

Cbilodeau: add mysql link for user and privileges

2010-05-25T17:39:41Z

add mysql link for user and privileges

Cbilodeau: improve syntaxe

2010-05-25T17:36:03Z

improve syntaxe

Cbilodeau: Creation

2010-05-25T17:31:31Z

Creation

New page

== 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=<nowiki>''</nowiki>;

: 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. Make sure you connect to the right one:
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/[[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 = 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 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

@@ Line 1: / Line 1: @@
 '''<big>Applies to version(s) v2.5 to v2.9</big>'''
-{{DISPLAYTITLE:Toolpack Validate Common}}
+{{DISPLAYTITLE:Toolpack Install Common Validation}}
 == MySQL Configuration ==

@@ Line 28: / Line 28: @@
-*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 [http://dev.mysql.com/doc/refman/5.1-maria/en/default-privileges.html 'Securing the Initial MySQL Accounts'] ):
+*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 [http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html 'Securing the Initial MySQL Accounts'] ):
    mysql -u root -h localhost -p
    mysql -u root -h 127.0.0.1 -p

@@ Line 1: / Line 1: @@
 == MySQL Configuration ==
 *Connect to mysql using tbdb:
@@ Line 106: / Line 109: @@
 :Windows
    Control Panel -> Windows Firewall

@@ Line 85: / Line 85: @@
    # Variables related to database access driver
-   TBDB_DRIVER         = OTLODBC             <--- Needs to be set to OTLODBC.
+   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

@@ Line 87: / Line 87: @@
    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 for Linux, or "MYSQL ODBC 3.51 Driver" for Windows platforms
+   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
@@ Line 95: / Line 95: @@
    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_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.