Toolpack migration TMG3200 2-3
From TBwiki
This page shows the Toolpack 2-3 migration guide for TMG3200 (embedded host).
Contents |
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
Toolpack System installation
Now that the prerequisite are installed, we can go back to the migration guide Toolpack migration 2-3.