Toolpack prerequisite CentOS4 2-3

Latest revision as of 13:21, 21 June 2010

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

Toolpack Prerequisite

Toolpack Basic packages

The software listed below is required by the host machines.

 yum install gcc
 yum install zlib-devel
 yum install openssl-devel perl-DBI

Toolpack System Database

The Toolpack system database is used by the main host and requires mySQL database server. The system database packages are as follows:

a. For 32 bits sytem:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-server-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-devel-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-libs-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/perl-DBD-MySQL-2.9004-3.1.centos4.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysqlclient14-4.1.22-1.el4s1.1.i386.rpm
 rpm -ivh mysql-server-5.0.68-1.el4_6.i386.rpm mysql-devel-5.0.68-1.el4_6.i386.rpm mysql-5.0.68-1.el4_6.i386.rpm mysql-libs-5.0.68-1.el4_6.i386.rpm perl-DBD-MySQL-2.9004-3.1.centos4.i386.rpm mysqlclient14-4.1.22-1.el4s1.1.i386.rpm

b. For 64 bits sytem:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-server-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-devel-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-libs-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/perl-DBD-MySQL-2.9004-3.1.centos4.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysqlclient14-4.1.22-1.el4s1.1.x86_64.rpm
 rpm -ivh mysql-server-5.0.68-1.el4_6.x86_64.rpm mysql-devel-5.0.68-1.el4_6.x86_64.rpm mysql-5.0.68-1.el4_6.x86_64.rpm mysql-libs-5.0.68-1.el4_6.x86_64.rpm perl-DBD-MySQL-2.9004-3.1.centos4.x86_64.rpm mysqlclient14-4.1.22-1.el4s1.1.x86_64.rpm

Then, install the encryption package.

 yum install openssl

Depending on the CentOS installation, the command paths for the database (i.e. mysql_install_db, mysqladmin, mysql) and system tools (chkconfig, service, etc) may not be included in the active PATH environment variable. MySql is usually installed in /usr/bin and system tools in sbin.

1. start and enable mysql

 chkconfig mysqld on
 service mysqld start

2. Install the database.

 mysql_install_db

3. Log onto mysql, create a tbdb user. The [HostName], [DatabaseUsername] and [DatabasePassword] 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 of the [HostName].

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

ex.

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

To verify if the user is created:

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

4. Retrieve the socket path (this command will give the path to the socket file).

 mysql_config --socket

5. Create a symbolic link to the path retrieve using the last command.

 ln -s <PATH TAKEN FROM THE LAST CMD> /tmp/mysql.sock

For example:

 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

6. Set the permission. Select option 7 (Create full privileges) for all database (*) on all hosts (%) for the user [DatabaseUsername] (i.e. tbdb).

 mysql_setpermission

7.Install odbc driver and driver manager

 yum install mysql-connector-odbc

7a. For 32 bits sytem:

 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/

7b. For 64 bits sytem:

 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/

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

8a. For 32 bits system:

 yum install unixODBC.i386

8b. For 64 bits system:

 yum install unixODBC.x86_64

 vim /etc/odbcinst.ini 

Here is an example:

 # Driver from the MyODBC package
 # Setup from the unixODBC package
 [MySQL]                            <----- This line must NOT start with a '#'. Must also not start with a space.
 Description     = ODBC for MySQL
 Driver          = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so
 Setup           = /usr/lib/libodbcmyS.so
 FileUsage       = 1

9. Configure mysql to support database replication (Will not interfere if your system do not use it).

 vim /etc/my.cnf

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:

 [root@TL-CENTOS64-02 tblab]# cat /etc/my.cnf
 [mysqld]
 datadir=/var/lib/mysql
 socket=/var/lib/mysql/mysql.sock
 user=mysql
 log-bin
 server-id=1
 # Default to using old password format for compatibility with mysql 3.x
 # clients (those using the mysqlclient10 compatibility package).
 old_passwords=1
 
 [mysqld_safe]
 log-error=/var/log/mysqld.log
 pid-file=/var/run/mysqld/mysqld.pid
 [root@TL-CENTOS64-02 tblab]#

