Toolpack migration Debian4 2-3
From TBwiki
(Difference between revisions)
(→Configure ODBC driver manager) |
(add mysql configuration file modification) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 8: | Line 8: | ||
Connect to MySQL and create a new user tbdb with all privilege. | 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 | + | 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]'; | ||
| Line 15: | Line 16: | ||
Example | Example | ||
| − | mysql -u root | + | mysql -u root -h debian64-01 |
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 29: | Line 30: | ||
odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d | 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 | ||
| Line 34: | Line 61: | ||
/etc/init.d/mysql restart | /etc/init.d/mysql restart | ||
| + | |||
| + | |||
| + | === Disable Release 2-2 Service === | ||
| + | |||
| + | tbtoolpack disable 2.2 | ||
| + | |||
== Toolpack System installation == | == Toolpack System installation == | ||
Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]]. | Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]]. | ||
Latest revision as of 13:54, 3 November 2009
This page shows the Toolpack 2-4 migration guide for Debian 4.
Contents |
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.
