How to Install Openbravo ERP on an Ubuntu VPS

Leave reply

openbravo vpsIn this tutorial, we will show you how to install Openbravo ERP on an Ubuntu VPS . Openbravo ERP is an open source ERP (Enterprise Resource Planning) web-based business solution for small and medium sized companies released under the Openbravo Public License.

Please note, Openbravo is a resource hungry software, so in order to install Openbravo it is necessary to have at least 1.5 GB of RAM free on your server.

At the time of writing this tutorial, the latest stable version of Openbravo is 3.0PR14Q3.4 and it requires:

  • Tomcat 6 (Tomcat 7 is not supported)
  • Ant >= 1.7.1
  • OpenJDK >= 1.6.0
  • PostgreSQL >= 8.4 installed on your virtual server.

Update the server’s OS packages using the following commands:

apt-get update
apt-get upgrade

Install PostgreSQL:

sudo apt-get install postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3 uuid

Then, run the the following commands:

sudo -i -u postgres
update pg_database set datallowconn = TRUE where datname = 'template0';
\c template0
update pg_database set datistemplate = FALSE where datname = 'template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';
update pg_database set datistemplate = TRUE where datname = 'template1';
\c template1
update pg_database set datallowconn = FALSE where datname = 'template0';
ALTER ROLE postgres WITH PASSWORD 'your-password';
CREATE ROLE tad LOGIN PASSWORD 'your-tad-user-password';
CREATE DATABASE openbravo WITH ENCODING='UTF8' OWNER=tad;
template1=# \q
exit

Restart the PostgreSQL service for the changes to take effect:

/etc/init.d/postgresql restart

Install Ant, OpenJDK and Tomcat 6:

sudo apt-get install ant openjdk-7-jdk tomcat6 tomcat6-admin tomcat6-user tomcat6-common

Run the following commands:

echo 'export JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64' > /etc/profile.d/java.sh
echo 'export CATALINA_HOME=/usr/share/tomcat6' >> /etc/profile.d/java.sh
echo 'export CATALINA_BASE=/var/lib/tomcat6' >> /etc/profile.d/java.sh
echo 'export CATALINA_OPTS="-server -Djava.awt.headless=true -Xms512M -Xmx2048M -XX:MaxPermSize=512M"' >> /etc/profile.d/java.sh
chmod +x /etc/profile.d/java.sh
source /etc/profile.d/java.sh
cp $JAVA_HOME/lib/tools.jar /usr/share/tomcat6/lib/

Edit your Tomcat startup script and add the lines below immediately after ‘JVM_TMP=/tmp/tomcat6-$NAME-tmp’ line:

vi /etc/init.d/tomcat6

add the following lines:

JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64
CATALINA_HOME=/usr/share/tomcat6
CATALINA_BASE=/var/lib/tomcat6
CATALINA_OPTS="-server -Djava.awt.headless=true -Xms512M -Xmx2048M -XX:MaxPermSize=512M"

Edit /etc/tomcat6/tomcat-users.xml file:

vi /etc/tomcat6/tomcat-users.xml

add the following lines:

<tomcat-users>
<role rolename="manager"/>
<role rolename="admin"/>
<user username="admin" password="your-tomcat-admin-password" roles="admin,manager"/>
</tomcat-users>

Download the latest version of Openbravo ERP available at http://sourceforge.net/projects/openbravo/files/ to the server, extract it and run ‘ant setup’:

cd /opt/
wget http://sourceforge.net/projects/openbravo/files/02-openbravo-sources/3.0PR14Q3.4/openbravo-3.0PR14Q3.4.tar.bz2/download -O openbravo3.tar.bz2
tar -xjvf openbravo3.tar.bz2
cd /opt/Openbravo-3.0PR14Q3.4/
ant setup
cd config/
chmod 755 setup-properties-linux-x64.bin

Then, run the following command:

./setup-properties-linux-x64.bin

