The Bit-Boy’s-Blog

If you have found this, you are probably saying… “Help me Bit-Boy, I’m just a newb!  Share with me your knowledge, wisdom and God-like *nix skills!” (No, thats not a typo newb!)  So, in a moment of kindness, I took it upon myself to document how to install Openbravo ERP.  Yes, after this, you will probably explain to your client just how insanely difficult this software is to configure and that only you at your very reasonable rate of (insert ridiculous amount of $ here) could get it done.  Just remember that the Bit Boy helped you out and beer money is greatly appreciated.

Note:  This installation was completed from a clean installation of Ubuntu 7.1 Server.  No desktop environment was installed. (Didn’t I tell you my *nix powers were God-like?)Even though I have proven my superior intelligence yet again, you should be able to use the same process from the desktop.  If you have just installed Ubuntu server and are trying to figure out how to get the GUI installed, just type: sudo apt-get install ubuntu-desktop at the command line.

Step 1:  Enable Ubuntu Extra Packages

sudo gedit /etc/apt/sources.list Edit and remove the # from the beginning of lines 43 and 44.  This is necessary to install the correct Java Runtime Environment and Java Development Kit.

Step 2: Install Necessary Packages (the easy way) 

sudo apt-get updatesudo apt-get install sun-java6-jdk sun-java6-jre libpg-java postgresql-8.2 tomcat5.5 tomcat5.5-admin tomcat5.5-webappssudo apt-get dist-upgrade [optional - upgrades all currently installed packages]

If you dont feel like typing all of that, you can copy and paste it in, minus the note at the end of course.

Step 3: Setup Postgres Administrator User

1. sudo su postgrespsql 
2. Now, in the Postgres client: ALTER USER postgres WITH PASSWORD ‘your perferred password’;
   
3. \q to exit

Step 4: Get Openbravo and Begin Installation 

1. wget [Openbravo installer URL]
2. sudo chmod a+rwx [Openbravo installer file]
3. sudo ./[Openbravo installer file]
   

Generally, you can find the latest installer file here http://sourceforge.net/projects/openbravo/

Step 5: Set Environment Variables

1. echo ‘JAVA_HOME=”/usr/lib/jvm/java-1.5.0-sun”‘ | sudo tee -a /etc/environment
   
2. echo ‘JRE_HOME=”/usr/lib/jvm/java-1.5.0-sun”‘ | sudo tee -a /etc/environment
   
3. echo ‘CATALINA_HOME=”/usr/share/tomcat5.5″‘ | sudo tee -a /etc/environment
4. echo ‘CATALINA_BASE=”/var/lib/tomcat5.5″‘ | sudo tee -a /etc/environment
5. echo ‘CATALINA_OPTS=”-server -Xms384M -Xmx512M”‘ | sudo tee -a /etc/environment
6. sudo gedit /etc/init.d/tomcat5.5  There is a problem with JDK 1.5.0_13 and the jsvc binary used in the Apache Tomcat daemon script. Modify it [/etc/init.d/tomcat5.5], by setting the LD_LIBRARY_PATH variable pointing to the path where the libawt.so shared library is located.
   Next, due to the security policies of debian’s tomcat package, it is necessary to either create a rule or disable it. Otherwise it will refuse to load the openbravo context. To disable it, edit /etc/init.d/tomcat5.5 and change TOMCAT5_SECURITY=YES into TOMCAT5_SECURITY=NO.
   

Step 6: Answer Openbravo’s Questions and Wait 1-2 Hours 

1. Installation Directory: [Just Type Enter]
2. Attachments Directory: [Just Type Enter]
3. Installation Type: [Just Type Enter]
4. Installation Type: [Just Type Enter]
5. Database: 1
6. PostgresJava Directory: [Just Type Enter]
7. Ant Directory: /usr/share/ant
8. Tomcat Directory: /usr/share/tomcat5.5
9. Domain: Enter your domain, if you dont know what a domain is, you are an idiot.  If you are an idiot, just type localhost or your static IP Address.
10. Port: 8180 Note: This is specific to the Ubuntu installation, normally this value would be the secondary HTTP port 8080.  If you want to change it, that is find, just remember to go back and edit the tomcat configuartion files to indicate this port as well.
11. Context Name: [Just Type Enter]
12. PostgreSQL Directory: /usr/lib/postgresl/8.2/bin
13. Database Host: [Just Type Enter]
14. Database Port: [Just Type Enter]
15. Database Name: [Just Type Enter]
16. Postgres Password: Enter the password you selected in step 3.
17. Username: [Just Type Enter]
18. Password: Create another password
19. Continue?:  y
20. Now, just kick back, relax and crack open a nice cold beer, look at pictures of Britney Spears or whatever you newbs do.

Step 7: Restart Tomcat

1. sudo /etc/init.d/tomcat5.5 restart

Step 8: Now Login Newb!

1. http://yourdomain:8180/openbravo or http//localhost:8180/openbravo or http://yourip:8180/openbravo (That should give you enough options.  I dont want anyone sending me emails saying “But Bit-Boy, your instructions are wrong, my browser cant find the server”)
2. Login: Openbravo  Pass:openbravo   (Note the caps in the Login!)

This document is copyright 2008 by the Bit-Boy’s-Blog all rights reserved.  Got that bitches!?  You may NOT, I repeat NOT reproduce this content in any way without the express permission of the Bit Boy himself.  Should you violate these copyright restrictions I will have no choice but to send this woman over to sit on you.

Tags: 7.10, database, ERP, guide, howto, installation guide, newb, openbravo, openbravo installation, postgres, server, ubuntu

This entry was posted on Thursday, February 14th, 2008 at 3:53 pm and is filed under Opensource. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.