Toolpack Installation:toolpack validate Debian4 2-3

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

apt-get Packages

• Validation of the following package on the system using yum:

 dpkg -l sysvconfig
 dpkg -l zlib1g-dev
 dpkg -l mysql-server
 dpkg -l libmysqlclient15-dev
 dpkg -l unixodbc
 dpkg -l libmyodbc
 dpkg -l libfcgi
 dpkg -l libfcgi-dev
 dpkg -l lighttpd
 dpkg -l ruby irb ri rdoc build-essential 
 dpkg -l rubygems
 dpkg -l ruby1.8-dev
 dpkg -l libopenssl-ruby1.8
 dpkg -l libxml2
 dpkg -l libpcap0.8

Example:

tl-debian64-01:/home/tblab# dpkg -l sysvconfig
 Desired=Unknown/Install/Remove/Purge/Hold
 | Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
 |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
 ||/ Name                          Version                       Description
 +++-=============================-=============================-==========================================================================
 ii  sysvconfig                    0.70                          A text menu based utility for configuring init script links
tl-debian64-01:/home/tblab#

Other Packages Installed

gem Installation

• execute the following command:

 gem list --local

Result should contain:

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

ODBC Configuration

• Verify odbc config file:

 cat /etc/odbcinst.ini

Result should contain:

 [MySQL]                            <----- This line must NOT start with a '#'. Must also not start with a space.
 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

MySQL Configuration

• Verify MySQL config file:

 cat /etc/mysql/my.cnf

Result should contain under [mysqld]:

 # The following can be used as easy to replay backup logs or for replication.
 server-id              = [UniqueId]
 log_bin                = /var/log/mysql/mysql-bin.log

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

The bind-address line should be commented out or not exist.

 # bind-address          = 127.0.0.1

• Verify if the server is running

 service mysqld status

Result, should be something like this:

 /usr/bin/mysqladmin  Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on x86_64
 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
 This software comes with ABSOLUTELY NO WARRANTY. This is free software,
 and you are welcome to modify and redistribute it under the GPL license
 
 Server version          5.0.32-Debian_7etch8-log
 Protocol version        10
 Connection              Localhost via UNIX socket
 UNIX socket             /var/run/mysqld/mysqld.sock
 Uptime:                 30 min 49 sec
 
 Threads: 1  Questions: 449  Slow queries: 0  Opens: 753  Flush tables: 1  Open tables: 64  Queries per second avg: 0.243.