OpenERP Appliance

Collaboration Works

New release of OpenERP All-in-one installer & updater for Ubuntu

A new release of this open source script is available and compatible with Ubuntu 9.10. It automates the installation and update of OpenERP from source code (latest stable or trunk branch from launchpad.net). The following optional modules have been included: openerp-spain, magentoerpconnect, report-openoffice and openetl.

Many thanks to Ana Juaristi (openerpsite.com) for suggesting the idea of adding report-openoffice into this installer. Brandnew OpenOffice.org Reporting Engine rocks!!

Click on this link to grab the new installer

January 31, 2010 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 21 Comments

Instalador y actualizador gráfico de OpenERP Spain para Ubuntu (descarga última versión estable de launchpad)

OpenERP Appliance & All-In-One Forum

Click here to view this post in English

El siguiente script de software libre automatiza la instalación y actualización de openerp-server, openerp-client, openerp-web, openerp-addons y openerp-extra-addons para Ubuntu 8.04 LTS, Ubuntu 9.10 y Ubuntu 10.04 LTS (Desktop ó Server):

  • openerp-allinone-setup.sh : Instala o actualiza las última ramas (branch) estables ó trunk (desarrollo) disponibles en launchpad.net. Incluye opcionalmente las ramas en desarrollo openerp-spain, magentoerpconnect, report-openoffice y openetl.
  • Mayo 2010: El nuevo módulo pxgo_openoffice_reports, una mejora con respecto a report-openoffice, se encuentra disponible en extra-addons. Para su instalación seleccionar “report-openoffice” en el all-in-one para ubuntu, activando posteriormente el módulo pxgo_openoffice_reports desde el cliente openerp (sin cargar el módulo report-openoffice).
  • 15 Mayo 2010:  OpenERP Appliance disponible!! Esta es una importante mejora con respecto al all-in-one para linux, muy recomendable para entornos de pruebas y producción. No requiere conocimientos técnicos. Disponible aquí.
  • 27 Mayo 2010: OpenERP 6 trunk appliance disponible para pruebas.

17 Febrero 2010: Hay un problema al instalar openerp trunk con este script: /usr/bin/openerp-server no es creado y es necesario volver a instalarlo con uno de los dos procedimientos siguientes: 1) Ejecutando nuevamente el script, como si fuera una actualización, pero haciendo click en “Cancelar” al no encontrar nuevas actualizaciones y proceder con la reinstalación. 2) Manualmente desde línea de comandos:

cd /opt/openerp-server

sudo python setup.py install

sudo /etc/init.d/openerp-server start

El objetivo es desarrollar un completo instalador y actualizador gráfico de OpenERP para Ubuntu con un principio KISS y con el último código fuente disponible.

Actual rama estable de OpenERP es la versión 5.0.7 (marzo 2010)

