Toolpack migration Fedora Core8 2-3

This page shows the Toolpack 2-3 migration guide for Fedora Core 8.

Toolpack Migration Steps

Create new database user

Connect to MySQL and create a new user tbdb with all privilege. If you are unable to connect, 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 fedora64-02
 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 exit

Install ODBC MySQL connector

 yum install mysql-connector-odbc

Configure ODBC driver manager

Retreive the right driver for mysql-odbc

 rpm -ql mysql-connector-odbc | grep _r.so

ex.

 /usr/lib/libmyodbc3_r.so

• Enable the MySQL driver is enable (remove the comments for the MySQL driver).
• Set the Driver to value of the previous command (i.e. /usr/lib/libmyodbc3_r.so)

 vim /etc/odbcinst.ini 

Here is an 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

Enable MySQL database replication

Configure the MySQL configuration file

 vim /etc/my.cnf

Add 2 lines in the configuration file:

• log-bin
• server-id

server-id value needs to be a non-zero value and unique on each host if database redundancy is used.

Make sure it is under the [mysqld] section

 log-bin
 server-id=[UniqueId]

Example:

 [root@TL-FEDORA64-02 tblab]# cat /etc/my.cnf
 [mysqld]
 datadir=/var/lib/mysql
 socket=/var/lib/mysql/mysql.sock
 user=mysql
 log-bin
 server-id=1
 # Default to using old password format for compatibility with mysql 3.x
 # clients (those using the mysqlclient10 compatibility package).
 old_passwords=1
 
 [mysqld_safe]
 log-error=/var/log/mysqld.log
 pid-file=/var/run/mysqld/mysqld.pid
 [root@TL-FEDORA64-02 tblab]#

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.