Toolpack migration CentOS5 2-3 - Revision history

Abrassard: /* Configure ODBC driver manager */

2010-06-21T18:17:21Z

Configure ODBC driver manager

Abrassard: /* Configure ODBC driver manager */

2010-06-21T18:15:57Z

Configure ODBC driver manager

Cbilodeau: add disable 2.2 system

2009-06-05T12:50:25Z

add disable 2.2 system

Cbilodeau at 13:47, 29 May 2009

2009-05-29T13:47:04Z

Cbilodeau: add mysql connection through host name

2009-05-29T13:45:48Z

add mysql connection through host name

Cbilodeau: /* Enable MySQL database replication */

2009-05-19T20:12:36Z

Enable MySQL database replication

Cbilodeau: Toolpack migration centos5 2-3 moved to Toolpack migration CentOS5 2-3: move to correct cases

2009-05-19T19:32:54Z

Toolpack migration centos5 2-3 moved to Toolpack migration CentOS5 2-3: move to correct cases

10.0.0.157: Modify to the real migration guide

2009-05-19T18:41:15Z

Modify to the real migration guide

Show changes

10.0.0.157: /* Toolpack System installation */

2009-05-19T18:01:50Z

Toolpack System installation

Cbilodeau: New page: This page shows the Toolpack 2-3 prerequisites for Centos 5. == Toolpack Prerequisite == === Toolpack Basic packages === The software listed below is required by the host machines. ...

2009-05-14T13:02:55Z

New page: This page shows the Toolpack 2-3 prerequisites for Centos 5. == Toolpack Prerequisite == === Toolpack Basic packages === The software listed below is required by the host machines. ...

New page

This page shows the Toolpack 2-3 prerequisites for Centos 5.

== Toolpack Prerequisite ==

=== Toolpack Basic packages ===

The software listed below is required by the host machines.

yum install gcc
yum install zlib-devel2

=== 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
yum install 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

chkconfig mysqld on
service mysqld start

2. Install the database.

mysql_install_db

3. Log onto mysql, create a tbdb user. The ''[DatabaseUsername]'' and ''[DatabasePassword]'' will need to be supplied to the toolpack installer.

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

ex.

mysql -u root -p
CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
GRANT ALL PRIVILEGES ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
exit

To verify if the user is created:

mysql -u root -p
SELECT * FROM mysql.user;
exit

4. Retrieve the socket path (this command will give the path to the socket file).

mysql_config --socket

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

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

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

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.

vim /etc/odbcinst.ini

Here is an example:

# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1

9. Configure mysql to support database replication (Will not interfere if your system do not use it).

vim my.ini

Add 2 new variable in the mysql config file

vim /etc/my.cnf

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

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.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
yum install 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:

gem install fcgi

8. Install libxml:

yum install libxml2

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

=== 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
yum install zlib-devel

== Toolpack System installation ==

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

@@ Line 43: / Line 43: @@
 === Configure ODBC driver manager ===
-*Enable the MySQL driver is enable (remove the comments for the MySQL driver).
+*Enable the MySQL driver is enable (remove the comments for the MySQL driver). '''***WARNING: There must be no space at the beginning of the line'''
 *Set the Driver to /lib/tb/toolpack/3rdparty/odbc-connector/
@@ Line 57: / Line 57: @@
    Setup           = /usr/lib/libodbcmyS.so
    FileUsage       = 1
 === Enable MySQL database replication ===

@@ Line 8: / Line 8: @@
 Connect to MySQL and create a new user tbdb with all privilege.
-If you are unable to connect, use an IP Address instead of the ''[HostName]''
+If you are unable to connect, use an IP Address instead of the ''[HostName]''.
    mysql -u root -h '[HostName]'
@@ Line 16: / Line 16: @@
 Example
-   mysql -u root -h TB003539
+   mysql -u root -h centos64-02
    CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';

@@ Line 8: / Line 8: @@
 Connect to MySQL and create a new user tbdb with all privilege.
-   mysql -u root
+   mysql -u root -h '[HostName]'
    CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
@@ Line 15: / Line 16: @@
 Example
-   mysql -u root
+   mysql -u root -h TB003539
    CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
    GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';

← Older revision		Revision as of 18:01, 19 May 2009
Line 223:		Line 223:
	== Toolpack System installation ==		== Toolpack System installation ==

−	Now that the prerequisite are installed, ~~now it is time~~ to ~~install~~ the [[~~toolpack_installer_2~~-3\|Toolpack ~~system~~]]	+	Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3\|Toolpack migration 2-3]].

@@ Line 52: / Line 52: @@
    # Driver from the MyODBC package
    # Setup from the unixODBC package
-   [MySQL]
+   [MySQL]                                              <----- This line must NOT start with a '#'. Must also not start with a space.
    Description     = ODBC for MySQL
    Driver          = /lib/tb/toolpack/3rdparty/odbc-connector/libmyodbc3_r-3.51.27.so

@@ Line 93: / Line 93: @@
    pid-file=/var/run/mysqld/mysqld.pid
    [root@TL-CENTOS64-02 tblab]#
 === Restart MySQL service ===
    service mysqld restart
 == Toolpack System installation ==
 Now that the prerequisite are installed, we can go back to the migration guide [[Toolpack_migration_2-3|Toolpack migration 2-3]].