Toolpack migration TMG3200 2-3

Revision as of 13:19, 21 June 2010

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

Toolpack Migration Steps

Connect to TMG Linux host

• Use SSH to access the TMG Linux Host using hostname or static IP address
• You can use a program like PuTTY or others like it
• The default username and password are root/root (passwd to change it)

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). ***WARNING: There must be no space at the beginning of the line
• 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]                            <----- This line must NOT start with a '#'. Must also not start with a space.
 Description    = ODBC for MySQL
 Driver         = /usr/lib/libmyodbc3_r.so
 Setup          = /usr/lib/libodbcmyS.so
 FileUsage      = 1

Restart MySQL service

 service mysqld restart

Disable Release 2-2 Service

 tbtoolpack disable 2.2

Toolpack System installation

Now that the prerequisites are installed, you can return to the migration guide Toolpack migration 2-3.