Toolpack migration Debian4 2-3

Latest revision as of 13:54, 3 November 2009

This page shows the Toolpack 2-4 migration guide for Debian 4.

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 debian64-01
 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 exit

Install ODBC MySQL connector

 apt-get install libmyodbc

Configure ODBC driver manager

 odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d

Modify MySQL configuration

Configure mysql to support database replication (Will not interfere if your system do not use it).

 vi /etc/mysql/my.cnf

6.Add 2 new variable in the mysql config file

Comment out the bind-address line (put a '#' in front of the line) Example:

 # bind-address          = 127.0.0.1

Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).

Make sure it is in the [mysqld] section

 log-bin
 server-id=[UniqueId]

Example:

 # The following can be used as easy to replay backup logs or for replication.
 server-id              = 1
 log_bin                = /var/log/mysql/mysql-bin.log

Restart MySQL service

 service mysql restart

Restart MySQL service

 /etc/init.d/mysql restart

Disable Release 2-2 Service

 tbtoolpack disable 2.2

Toolpack System installation

Now that the prerequisite are installed, we can go back to the migration guide Toolpack migration 2-3.