Requisitos: Una nueva instalación de Ubuntu 8.04 LTS, Ubuntu 9.10 ó Ubuntu 10.04 LTS (http://www.ubuntu.com/getubuntu/download)

El proceso de instalación puede ser tan simple como responder “Aceptar” ó “OK” en cada pregunta. Es necesario introducir la clave de usuario (sudo).

Consejo: probar este script dentro de una Máquina Virtual tras instalar Ubuntu 8.04 LTS Desktop ó Ubuntu 9.10 Desktop. Tamaño mínimo de la máquina virtual: 5 GB (apurando mucho) – 6 GB (1GB libre en un Ubuntu Desktop con un completo openerp). Ubuntu Server requiere menos espacio al no disponer de interfaz gráfica. Ejecutar la máquina virtual en una bridged network: host y guest comparten misma subred y son accesibles desde la red local (LAN).

Ubuntu Desktop (para iniciados en Linux ó usuarios interesados en escritorio con interfaz gráfica): Ejecutar el script desde el escritorio

  1. descomprimir el fichero
  2. click derecho en el icono de openerp-allinone-setup.sh
  3. click en ” Propiedades”
  4. click en pestaña “Permisos”
  5. click en la casilla de verificación “Ejecución: Permitir ejecutar el archivo como un programa”
  6. click en “Cerrar”
  7. doble click en el icono y “Ejecutar en un terminal” ó “Ejecutar”: OpenERP será instalado en la primera ejecución. Una vez instalado, el script actualizará OpenERP si se vuelve a ejecutar con doble click (siempre y cuando existan nuevas actualizaciones).
  8. El fichero OpenERP-README.txt incluye los pasos siguientes a configurar en OpenERP desde el cliente Web ó GTK

Ubuntu Server (para usuarios avanzados no interesados en escritorio con interfaz gráfica): Durante la instalación de Ubuntu Server no seleccionar software a instalar como LAMP Server ó PostgreSQL Server en el menú “Selección de Software” (a excepción de SSH Server). Ejecutar el script como no-root con los siguientes comandos en una sesión SSH con X11 Forwarding

  1. Crear una sesión de shell seguro (SSH) con X11 Forwarding:
  2. Transferir el script a Ubuntu Server. Dos opciones:
  3. gzip -d openerp-allinone-setup.sh.gz
  4. chmod +x openerp-allinone-setup.sh
  5. ./openerp-allinone-setup.sh
  6. Salir de la sesión SSH:
    • exit
  7. Iniciar de nuevo una sesión SSH con X11 Forwarding:
    • Linux o Mac: ssh -X usuario@yourubuntuserver8.04
  8. ./openerp-allinone-setup.sh
  9. OpenERP será instalado en la segunda ejecución, y se actualizará de aquí en adelante si el script es ejecutado de nuevo.
  10. El fichero OpenERP-README.txt incluye los pasos siguientes a configurar en OpenERP desde el cliente Web ó GTK

Información adicional:

  1. Se recomienda Ubuntu 8.04 LTS para OpenERP en entornos de producción
  2. El Control de Calidad de OpenERP realizado por Tiny y Axelor se desarrolla en plataformas Debian Etch y Ubuntu Hardy (versión 8.04 LTS)
  3. Durante el proceso de instalación se muestran las direcciones IP disponibles en el sistema. La primera es seleccionada por defecto.
  4. En el directorio /opt se descarga el software de OpenERP a compilar e instalar
  5. Apache es configurado como frontal de OpenERP Web y redirecciona todo el tráfico HTTP entrante a HTTPS (HTTP Seguro). El mensaje de error “invalid security certificate” que aparece en su navegador Web es correcto porque el certificado SSL es de prueba.
  6. Se configura el firewall de Ubuntu con los siguientes puertos abiertos: SSH, HTTP, HTTPS, 8069 & 8070 (para el acceso remoto de los clientes GTK de OpenERP).
  7. Se crean los scripts de inicio (startup/init scripts) para openerp-server y openerp-web.
  8. Se crean en el Escritorio los iconos para openerp-client y openerpweb URL.
  9. Se crea el fichero OpenERP-README.txt con instrucciones para comenzar la configuración de la Base de Datos desde el cliente Web ó GTK de OpenERP.
  10. Se crea el fichero OpenERP-updates.txt con registros de las revisiones instaladas ó actualizadas. Esto resulta útil para mantener un control de las actualizaciones.
  11. El actualizador de OpenERP funciona ejecutando “bzr missing” y “bzr pull”.
  12. Los siguientes mensajes pueden ser ignorados (ref #1, ref #2) durante la instalación si se ejecuta el script en un Terminal:
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘console’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘windows’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘copyright’ warnings.warn(msg)
    File “build/bdist.linux-i686/egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
    File “/usr/lib/python2.5/site-packages/pyparsing-1.5.2-py2.5.egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
  13. Módulo Document: Menú -> Gestion de Documentos -> Navegar por los archivos usando FTP. Por defecto es configurado para localhost (lado del servidor) en el puerto 8021, pero el asistente de configuración puede modificarlo y el usuario abrir el puerto  en el firewall (sudo ufw allow 8021/tcp).

Enlaces de interés:

Capturas de pantalla:

September 27, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 97 Comments

OpenERP installation: All-in-One for Ubuntu with updates (latest revisions from launchpad)

OpenERP Appliance & All-In-One Forum

Haga click aquí para ver este mismo post en español con infomación de módulos OpenERP Spain

The following open source script automates the setting up and the update of openerp-server, openerp-client, openerp-web, openerp-addons and openerp-extra-addons for Ubuntu 8.04 LTS, Ubuntu 9.10 and Ubuntu 10.04 LTS (Desktop or Server):

  • openerp-allinone-setup.sh : Installs or updates latest stable or trunk branch from launchpad.net with the following optional modules: openerp-spain, magentoerpconnect, report-openoffice and openetl.
  • May 2010: The brandnew pxgo_openoffice_reports module (an improvement over report-openoffice) is available in extra-addons. It can be set up after installing report-openoffice with the all-in-one for linux. Just make sure you don’t load both modules from the openerp client.
  • May 15th 2010:  OpenERP Appliance available!! This is an important improvement over the all-in-one for linux, recommended for both testing and production environments. Non technical knowledge required. Click here to grab it.
  • May 27th 2010: OpenERP 6 trunk appliance available for testing purposes. Click here to grab it.

17th February 2010: There’s a problem with openerp trunk when installed by this script: /usr/bin/openerp-server is not created and has to be reinstalled with one of the following two procedures: 1) Running again the script, like if you were updating openerp, and then “cancel” button to reinstall as no new branches are found. 2) Manually from command line:

