OpenERP Appliance

Collaboration Works

OpenERP 5.0.3 All-in-one installer for Ubuntu

This script automates the setting up of openerp-server-5.0.3 & openerp-client-5.0.3 & openerp-web-5.0.3 on Ubuntu 8.04.3 LTS (Server and Desktop).

The Goal is to provide an All in one installer of OpenERP for Linux with a Unix philosophy: “Do one thing, and do it well”.

New Update! OpenERP graphical installer For Dummies: http://opensourceconsulting.wordpress.com/2009/09/09/openerp-5-0-3-installer-for-dummies/

Requirements: A fresh installation of Ubuntu 8.04.3 LTS Server or Desktop without Apache nor Postgres. Only the core of the system is needed, so during the installation of your Ubuntu Server don’t select software to install like LAMP Server or PostgreSQL Server in the “Software Selection” menu (except for OpenSSH Server). This script installs Apache and Postgres and expects to deal with default config files.
TIP: test this script within a Virtual Machine after installing Ubuntu 8.04.3 LTS from scratch. Run the virtual machine in a bridged network (host and guest have same subnet and can be reached from the LAN).

Tested on:

  • Ubuntu 8.04.3 LTS Server, computer platform amd64 (64 bits)
  • Ubuntu 8.04.3 LTS Desktop, computer platform i386 (32 bits)

Run this script as non-root with the following commands in a Linux terminal:
$ gzip -d openerp-allinone-setup-5.0.3.sh.gz
$ chmod +x openerp-allinone-setup-5.0.3.sh
$ ./openerp-allinone-setup-5.0.3.sh

You can also run the script on Ubuntu Desktop through the Graphical User Interface: uncompress the file, make openerp-allinone-setup-5.0.3.sh icon executable with “right click -> properties”, double click on the icon and “run in a terminal”.

You will be asked for:
1) DNS name of your URL
2) IP address your OpenERP Web service will be listening on
3) OpenERP Database Admin Password
4) SSL Certificate settings of Apache SSL

