Toolpack prerequisite CentOS4 2-5

From TBwiki
(Difference between revisions)
Jump to: navigation, search
(creation)
 
m (Forgot to add the line in the 'example' section)
 
(11 intermediate revisions by 3 users not shown)
Line 9: Line 9:
 
The software listed below is required by the host machines.
 
The software listed below is required by the host machines.
  
−
   yum install gcc zlib-devel
+
   yum install gcc zlib-devel openssl-devel perl-DBI
  
 
=== Toolpack System Database ===
 
=== Toolpack System Database ===
Line 52: Line 52:
 
   mysql_install_db
 
   mysql_install_db
  
 +
'''IMPORTANT''': By default CentOS allow anonymous connections.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. Log onto mysql, create a tbdb user. The ''[HostName]'', ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
 
3. Log onto mysql, create a tbdb user. The ''[HostName]'', ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.
Line 59: Line 60:
 
   CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 
   CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 
   GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 
   GRANT ALL PRIVILEGES ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 +
  FLUSH PRIVILEGES;
 
   exit
 
   exit
  
Line 66: Line 68:
 
   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';
 +
  FLUSH PRIVILEGES;
 
   exit
 
   exit
  
Line 74: Line 77:
 
   exit
 
   exit
  
−
4. Retrieve the socket path (this command will give the path to the socket file).
 
  
−
  mysql_config --socket
+
4.Install odbc driver and driver manager
−
 
+
−
5. Create a symbolic link to the path retrieve using the last command.
+
−
 
+
−
  ln -s <PATH TAKEN FROM THE LAST CMD> /tmp/mysql.sock
+
−
 
+
−
For example:
+
−
 
+
−
  ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
+
−
 
+
−
6. Set the permission. Select option 7 (Create full privileges) for all database (*) on all hosts (%) for
+
−
the user ''[DatabaseUsername]'' (i.e. tbdb).
+
−
 
+
−
  mysql_setpermission
+
−
 
+
−
 
+
−
7.Install odbc driver and driver manager
+
  
 
   yum install mysql-connector-odbc
 
   yum install mysql-connector-odbc
  
−
7a. For 32 bits sytem:
+
4a. For 32 bits sytem:
  
 
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-32bit.tar.gz
 
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-32bit.tar.gz
Line 103: Line 89:
 
   cp mysql-connector-odbc-3.51.27-linux-x86-32bit/lib/libmyodbc3_r-3.51.27.so /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/
  
−
7b. For 64 bits sytem:
+
4b. For 64 bits sytem:
  
 
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-64bit.tar.gz
 
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/mysql-connector-odbc-3.51.27-linux-x86-64bit.tar.gz
Line 111: Line 97:
  
  
−
8. 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.
+
5. Manually configure the odbc manager.
 +
 
 +
  yum install unixODBC
  
−
8a. For 32 bits system:
+
Set the mysql odbc driver to its new value. Make sure mysql driver is enable(removing the comments for the mysql driver)
−
  yum install unixODBC.i386 ????
+
−
8b. For 64 bits system:
+
−
  yum install unixODBC.x86_64 ????
+
  
 
   vim /etc/odbcinst.ini  
 
   vim /etc/odbcinst.ini  
Line 132: Line 117:
  
  
−
9. Configure mysql to support database replication (Will not interfere if your system do not use it).
+
6. Configure mysql to support database replication (Will not interfere if your system do not use it).
  
 
   vim /etc/my.cnf
 
   vim /etc/my.cnf
Line 139: Line 124:
  
 
Add log-bin and server-id. The value of server-id needs to be unique on each host( do not use 0 ).
 
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
 
Make sure it is in the [mysqld] section
−
 
 
   log-bin
 
   log-bin
 
   server-id=''[UniqueId]''
 
   server-id=''[UniqueId]''
 +
  skip-name-resolve
 +
 +
Add max_allowed_packet to increase the maximum size of binary blobs in the database.
 +
Make sure it is in the [mysqld] section AND [mysqldump] section
 +
  max_allowed_packet = 200MB
  
  
Line 155: Line 143:
 
   log-bin
 
   log-bin
 
   server-id=1
 
   server-id=1
 +
  max_allowed_packet = 200MB
 +
  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
 
   # clients (those using the mysqlclient10 compatibility package).
 
   # clients (those using the mysqlclient10 compatibility package).
Line 163: Line 153:
 
   pid-file=/var/run/mysqld/mysqld.pid
 
   pid-file=/var/run/mysqld/mysqld.pid
 
   [root@TL-CENTOS64-02 tblab]#
 
   [root@TL-CENTOS64-02 tblab]#
−
 
+
 
 +
  [mysqldump]
 +
  max_allowed_packet = 200MB
  
 
Reboot the mysql service
 
Reboot the mysql service
Line 185: Line 177:
 
2. Install pcre:
 
2. Install pcre:
  
−
2a. for 32 bits systems
+
   yum install pcre
−
   yum install pcre.i386      ??????
+
−
2b. For 64 bits system
+
−
  yum install pcre.x86_64    ??????
+
  
 
3. Install lighttpd:
 
3. Install lighttpd:
Line 255: Line 244:
 
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/fcgi-0.8.8.gem
 
   wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/fcgi-0.8.8.gem
 
   gem install ./fcgi-0.8.8.gem
 
   gem install ./fcgi-0.8.8.gem
−
 
−
In case the gem file is corrupted (or the site is unavailable), follow the following guidelines to compile the gem directly:
 
−
 
 
−
  wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/ruby-fcgi-0.8.7.tar.gz
 
−
  tar -xzvf ruby-fcgi-0.8.7.tar.gz    ????????
 
