Toolpack prerequisite CentOS5 A

From TBwiki
(Difference between revisions)
Jump to: navigation, search
(revert procedure (something went wrong))
(re-enable simplify prerequisites procedure)
Line 1: Line 1:
−
This page shows the Toolpack 2-5 prerequisites for CentOS 5.
+
This page shows the Toolpack 2-5 prerequisites for CentOS 5.5.
  
 +
<span style="color:#B22222">
 +
''WARNING'': The host MUST have CentOS 5.5 installed. If you don't want to update your host, please follow the [[Toolpack_prerequisite_CentOS5_2-5_manual | manual procedure]] instead.
 +
</span>
  
−
== Toolpack Prerequisites ==
+
== CentOS update (Optional) ==
  
 +
If the host isn't version 5.5, it is possible to update using the following command
  
−
=== Toolpack Basic packages ===
+
yum update
  
−
The software listed below is required by the host machines.
+
== TelcoBridges repository ==
  
−
  yum install gcc zlib-devel gdbm
+
Add TelcoBridges repository file
  
−
=== Toolpack System Database ===
+
  vim /etc/yum.repos.d/TB-Base.repo
  
−
The Toolpack system database is used by the main host and requires mySQL database server. The
+
Paste the following information in that file:
−
system database packages are as follows:
+
  
−
  yum install mysql-server mysql-devel
+
# 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
  
−
Depending on the CentOS installation, the command paths for the database (i.e. mysql_install_db, mysqladmin, mysql) and system tools (chkconfig, service, etc) may not be included in the active PATH environment variable. MySql is usually installed in /usr/bin and system tools in sbin.
+
Get TelcoBridges repository key
  
−
1. start and enable mysql
+
cd /etc/pki/rpm-gpg/
 +
wget http://repo.telcobridges.com/centos/RPM-GPG-KEY-CentOS-5-tb
  
−
  /sbin/chkconfig mysqld on
+
== Install Toolpack Prerequisites ==
−
  /sbin/service mysqld start
+
  
−
2. Setup initial database root password
+
When ask to 'Importing GPG key', answer yes.
  
−
  /usr/bin/mysqladmin -u root password ''new-password-1''
+
yum groupinstall Toolpack-Prerequisites
−
  /usr/bin/mysqladmin -u root -p''new-password-1'' -h ''HostName'' password ''new-password-2''
+
  
−
'''IMPORTANT''': Please read the [http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html 'Securing the Initial MySQL Accounts'] article to learn how to manage users and privileges.
 
  
−
3. Install the database.
+
== Configure Toolpack Prerequisites ==
 +
=== Configure ODBC ===
  
−
  mysql_install_db
+
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
  
−
4. Log onto mysql, create a tbdb user. The ''[HostName]'', ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
+
Example:
−
If you cannot log in it is possible that the host name is not configure properly, use an IP Address instead.
+
  
−
  mysql -u root -p''new-password-1''
+
[MySQL]
−
  CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
+
Description    = ODBC for MySQL
−
  GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
+
Driver          = /usr/lib64/libmyodbc3_r.so
−
  FLUSH PRIVILEGES;
+
Setup          = /usr/lib/libodbcmyS.so
−
  exit
+
FileUsage      = 1
  
−
ex.
+
=== Configure MySQL ===
−
 
+
−
  mysql -u root -pMyDbRootPassword
+
−
  CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
+
−
  GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
+
−
  FLUSH PRIVILEGES;
+
−
  exit
+
−
 
+
−
To verify if the user is created:
+
−
 
+
−
  mysql -u root
+
−
  SELECT * FROM mysql.user;
+
−
  exit
+
−
 
+
−
5.Install odbc driver and driver manager
+
−
 
+
−
  yum install mysql-connector-odbc
+
−
 
+
−
5a. For 32 bits system:
+
−
 
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-32bit.tar.gz
+
−
  tar -zxf mysql-connector-odbc-3.51.27-linux-x86-32bit.tar.gz