Follow the easy on-screen instructions and make sure you change these settings:

Admin Role Password [syspass]: <your-password>

DB Role Password [tad]: <your-tad-user-password>

Tomcat Manager URL:  http://<your_ip>:8080/manager

Tomcat manager password [admin]: <your-tomcat-admin-password>

Run ‘ant install.source’ as unprivileged user, for example create a new user named ‘openbravo’:

adduser openbravo
chown openbravo:openbravo -R /opt/openbravo/
chown openbravo:openbravo -R /opt/Openbravo-3.0PR14Q3.4/
cd /opt/Openbravo-3.0PR14Q3.4/
su openbravo
ant install.source
ant smartbuild
exit

If you receive the following errors:

BUILD FAILED
/opt/Openbravo-3.0PR14Q3.4/build.xml:487: The following error occurred while executing this line:
/opt/Openbravo-3.0PR14Q3.4/src/build.xml:843: The following error occurred while executing this line:
/opt/Openbravo-3.0PR14Q3.4/src/build.xml:849: Directory /var/lib/tomcat6/webapps/openbravo/WEB-INF/lib creation was not successful for an unknown reason

run the following commands to fix the problem:

su root
mkdir -p /var/lib/tomcat6/webapps/openbravo/
chown openbravo:openbravo /var/lib/tomcat6/webapps/openbravo/
su openbravo
ant smartbuild
exit

Make sure tomcat6 user has read/write permissions to the ‘/var/lib/tomcat6/webapps/openbravo/’ directory:

chown tomcat6:tomcat6 -R /var/lib/tomcat6/webapps/openbravo/

Restart the Tomcat service:

/etc/init.d/tomcat6 restart

Open http://your_ip:8080/openbravo in your favorite web browser and log in into Openbravo using ‘Openbravo’ as username and  ‘openbravo’ as password. The system is case-sensitive so you need to type both username and password correctly to access Openbravo. Do not forget to change your Openbravo user password:

 

openbravo 3

 

If you like to redirect to port 80 instead of 8080 and open Openbravo ERP using http://your-domain.com/openbravo , you need to edit the Apache configuration and set a reverse proxy. For example, edit the virtual host for your-domain.com in Apache and add these lines:

ProxyRequests Off

     <Proxy *>
         Order deny,allow
         Allow from all
     </Proxy>
         ProxyPass / http://your-domain.com:8080/
         ProxyPassReverse / http://your-domain.com:8080/
     <Location />
         Order allow,deny
          Allow from all
     </Location>

Restart your Apache web server for the changes to take effect and open Openbravo using http://your-domain.com/openbravo

That’s it. Openbravo has successfully been installed on your Ubuntu VPS.

Of course you don’t have to do any of this if you use one of our Linux VPS Hosting services, in which case you can simply ask our expert Linux admins to Openbravo ERP for you. They are available 24×7 and will take care of your request immediately.

PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.

 


50% OFF Coupon

EXCLUSIVE EMAIL UPDATES AND “MEMBERS-ONLY” CONTENT


