Toolpack prerequisite Debian5 2-5

This page shows the Toolpack 2-5 prerequisites for Debian 5 (although not tested, it should be the same for Debian 4).

Toolpack Prerequisite

Toolpack Basic packages

 apt-get install sysvconfig zlib1g-dev make

Toolpack System Database

1. Install mysql.

 apt-get install mysql-server libmysqlclient15-dev

2. Configure mysql

 mysql_install_db
 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.

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

ex.

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

4.Install ODBC

 apt-get install unixodbc libmyodbc

Configure ODBC to use the MySQL connector

 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).

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

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:

 [mysqld]
 # 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
 max_allowed_packet = 200MB
 
 [mysqldump]
 max_allowed_packet = 200MB

Restart MySQL service

 service mysql restart

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 tbdb -p -h '[HostName]'
 SELECT * FROM mysql.user;
 exit

ex.

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

Toolpack System Web Portal

Install web server packages

 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

For 32 bits system:

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p174.tar.gz
 tar -zxf ruby-1.8.7-p174.tar.gz
 cd ruby-1.8.7-p174
 ./configure --libdir=/usr/local/lib  --enable-shared
 make
 make install
 cd ext/openssl/
 ruby extconf.rb
 make
 make install
 cd ../../..
 ln -s /usr/local/bin/ruby /usr/bin/ruby
 ln -s /usr/local/lib/libruby.so.1.8 /lib/libruby.so.1.8

For 64 bits system:

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p174.tar.gz
 tar -zxf ruby-1.8.7-p174.tar.gz
 cd ruby-1.8.7-p174
 ./configure --libdir=/usr/local/lib64 --enable-shared
 make
 make install
 cd ext/openssl/
 ruby extconf.rb 
 make
 make install
 cd ../../..
 ln -s /usr/local/bin/ruby /usr/bin/ruby
 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

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/fcgi-0.8.8.gem
 gem install ./fcgi-0.8.8.gem

Firewall

Firewall is not installed by default. If you installed one on your Toolpack host make sure to allow:

Service: http (12358/tcp)

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

Disabling SELinux

SELinux is not installed by default. If you installed it, you will need to disable it. Check SELinux status

 sestatus

If SELinux is enable, see the Disabling SELinux article to disable it.

Toolpack Stream Server

Install pcap0.8 for the stream server

 apt-get install libpcap0.8

Toolpack Development Prerequisite

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

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