Toolpack prerequisite Debian5 2-5 - Revision history

Abrassard: Adding max_allowed_packet to mysqld to support bigger binary blobs

2011-05-16T19:19:21Z

Adding max_allowed_packet to mysqld to support bigger binary blobs

← Older revision		Revision as of 15:19, 16 May 2011
Line 84:		Line 84:

	Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).		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		Make sure it is in the [mysqld] section

	log-bin		log-bin
	server-id=''[UniqueId]''		server-id=''[UniqueId]''

			Add max_allowed_packet to increase the maximum size of binary blobs in the database.
			Make sure it is in the [mysqld] section AND [mysqldump] section
			max_allowed_packet = 200MB

	Example:		Example:
			[mysqld]
	# The following can be used as easy to replay backup logs or for replication.		# The following can be used as easy to replay backup logs or for replication.
	server-id = 1		server-id = 1
	log_bin = /var/log/mysql/mysql-bin.log		log_bin = /var/log/mysql/mysql-bin.log
			max_allowed_packet = 200MB

			[mysqldump]
			max_allowed_packet = 200MB

	Restart MySQL service		Restart MySQL service

Cbilodeau: /* Validation Guide (Optional) */ modify validation guide link to Toolpack_Installation:Validate_Toolpack_Installation_2-5

2010-05-25T15:52:30Z

Validation Guide (Optional): modify validation guide link to Toolpack_Installation:Validate_Toolpack_Installation_2-5

← Older revision		Revision as of 11:52, 25 May 2010
Line 201:		Line 201:

	== Validation Guide (Optional) ==		== Validation Guide (Optional) ==
	If you would like to verify your installation go to the [[Toolpack_Installation:~~Validate_Toolpack_Installation~~\|Toolpack Validation Guide]]		If you would like to verify your installation go to the [[Toolpack_Installation:Validate_Toolpack_Installation_2-5\|Toolpack Validation Guide]]


	== Toolpack System installation ==		== Toolpack System installation ==

	Now that the prerequisite are installed, now it is time to install the [[toolpack_installer_2-5\|Toolpack system]]		Now that the prerequisite are installed, now it is time to install the [[toolpack_installer_2-5\|Toolpack system]]

Cbilodeau: /* Toolpack Development Prerequisite */ add unixodbc-dev

2010-05-25T15:36:25Z

Toolpack Development Prerequisite: add unixodbc-dev

← Older revision		Revision as of 11:36, 25 May 2010
Line 198:		Line 198:
	=== Toolpack Development Prerequisite ===		=== Toolpack Development Prerequisite ===

	apt-get install g++ libxml2-dev libpcap0.8-dev		apt-get install g++ libxml2-dev libpcap0.8-dev unixodbc-dev


	== Validation Guide (Optional) ==		== Validation Guide (Optional) ==

Cbilodeau: add developper dependencies

2010-05-25T15:18:29Z

add developper dependencies

← Older revision		Revision as of 11:18, 25 May 2010
Line 198:		Line 198:
	=== Toolpack Development Prerequisite ===		=== Toolpack Development Prerequisite ===

	~~No prerequisite required~~		apt-get install g++ libxml2-dev libpcap0.8-dev

Cbilodeau: cleanup procedure

2010-05-21T12:48:32Z

cleanup procedure

← Older revision		Revision as of 08:48, 21 May 2010
Line 19:		Line 19:

	mysql_install_db		mysql_install_db
	service mysql start		service mysql start <--- service should already be started

	3. Log onto mysql, create a tbdb user. The ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.		3. Log onto mysql, create a tbdb user. The ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
Line 63:		Line 63:
	5. Manually configure the odbc manager. Make sure mysql driver is enable(removing the comments for the mysql driver). Set the Driver as the previous command answer.		5. Manually configure the odbc manager. Make sure mysql driver is enable(removing the comments for the mysql driver). Set the Driver as the previous command answer.

	vim /etc/odbcinst.ini		vim /etc/odbcinst.ini

	Here is an example:		Here is an example:
Line 115:		Line 115:

	apt-get install libfcgi libfcgi-dev lighttpd libopenssl-ruby1.8 libssl-dev		apt-get install libfcgi libfcgi-dev lighttpd libopenssl-ruby1.8 libssl-dev

			Use the UI to prevent lighttpd to start at boot time. ( Remove the '*' besides the lighttpd service )

			sysvconfig


			Stop the lighttpd service

			service lighttpd stop

	Install ruby		Install ruby
Line 163:		Line 172:
	gem install ./fcgi-0.8.8.gem		gem install ./fcgi-0.8.8.gem


	~~Install libxml2 ( was already installed )~~

	~~apt-get install libxml2~~


	~~Use the UI to prevent lighttpd to start at boot time. ( Remove the '*' besides the lighttpd service )~~

	~~sysvconfig~~


	~~Stop the lighttpd service~~

	~~service lighttpd stop~~

	=== Firewall ===		=== Firewall ===