15 Responses to “How to Install Openbravo ERP on an Ubuntu VPS”

  1. Jorge

    Hi! A very nice article.
    How-to guides are always interesting and help developers to easily understand and integrate software.
    I would like just to point out that Openbravo will run in Tomcat 7 in 2015 along with Java 7 and Postgres 9.3 in a future appliance.
    Anyway, congrats again and thanks for thinking of Openbravo to do so.
    Regards.

    Reply
  2. Shyam Prasath S

    I have followed this steps for openbravo installation in Ubuntu Desktop. After completed all the steps openbravo is not running in localhosyt:8080/openbravo. I cannot see openbravo folder in /var/lib/tomcat6/webapps/. Instead of that ${env.CATALINA_HOME} folder is created and inside that I can see webapps/openbravo. Build is done in project directory it self. Could you reply the solution to resolve this?

    Reply
    • admin

      Please run the following commands on your server and provide us with the output:
      echo $CATALINA_HOME
      echo $CATALINA_BASE

      Reply
  3. Ariel

    Hi! Very nice guide.
    I have a question, i have followed all steps for Ubuntu 14.04, and when i try to start openbravo on my browse it doesn´t, i found on tomcat logs and the problem is the lack of memory “Error deploying web application directory openbravo
    java.lang.OutOfMemoryError: Java heap space” Could you reply a solution, i added echo ‘export JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64’
    ‘export CATALINA_HOME=/usr/share/tomcat6’
    ‘export CATALINA_BASE=/var/lib/tomcat6’
    ‘export CATALINA_OPTS=”-server -Djava.awt.headless=true -Xms512M -Xmx2048M -XX:MaxPermSize=512M” to my bashrc, because on java.sh the variables doesn´t appear, do you have any suggestion?

    Reply
    • admin

      To avoid out of memory complaints you should add the following values to the Tomcat startup script:

      vi /etc/init.d/tomcat6

      JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64
      CATALINA_HOME=/usr/share/tomcat6
      CATALINA_BASE=/var/lib/tomcat6
      CATALINA_OPTS=”-server -Djava.awt.headless=true -Xms512M -Xmx2048M -XX:MaxPermSize=512M”

      Reply
  4. James Utru

    Great tutorial and well structured but I’ve been trying to install this on Ubuntu14.04 and I can’t get it to work after installation is complete. Has anyone tested and verified it’s working? I am not a programmer or developer so hopefully this is not missing any steps that I’d have to figure out.

    Reply
    • James Utru

      One of the reasons why I asked this is that when I use the cli code to install Postgres it doesn’t install 8.4 but in the beginning of the document, it says it’s for 8.4. It keeps installing 9.3 and after some research I found it 8.4 is obsolete.

      Reply
    • Benny

      It does not work for me either!
      Ubuntu 14.04 with tomcat7 and Openbravo-3.0PR15Q1.
      There is always some Java heap space problem.

      But “echo $CATALINA_OPTS” gives me the right values -server -Djava.awt.headless=true -Xms512M -Xmx2048M -XX:MaxPermSize=512M

      Reply
      • admin

        To avoid out of memory complaints you should add the following values to the Tomcat startup script:

        JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64
        CATALINA_HOME=/usr/share/tomcat7
        CATALINA_BASE=/var/lib/tomcat7
        CATALINA_OPTS=”-server -Djava.awt.headless=true -Xms512M -Xmx2048M -XX:MaxPermSize=512M”

        Reply
  5. Raúl

    Excellent guide, when browsing openbravo to the next path:
    Application / Sales managment / transaction / sales order / form personalization; I’ve seen this alert:

    Form Personalization is a Premium Feature only available for Professional and Basic Edition subscribers.
    Learn more about the benefits of Openbravo’s Professional and Basic Editions.

    ¿Is Openbravo ERP really open source?

    Reply
  6. Dave

    When I try to update the postgres server with the following:
    update pg_database set datallowconn = TRUE where datname = ‘template0’;
    \c template0
    Returns the error:
    No command ‘update’ found, did you mean:
    Command ‘xupdate’ from package ‘libxml-xupdate-libxml-perl’ (universe)
    Command ‘lupdate’ from package ‘qtchooser’ (main)
    Command ‘pupdate’ from package ‘pbuilder-scripts’ (universe)
    Command ‘uupdate’ from package ‘devscripts’ (main)
    update: command not found
    -bash: /c: No such file or directory

    Reply
    • admin

      Please try using the interactive terminal for working with Postgres. Enter the following command after switching to the ‘postgres’ user:

      psql

      Thanks.

      Reply
  7. Joseph

    when I try to access by browser tells me “The requested resource is not available”

    Reply
    • admin

      Did you edit the Apache virtual host and replace ‘your-domain.com’ with your actual domain as instructed?

      Reply

Leave a Reply