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

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

Install pcap0.8 for the stream server apt-get install libpcap0.8

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