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

Example:

 [tblab@srv-test-install-centos4-x64-1 ~]$ sudo yum list installed gcc zlib-devel openssl-devel perl-DBI mysql-connector-odbc unixODBC pcre
 Installed Packages
 gcc.x86_64                               3.4.6-11.el4_8.1       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.x86_64                              4.5-4.el4_6.6          installed
 pcre.i386                                4.5-4.el4_6.6          installed
 perl-DBI.x86_64                          1.40-9                 installed
 unixODBC.x86_64                          2.2.11-1.RHEL4.1       installed
 unixODBC.i386                            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
 [tblab@srv-test-install-centos4-x64-1 ~]$

RPM Packages

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

 rpm -V

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=1

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