Toolpack migration TMG3200 2-3 - Revision history

Abrassard: /* Configure ODBC driver manager */

2010-06-21T18:22:30Z

Configure ODBC driver manager

Abrassard: /* Configure ODBC driver manager */

2010-06-21T18:19:51Z

Configure ODBC driver manager

Ktrueman: clean up

2009-08-26T17:03:40Z

clean up

Luc Morissette: /* Connect to TMG Linux host */

2009-08-26T15:09:17Z

Connect to TMG Linux host

Luc Morissette: /* Create new database user */

2009-08-26T15:06:58Z

Create new database user

Cbilodeau: add disable 2.2 system

2009-06-05T12:50:18Z

add disable 2.2 system

Cbilodeau: add mysql connection through host name

2009-05-29T12:50:21Z

add mysql connection through host name

Cbilodeau: add back link

2009-05-28T15:19:25Z

add back link

Cbilodeau: creation

2009-05-28T15:17:21Z

creation

New page

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

@@ Line 31: / 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). '''***WARNING: There must be no space at the beginning of the line'''
 *Verify that the Driver is set to /usr/lib/libmyodbc3_r.so

@@ Line 6: / Line 6: @@
 === Connect to TMG Linux host ===
-SSH to TMG Linux Host using hostname or static IP address.
+*SSH to TMG Linux Host using hostname or static IP address.
-You can use a program like PuTTY (http://www.putty.org/) or other.
+*You can use a program like PuTTY (http://www.putty.org/) or other.
-Default username and password is root/root (passwd to change it)
+*Default username and password is root/root (passwd to change it)
-−
 === Create new database user ===

← Older revision		Revision as of 12:50, 5 June 2009
Line 47:		Line 47:

	service mysqld restart		service mysqld restart
		+
		+
		+	=== Disable Release 2-2 Service ===
		+
		+	tbtoolpack disable 2.2

← Older revision		Revision as of 15:19, 28 May 2009
Line 47:		Line 47:

	service mysqld restart		service mysqld restart
		+
		+
		+	== Toolpack System installation ==
		+
		+	Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].

@@ Line 31: / Line 31: @@
 === Configure ODBC driver manager ===
-*Enable the MySQL driver is enable (remove the comments for the MySQL driver).
+*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
@@ Line 40: / Line 40: @@
    # 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
    Setup          = /usr/lib/libodbcmyS.so
    FileUsage      = 1
 === Restart MySQL service ===

@@ Line 5: / Line 5: @@
 === Connect to TMG Linux host ===
 === 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]''.
@@ Line 19: / Line 18: @@
    exit
-Example
+Example:
    mysql -u root -h TB003539
    CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
@@ Line 25: / Line 24: @@
    exit
    yum install unixODBC
    yum install mysql-connector-odbc
@@ Line 32: / Line 31: @@
 === 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
@@ Line 38: / Line 36: @@
    vi /etc/odbcinst.ini
-:Example:
+Example:
    # Driver from the MyODBC package
@@ Line 50: / Line 48: @@
 === 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|Toolpack migration 2-3]].
-Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]].

@@ Line 2: / Line 2: @@
 == Toolpack Migration Steps ==
@@ Line 18: / Line 25: @@
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    exit
 === Install ODBC MySQL connector ===