Bu öğretici klavuzda, Ubuntu VPS’e nasıl Openbravo ERP yükleneceği size gösterilecektir. Openbravo ERP açık kaynak kodlu Kamu Lisansı altında dağıtılan küçük ve orta ölçekli şirketler için (Enterprise Resource Planning) web tabanlı bir iş yazılımı çözümüdür.

Openbravo yüklemek için o sunucu üzerindeki RAM en az 1,5 GB olması gerekir, lütfen unutmayınız.

 

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, eidt 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.