cd /opt/openerp-server

sudo python setup.py install

sudo /etc/init.d/openerp-server start

The aim is to develop a graphical installer and update mechanism of OpenERP for Ubuntu with a KISS principle and with the latest source code.

Current stable branch is version 5.0.7 (March 2010)

Requirements: A fresh installation of Ubuntu 8.04 LTS, Ubuntu 9.10 or Ubuntu 10.04 LTS (http://www.ubuntu.com/getubuntu/download)

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

TIP: test this script within a Virtual Machine after installing Ubuntu 8.04 LTS Desktop or Ubuntu 9.10 Desktop from scratch. Minimum virtual machine size of 5 GB space for testing, although at least 6 GB recommended (around 1GB free with a flat ubuntu desktop and full openerp). Remember that Ubuntu Server has even less space requirements. Run the virtual machine in a bridged network: host and guest have same subnet and can be reached from the LAN.

Ubuntu Desktop (for Linux newbies or users interested in having a GUI desktop): Run the script through the Graphical User Interface

  1. uncompress the file
  2. right click on openerp-allinone-setup.sh
  3. click on ” Properties”
  4. click on “Permissions” tab
  5. Click on checkbox “Execute: Allow executing file as program”
  6. click on “Close”
  7. double click on the icon and “Run in a Terminal” or “Run”: OpenERP will be installed during the first execution. OpenERP will be updated from this point onwards if you double click again on the icon.
  8. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Ubuntu Server (for advanced users not interested in having a GUI desktop): 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. Run the script as non-root user with the following commands in an SSH session with X11 Forwarding

  1. Create a secure shell (SSH) session with X11 Forwarding enabled:
  2. Transfer the script to Ubuntu Server. Two options:
  3. gzip -d openerp-allinone-setup.sh.gz
  4. chmod +x openerp-allinone-setup.sh
  5. ./openerp-allinone-setup.sh
  6. Exit from the SSH session:
    • exit
  7. Start again a new SSH session with X11 Forwarding enabled:
  8. ./openerp-allinone-setup.sh
  9. OpenERP will be installed during the second execution. OpenERP will be updated from this point onwards if the script is executed again.
  10. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Additional info:

  1. OpenERP on Ubuntu 8.04 LTS (Long Term Support) is recommended for production systems
  2. OpenERP has been tested by Tiny and Axelor on Debian Etch and Ubuntu Hardy (release 8.04 LTS)
  3. openerp-server and openerp-client (>= v5.0.3) are available on Ubuntu 9.10 Karmic Koala as Ubuntu packages: https://launchpad.net/ubuntu/+search?text=openerp
  4. Ubuntu 8.04 does not provide Ubuntu packages for OpenERP but is LTS (Long Term Support). Basically this is why I wrote this script (it makes less sense on newer Ubuntu releases)
  5. During the installation process, available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one.
  6. /opt is the working directory where OpenERP files are downloaded.
  7. Apache is configured as a front-end for OpenERP Web and redirects all the incoming HTTP traffic to HTTPS. The “invalid security certificate” error message in your Web browser is correct as the SSL certificate has been created for testing purposes.
  8. Ubuntu’s firewall is setup with the following ports open: SSH, HTTP, HTTPS, 8069 & 8070 (for remote access of OpenERP GTK clients).
  9. Startup/init scripts for openerp-server and openerp-web are added.
  10. Desktop Icons for openerp-client and openerpweb URL are created
  11. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)
  12. OpenERP-updates.txt file is created with records of installed or updated OpenERP revisions. This is useful to be in control of your updates.
  13. This OpenERP Updater works by running “bzr missing” and “bzr pull”.
  14. The following messages can be ignored (ref #1, ref #2) during the installation if you run the script in a Terminal:
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘console’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘windows’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘copyright’ warnings.warn(msg)
    File “build/bdist.linux-i686/egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
    File “/usr/lib/python2.5/site-packages/pyparsing-1.5.2-py2.5.egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
  15. Document module: the “Browse Files Using FTP” option is setup by default for localhost (server side) on port 8021. This can be configured with the wizard and by opening that port on the firewall (sudo ufw allow 8021/tcp)
  16. Remember to set up your mail server specified in /etc/openerp-server.conf file if you want OpenERP to send emails.

Links of interest:

Screenshots:

The following two scripts automate the setting up and update openerp-server-5.0.x & openerp-client-5.0.x & openerp-web-5.0.x & openerp-addons-5.0.x & openerp-extra-addons-5.0.x for Ubuntu 8.04 LTS Desktop and Server:* openerp-allinone-setup-stable.sh : Installs or updates latest stable branch from launchpad.net. This is the recommended one.
* openerp-allinone-setup-trunk.sh : Installs or updates latest trunk (development) branch from launchpad.net. Current branch links are not valid (view status of source code trunk and stable: http://openobject.com/forum/topic13013.html)The aim is to provide a graphical installer and update mechanism of OpenERP for Ubuntu Desktop and Server with a KISS principleCurrent stable branch is version 5.0.6 (Sep 22th 2009)Requirements: A fresh installation of Ubuntu 8.04 LTS Desktop or Server (http://www.ubuntu.com/getubuntu/download)TIP: test this script within a Virtual Machine after installing Ubuntu 8.04 LTS Desktop or Server from scratch. Run the virtual machine in a bridged network: host and guest have same subnet and can be reached from the LAN.Ubuntu Desktop: run the script through the Graphical User Interface1. uncompress the file
2. right click on openerp-allinone-setup-stable.sh or openerp-allinone-setup-trunk.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 in a Terminal” or “Run”: OpenERP will be installed during the first execution. OpenERP will be updated from this point onwards if you double click again on the icon.Ubuntu Server: 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. Run the script as non-root with the following commands in a SSH session with X11 Forwarding1. ssh -X user@ubuntuserver8.04
2. gzip -d openerp-allinone-setup-stable.sh.gz
3. chmod +x openerp-allinone-setup-stable.sh
4. ./openerp-allinone-setup-stable.sh
5. exit
6. ssh -X user@ubuntuserver8.04
7. ./openerp-allinone-setup-stable.sh
8. OpenERP will be installed during the second execution. OpenERP will be updated from this point onwards if the script is executed again.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 LTS is recommended for production systems
2. OpenERP has been tested by Tiny and Axelor on Debian Etch and Ubuntu Hardy (release 8.04 LTS)
3. The “invalid security certificate” error message in your Web browser is correct as the SSL certificate has been created for testing purposes
4. Desktop Icons for openerp-client and openerpweb URL are made
5. Available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one
6. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)
7. OpenERP-updates.txt file is created with records of installed or updated OpenERP revisions. This is useful to be in control of your updates.
8. Update process is now working by running “bzr missing” and “bzr pull” (Sep 22th).
9. Note for those who already downloaded stable extra-addons branch: Change of name due to bzr_set.py. Change the parent location and bound location in your .bzr/branch/branch.conf file. Changes: stable_5.0_extra-addons to stable_5.0-extra-addonsScreenshots:

September 15, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 232 Comments

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