Toolpack prerequisite Debian4 2-3
(→Toolpack Stream Server) |
(add database replication) |
||
| Line 66: | Line 66: | ||
mysql_setpermission | mysql_setpermission | ||
| − | Install | + | Install ODBC |
apt-get install unixodbc | apt-get install unixodbc | ||
| Line 72: | Line 72: | ||
| − | + | Configure ODBC to use the MySQL connector | |
sudo odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d | 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 | ||
Revision as of 09:30, 25 May 2009
This page shows the Toolpack 2-3 prerequisites for Debian 4.
Contents |
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
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