Line 203:		Line 198:
	=== Toolpack Development Prerequisite ===		=== Toolpack Development Prerequisite ===

	~~apt-get install gcc~~		No prerequisite required

Cbilodeau: simplify procedure

2010-05-21T12:34:37Z

simplify procedure

← Older revision		Revision as of 08:34, 21 May 2010
Line 2:		Line 2:

	== Toolpack Prerequisite ==		== Toolpack Prerequisite ==

	~~WARNING: This prerequisite was not validate yet~~


	=== Toolpack Basic packages ===		=== Toolpack Basic packages ===

	apt-get install sysvconfig		apt-get install sysvconfig zlib1g-dev make
	~~apt-get install~~ zlib1g-dev make


Line 16:		Line 13:
	1. Install mysql.		1. Install mysql.

	apt-get install mysql-server		apt-get install mysql-server libmysqlclient15-dev
	~~apt-get install~~ libmysqlclient15-dev


Line 44:		Line 40:
	4.Install ODBC		4.Install ODBC

	apt-get install unixodbc		apt-get install unixodbc libmyodbc
	~~apt-get install~~ libmyodbc


Line 119:		Line 114:
	Install web server packages		Install web server packages

	apt-get install libfcgi		apt-get install libfcgi libfcgi-dev lighttpd libopenssl-ruby1.8 libssl-dev
	~~apt-get install~~ libfcgi-dev
	~~apt-get install~~ lighttpd
	~~apt-get install~~ libopenssl-ruby1.8
	~~apt-get install~~ libssl-dev

	Install ruby		Install ruby
Line 213:		Line 204:

	apt-get install gcc		apt-get install gcc
	~~apt-get install make~~

Cbilodeau: fix debian5 ruby and rubygems steps

2010-05-20T20:22:31Z

fix debian5 ruby and rubygems steps

← Older revision		Revision as of 16:22, 20 May 2010
Line 122:		Line 122:
	apt-get install libfcgi-dev		apt-get install libfcgi-dev
	apt-get install lighttpd		apt-get install lighttpd
	~~apt-get install ruby irb ri rdoc build-essential~~
	~~apt-get install rubygems~~
	~~apt-get install ruby1.8-dev~~
	apt-get install libopenssl-ruby1.8		apt-get install libopenssl-ruby1.8
			apt-get install libssl-dev

	Install ruby		Install ruby
Line 161:		Line 159:
	ln -s /usr/local/lib64/libruby.so.1.8 /lib64/libruby.so.1.8		ln -s /usr/local/lib64/libruby.so.1.8 /lib64/libruby.so.1.8

			Install RubyGems 1.3.5

			wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/rubygems-1.3.5.tgz
			tar -zxf rubygems-1.3.5.tgz
			cd rubygems-1.3.5
			ruby setup.rb
			cd ..

	Install fcgi gem		Install fcgi gem

Cbilodeau: add make in prerequisite

2010-05-20T19:07:30Z

add make in prerequisite

← Older revision		Revision as of 15:07, 20 May 2010
Line 9:		Line 9:

	apt-get install sysvconfig		apt-get install sysvconfig
	apt-get install zlib1g-dev		apt-get install zlib1g-dev make

Cbilodeau: change root user to tbdb for db check

2010-05-20T19:03:07Z

change root user to tbdb for db check

← Older revision		Revision as of 15:03, 20 May 2010
Line 106:		Line 106:
	If you cannot log in it is possible that the host name is not configure properly, use an IP Address instead.		If you cannot log in it is possible that the host name is not configure properly, use an IP Address instead.

	mysql -u ~~root~~ -h '[HostName]' -p		mysql -u tbdb -p -h '[HostName]'
	SELECT * FROM mysql.user;		SELECT * FROM mysql.user;
	exit		exit

	ex.		ex.
	mysql -u ~~root~~ -h debian64-01 -p		mysql -u tbdb -p -h debian64-01
	SELECT * FROM mysql.user;		SELECT * FROM mysql.user;
	exit		exit

Cbilodeau: /* Toolpack System Database */ improve mysql prerequisite

2010-05-20T18:34:06Z

Toolpack System Database: improve mysql prerequisite

@@ Line 24: / Line 24: @@
    mysql_install_db
    service mysql start
 . Log onto mysql, create a tbdb user. The ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
@@ Line 43: / Line 39: @@
    GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    FLUSH PRIVILEGES;
    exit
@@ Line 119: / Line 103: @@
    service mysql restart
 === Toolpack System Web Portal ===