+
−
  mkdir -p /lib/tb/toolpack/3rdparty/odbc-connector/
+
−
  cp mysql-connector-odbc-3.51.27-linux-x86-32bit/lib/libmyodbc3_r-3.51.27.so /lib/tb/toolpack/3rdparty/odbc-connector/
+
−
 
+
−
5b. For 64 bits system:
+
−
 
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-64bit.tar.gz
+
−
  tar -zxf mysql-connector-odbc-3.51.27-linux-x86-64bit.tar.gz
+
−
  mkdir -p /lib/tb/toolpack/3rdparty/odbc-connector/
+
−
  cp mysql-connector-odbc-3.51.27-linux-x86-64bit/lib/libmyodbc3_r-3.51.27.so /lib/tb/toolpack/3rdparty/odbc-connector/
+
−
 
+
−
 
+
−
6. Manually configure the odbc manager. Make sure mysql driver is enable(removing the comments for the mysql driver). Set the Driver as the previous command answer.
+
−
 
+
−
  vim /etc/odbcinst.ini
+
−
 
+
−
Here is an example:
+
−
 
+
−
  # 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
+
−
 
+
−
 
+
−
 
+
−
7. Configure mysql to support database replication (Will not interfere if your system do not use it).
+
  
 
   vim /etc/my.cnf
 
   vim /etc/my.cnf
  
−
Add 2 new variable in the mysql config file
+
Add 2 new variables in the file under the [mysqld] section:
−
 
+
*log-bin
−
Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).
+
*server-id=''[UniqueId]''
−
 
+
−
Make sure it is in 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:
 
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
  
−
  [root@TL-CENTOS64-02 tblab]# cat /etc/my.cnf
+
=== Start MySQL ===
−
  [mysqld]
+
−
  datadir=/var/lib/mysql
+
−
  socket=/var/lib/mysql/mysql.sock
+
−
  user=mysql
+
−
  log-bin
+
−
  server-id=1
+
−
  # Default to using old password format for compatibility with mysql 3.x
+
−
  # clients (those using the mysqlclient10 compatibility package).
+
−
  old_passwords=1
+
−
 
+
−
  [mysqld_safe]
+
−
  log-error=/var/log/mysqld.log
+
−
  pid-file=/var/run/mysqld/mysqld.pid
+
−
  [root@TL-CENTOS64-02 tblab]#
+
  
 +
service mysqld start
  
−
Reboot the mysql service
+
=== Configure MySQL Users ===
  
−
/sbin/service mysqld restart
+
*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
  
−
=== Toolpack System Web Portal  ===
+
Example:
−
 
+
−
The Toolpack System Web Portal is required in order to host the Toolpack Web Portal. It requires the execution of all following commands:
+
−
 
+
−
1. Manually install fcgi:
+
−
 
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/fcgi-2.4.0.tar.gz
+
−
  tar -xzf fcgi-2.4.0.tar.gz
+
−
  cd fcgi-2.4.0
+
−
  ./configure
+
−
  make
+
−
  make install
+
−
  cd ../
+
−
 
+
−
2. Install pcre, libxml2 and openssl:
+
−
 
+
−
  yum install pcre libxml2 openssl-devel
+
−
 
+
−
3. Install lighttpd:
+
−
 
+
−
3a. For 32 bits sytem:
+
−
 
+
−
  wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-1.4.18-1.el5.rf.i386.rpm
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-fastcgi-1.4.18-1.el5.rf.i386.rpm
+
−
  rpm -ivh lighttpd-1.4.18-1.el5.rf.i386.rpm lighttpd-fastcgi-1.4.18-1.el5.rf.i386.rpm
+
−
 
+
−
3b. For 64 bits sytem:
+
−
 
+
−
  wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-1.4.18-1.el5.rf.x86_64.rpm
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-fastcgi-1.4.18-1.el5.rf.x86_64.rpm
+
−
  rpm -ivh lighttpd-1.4.18-1.el5.rf.x86_64.rpm lighttpd-fastcgi-1.4.18-1.el5.rf.x86_64.rpm
