OpenERP Appliance

Collaboration Works

OpenERP 5.0.3 on Ubuntu All-in-one installer For Dummies

OpenERP Appliance & All-In-One & Magento Forum

This script automates the setting up of openerp-server-5.0.3 & openerp-client-5.0.3 & openerp-web-5.0.3 & openerp-addons-5.0.3 for Ubuntu 8.04 LTS Desktop

The Goal is to provide a graphical installer of OpenERP for Ubuntu Desktop with a KISS philosophy

This post is obsolete! This script doesn’t work any longer as openerp v5.0.3 is out of date and not available at openerp.com. Please consider the new script and post: OpenERP 5.0.5 on Ubuntu All-in-one installer & updater For Dummies: http://bit.ly/3RL7Sa

Requirements: A fresh installation of Ubuntu 8.04 LTS Desktop (http://www.ubuntu.com/getubuntu/download)

Run the script through the Graphical User Interface:

  1. uncompress the file
  2. right click on openerp-allinone-setup-5.0.3-GUI.sh icon
  3. click on ” Properties”
  4. click on “Permissions” tab
  5. select “Execute: Allow executing file as program”
  6. click on “Close”
  7. double click on the icon and “Run”

The installation process can be as simple as “Accept” for each question. You will need to type your user password (sudo).

Additional info:

  1. OpenERP on Ubuntu 8.04 is recommended for production systems
  2. Desktop Icons for openerp-client and openerpweb URL are made
  3. Available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one
  4. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Screenshots:

September 9, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop | , , | 10 Comments

HOWTO Backup OpenERP

For saving OpenERP you need to backup the Database with your data.

From the GTK openerp-client menu

  • File-> Databases->Backup Database

Then you can restore it after saving from the same menu:

  • File-> Databases->Restore Database

From the OpenERP Web login screen

  • Databases -> Backup / Restore

pgAdmin III

A complete OpenERP database can be moved using PostgreSQL’s native backup/restore mechanism. Apart from the command line, the easy and straightforward way is to use pgadmin3 (GUI admin tool). Run pgadmin3, then connect to the database server, right click on the database name and select Backup from the contextual menu. I recommend to use COMPRESS mode (native and efficient) to save the backup. Still using pgadmin3, connect on the destination server, create a new database, right click on its name and select Restore.

Virtualization

Consider virtualizing your OpenERP installation. This would allow you to redeploy OpenERP by cloning your OpenERP’s virtual machine.

One great virtualization solution and probably the easiest way to set up a virtual machine in Linux is KVM, already available in Fedora 11 and the new Red Hat Enterprise Linux 5.4. KVM is intregated in the Linux kernel and virtual machines can be easily deployed with virt-manager and Virtual Network Editor (GUI tools). CentOS 5.4 & ScientificLinux 5.4 (RHEL clones) will be available in 2-4 weeks.

System Backup and Bare-Metal Restore on Linux platforms

You can also backup your OpenERP Software for bare-metal recovery:

http://opensourceconsulting.wordpress.com/2009/09/05/installing-mondorescue/
http://opensourceconsulting.wordpress.com/2009/09/05/linux-p2v-physical-to-virtual-migrations-using-mondorescue-by-hewlett-packard/
http://www.mondorescue.org/
http://mkcdrec.org/
http://www.clonezilla.org/

References:

http://www.postgresql.org/docs/8.3/interactive/backup.html
http://www.openerp.com/forum

September 6, 2009 Posted by | Backup, ERP | | 8 Comments

Installing MondoRescue. System Backup for bare-metal recovery of Linux

Mondo is a GPL disaster recovery solution to create backup media (CD, DVD, tape, network images) that can be used to redeploy the damaged system, as well as deploy similar or less similar systems. In the event of catastrophic data loss, you will be able to restore all of your data [or as much as you want], from bare metal if necessary. Mondo is in use by Lockheed-Martin, Nortel Networks, Siemens, HP, IBM, NASA’s JPL, the US Dept of Agriculture, dozens of smaller companies, and tens of thousands of users. The backup media is created while the system is up and running. Those coming from an HP-UX background may liken MondoRescue to Ignite-UX.

Installing MondoRescue on Ubuntu

$ sudo apt-get install mondo

Installed version: 2.2.7-2

Installing MondoRescue on Red Hat Enterprise Linux / CentOS / ScientificLinux

Mondo is available from the RPMForge repository.

# yum install mondo

Installed version: 2.2.4

Installing the latest version of MondoRescue is highly recommended. The current release of Mondo is 2.2.8-1, and can be obtained from the MondoRescue repository

Install the following binary packages suited for your distribution if they are available at the MondoRescue repository (i.e. afio and buffer are sometimes unavailable meaning that they are not required):

  • afio
  • buffer
  • mindi
  • mindi-busybox
  • mondo
  • mondo-doc

The previous binary packages can be installed from the command line with these commands:

  • RPM based Linux distributions (Red Hat, Fedora, SuSE, etc): rpm -ivh *.rpm (as root)
  • DEB based Linux distributions (Debian, Ubuntu, etc): dpkg -i *.deb (run as root or “sudo dpkg -i *.deb” on Ubuntu)

Most of the time, you’ll be able to download directly the packages suited for your distribution. Currently Mondorescue.org provides packages for :

Older packages are also on the ftp site to help for some old fashion distros/versions.

Running mondoarchive and mondorestore

Run mondoarchive as root or with “sudo” on Ubuntu. The following screenshots show how to create an ISO based backup media:

Now we have an ISO image that can be burnt into a DVD. Our system can be easily redeployed or restored by booting from this DVD. To format and restore all files automatically type “nuke” <ENTER> at the boot prompt (bare-metal recovery).

To restore you also have mondorestore.

NOTE – For migrations in a production environment it’s good practice to use a temporary IP address on the machine to be backed up. This will mean users and services can’t connect to the server during the backup.
NOTE – As the archival is done live on the system, you may want to stop all processes maintaining coherent information, such as RDBMS systems for which the operation could cause a synchronisation data issue.

Video: Bare-metal recovery from CD

Podcast:

Mondo Rescue and Ample

References:

http://www.mondorescue.org
MondoRescue HOWTO
HOWTO run mondo interactively using cron
Bare-metal restore
Linux P2V (physical to virtual) migrations using mondorescue by Hewlett Packard

September 5, 2009 Posted by | System Backup, Video | | 13 Comments

Linux P2V (physical to virtual) migrations using MondoRescue. By Hewlett Packard

View this document on Scribd

This document is available at http://www.mondorescue.org/docs/p2v.pdf with the source (.odt) in the same directory.

September 5, 2009 Posted by | Docs, P2V, System Backup | | 12 Comments

Adding OpenERP 5.0 Modules for Spain on Ubuntu 8.04 LTS (in Spanish)

En este blog se ha facilitado un script de instalación de OpenERP 5.0 en Ubuntu 8.04 LTS Server & Desktop.

El siguiente paso es generar un plan contable e impuestos desde la plantilla correspondiente a nuestro país. Actualmente no figuran como oficiales los módulos OpenERP para España, así que será necesario descargarlos desde launchpad.net (alojamiento de código fuente que utiliza el sistema de control de versiones Bazaar).

24 Septiembre 2009. El nuevo instalador de este blog incluye stable_5.0-extra-addons, en cuyo caso resuta prescindible la parte de este procedimiento donde figura trunk-extra-addons. Si se emplea el instalador openerp-spain-allinone-setup-stable.sh también sería prescindible el procedimiento aquí detallado de descarga e instalación de módulos openerp-spain.

Descarga de las versiones más recientes de los módulos openerp-spain y trunk-extra-addons. Copiamos los nuevos módulos al directorio /usr/lib/python2.5/site-packages/openerp-server/addons

cd /opt
sudo bzr branch lp:openerp-spain
sudo chown -R openerp.root openerp-spain
sudo cp -r openerp-spain/l10n_es/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_es_extras/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_es_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/extra_addons/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_ca_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_gl_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_eu_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons

sudo bzr branch lp:~openerp-commiter/openobject-addons/trunk-extra-addons
sudo chown -R openerp.root trunk-extra-addons/
sudo cp -r trunk-extra-addons/account_payment_extension/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/sale_payment/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/label/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/partner_spam/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/smtpclient /usr/lib/python2.5/site-packages/openerp-server/addons

Donde:

* l10n_es_ES para las traducciones al castellano (directorio vacío)
* l10n_ca_ES para las traducciones al català
* l10n_gl_ES para las traducciones al galego (directorio vacío)
* l10n_eu_ES para las traducciones al euskera (directorio vacío)

Desde el cliente OpenERP (Web ó GTK): Administración -> Módulos -> Actualizar Lista de Módulos . Esta opción actualiza la lista de módulos y añade los nuevos en la lista de los “no instalados”.

24 Septiembre 2009-> No aplica en últimas revisiones de openerp-spain: Crear una nueva base de datos desde el cliente OpenERP con la opción de no instalar datos de prueba (de otro modo se generaría un error durante el procedimiento de instalación de los módulos). Una vez creada la base de datos,  NO continuar con el asistente de configuración (hacer click en “Saltar paso” cuando aparezca la pantalla de “Definir ejercicios fiscales y seleccionar plan contable“). De esta manera evitamos los errores que surgirían al instalar la plantilla contable y los ejercicios.

Desde el cliente OpenERP: Administración -> Módulos -> Instalar el nuevo módulo “l0n_ES_pyme_install” y todas sus dependencias.

Crear los topónimos del Estado Español (crear las provincias mediante el asistente que se ejecuta automáticamente al instalar el anterior módulo)

Cear cuentas contables a partir de la plantilla (mediante el menu Gestion financiera/Configuracion/Contabilidad financiera/Plantillas/Generar plan contable a partir de una plantilla de plan contable).

Instalar modulo l10n_ES_pyme_custom y todas sus dependencias (este modulo crea ejercicios para 2009 y 2010).

24 Septiembre 2009. Actualizar módulos de openerp-spain con las últimas revisiones de launchpad.net (en el caso de no emplear el instalador específico para España openerp-spain-allinone-setup-stable.sh):

  • cd /opt/openerp-spain
  • sudo bzr missing
  • sudo bzr pull
  • Copiar nuevamente los módulos a /usr/lib/python2.5/site-packages/openerp-server/addons
  • Actualizar la lista de módulos desde el cliente Web ó GTK de OpenERP

Referencias:

September 4, 2009 Posted by | ERP, Turnkey | | 3 Comments

How to upgrade OpenERP on Ubuntu Linux

Here are my steps to upgrade OpenERP from 5.0.2 release to 5.0.3 on Ubuntu Linux. Please note this procedure only applies when OpenERP 5.0.2 was previously installed from source code (.tar.gz files). This upgrade is easy because both releases share the same Python libraries. This procedure is expected to work with the next OpenERP releases.

TIP: Copy and paste the following lines on a linux terminal

cd /opt
sudo apt-get install wget -y
sudo wget http://www.openerp.com/download/stable/source/openerp-server-5.0.3.tar.gz
sudo wget http://www.openerp.com/download/stable/source/openerp-client-5.0.3.tar.gz
sudo wget http://www.openerp.com/download/stable/source/openerp-web-5.0.3.tar.gz
sudo tar xvzf openerp-server-5.0.3.tar.gz
sudo tar xvzf openerp-client-5.0.3.tar.gz
sudo tar xvzf openerp-web-5.0.3.tar.gz
cd /opt/openerp-server-5.0.3
sudo python setup.py install
cd /opt/openerp-client-5.0.3
sudo python setup.py install
cd /opt/openerp-web-5.0.3
sudo python setup.py install

August 26, 2009 Posted by | Backup, ERP, Linux, Procedure, Ubuntu Desktop, Ubuntu Server Canonical | , | 10 Comments

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

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

openerp-allinone-setup-5.0.2-0.sh

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

The Goal is to provide an All in one installer of OpenERP for Linux.

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/

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:
$ gzip -d openerp-allinone-setup-5.0.2-0.sh.gz
$ chmod +x openerp-allinone-setup-5.0.2-0.sh
$ ./openerp-allinone-setup-5.0.2-0.sh

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.2 has been tested by Tiny and Axelor on Debian Etch and Ubuntu Hardy.
  10. Package python-xml is broken in Ubuntu 9.04
  11. Ubuntu 9.04 is not LTS (Long Term Support)
  12. Ubuntu 8.04.3 LTS provides Postgresql 8.3 & Python 2.5.2, which are compatible with OpenERP 5.0.2.
  13. OpenERP 5.0.2 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).
  14. OpenERP 5.0.2 All-in-one installer for windows is recommended for beginners.
  15. This script eases the setting up of OpenERP 5.0.2 for Linux, but still requires some technical knowledge (and custom improvements?). OpenERP for Ubuntu Linux is recommended on production systems.

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.

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

