Toolpack prerequisite CentOS5 2-3
(add selinux link) |
(add clarification about the odbc configuration file) |
||
Line 85: | Line 85: | ||
# Driver from the MyODBC package | # Driver from the MyODBC package | ||
# Setup from the unixODBC package | # Setup from the unixODBC package | ||
− | [MySQL] | + | [MySQL] <----- This line must NOT start with a '#' |
Description = ODBC for MySQL | Description = ODBC for MySQL | ||
Driver = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so | Driver = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so |
Revision as of 14:42, 13 April 2010
This page shows the Toolpack 2-3 prerequisites for CentOS 5.
Contents |
Toolpack Prerequisites
Toolpack Basic packages
The software listed below is required by the host machines.
yum install gcc zlib-devel
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
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 and libxml2:
yum install pcre libxml2
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:
yum install ruby ruby-devel
6. Manually install rubygems:
wget http://download.distribution.telcobridges.com/3rdparty/prerequisite/src/centos/rubygems-0.9.0.tgz tar -xzf rubygems-0.9.0.tgz cd rubygems-0.9.0 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 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++ yum install libxml2-devel yum install libpcap-devel yum install unixODBC-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