Toolpack migration TMG3200 2-3 - Revision history

Abrassard: /* Configure ODBC driver manager */

2010-06-21T18:22:30Z

Configure ODBC driver manager

← Older revision		Revision as of 14:22, 21 June 2010
Line 31:		Line 31:

	=== Configure ODBC driver manager ===		=== Configure ODBC driver manager ===
	Enable the MySQL driver is enable (remove the comments for the MySQL driver). **WARNING: There must be no space at the beginning of the line		Enable the MySQL driver is enable (remove the comments for the MySQL driver). '''**WARNING: There must be no space at the beginning of the line'''
	*Verify that the Driver is set to /usr/lib/libmyodbc3_r.so		*Verify that the Driver is set to /usr/lib/libmyodbc3_r.so

Abrassard: /* Configure ODBC driver manager */

2010-06-21T18:19:51Z

Configure ODBC driver manager

← Older revision		Revision as of 14:19, 21 June 2010
Line 31:		Line 31:

	=== Configure ODBC driver manager ===		=== Configure ODBC driver manager ===
	*Enable the MySQL driver is enable (remove the comments for the MySQL driver).		Enable the MySQL driver is enable (remove the comments for the MySQL driver). **WARNING: There must be no space at the beginning of the line
	*Verify that the Driver is set to /usr/lib/libmyodbc3_r.so		*Verify that the Driver is set to /usr/lib/libmyodbc3_r.so

Line 40:		Line 40:
	# Driver from the MyODBC package		# Driver from the MyODBC package
	# Setup from the unixODBC package		# Setup from the unixODBC package
	[MySQL]		[MySQL] <----- This line must NOT start with a '#'. Must also not start with a space.
	Description = ODBC for MySQL		Description = ODBC for MySQL
	Driver = /usr/lib/libmyodbc3_r.so		Driver = /usr/lib/libmyodbc3_r.so
	Setup = /usr/lib/libodbcmyS.so		Setup = /usr/lib/libodbcmyS.so
	FileUsage = 1		FileUsage = 1


	=== Restart MySQL service ===		=== Restart MySQL service ===

Ktrueman: clean up

2009-08-26T17:03:40Z

clean up

← Older revision		Revision as of 13:03, 26 August 2009
Line 5:		Line 5:

	=== Connect to TMG Linux host ===		=== Connect to TMG Linux host ===
			*Use SSH to access the TMG Linux Host using hostname or static IP address
			*You can use a program like [http://www.putty.org/ PuTTY] or others like it
			*The default username and password are root/root (passwd to change it)

	*SSH to TMG Linux Host using hostname or static IP address.
	*You can use a program like PuTTY (http://www.putty.org/) or other.
	*Default username and password is root/root (passwd to change it)

	=== Create new database user ===		=== Create new database user ===

	Connect to MySQL and create a new user tbdb with all privilege. If you are unable to log in, use an IP Address instead of the ''[HostName]''.		Connect to MySQL and create a new user tbdb with all privilege. If you are unable to log in, use an IP Address instead of the ''[HostName]''.

Line 19:		Line 18:
	exit		exit

	Example		Example:
	mysql -u root -h TB003539		mysql -u root -h TB003539
	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';
	exit		exit


	=== Install ODBC MySQL connector ===		=== Install ODBC MySQL connector ===

	yum install unixODBC		yum install unixODBC
	yum install mysql-connector-odbc		yum install mysql-connector-odbc
Line 32:		Line 31:

	=== Configure ODBC driver manager ===		=== Configure ODBC driver manager ===

	*Enable the MySQL driver is enable (remove the comments for the MySQL driver).		*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		*Verify that the Driver is set to /usr/lib/libmyodbc3_r.so
Line 38:		Line 36:
	vi /etc/odbcinst.ini		vi /etc/odbcinst.ini

	:Example:		Example:

	# Driver from the MyODBC package		# Driver from the MyODBC package
Line 50:		Line 48:

	=== Restart MySQL service ===		=== Restart MySQL service ===

	service mysqld restart		service mysqld restart


	=== Disable Release 2-2 Service ===		=== Disable Release 2-2 Service ===

	tbtoolpack disable 2.2		tbtoolpack disable 2.2


	== Toolpack System installation ==		== Toolpack System installation ==
			Now that the prerequisites are installed, you can return 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]].

Luc Morissette: /* Connect to TMG Linux host */

2009-08-26T15:09:17Z

Connect to TMG Linux host

← Older revision		Revision as of 11:09, 26 August 2009
Line 6:		Line 6:
	=== Connect to TMG Linux host ===		=== Connect to TMG Linux host ===

	SSH to TMG Linux Host using hostname or static IP address.		*SSH to TMG Linux Host using hostname or static IP address.
	You can use a program like PuTTY (http://www.putty.org/) or other.		*You can use a program like PuTTY (http://www.putty.org/) or other.
	Default username and password is root/root (passwd to change it)		*Default username and password is root/root (passwd to change it)


	=== Create new database user ===		=== Create new database user ===

Luc Morissette: /* Create new database user */

2009-08-26T15:06:58Z

Create new database user

← Older revision		Revision as of 11:06, 26 August 2009
Line 2:		Line 2:

	== Toolpack Migration Steps ==		== Toolpack Migration Steps ==


			=== Connect to TMG Linux host ===

			SSH to TMG Linux Host using hostname or static IP address.
			You can use a program like PuTTY (http://www.putty.org/) or other.
			Default username and password is root/root (passwd to change it)


Line 18:		Line 25:
	GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';		GRANT ALL privileges ON . TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
	exit		exit


	=== Install ODBC MySQL connector ===		=== Install ODBC MySQL connector ===

Cbilodeau: add disable 2.2 system

2009-06-05T12:50:18Z

add disable 2.2 system

← Older revision		Revision as of 08:50, 5 June 2009
Line 47:		Line 47:

	service mysqld restart		service mysqld restart


			=== Disable Release 2-2 Service ===

			tbtoolpack disable 2.2

Cbilodeau: add mysql connection through host name

2009-05-29T12:50:21Z

add mysql connection through host name

← Older revision		Revision as of 08:50, 29 May 2009
Line 6:		Line 6:
	=== Create new database user ===		=== Create new database user ===

	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 log in, 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 14:		Line 14:

	Example		Example
	mysql -u root		mysql -u root -h TB003539
	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: add back link

2009-05-28T15:19:25Z

add back link

← Older revision		Revision as of 11:19, 28 May 2009
Line 47:		Line 47:

	service mysqld restart		service mysqld restart


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

Cbilodeau: creation

2009-05-28T15:17:21Z

creation

New page

This page shows the Toolpack 2-3 migration guide for TMG3200 (embedded host).

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