Toolpack migration TMG3200 2-3
From TBwiki
(Difference between revisions)
(creation) |
(→Configure ODBC driver manager) |
||
| (7 intermediate revisions by 4 users not shown) | |||
| Line 4: | Line 4: | ||
| − | === | + | === 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) | ||
| − | |||
| − | mysql -u root | + | === 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]'; | CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | ||
GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]'; | ||
exit | exit | ||
| − | Example | + | Example: |
| − | mysql -u root | + | 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'; | ||
| Line 21: | Line 26: | ||
=== 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 27: | Line 31: | ||
=== Configure ODBC driver manager === | === 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 | *Verify that the Driver is set to /usr/lib/libmyodbc3_r.so | ||
vi /etc/odbcinst.ini | vi /etc/odbcinst.ini | ||
| − | + | Example: | |
# Driver from the MyODBC package | # Driver from the MyODBC package | ||
# Setup from the unixODBC 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 | Description = ODBC for MySQL | ||
Driver = /usr/lib/libmyodbc3_r.so | Driver = /usr/lib/libmyodbc3_r.so | ||
Setup = /usr/lib/libodbcmyS.so | Setup = /usr/lib/libodbcmyS.so | ||
FileUsage = 1 | FileUsage = 1 | ||
| − | |||
=== Restart MySQL service === | === Restart MySQL service === | ||
| − | |||
service mysqld restart | 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]]. | ||
Latest revision as of 13:22, 21 June 2010
This page shows the Toolpack 2-3 migration guide for TMG3200 (embedded host).
Contents |
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.
