Toolpack prerequisite CentOS5 2-5 manual

From TBwiki
(Difference between revisions)
Jump to: navigation, search
m (Added skip_name_resolve for mysql config)
m (skip-name-resolve must be with "dash")
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This page shows the Toolpack 2-5 prerequisites for CentOS 5.  
+
This page shows how to manually install the prerequisites for Toolpack 2-5 on CentOS 5.x (instead of using the [[Toolpack_prerequisite_CentOS5_2-5| repository procedure]])
  
 
<br>  
 
<br>  
Line 26: Line 26:
 
2. Setup initial database root password  
 
2. Setup initial database root password  
  
   /usr/bin/mysqladmin -u root password ''new-password-1''
+
   /usr/bin/mysqladmin -u root password tbdbpw
/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.  
 
'''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.  
Line 35: Line 34:
 
   mysql_install_db
 
   mysql_install_db
  
<br> 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.
+
<br> 4. Configure MySQL Users
  
  mysql -u root -p''new-password-1''
+
*Set password for the root user to 'tbdbpw' (TelcoBridges recommends that you set your own password for root)
CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
+
*Enable root connection from localhost only
GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
+
*Create a tbdb user (required by Toolpack)
FLUSH PRIVILEGES;
+
*Remove anonymous connection
exit
+
  
ex.
+
Example:
  
  mysql -u root -pMyDbRootPassword
+
/usr/bin/mysqladmin -u root password tbdbpw
 +
 
 +
mysql -uroot -ptbdbpw
 +
DELETE FROM mysql.user WHERE&nbsp;!(Host = 'localhost' AND User = 'root');
 +
FLUSH PRIVILEGES;
 
  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';
Line 53: Line 55:
 
To verify if the user is created:  
 
To verify if the user is created:  
  
  mysql -u root
+
mysql -uroot -ptbdbpw
 
  SELECT * FROM mysql.user;
 
  SELECT * FROM mysql.user;
 
  exit
 
  exit
Line 105: Line 107:
 
   
 
   
 
  #Added to remove mysql dependency on DNS/nameserver
 
  #Added to remove mysql dependency on DNS/nameserver
  skip_name_resolve
+
skip-name-resolve
 
   
 
   
  
Line 119: Line 121:
 
   
 
   
 
  #Added to remove mysql dependency on DNS/nameserver
 
  #Added to remove mysql dependency on DNS/nameserver
  skip_name_resolve
+
skip-name-resolve
 
   
 
   
 
  # Default to using old password format for compatibility with mysql 3.x
 
  # Default to using old password format for compatibility with mysql 3.x
Line 148: Line 150:
 
  cd ../
 
  cd ../
  
2. Install pcre, libxml2 and openssl:  
+
2. Install the following packages:  
  
   yum install pcre libxml2 openssl-devel
+
   yum install pcre libxml2 openssl-devel bzip2-libs
  
 
3. Install lighttpd:  
 
3. Install lighttpd:  
Line 169: Line 171:
  
 
4. Install ruby  
 
4. Install ruby  
 +
wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p299.tar.gz
 +
tar -zxf ruby-1.8.7-p299.tar.gz
 +
cd ruby-1.8.7-p299
  
4a. For 32 bits system:  
+
For 32 bits system:
 +
  ./configure --libdir=/usr/local/lib  --enable-shared
  
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p174.tar.gz
+
For 64 bits system:  
tar -zxf ruby-1.8.7-p174.tar.gz
+
  ./configure --libdir=/usr/local/lib64 --enable-shared
cd ruby-1.8.7-p174
+
 
  ./configure --libdir=/usr/local/lib  --enable-shared
+
Then, execute the following for either 32 or 64 bits system:
 
  make
 
  make
 
  make install
 
  make install
Line 184: Line 190:
 
  cd ../../..
 
  cd ../../..
 
  ln -s /usr/local/bin/ruby /usr/bin/ruby
 
  ln -s /usr/local/bin/ruby /usr/bin/ruby
 +
 +
For 32 bits system:
 
  ln -s /usr/local/lib/libruby.so.1.8 /lib/libruby.so.1.8
 
  ln -s /usr/local/lib/libruby.so.1.8 /lib/libruby.so.1.8
  
<br> 4b. For 64 bits system:  
+
For 64 bits system:  
 
+
   ln -s /usr/local/lib64/libruby.so.1.8 /lib64/libruby.so.1.8
   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
+
<br> 5. Install RubyGems 1.3.7
  
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/rubygems-1.3.5.tgz
+
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/rubygems-1.3.7.tgz
  tar -zxf rubygems-1.3.5.tgz
+
  tar -zxf rubygems-1.3.7.tgz
  cd rubygems-1.3.5
+
  cd rubygems-1.3.7
 
  ruby setup.rb
 
  ruby setup.rb
 
  cd ..
 
  cd ..

Latest revision as of 12:35, 9 January 2017

This page shows how to manually install the prerequisites for Toolpack 2-5 on CentOS 5.x (instead of using the repository procedure)


Contents

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 tbdbpw

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. 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

To verify if the user is created:

mysql -uroot -ptbdbpw
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]

#Added to remove mysql dependency on DNS/nameserver
skip-name-resolve


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

#Added to remove mysql dependency on DNS/nameserver
skip-name-resolve

# 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 the following packages:

 yum install pcre libxml2 openssl-devel bzip2-libs

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

wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-1.8.7-p299.tar.gz
tar -zxf ruby-1.8.7-p299.tar.gz
cd ruby-1.8.7-p299

For 32 bits system:

 ./configure --libdir=/usr/local/lib  --enable-shared

For 64 bits system:

./configure --libdir=/usr/local/lib64 --enable-shared

Then, execute the following for either 32 or 64 bits system:

make
make install
cd ext/openssl/
ruby extconf.rb
make
make install
cd ../../..
ln -s /usr/local/bin/ruby /usr/bin/ruby

For 32 bits system:

ln -s /usr/local/lib/libruby.so.1.8 /lib/libruby.so.1.8

For 64 bits system:

 ln -s /usr/local/lib64/libruby.so.1.8 /lib64/libruby.so.1.8


5. Install RubyGems 1.3.7

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/rubygems-1.3.7.tgz
tar -zxf rubygems-1.3.7.tgz
cd rubygems-1.3.7
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

Personal tools