Toolpack migration TMG3200 2-3: Difference between revisions

Latest revision as of 14:22, 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.

@@ Line 2: / Line 2: @@
 == 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 [http://www.putty.org/ 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]''.
-Connect to MySQL and create a new user tbdb with all privilege.
+   mysql -u root -h '[HostName]'
-   mysql -u root
    CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
    exit
-Example
+Example:
-   mysql -u root
+   mysql -u root -h TB003539
    CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
@@ Line 21: / Line 26: @@
 === Install ODBC MySQL connector ===
    yum install unixODBC
    yum install mysql-connector-odbc
@@ Line 27: / Line 31: @@
 === 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'''
-*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:
+Example:
    # Driver from the MyODBC package
    # Setup from the unixODBC package
-   [MySQL]
+   [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
@@ Line 43: / Line 46: @@
    FileUsage      = 1
+=== Restart MySQL service ===
+  service mysqld restart
+=== Disable Release 2-2 Service ===
+  tbtoolpack disable 2.2
-=== Restart MySQL service ===
-  service mysqld restart
+== Toolpack System installation ==
+Now that the prerequisites are installed, you can return to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]].