Toolpack migration TMG3200 2-3

This page shows the Toolpack 2-3 migration guide for TMG3200 (embedded host).

Toolpack Migration Steps

Create new database user

Connect to MySQL and create a new user tbdb with all privilege.

 mysql -u root
 CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
 exit

Example

 mysql -u root
 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 exit

Install ODBC MySQL connector

 yum install unixODBC
 yum install mysql-connector-odbc

Configure ODBC driver manager

• Enable the MySQL driver is enable (remove the comments for the MySQL driver).
• Verify that the Driver is set to /usr/lib/libmyodbc3_r.so

 vi /etc/odbcinst.ini 

Example:

 # Driver from the MyODBC package
 # Setup from the unixODBC package
 [MySQL]
 Description    = ODBC for MySQL
 Driver         = /usr/lib/libmyodbc3_r.so
 Setup          = /usr/lib/libodbcmyS.so
 FileUsage      = 1

Restart MySQL service

 service mysqld restart