OpenBravo on OSX

Introduction

OpenBravo is an open source ERP. The first major ERP that was open sourced is Compiere from US. Adempiere is a european fork of Compiere. To my knowledge is OpenBravo and OpenERP currently the the open source ERPs in Europe that are getting most traction. Apache OfBiz (which also goes under the name OpenTAPS) is another alternative and xTuple and ERP5 are yet to more alternatives.

OpenBravo has Retail support so I’m going to try this out.

Installation

Links:

Summary:

# Install postgres, see below
pg_ctl -D /usr/local/var/postgres9 -l /usr/local/var/postgres9/server.log start

# Make sure it started
pg_ctl -D /usr/local/var/postgres9 -l /usr/local/var/postgres9/server.log status

createdb openbravo
createuser openbravo
# Connect to db jonas as user jonas
psql -U openbravo
\password

# Try to connect to localhost on port 5432
psql -h localhost -p 5432 -U openbravo

# Create config/Openbravo.properties, use the Openbravo.properties.template or the content below (from ubuntu)
ant install.source

Increase shared memory:

sysctl kern.sysv.shmmax
kern.sysv.shmmax: 4194304

sudo sysctl -w kern.sysv.shmmax=1073741824

Increase Java Heap size:

export JAVA_OPTS="-Xms128m -Xmx1024m"
export ANT_OPTS="-Xms128m -Xmx1024m"

Install pgAdmin:

Dump database

pg_dump -U openbravo -C -f openbravo.pg_dump openbravo

Install Tomcat

Links:

Installation using brew:

brew install tomcat6
brew link tomcat6 --force

ls -al /usr/local/bin/startup.sh 
ls -al /usr/local/Cellar/tomcat6/6.0.36/

nano /usr/local/Cellar/tomcat6/6.0.36/libexec/conf/tomcat-users.xml

...
  <role rolename="manager"/>
  <role rolename="admin"/>
  <user username="admin" password="admin" roles="admin,manager"/>


shutdown.sh
startup.sh

Configure Apache

Links:

mod_jk needs to be installed, see http://wiki.apache.org/tomcat/FAQ/Connectors:

# Available modules
ls -al /usr/libexec/apache2/

# Download mod_jk
wget http://apache.mirror3.ip-only.net//tomcat/tomcat-connectors/jk/tomcat-connectors-1.2.37-src.tar.gz
tar -xzf tomcat-connectors-1.2.37-src.tar.gz

cd native
./configure CFLAGS='-arch x86_64' APXSLDFLAGS='-arch x86_64' --with-apxs=/usr/sbin/apxs
make
sudo make install

Use of mod_jk in Elastic Beanstalk:

Install phpPgAdmin

wget http://downloads.sourceforge.net/project/phppgadmin/phpPgAdmin%20%5Bstable%5D/phpPgAdmin-5.1/phpPgAdmin-5.1.tar.bz2?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fphppgadmin%2F%3Fsource%3Ddlp&ts=1367783807&use_mirror=freefr

Install database

Postgres:

Gizur-Laptop-5:config jonas$ brew install postgresql9
==> Installing postgresql9 dependency: ossp-uuid
dyld: DYLD_ environment variables being ignored because main executable (/usr/bin/sudo) is setuid or setgid
==> Downloading ftp://ftp.ossp.org/pkg/lib/uuid/uuid-1.6.2.tar.gz
######################################################################## 100,0%
######################################################################## 100,0%==> ./configure --prefix=/usr/local/Cellar/ossp-uuid/1.6.2 --without-perl --without-php --without-pgsql
==> make
==> make install
==> Caveats
This formula is keg-only: so it was not symlinked into /usr/local.

OS X provides a uuid.h which conflicts with ossp-uuid's header.

Generally there are no consequences of this for you. If you build your
own software and it requires this formula, you'll need to add to your
build variables:

    LDFLAGS:  -L/usr/local/opt/ossp-uuid/lib
    CPPFLAGS: -I/usr/local/opt/ossp-uuid/include

==> Summary