Toolpack prerequisite CentOS5 A

From TBwiki
(Difference between revisions)
Jump to: navigation, search
(Configure MySQL Users: add mysql login command)
(fix mysql root password procedure)
Line 92: Line 92:
 
=== Configure MySQL Users ===
 
=== Configure MySQL Users ===
  
 +
*Set password for the root user to 'tbdbpw' (TelcoBridges recommend that you set your own password for root)
 
*Create a tbdb user (required by Toolpack)
 
*Create a tbdb user (required by Toolpack)
 
*Remove anonymous connection
 
*Remove anonymous connection
*Set password for the root user to 'tbdbpw' (TelcoBridges recommend that you set your own password for root)
 
  
 
Example:
 
Example:
  
  mysql -uroot
+
/usr/bin/mysqladmin -u root password tbdbpw
 +
 
 +
  mysql -uroot -ptbdbpw
 
  CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 
  CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 
  GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 
  GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 
  DELETE FROM mysql.user WHERE user='';
 
  DELETE FROM mysql.user WHERE user='';
SET PASSWORD FOR 'root' = PASSWORD('tbdbpw');
 
 
  FLUSH PRIVILEGES;
 
  FLUSH PRIVILEGES;
 +
exit
  
 
== Toolpack Development Prerequisite (Optional) ==
 
== Toolpack Development Prerequisite (Optional) ==

Revision as of 10:15, 25 January 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.

Contents

CentOS update (Optional)

If the host isn't version 5.5, it is possible to update using the following command

 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

 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 '/usr/lib64/libmyodbc3_r.so

Example:

 [MySQL]
 Description     = ODBC for MySQL
 Driver          = /usr/lib64/libmyodbc3_r.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 recommend that you set your own password for root)
  • Create a tbdb user (required by Toolpack)
  • Remove anonymous connection

Example:

/usr/bin/mysqladmin -u root password tbdbpw
mysql -uroot -ptbdbpw
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
DELETE FROM mysql.user WHERE user=;
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

Personal tools