Additional info:

  1. Before running the script set up the network of your Ubuntu system. It should be reachable from your PC (client side) via ping. Make a note of the correct IP address.
  2. While running the script enter the previous IP address.
  3. The script only modifies the server side. The DNS system needs to be updated on your LAN’s DNS server or your PC’s hosts file (http://en.wikipedia.org/wiki/Hosts_file). Take a look at the end of the script as important info is given.
  4. The “invalid security certificate” error message is correct as the SSL certificate has been created for testing purposes.
  5. /opt is the working directory where .tar.gz files are downloaded.
  6. Apache is configured as a front-end for OpenERP Web and redirects all the incoming HTTP traffic to HTTPS.
  7. Ubuntu’s firewall is setup with the following ports open: SSH, HTTP, HTTPS, 8069 & 8070 (for remote access of OpenERP GTK clients).
  8. Startup/init scripts for openerp-server and openerp-web are added.
  9. OpenERP Web 5.0.3 has been tested by Tiny and Axelor on Debian Etch and Ubuntu Hardy.
  10. python-xml is broken in Ubuntu 9.04. This package has been deleted from karmic repository (lack of maintenance).
  11. OpenERP >= 5.0.2-0-3 drops old python-xml dependency. python-xml cannot be removed from this script (I couldn’t connect to openerp-server without this package)
  12. Ubuntu 9.04 is not LTS (Long Term Support)
  13. Ubuntu 8.04.3 LTS provides Postgresql 8.3 & Python 2.5.2, which are compatible with OpenERP 5.0.3.
  14. OpenERP 5.0.3 is not yet compatible with Ubuntu 9.04′s default  python 2.6, but it can be run on 9.04 with /usr/bin/python2.5 (package python2.5).
  15. OpenERP on Red Hat Enterprise platforms: python-reportlab is not available in EPEL repository . This package is available in Fedora 11, but not yet in RHEL 5.3. EPEL stands for Extra Packages for Enterprise Linux, a volunteer-based community effort from the Fedora project to create a repository of high-quality add-on packages for Red Hat Enterprise (RHEL) and its compatible spinoffs such as CentOS or Scientific Linux. Fedora is the upstream of RHEL and add-on packages for EPEL are sourced from the Fedora repository primarily and built against RHEL. More info at https://fedoraproject.org/wiki/EPEL
  16. OpenERP 5.0.3 All-in-one installer for windows is recommended for beginners.
  17. This script eases the setting up of OpenERP 5.0.3 for Linux, but still requires some technical knowledge (and custom improvements?). OpenERP for Ubuntu Linux is recommended on production systems.
  18. Desktop Icons for openerp-client and openerpweb URL are made (only on Ubuntu Desktop)
  19. Available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one (Sep 8th 2009)
  20. The installation process can be as simple as “Pressing Enter” for each question.

Startup/init scripts:

  • /etc/init.d/openerp-server
  • /etc/init.d/openerp-web

The script ends pointing out the URL of your OpenERP Web and its corresponding passwords. An OpenERP-README.txt file is created with this information.

Disclaimer: Although this new installer is simpler than the one I created for OpenERP Web 5.0.1 on Ubuntu 9.04, more testing is recommended. At the moment I’m happy with the initial results.

I. Fernández

About these ads

August 25, 2009 - Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | ,

15 Comments

  1. [...] This post is now obsolete. Please consider the following update: http://opensourceconsulting.wordpress.com/2009/08/25/openerp-5-0-3-all-in-one-installer-for-ubuntu-8… [...]

    Pingback by openerp-allinone-setup-5.0.2-0.sh « Open Source Consulting | August 25, 2009

  2. No module named matplotlib. Only had to install matplotlib ( sudo apt-get install python-matplotlib ) and everything worked like a dream! Thanks

    Comment by Peter | September 1, 2009

  3. sudo chmod 777 /usr/lib/python2.5/site-packages/openerp-server/addons

    Comment by Peter | September 1, 2009

    • Hi Peter, your two tips are now in the script. Thx for your help!

      Comment by I. Fernández | September 1, 2009

  4. ha, ha, .. last one (I am using the client / not web-based) sudo apt-get install python-hippocanvas

    Comment by Peter | September 5, 2009

    • Fixed! Thanks a mill!! :-)

      Comment by opensourceconsultant | September 5, 2009

      • I think it is a nice contribution. Setting up an OpenERP server on a clean install has been a piece of cake!

        Comment by Peter | September 6, 2009

  5. Completed the first two steps successfully.
    1) $ gzip -d openerp-allinone-setup-5.0.3.sh.gz
    2) $ chmod +x openerp-allinone-setup-5.0.3.sh
    3) $ ./openerp-allinone-setup-5.0.3.sh

    But when running step three on the terminal or when double-clicking the script from the desktop, I get the following error message “This program must be executed on Ubuntu 8.04.3 LTS Server or Desktop”

    Would it be possible to use the script on testing systems?

    Comment by HHK | September 12, 2009

    • You can run this script on testing systems, but the Operating System has to be Ubuntu 8.04 LTS Server or Desktop: http://www.ubuntu.com/getubuntu/download

      Ubuntu Server has no GUI
      Ubuntu Desktop provides GUI

      Comment by I. Fernández | September 12, 2009

  6. Has a port to macosx already surfaced? There already is a client available at taktik, and there also a standalone server installer was discussed; http://devteam.taktik.be/index.php?/archives/9-How-to-install-Open-ERP-5.0.0-on-Mac-OS-X-10.5-Leopard.html

    Comment by newnomad | January 2, 2010

    • Hi there,

      Macosx is a great OS, but unfortunately I don’t know how to install it on a virtual machine. That said, I wonder if this script could be ported to macosx , as MacosX is based on freebsd…
      Thanks for your valuable link!!!

      Comment by opensourceconsultant | January 18, 2010

  7. Thank you for your great installer! It works great. I did run into an issue however: in the Module submenu I no longer find an option to import and install an additional module.
    How to proceed for installing these modules?

    Comment by SeppeDL | February 15, 2010

    • SeppeDL,

      Thanks for your comments. AFAIK the submenu option you’re looking for is no longer available in latest updates of OpenERP… On the other hand this allinone installer adds most of the modules. In case other modules need to be installed, just copy them to the “addons” directory (“$ADDONSPATH” var in the script). Make sure you grab the latest installer!! (v.4.0.0)

      Comment by I. Fernández | February 15, 2010


Sorry, the comment form is closed at this time.

Follow

Get every new post delivered to your Inbox.

Join 30 other followers

%d bloggers like this: