Toolpack migration Debian4 2-3 - Revision history

Cbilodeau: add mysql configuration file modification

2009-11-03T18:54:56Z

add mysql configuration file modification

← Older revision		Revision as of 14:54, 3 November 2009
Line 30:		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

Cbilodeau: add disable 2.2 system

2009-06-05T12:51:07Z

add disable 2.2 system

← Older revision		Revision as of 08:51, 5 June 2009
Line 35:		Line 35:

	/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]].

Cbilodeau: add mysql connection through host name

2009-05-29T13:46:58Z

add mysql connection through host name

← Older revision		Revision as of 09:46, 29 May 2009
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';

Cbilodeau: /* Configure ODBC driver manager */

2009-05-19T20:15:21Z

Configure ODBC driver manager

← Older revision		Revision as of 16:15, 19 May 2009
Line 29:		Line 29:

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


			=== Restart MySQL service ===

			/etc/init.d/mysql restart

	== 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]].

Cbilodeau: Toolpack migration debian4 2-3 moved to Toolpack migration Debian4 2-3: move to correct cases

2009-05-19T19:33:25Z

Toolpack migration debian4 2-3 moved to Toolpack migration Debian4 2-3: move to correct cases

← Older revision	Revision as of 15:33, 19 May 2009
(No difference)

10.0.0.157: Creation

2009-05-19T18:45:29Z

Creation

New page

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.

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 ===

apt-get install libmyodbc

=== Configure ODBC driver manager ===

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

== 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]].