IBSng Accounting Software (Free Version) on Slackware Linux
Dear readers;
I’ve decided to explain the IBSng Integrated Accounting Software (ParsPooyesh Co.)Here we have a free version of this accounting that provides most of the functions that you need for LAN ACCOUNTING.The bandwidth management of this version works too. It’s great for working on small networks which needs LAN Accounting or dial-up accounting for free.For more information about the IBSng go to http://www.parspooyesh.com/ .
Lets’ do Server Stuff
1. Make sure you’ve configured the apache web server and php before and it works well. (php needs libpng for IBSng graphs)
2. I will Downgrade the Python from 2.7 to 2.3.7, with the default version (2.7) we can’t create users in IBSng due the xmlrpc error.
3. IBSng uses PostgreSQL as Database server. We need to install and configure the Postgresql and Pygresql (PostgreSQL module for Python) before IBSng installation.
PostgreSQL & PyGreSQL Installation:
Downgrade the Python:
removepkg python rm -rf /usr/lib/python2.7 cd /usr/src/ wget http://python.org/ftp/python/2.3.7/Python-2.3.7.tar.bz2 tar -jxvf Python-2.3.7.tar.bz2 cd Python-2.3.7 ./configure --prefix=/usr/lib/python-2.3 make; make install ln -sfn /usr/lib/python-2.3/bin/python /usr/bin/
postgresql:
wget https://ftp.postgresql.org/pub/source/v9.2.16/postgresql-9.2.16.tar.gz tar -zxvf postgresql-9.2.16.tar.gz cd postgresql-9.2.16 ./configure gmake; gmake install groupadd postgres useradd postgres -g postgres mkdir /usr/local/pgsql/data chown -R postgres /usr/local/pgsql/data/ cd ln -sfn /usr/local/pgsql/bin/* /usr/bin su - postgres initdb -D /usr/local/pgsql/data/ postgres -D /usr/local/pgsql/data/ > /usr/local/pgsql/data/logfile 2>&1 & ps -A|grep postgres 17393 pts/0 00:00:00 postgres 17395 ? 00:00:00 postgres 17396 ? 00:00:00 postgres 17397 ? 00:00:00 postgres 17398 ? 00:00:00 postgres cd /etc/rc.d/
vi rc.pgsql
#!/bin/sh
# Start/stop/restart postgresql.
#
# PostgreSQL Startup Serveice Designed By Mehdi Sadighian.
#
# To start PostgreSQL automatically at boot, be sure this script is executable:
# chmod 755 /etc/rc.d/rc.pgsql
# Start PostgreSQL:
start() {
# Check if the postgres exist
sleep 2
if [ -x /usr/local/pgsql/bin/postgres ]; then
# Check if the postgres running now
if ps -A|grep postgres > /dev/null; then
echo "The process is running Now"
exit 0
else
echo "Starting PostgreSQL Server..."
su - postgres -c "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data/ > /usr/local/pgsql/data/logfile 2>&1 &"
exit 0
fi
fi
}
# Stop PostgreSQL:
stop(){
# Check if the postgres running now
if ps -A|grep postgres > /dev/null; then
killall postgres
echo "stopped"
exit 0
else
echo "the process is not running"
exit 0
fi
}
# Restart PostgreSQL:
restart() {
/etc/rc.d/rc.pgsql stop
/etc/rc.d/rc.pgsql start
}
case "$1" in
'start')
start
;;
'stop')
stop
;;
'restart')
restart
;;
*)
echo "usage $0 start|stop|restart"
esac
chmod 755 rc.pgsql cd rc3.d/ ln -sn /etc/rc.d/rc.pgsql ./S.pgsql /etc/rc.d/rc.pgsql restart
PyGreSQL:
cd /usr/src/ wget http://pygresql.org/files/PyGreSQL.tar.gz tar -zxvf PyGreSQL.tgz cd PyGreSQL-5.0.3 python setup.py build python setup.py install
IBSng Installation:
1. Create IBSng database and ibs user.
2. Edit “pg_hba.conf” file to tell the PostgreSQL, trust “ibs” user from the local computer to access “IBSng” database.
3. Restart the PostgreSQL.
4. Add /usr/local/pgsql/lib to the /etc/ld.so.conf file.
5. Use “ldconfig” to create the necessary libraries links and cache.
6. Get the latest IBSng free version from http://ibs.sourceforge.net/ (A1.24) . if you are going to install the IBSng on other distribution, the best way is to download the IBSng iso file that is a Debian Linux included IBSng free. You could get it from: http://sourceforge.net/project/downloading.php?group_id=89337&filename=IBSng-A1.24-LinuxDistro-cd-v1.iso
7. Extract it.
8. Move it to /usr/src and extract it, then move the extracted directory to /usr/local
9. Execute “setup.py” for installing the IBSng.
10. Choose 1,2,2,1 and then enter the system password, then choose 1, 2, 3 then enter “/etc/httpd” as apache config directory then choose 5, 1, 3, 1, 3 then press b for backing to the main menu and x for exiting the setup program.
11. Start the IBSng service.
12. Go to “/var/www/htdocs” directory and make a link to “/usr/local/IBSng/interface/IBSng”
13. Make an index.html file to point the “/IBSng/user” directory.
14. Add IBSng Service to the /etc/rc.local file to start automatically at boot time. It will not start correctly if you use sysvint support.
15. Brows the server IP Address (as I have here http://192.168.0.1) to see the IBSng users login page.
16. Use http://serverip/IBSng/admin to see the IBSng admin login page.
17. Use “system” as username and the password you specified in setup program.
su - postgres createuser ibs -s createdb IBSng createlang plpgsql IBSng logout
vi /usr/local/pgsql/data/pg_hba.conf
add this line:
local IBSng ibs trust
then continue:
/etc/rc.d/rc.pgsql restart echo "/usr/local/pgsql/lib/" >> /etc/ld.so.conf ldconfig
cd /usr/src wget http://downloads.sourceforge.net/project/ibs/IBSng/IBSng-A1.24/IBSng-A1.24.tar.bz2?use_mirror=garr tar -jxvf IBSng-A1.24.tar.bz2 mv IBSng /usr/local/ cd /usr/local/IBSng/scripts ./setup.py
choose 1(Install)
choose 2(Test DB Connection And Continue)
choose 2(Compile configuration and continue)
choose 1(Import tables and continue)
Please Enter System Password:
Choose 1(Copy ibs.conf o ‘/etc/httpd/conf.d’
Choose 2(chown apache directories to ‘apache’)
Choose 3(Change apache config directory)
/etc/httpd
Choose 5(Continue)
Choose 1(Copy Logrotate Conf to /etc/logrotate.d)
Choose 3(Continue)
Choose 1(Copy Redhat init file to /etc/init.d)
Choose 3(Continue)
Choose b (Back to main menu)
Choose x (Exit)
/etc/init.d/IBSng start echo "/etc/init.d/IBSng start" >> /etc/rc.d/rc.local cd /var/www/htdocs/ rm -rf index.html
vi index.html
<html> <meta http-equiv="REFRESH" content="0;url=/IBSng/admin/"></HEAD> </html>
ln -sn /usr/local/IBSng/interface/IBSng/ /var/www/htdocs
It’s ready to use, surf http://yourip/IBSng/admin/ , it will show the IBSng admin login page.
You can see the IBSng logs under “/var/log/IBSng”.
Backup:
pg_dump -U ibs -W IBSng > IBS.sql
Restore:
/etc/init.d/IBSng stop dropdb -U ibs IBSng createdb -U ibs IBSng createlang -U ibs plpgsql IBSng psql -U ibs -W IBSng < IBS.sql /etc/rc.d/rc.pgsql restart
Note: pygresql on slackware 64 bit:
cp /usr/local/lib/python2.3/site-packages/* /usr/lib64/python-2.3/lib/python2.3/
By: Mehdi Sadighian
Contact: mehdi.sadighian@hotmail.com
TAG: slackware, slackware 14.1, postgresql,PyGresql, python, IBSng, IBS