Reboot the mysql service

service mysqld restart

Toolpack System Web Portal

The Toolpack System Web Portal is required in order to host the Toolpack Web Portal. It requires the execution of all following commands:

1. Manually install fcgi:

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/fcgi-2.4.0.tar.gz
 tar -xzf fcgi-2.4.0.tar.gz
 cd fcgi-2.4.0
 ./configure
 make
 make install
 cd ../

2. Install pcre:

2a. for 32 bits systems

 yum install pcre.i386

2b. For 64 bits system

 yum install pcre.x86_64

3. Install lighttpd:

3a. For 32 bits sytem:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-1.4.20-6.el4.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/spawn-fcgi-1.4.20-6.el4.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-fastcgi-1.4.20-6.el4.i386.rpm
 rpm -ivh lighttpd-1.4.20-6.el4.i386.rpm lighttpd-fastcgi-1.4.20-6.el4.i386.rpm spawn-fcgi-1.4.20-6.el4.i386.rpm

3b. For 64 bits sytem:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-1.4.20-6.el4.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/spawn-fcgi-1.4.20-6.el4.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-fastcgi-1.4.20-6.el4.x86_64.rpm
 rpm -ivh lighttpd-1.4.20-6.el4.x86_64.rpm lighttpd-fastcgi-1.4.20-6.el4.x86_64.rpm spawn-fcgi-1.4.20-6.el4.x86_64.rpm

4. Install Ruby:

4a. For 32 bits system:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-1.8.6.287-1.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-devel-1.8.6.287-1.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-libs-1.8.6.287-1.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-rdoc-1.8.6.287-1.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-irb-1.8.6.287-1.i386.rpm
 rpm -ivh ruby-1.8.6.287-1.i386.rpm ruby-devel-1.8.6.287-1.i386.rpm ruby-libs-1.8.6.287-1.i386.rpm ruby-rdoc-1.8.6.287-1.i386.rpm ruby-irb-1.8.6.287-1.i386.rpm

4b. For 64 bits system:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-1.8.6.287-1.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-devel-1.8.6.287-1.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-libs-1.8.6.287-1.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-rdoc-1.8.6.287-1.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/ruby-irb-1.8.6.287-1.x86_64.rpm
 rpm -ivh ruby-1.8.6.287-1.x86_64.rpm ruby-devel-1.8.6.287-1.x86_64.rpm ruby-libs-1.8.6.287-1.x86_64.rpm ruby-rdoc-1.8.6.287-1.x86_64.rpm ruby-irb-1.8.6.287-1.x86_64.rpm

6. Manually install rubygems:

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

7. Install gem fcgi:

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

In case the gem file is corrupted (or the site is unavailable), follow the following guidelines to compile the gem directly:

  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-fcgi-0.8.7.tar.gz
  tar -xzvf ruby-fcgi-0.8.7.tar.gz
  cd ruby-fcgi-0.8.7
  ruby install.rb config
  ruby install.rb setup
  ruby install.rb install
  cd ../

8. Install libxml:

8a. For 32 bits sytem:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-2.6.16-12.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-devel-2.6.16-12.i386.rpm
 rpm -ivh libxml2-2.6.16-12.i386.rpm libxml2-devel-2.6.16-12.i386.rpm

8b. For 64 bits sytem:

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-2.6.16-12.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-devel-2.6.16-12.x86_64.rpm
 rpm -ivh libxml2-2.6.16-12.x86_64.rpm libxml2-devel-2.6.16-12.x86_64.rpm

Make sure that the firewall enables these following services and ports. Failure to open those ports will render socket communication between the distributed software elements unavailable.

Service: http (12358/tcp)

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

Disabling SELinux

Check SELinux status

 sestatus

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

Toolpack Development Prerequisite

The Toolpack System Development prerequisite section is only required for customers that will develop their own application using the Toolpack API:

 yum install gcc-c++
 yum install unixODBC-devel
 yum install zlib-devel

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