Toolpack migration TMG3200 2-3

Revision as of 07:50, 29 May 2009

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. If you are unable to log in, use an IP Address instead of the [HostName].

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

Example

 mysql -u root -h TB003539
 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

Toolpack System installation

Now that the prerequisite are installed, we can go back to the migration guide Toolpack migration 2-3.