Toolpack prerequisite CentOS5 A

Revision as of 16:59, 22 February 2011 (view source) Cbilodeau (Talk | contribs) (add example for 32 bits system) ← Older edit		Revision as of 11:41, 28 February 2011 (view source) Cbilodeau (Talk | contribs) (modify connector librairy) Newer edit →
Line 67:		Line 67:
	[MySQL]		[MySQL]
	Description    = ODBC for MySQL		Description    = ODBC for MySQL
−	Driver          = /usr/lib/libmyodbc3_r.so	+	Driver          = /usr/lib/libmyodbc5.so
	Setup          = /usr/lib/libodbcmyS.so		Setup          = /usr/lib/libodbcmyS.so
	FileUsage      = 1		FileUsage      = 1
Line 76:		Line 76:
	[MySQL]		[MySQL]
	Description    = ODBC for MySQL		Description    = ODBC for MySQL
−	Driver          = /usr/lib64/libmyodbc3_r.so	+	Driver          = /usr/lib64/libmyodbc5.so
	Setup          = /usr/lib/libodbcmyS.so		Setup          = /usr/lib/libodbcmyS.so
	FileUsage      = 1		FileUsage      = 1

---

Revision as of 11:41, 28 February 2011

This page shows the Toolpack 2-5 prerequisites for CentOS 5.5.

WARNING: The host MUST have CentOS 5.5 installed. If you don't want to update your host, please follow the manual procedure instead.

WARNING: This procedure requires internet access

Contents 1 CentOS update 2 TelcoBridges repository 3 Install Toolpack Prerequisites 4 Configure Toolpack Prerequisites 4.1 Configure ODBC 4.2 Configure MySQL 4.3 Start MySQL 4.4 Configure MySQL Users 5 Toolpack Development Prerequisite (Optional) 6 Validation Guide (highly recommended) 7 Toolpack System installation

CentOS update

Update your system to CentOS 5.5

yum update

TelcoBridges repository

Add TelcoBridges repository file

 vim /etc/yum.repos.d/TB-Base.repo

Paste the following information in that file:

# TelcoBridges-Base.repo
#
# This repository is using TelcoBridges frozen version of CentOS
# to help client installing the required version of the
# applications required to run Toolpack
#

[tb-base]
name=TelcoBridges-$releasever - Base
baseurl=http://repo.telcobridges.com/centos/5.5/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5

#released updates
[tb-updates]
name=TelcoBridges-$releasever - Updates
baseurl=http://repo.telcobridges.com/centos/5.5/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5-tb

Get TelcoBridges repository key

cd /etc/pki/rpm-gpg/
wget http://repo.telcobridges.com/centos/RPM-GPG-KEY-CentOS-5-tb

Install Toolpack Prerequisites

When asked to 'Importing GPG key', answer yes.

yum groupinstall Toolpack-Prerequisites

Configure Toolpack Prerequisites

Configure ODBC

vim /etc/odbcinst.ini

Remove the '#' in front of each lines of the [MySQL] section Modify the 'Driver' line to set the correct driver

Example for 32 bits system:

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS.so
FileUsage       = 1	

Example for 64 bits system:

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib64/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS.so
FileUsage       = 1	

Configure MySQL

 vim /etc/my.cnf

Add 2 new variables in the file under the [mysqld] section:

• log-bin
• server-id=[UniqueId]

The server-id needs to be a non-zero unique value (do not use 0). If you use the host redundancy feature, the value needs to be different on each host .

Example:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
log-bin
server-id=5876
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

Start MySQL

service mysqld start

Configure MySQL Users

• Set password for the root user to 'tbdbpw' (TelcoBridges recommends that you set your own password for root)
• Enable root connection from localhost only
• Create a tbdb user (required by Toolpack)
• Remove anonymous connection

Example:

/usr/bin/mysqladmin -u root password tbdbpw

mysql -uroot -ptbdbpw
DELETE FROM mysql.user WHERE !(Host = 'localhost' AND User = 'root');
FLUSH PRIVILEGES;
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
FLUSH PRIVILEGES;
exit

Toolpack Development Prerequisite (Optional)

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++ libxml2-devel libpcap-devel unixODBC-devel

Validation Guide (highly recommended)

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