August 13, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Server Canonical | , | 22 Comments

alfresco-installation-script-for-ubuntu9.04.sh

This script automates the setting up of Alfresco Community on Ubuntu Server 9.0.4 & Ubuntu Desktop 9.0.4.

Alfresco is an enterprise content management system for Microsoft Windows and Unix-like operating systems. Alfresco comes in two flavours . Alfresco Community Edition is free software, GPL licensed open source and open standards, but never officially stable. Alfresco Enterprise Edition is commercially / proprietary licensed open source, open standards and enterprise scale. Its design is geared towards users who require a high degree of modularity and scalable performance. Alfresco includes a content repository, an out-of-the-box web portal framework for managing and using standard portal content, a CIFS interface that provides file system compatibility on Microsoft Windows and Unix-like operating systems, a web content management system capable of virtualizing webapps and static sites via Apache Tomcat, Lucene indexing, and jBPM workflow. The Alfresco system is developed using Java technology.

Requirements: A fresh installation of Ubuntu Server 9.0.4 or Ubuntu Desktop 9.0.4. Apache is installed by this script. This means that the script expects to deal with default config files. TIP: test this script within a Virtual Machine after installing Ubuntu 9.04 from scratch.

Run the script as non-root with the following commands:

$ sudo apt-get install gzip
$ gzip -d alfresco-installation-script-for-ubuntu9.04.sh.gz
$ chmod +x alfresco-installation-script-for-ubuntu9.04.sh
$ ./alfresco-installation-script-for-ubuntu9.04.sh

You will be asked for:
1) The DNS Name your Alfresco service will be available at
2) IP address your Alfresco service will be listening on
3) Your LANG
4) Etc.

Your brandnew Alfresco Community Edition will be reached with a web browser at:
http://YOUR-DNS-NAME/alfresco/faces/ (admin/admin)
http://YOUR-DNS-NAME/alfresco (guest)
Language Pack Installation: http://wiki.alfresco.com/wiki/Language_Pack_Installation

August 3, 2009 Posted by | Content Management Systems (CMS), Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | | 47 Comments

OpenERP – Functional Book / User Manual

Tip: View mode can be changed to “Book Mode” if you click on More -> View Mode

View this document on Scribd

PDF: http://www.openerp.com/books/openerp-book.pdf

July 30, 2009 Posted by | Docs, ERP | , | 9 Comments

Follow

Get every new post delivered to your Inbox.

Join 32 other followers