Actions

Toolpack prerequisite CentOS5 A: Difference between revisions

(fix mysql root password procedure)
(revert procedure (something went wrong))
Line 1: Line 1:
This page shows the Toolpack 2-5 prerequisites for CentOS 5.5.
This page shows the Toolpack 2-5 prerequisites for CentOS 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>


== CentOS update (Optional) ==
== Toolpack Prerequisites ==


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


  yum update
=== Toolpack Basic packages ===


== TelcoBridges repository ==
The software listed below is required by the host machines.


Add TelcoBridges repository file
  yum install gcc zlib-devel gdbm


  vim /etc/yum.repos.d/TB-Base.repo
=== Toolpack System Database ===


Paste the following information in that file:
The Toolpack system database is used by the main host and requires mySQL database server. The
system database packages are as follows:


# TelcoBridges-Base.repo
  yum install mysql-server mysql-devel
#
# 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
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.


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


== Install Toolpack Prerequisites ==
  /sbin/chkconfig mysqld on
  /sbin/service mysqld start


  yum groupinstall Toolpack-Prerequisites
2. Setup initial database root password


  /usr/bin/mysqladmin -u root password ''new-password-1''
  /usr/bin/mysqladmin -u root -p''new-password-1'' -h ''HostName'' password ''new-password-2''


== Configure Toolpack Prerequisites ==
'''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.
=== Configure ODBC ===


  vim /etc/odbcinst.ini
3. Install the database.


Remove the '#' in front of each lines of the [MySQL] section
  mysql_install_db
Modify the 'Driver' line to '/usr/lib64/libmyodbc3_r.so


Example:


   [MySQL]
4. Log onto mysql, create a tbdb user. The ''[HostName]'', ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
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''
  CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
  GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
  FLUSH PRIVILEGES;
  exit
 
ex.
 
  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
   Description    = ODBC for MySQL
   Driver          = /usr/lib64/libmyodbc3_r.so
   Driver          = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so
   Setup          = /usr/lib/libodbcmyS.so
   Setup          = /usr/lib/libodbcmyS.so
   FileUsage      = 1
   FileUsage      = 1


=== Configure MySQL ===
 
 
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 variables in the file under the [mysqld] section:
Add 2 new variable in the mysql config file
*log-bin
 
*server-id=''[UniqueId]''
Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).
 
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:
  [root@TL-CENTOS64-02 tblab]# cat /etc/my.cnf
   [mysqld]
   [mysqld]
   datadir=/var/lib/mysql
   datadir=/var/lib/mysql
Line 81: Line 117:
   user=mysql
   user=mysql
   log-bin
   log-bin
   server-id=5876
   server-id=1
   # Default to using old password format for compatibility with mysql 3.x
   # Default to using old password format for compatibility with mysql 3.x
   # clients (those using the mysqlclient10 compatibility package).
   # clients (those using the mysqlclient10 compatibility package).
   old_passwords=1
   old_passwords=1
 
  [mysqld_safe]
  log-error=/var/log/mysqld.log
  pid-file=/var/run/mysqld/mysqld.pid
  [root@TL-CENTOS64-02 tblab]#


=== Start MySQL ===


  service mysqld start
Reboot the mysql service


=== Configure MySQL Users ===
/sbin/service mysqld restart


*Set password for the root user to 'tbdbpw' (TelcoBridges recommend that you set your own password for root)
=== Toolpack System Web Portal  ===
*Create a tbdb user (required by Toolpack)
*Remove anonymous connection


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:


/usr/bin/mysqladmin -u root password tbdbpw
  yum install libpcap


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) ==
=== Toolpack Development Prerequisite ===
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:


Line 119: Line 240:
== Toolpack System installation ==
== Toolpack System installation ==


Now that the prerequisite are installed, now it is time to install the [[toolpack_installer_2-4|Toolpack system]]
Now that the prerequisite are installed, now it is time to install the [[toolpack_installer_2-5|Toolpack system]]

Revision as of 11:33, 25 January 2011

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


Toolpack Prerequisites

Toolpack Basic packages

The software listed below is required by the host machines. 

 yum install gcc zlib-devel gdbm

Toolpack System Database

The Toolpack system database is used by the main host and requires mySQL database server. The system database packages are as follows: 

 yum install mysql-server mysql-devel

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.

1. start and enable mysql 

 /sbin/chkconfig mysqld on
 /sbin/service mysqld start

2. Setup initial database root password 

 /usr/bin/mysqladmin -u root password new-password-1
 /usr/bin/mysqladmin -u root -pnew-password-1 -h HostName password new-password-2

IMPORTANT: Please read the 'Securing the Initial MySQL Accounts' article to learn how to manage users and privileges.

3. Install the database. 

 mysql_install_db


4. Log onto mysql, create a tbdb user. The [HostName], [DatabaseUsername] and [DatabasePassword] will need to be supplied to the toolpack installer. If you cannot log in it is possible that the host name is not configure properly, use an IP Address instead. 

 mysql -u root -pnew-password-1
 CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 FLUSH PRIVILEGES;
 exit

ex. 

 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

Add 2 new variable in the mysql config file

Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).

Make sure it is in the [mysqld] section 

 log-bin
 server-id=[UniqueId]


Example: 

 [root@TL-CENTOS64-02 tblab]# cat /etc/my.cnf
 [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]#


Reboot the mysql service 

/sbin/service mysqld restart

Toolpack System Web Portal

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


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


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


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


Toolpack Development Prerequisite

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/w/index.php?title=Toolpack_prerequisite_CentOS5_A&oldid=8346"