Wednesday, August 27, 2008

Openbravo ERP On OpenSolaris 2008.05

How to install Openbravo ERP on OpenSolaris 2008.05


Or it should read how to setup an ERP System quickly for your enterprise using PostgreSQL. 


What you need:



  • A x86 or x64 based server running OpenSolaris 2008.05

  • Fast access to Internet



Preparing OpenSolaris 2008.05 to be Openbravo ready:


Let's start from the point where you have already installed OpenSolaris 2008.05 configured to access the internet.


Requirements for Openbravo:



  • JDK

  • ANT

  • Tomcat

  • PostgreSQL 

Before executing the binary you need to install the following packages on  OpenSolaris 2008.05.

# pkg install SUNWj6dev


# pkg install SUNWant


# pkg install SUNWtcat


# pkg install SUNWpostgr-82-server


# pkg install SUNWpostgr-82-client


# pkg install SUNWpostgr-82-jdbc


# pkg install SUNWpostgr-82-server-data-root


# svccfg import /var/svc/manifest/application/database/postgresql.xml


# svcadm enable svc:/application/database/postgresql:version_82



To improve data loading speed during installation, you might want to edit /var/postgres/8.2/data/postgresql.conf and increase checkpoint_segments=16  and if you have 1GB RAM or more, increase shared_buffers = 128MB and wal_buffers=512kB. Restart PostgreSQL as follows:


# svcadm restart svc:/application/database/postgresql:version_82


Make sure that your newly installed tomcat setup has a valid server.xml file or copy it from an example file included. 


# cp /var/apache/tomcat/conf/server.xml-example /var/apache/tomcat/conf/server.xml




Installing Openbravo ERP 2.40Beta on OpenSolaris : 


Go to the download page of OpenBravo ERP

Select the version (I selected 2.40Beta) and download the installation binary of OpenBravo ERP for Solaris 10 (INTEL).










 $ pfexec ./OpenbravoERP_2.40beta-solaris-intel-installer.bin


Here is my quick cheat sheet of answers for the questions that OpenBravo installation GUI asks:




  • /opt/OpenbravoERP

  • /opt/OpenbravoERP/AppsOpenbravo/attachments

  • Complete

  • Standard

  • /usr/jdk/latest

  • /usr/bin/ant 

  • /var/apache/tomcat

  • PostgreSQL

  • /usr/postgres/8.2/bin

  • localhost     5432

  • (Enter password for postgres user as "postgres" twice)

  • openbravo    tad     (Enter password for tad user  twice)

  • Context name: openbravo

  • Date format: DD MM YYYY, Date Separator -, Time format 24h, Time Separator :

  • Demo data: Y or N depending on your preferences



After the information the installation GUI takes quite a bit of time to complete specially if you select to load the demo data. (Hope you made changes to PostgreSQL before to tune this loading.)


Once the installation completes  start tomcat as follows


# /usr/apache/tomcat/bin/startup.sh


And then open a browser and go to


http://localhost:8080/openbravo


If you see the login screen if everything goes right !. Use Openbravo as username and openbravo (all lower case) as password to login and set it up for your business.


More help on installation is available on their wiki site





1 comment:

On The Margins said...

[Trackback] Jignesh K. Shah and Robert Lor describe how to set up Openbravo (an open-source ERP system) and Drupal (an open-source CMS) on PostgreSQL on OpenSolaris .