Toolpack prerequisite Debian4 2-3

This page shows the Toolpack 2-3 prerequisites for Debian 4.

Toolpack Prerequisite

WARNING: This prerequisite was not validate yet

Toolpack Basic packages

 apt-get install sysvconfig
 apt-get install zlib1g-dev

Toolpack System Database

1. Install mysql.

 apt-get install mysql-server
 apt-get install libmysqlclient15-dev

2. Configure mysql

 mysql_install_db
 service mysql start
 /usr/bin/mysqladmin -u root password 'mysql'
 mysql -u root -p
 
 exit

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/run/mysqld/mysqld.sock /tmp/mysql.sock

Set the permission. Select option 7 (Create full privileges) for all database (*) on all hosts (%) for the targeted user.

 mysql_setpermission

Install ODBC

 apt-get install unixodbc
 apt-get install libmyodbc

Configure ODBC to use the MySQL connector

 sudo odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d

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

 vi /etc/mysql/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:

 # The following can be used as easy to replay backup logs or for replication.
 server-id              = 1
 log_bin                = /var/log/mysql/mysql-bin.log

Restart MySQL service

 service mysqld restart

Toolpack System Web Portal

Install web server packages

 apt-get install libfcgi
 apt-get install libfcgi-dev
 apt-get install lighttpd
 apt-get install ruby irb ri rdoc build-essential 
 apt-get install rubygems
 apt-get install ruby1.8-dev
 apt-get install libopenssl-ruby1.8

Install fcgi gem

 gem install fcgi

Install libxml2 ( was already installed )

 apt-get install libxml2

Use the UI to prevent lighttpd to start at boot time. ( Remove the '*' besides the lighttpd service )

 sysvconfig

Stop the lighttpd service

 service lighttpd stop

Firewall seems to be disable by default. But if there is one, it needs to allow:

Service: http (12358/tcp)

Port: All ports (tcp/udp) enabled for local networks

Toolpack Stream Server

Install pcap0.8 for the stream server

 apt-get install libpcap0.8

Toolpack Development Prerequisite

Available soon

Toolpack System installation

Now that the prerequisite are installed, now it is time to install the Toolpack system