Toolpack prerequisite Debian4 2-3

Revision as of 10:40, 15 July 2009 (view source) Cbilodeau (Talk | contribs) (change odbc driver to get version 3.51.27) ← Older edit		Revision as of 11:38, 15 July 2009 (view source) Cbilodeau (Talk | contribs) (add toolpack development prerequisite) Newer edit →
Line 162:		Line 162:
	=== Toolpack Development Prerequisite ===		=== Toolpack Development Prerequisite ===
−	Available soon	+	apt-get install gcc
		+	apt-get install make

---

Revision as of 11:38, 15 July 2009

This page shows the Toolpack 2-3 prerequisites for Debian 4.

Contents 1 Toolpack Prerequisite 1.1 Toolpack Basic packages 1.2 Toolpack System Database 1.3 Toolpack System Web Portal 1.4 Toolpack Stream Server 1.5 Toolpack Development Prerequisite 2 Validation Guide (Optional) 3 Toolpack System installation

Toolpack Prerequisite

WARNING: This prerequisite was not validate yet

Toolpack Basic packages

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

Toolpack System Database

1. Install mysql.

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

2. Configure mysql

 mysql_install_db
 service mysql start
 /usr/bin/mysqladmin -u root password 'mysql'
 mysql -u root -p
 
 exit

3. Log onto mysql, create a tbdb user. The [DatabaseUsername] and [DatabasePassword] will need to be supplied to the toolpack installer.

 mysql -u root -p
 CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 exit

ex.

 mysql -u root -p
 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 exit

To verify if the user is created. The [HostName] will need to be supplied to the toolpack installer. 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
 SELECT * FROM mysql.user;
 exit

ex.

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

4.Install ODBC

 apt-get install unixodbc
 apt-get install libmyodbc

Configure ODBC to use the MySQL connector

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

4a. For 32 bits system:

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-32bit.tar.gz
 tar -zxf mysql-connector-odbc-3.51.27-linux-x86-32bit.tar.gz
 mkdir -p /lib/tb/toolpack/3rdparty/odbc-connector/
 cp mysql-connector-odbc-3.51.27-linux-x86-32bit/lib/libmyodbc3_r-3.51.27.so /lib/tb/toolpack/3rdparty/odbc-connector/

4b. For 64 bits system:

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-64bit.tar.gz
 tar -zxf mysql-connector-odbc-3.51.27-linux-x86-64bit.tar.gz
 mkdir -p /lib/tb/toolpack/3rdparty/odbc-connector/
 cp mysql-connector-odbc-3.51.27-linux-x86-64bit/lib/libmyodbc3_r-3.51.27.so /lib/tb/toolpack/3rdparty/odbc-connector/

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 

Here is an example:

 [MySQL]
 Description         = MySQL driver
 Driver              = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so
 Setup               = /usr/lib/odbc/libodbcmyS.so
 CPTimeout           =
 CPReuse             =
 UsageCount          = 2

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

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

Toolpack System Web Portal

Install web server packages

 apt-get install libfcgi
 apt-get install libfcgi-dev
 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

Install fcgi gem

 gem install fcgi

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 seems to be disable by default. But if there is one, it needs to allow:

Service: http (12358/tcp)

Port: All ports (tcp/udp) enabled for local networks

Toolpack Stream Server

Install pcap0.8 for the stream server

 apt-get install libpcap0.8

Toolpack Development Prerequisite

 apt-get install gcc
 apt-get install make

Validation Guide (Optional)

If you would like to verify your installation go to the Toolpack Validation Guide

Toolpack System installation

Now that the prerequisite are installed, now it is time to install the Toolpack system