+
−
 
+
−
<br>
+
−
 
+
−
4. Install ruby
+
−
 
+
−
4a. For 32 bits system:
+
−
 
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p174.tar.gz
+
−
  tar -zxf ruby-1.8.7-p174.tar.gz
+
−
  cd ruby-1.8.7-p174
+
−
  ./configure --libdir=/usr/local/lib  --enable-shared
+
−
  make
+
−
  make install
+
−
  cd ext/openssl/
+
−
  ruby extconf.rb
+
−
  make
+
−
  make install
+
−
  cd ../../..
+
−
  ln -s /usr/local/bin/ruby /usr/bin/ruby
+
−
  ln -s /usr/local/lib/libruby.so.1.8 /lib/libruby.so.1.8
+
−
 
+
−
 
+
−
4b. For 64 bits system:
+
−
 
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p174.tar.gz
+
−
  tar -zxf ruby-1.8.7-p174.tar.gz
+
−
  cd ruby-1.8.7-p174
+
−
  ./configure --libdir=/usr/local/lib64 --enable-shared
+
−
  make
+
−
  make install
+
−
  cd ext/openssl/
+
−
  ruby extconf.rb
+
−
  make
+
−
  make install
+
−
  cd ../../..
+
−
  ln -s /usr/local/bin/ruby /usr/bin/ruby
+
−
  ln -s /usr/local/lib64/libruby.so.1.8 /lib64/libruby.so.1.8
+
−
 
+
−
<br> 5. Install RubyGems 1.3.5
+
−
 
+
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/rubygems-1.3.5.tgz
+
−
  tar -zxf rubygems-1.3.5.tgz
+
−
  cd rubygems-1.3.5
+
−
  ruby setup.rb
+
−
  cd ..
+
−
 
+
−
6. Install gem fcgi
+
−
 
+
−
  /usr/local/bin/gem install fcgi
+
−
 
+
−
<br> Make sure that the firewall enables these following services and ports. Failure to open those ports will render socket communication between the distributed software elements unavailable.
+
−
 
+
−
Service: http (12358/tcp)
+
−
 
+
−
Port: All ports (tcp/udp) enabled for local networks
+
−
 
+
−
Make sure that SELinux is disabled.
+
−
 
+
−
=== Toolpack Stream Server ===
+
−
 
+
−
The Tmedia Toolpack Stream Server requires the execution of the following commands:
+
  
−
  yum install libpcap
+
/usr/bin/mysqladmin -u root password tbdbpw
 +
/usr/bin/mysqladmin -u root -ptbdbpw -h 127.0.0.1 password tbdbpw
  
 +
mysql -uroot -ptbdbpw
 +
DELETE FROM mysql.user WHERE !((Host = 'localhost' AND User = 'root') OR (Host = '127.0.0.1' 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 ===
+
== 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:
 
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
+
yum install gcc-c++ libxml2-devel libpcap-devel unixODBC-devel
  
  
Line 240: Line 124:
 
== Toolpack System installation ==
 
== Toolpack System installation ==
  
−
Now that the prerequisite are installed, now it is time to install the [[toolpack_installer_2-5|Toolpack system]]
+
Now that the prerequisite are installed, now it is time to install the [[toolpack_installer_2-4|Toolpack system]]

Revision as of 10:52, 28 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

When ask 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 '/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 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
/usr/bin/mysqladmin -u root -ptbdbpw -h 127.0.0.1 password tbdbpw

mysql -uroot -ptbdbpw
DELETE FROM mysql.user WHERE !((Host = 'localhost' AND User = 'root') OR (Host = '127.0.0.1' 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

Retrieved from "https://docs.telcobridges.com/mediawiki/index.php?title=Toolpack_prerequisite_CentOS5_A&oldid=8351"
Personal tools