−
  cd ruby-fcgi-0.8.7
 
−
  ruby install.rb config
 
−
  ruby install.rb setup
 
−
  ruby install.rb install
 
−
  cd ../
 
−
 
−
8. Install libxml:
 
−
 
−
8a. For 32 bits sytem:
 
−
 
−
  wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-2.6.16-12.i386.rpm
 
−
  wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-devel-2.6.16-12.i386.rpm
 
−
  rpm -ivh libxml2-2.6.16-12.i386.rpm libxml2-devel-2.6.16-12.i386.rpm
 
−
 
−
8b. For 64 bits sytem:
 
−
 
−
  wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-2.6.16-12.x86_64.rpm
 
−
  wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/libxml2-devel-2.6.16-12.x86_64.rpm
 
−
  rpm -ivh libxml2-2.6.16-12.x86_64.rpm libxml2-devel-2.6.16-12.x86_64.rpm
 
  
  
Line 298: Line 263:
 
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++ unixODBC-devel
+
   yum install gcc-c++ glibc-devel unixODBC-devel libxml2-devel libpcap-devel libiao libiao-devel
  
 
== Validation Guide (Optional) ==
 
== Validation Guide (Optional) ==
−
If you would like to verify your installation go to the [[Toolpack_Installation:Validate_Toolpack_Installation|Toolpack Validation Guide]]
+
If you would like to verify your installation go to the [[Toolpack_Installation:Validate_Toolpack_Installation_2-5|Toolpack Validation Guide]]
−
 
+
  
 
== 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-5|Toolpack system]]

Latest revision as of 10:13, 5 March 2014

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


Contents

Toolpack Prerequisite

Toolpack Basic packages

The software listed below is required by the host machines. 

 yum install gcc zlib-devel openssl-devel perl-DBI

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:

a. For 32 bits sytem: 

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-server-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-devel-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-libs-5.0.68-1.el4_6.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/perl-DBD-MySQL-2.9004-3.1.centos4.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysqlclient14-4.1.22-1.el4s1.1.i386.rpm
 rpm -ivh mysql-server-5.0.68-1.el4_6.i386.rpm mysql-devel-5.0.68-1.el4_6.i386.rpm mysql-5.0.68-1.el4_6.i386.rpm mysql-libs-5.0.68-1.el4_6.i386.rpm perl-DBD-MySQL-2.9004-3.1.centos4.i386.rpm mysqlclient14-4.1.22-1.el4s1.1.i386.rpm

b. For 64 bits sytem: 

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-server-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-devel-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysql-libs-5.0.68-1.el4_6.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/perl-DBD-MySQL-2.9004-3.1.centos4.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/mysqlclient14-4.1.22-1.el4s1.1.x86_64.rpm
 rpm -ivh mysql-server-5.0.68-1.el4_6.x86_64.rpm mysql-devel-5.0.68-1.el4_6.x86_64.rpm mysql-5.0.68-1.el4_6.x86_64.rpm mysql-libs-5.0.68-1.el4_6.x86_64.rpm perl-DBD-MySQL-2.9004-3.1.centos4.x86_64.rpm mysqlclient14-4.1.22-1.el4s1.1.x86_64.rpm


Then, install the encryption package. 

 yum install openssl

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 

 chkconfig mysqld on
 service mysqld start

2. Install the database. 

 mysql_install_db

IMPORTANT: By default CentOS allow anonymous connections.Please read the 'Securing the Initial MySQL Accounts' article to learn how to manage users and privileges.

3. 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 of the [HostName]. 

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

ex. 

 mysql -u root -h centos64-02 -p
 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 -p
 SELECT * FROM mysql.user;
 exit


4.Install odbc driver and driver manager 

 yum install mysql-connector-odbc

4a. For 32 bits sytem: 

 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/

4b. For 64 bits sytem: 

 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/


5. Manually configure the odbc manager. 

 yum install unixODBC

Set the mysql odbc driver to its new value. Make sure mysql driver is enable(removing the comments for the mysql driver) 

 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


6. 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]
 skip-name-resolve

Add max_allowed_packet to increase the maximum size of binary blobs in the database. Make sure it is in the [mysqld] section AND [mysqldump] section 

 max_allowed_packet = 200MB


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
 max_allowed_packet = 200MB
 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]#
 
 [mysqldump]
 max_allowed_packet = 200MB

Reboot the mysql service 

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: 

 yum install pcre

3. Install lighttpd:

3a. For 32 bits sytem: 

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-1.4.20-6.el4.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/spawn-fcgi-1.4.20-6.el4.i386.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-fastcgi-1.4.20-6.el4.i386.rpm
 rpm -ivh lighttpd-1.4.20-6.el4.i386.rpm lighttpd-fastcgi-1.4.20-6.el4.i386.rpm spawn-fcgi-1.4.20-6.el4.i386.rpm

3b. For 64 bits sytem: 

 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-1.4.20-6.el4.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/spawn-fcgi-1.4.20-6.el4.x86_64.rpm
 wget -c http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/centos/lighttpd-fastcgi-1.4.20-6.el4.x86_64.rpm
 rpm -ivh lighttpd-1.4.20-6.el4.x86_64.rpm lighttpd-fastcgi-1.4.20-6.el4.x86_64.rpm spawn-fcgi-1.4.20-6.el4.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 ..

7. Install gem fcgi: 

 wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/linux/fcgi-0.8.8.gem
 gem install ./fcgi-0.8.8.gem


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

Disabling SELinux

Check SELinux status 

 sestatus

If SELinux is enable, see the Disabling SELinux article to disable it.

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

Validation Guide (Optional)

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_CentOS4_2-5&oldid=15134"
Personal tools