Toolpack Installation:toolpack validate CentOS4 2-5

If any of those steps fails, refer to the CentOS5 installation guide

Yum Packages

• Verify that the following packages are installed on the system using yum:

 yum list installed gcc zlib-devel openssl openssl-devel perl-DBI mysql-connector-odbc unixODBC pcre

Output (Depending of the architecture, it is possible that only 1 package version is installed):

 [root@srv-test-install-centos4-x64-1 pkg]# yum list installed gcc zlib-devel openssl openssl-devel perl-DBI mysql-connector-odbc unixODBC pcre
 Installed Packages
 gcc.x86_64                               3.4.6-11.el4_8.1       installed
 openssl.i686                             0.9.7a-43.17.el4_8.5   installed
 openssl.x86_64                           0.9.7a-43.17.el4_8.5   installed
 openssl-devel.i386                       0.9.7a-43.17.el4_8.5   installed
 openssl-devel.x86_64                     0.9.7a-43.17.el4_8.5   installed
 pcre.i386                                4.5-4.el4_6.6          installed
 pcre.x86_64                              4.5-4.el4_6.6          installed
 perl-DBI.x86_64                          1.40-9                 installed
 unixODBC.i386                            2.2.11-1.RHEL4.1       installed
 unixODBC.x86_64                          2.2.11-1.RHEL4.1       installed
 zlib-devel.x86_64                        1.2.1.2-1.2            installed
 zlib-devel.i386                          1.2.1.2-1.2            installed
 [root@srv-test-install-centos4-x64-1 pkg]#

RPM Packages

• Verify that the following packages are installed on the system using rpm:

First query:

 rpm -q mysql-server-5.0.68-1.el4_6 mysql-devel-5.0.68-1.el4_6 mysql-5.0.68-1.el4_6 mysql-libs-5.0.68-1.el4_6 perl-DBD-MySQL-2.9004-3.1.centos4 mysqlclient14-4.1.22-1.el4s1.1

Output:

 [root@srv-test-install-centos4-x64-1 pkg]# rpm -q mysql-server-5.0.68-1.el4_6 mysql-devel-5.0.68-1.el4_6 mysql-5.0.68-1.el4_6 mysql-libs-5.0.68-1.el4_6 perl-DBD-MySQL-2.9004-3.1.centos4 mysqlclient14-4.1.22-1.el4s1.1
 mysql-server-5.0.68-1.el4_6
 mysql-devel-5.0.68-1.el4_6
 mysql-5.0.68-1.el4_6
 mysql-libs-5.0.68-1.el4_6
 perl-DBD-MySQL-2.9004-3.1.centos4
 mysqlclient14-4.1.22-1.el4s1.1

Second query:

 rpm -q lighttpd-1.4.20-6.el4 lighttpd-fastcgi-1.4.20-6.el4 spawn-fcgi-1.4.20-6.el4

Output:

 [root@srv-test-install-centos4-x64-1 pkg]# rpm -q lighttpd-1.4.20-6.el4 lighttpd-fastcgi-1.4.20-6.el4 spawn-fcgi-1.4.20-6.el4
 lighttpd-1.4.20-6.el4
 lighttpd-fastcgi-1.4.20-6.el4
 spawn-fcgi-1.4.20-6.el4

3rd party manual installation

fcgi

• Look for fcgi libraries

 find /usr/local/lib -name \*fcgi\*

Result should contain

 /usr/local/lib/libfcgi.a
 /usr/local/lib/libfcgi.so
 /usr/local/lib/libfcgi.so.0.0.0
 /usr/local/lib/libfcgi.la
 /usr/local/lib/libfcgi.so.0

ruby

• ruby version should be 1.8.7

Example:

 [root@srv-test-install-centos4-x64-1 pkg]# ruby --version
 ruby 1.8.7 (2009-06-12 patchlevel 174) [x86_64-linux]
 [root@srv-test-install-centos4-x64-1 pkg]#

rubygems

• rubygems version should be 1.3.5

Example:

 [root@srv-test-install-centos4-x64-1 pkg]# gem --version
 1.3.5
 [root@srv-test-install-centos4-x64-1 pkg]#

gem Installation

• execute the following command:

 gem list --local

Result should contain:

 *** LOCAL GEMS ***
 
 fcgi (0.8.8)
     FastCGI library for Ruby.
 
 sources (0.0.1)
     This package provides download sources for remote gem installation

ODBC Configuration

• Verify that the following file exists:

ls -al /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so

• Verify odbc config file:

 cat /etc/odbcinst.ini

Result should contain:

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

MySQL Configuration

• Verify MySQL config file:

 cat /etc/my.cnf

Result should contain under [mysqld]:

 log-bin
 server-id=[UniqueId]
 max_allowed_packet = 200MB

Result should contain under [mysqldump]:

 max_allowed_packet = 200MB

Note: server-id value may vary, but server-id needs to be a non-zero value and unique when using more than one host.

• Verify if the server is running

 service mysqld status

Result:

 mysqld (pid 5101) is running...