Monday, June 20, 2011

OpenERP


OpenERP follows a commercial open source business model. The development and community efforts are managed through Launchpad, using the Bazaar versioning system. The company maintains the copyright and determines what is accepted into the software code base and the direction of the software. The OpenERP community is organized on the OpenObject website, where you can find the forums, the IRC and all the available modules for OpenERP. The documentations are also managed on launchpad but a website dedicated to all books has been set up in 2009.
OpenERP is claimed to set up a business model with a win-win relationship between the community, the partner network and the editor. The partners are intended to create the market around OpenERP and the service offers, the editor is responsible for the quality and the vision on the development of the product and the community generates activities and contribute to the growth of the product.
Project-Open is a web-based ERP/Project Management application. It has
1.Project Management — Project Planing and Tracking,Resource Management,Workflow
2.IT Service Management–IT Helpdesk ,Configuration Managment
3.Timesheet Management–Work and time Accountability
4.Financial Management–Internal & External Finances ,Invoices ,Cost Record/Estimates , Financial Reporting
5.Knowledge Management & Collaboration–File Manager,Wiki,Forums
6.Human Resources–Skill Management,Absence Management,Employee Record,Surveys
7.Customer Relationship Management –Pre Sales activities,Email C om pains ,Customer Records.
I have installed Project Open on CentOS .The files downloaded from http://www.sourceforge.net/projects/project-open/files/
• aolserver-4.5-rhel5-rpms.tar (Support Files section)
• project-open-RHEL5-3.4.0.final.tgz (V3.4 section)¬¬
Login as root #groupadd projop
#mkdir /web/
#useradd -d /web/projop -g projop projop
#cd /web/projop/; tar xzf /tmp/project-open-RHEL5-3.4.0.final.tgz
#cd /web/projop/; tar xf /tmp/aolserver-4.5-rhel5-rpms.tar
#chown -R projop:projop /web/projop
Installation of AOL server , this is similar to Apache Tomcat Server. The RPMs are located by default in /web/projop/
#cd /web/projop/
#rpm -i *.rpm
In order to check that AOLserver is installed successfully execute
#/usr/local/aolserver/bin/nsd –h
Setup PostgreSql
#yum install postgresql postgresql-server postgresql-contrib postgresql-devel postgresql-docs
#/etc/init.d/postgresql start
edit the file /var/lib/pgsql/data/postgresql.conf and Change the following parameters,
• add_missing_from = on
• regex_flavor = extended
• default_with_oids = on
#/etc/init.d/postgresql restart
#su – postgres -c “createuser -s projop”
#su – projop -c “createdb -E utf8 -O projop projop”
#su – projop -c “createlang plpgsql projop”
#su – projop
#psql -f filestorage/backup/pg_dump.xxx.yyy.sql > import.log 2>&1
To check if the database dump has loaded correctly, execute:
#su – projop
#psql
#select count(*) from cc_users; (resulting in 194 users)
#\q
Other Software installation
#yum install cvs
#yum install ImageMagick
#rpm -i graphviz-2.8-1.el5.rf.i386.rpm (install GraphViz, afer downloading it from http://dag.wieers.com/rpm/packages/graphviz/
Start the Project Open
]project-open[ requires AOLserver and PostgreSQL to work properly. Once these two components are working execute the command as root:
#/usr/local/aolserver/bin/nsd -f -t /web/projop/etc/config.tcl -u projop -g projop
Notice: nssock: listening on 0.0.0.0:8000 will be seen at the terminal.
To login into Project Open , use demo system account which is given on the left panel of login screen.
To start the Server Automatically Add the following line at the end of /etc/inittab
ns1:345:respawn:/usr/local/aolserver/bin/nsd -it /web/projop/etc/config.tcl -u projop -g projop