Toolpack migration TMG3200 2-3: Difference between revisions
(clean up) |
|||
| Line 5: | Line 5: | ||
=== Connect to TMG Linux host === | === 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 === | === 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. If you are unable to log in, use an IP Address instead of the ''[HostName]''. | ||
| Line 19: | Line 18: | ||
exit | exit | ||
Example | Example: | ||
mysql -u root -h TB003539 | mysql -u root -h TB003539 | ||
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | ||
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw'; | ||
exit | exit | ||
=== Install ODBC MySQL connector === | === Install ODBC MySQL connector === | ||
yum install unixODBC | yum install unixODBC | ||
yum install mysql-connector-odbc | yum install mysql-connector-odbc | ||
| Line 32: | Line 31: | ||
=== Configure ODBC driver manager === | === 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). | ||
*Verify that the Driver is set to /usr/lib/libmyodbc3_r.so | *Verify that the Driver is set to /usr/lib/libmyodbc3_r.so | ||
| Line 38: | Line 36: | ||
vi /etc/odbcinst.ini | vi /etc/odbcinst.ini | ||
Example: | |||
# Driver from the MyODBC package | # Driver from the MyODBC package | ||
| Line 50: | Line 48: | ||
=== Restart MySQL service === | === Restart MySQL service === | ||
service mysqld restart | service mysqld restart | ||
=== Disable Release 2-2 Service === | === Disable Release 2-2 Service === | ||
tbtoolpack disable 2.2 | tbtoolpack disable 2.2 | ||
== Toolpack System installation == | == 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 | |||
Revision as of 13:03, 26 August 2009
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).
- 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
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.