> For the complete documentation index, see [llms.txt](https://prosbcdocs.telcobridges.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://prosbcdocs.telcobridges.com/tmedia-documentation/configuration/toolpack-install-common-validation.md).

# 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'](http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html) ): 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](https://github.com/telcobridges-main/tmedia-wiki/tree/main/tmedia/operations/selinux-management/README.md) 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:

1. 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.
2. 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
3. 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


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://prosbcdocs.telcobridges.com/tmedia-documentation/configuration/toolpack-install-common-validation.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.