Actions

Toolpack migration TMG3200 2-3

Revision as of 14:22, 21 June 2010 by Abrassard (talk | contribs) (→‎Configure ODBC driver manager)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

Retrieved from "https://docs.telcobridges.com/index.php?title=Toolpack_migration_TMG3200_2-3&oldid=6427"