OpenERP Appliance

Collaboration Works

OpenERP 6.1.1 server appliance

OpenERP Appliance Forum

OpenERP 6.1.1 server Appliance is now available for sale. It is based on Turnkey Linux Library 11.3 (Ubuntu 10.04) and  includes an ‘openerp-update fast‘ option for faster updates of openerp source code without prompts. Branches included: openerp-server, openerp-web, openerp-client, addons, openerp-spain (disabled), magentoerpconnect, prestashoperpconnect, e-commerce-addons, openobject-extension. Extra-Addons is no longer included as it’s full of junk and is supposed to disappear soon. If you need it you can always add it as any other community branch as explained below. Bazaar branches are now located in /home/openerp instead of the longer path /home/openerp/workspace, with the goal of simplifying the writing and reading of addons_path in /etc/openerp-server.conf.

E-Junkie is the e-commerce provider chosen for selling digital media at openerpappliance.com. The download link will expire after 120 hours (5 days) or after 5 attempts, which ever event happens first

Openerp login credentials are set up during the database creation, by default admin/openerp (required for backup/restore from openerp clients) and demo/demo.

OpenERP source code is update-able by running openerp-update command inside ‘openerp’ linux acount. Remember to login as linux user acount “openerp” with default password “openerp. As an interesting feature, openerp-update offers the possibility of reverse updating openerp-server, openerp-web, openerp-client and addons (branches with bzr milestones). Also note that openerp-update script is not longer obfuscated.

Please run ‘openerp-update fast’ in order to obtain latest commits available on Launchpad if you want HTTPS to work on your appliance (reverse proxy option). Otherwise openerp-web will fail. I was supposed to wait for v6.1.2 before publishing a 6.1 stable release, but at the end the 6.1.2 release is not coming out yet and I really need the money…

Example of how to add a new community branch to openerp-update:

  1. cd /home/openerp/
  2. bzr branch lp:openerp-spain
  3. Update addons-path in /etc/openerp-server.conf by adding ‘/home/openerp/openerp-spain’
  4. openerp-update

List of available appliances:

OpenERP 6.1.1 Server Appliance – NEW

  • 32-bit architecture
  • File size: 1GB
  • Build Date: March 13th 2012
  • Ubuntu release: 10.04.1 LTS (Lucid)
  • TurnKey Linux release: TKL 11.3
  • GUI Desktop included?: No
  • confconsole included?: Yes
  • Workaround for openerp-client bug #674231?: No
  • Price: 10€
  • May 2012: Latest commits require paramiko library: run ‘sudo apt-get install python-paramiko’ and restart the appliance in order to get the web client working.

Add to Cart

March 13, 2012 Posted by | Automated infrastructure, Deployment, Turnkey, Virtualization | | Leave a comment

OpenERP 6.1rc1 server appliance for QA testing purpose. ‘openerp-update fast’ option added

OpenERP Appliance Forum

OpenERP 6.1rc1 server Appliance is now available for sale. It is based on Turnkey Linux Library 11.3 (Ubuntu 10.04) and  includes an ‘openerp-update fast‘ option for faster updates of openerp source code without prompts. Please note this is a QA testing purpose build (trunk branch in Launchpad instead of stable branch). Branches included: openerp-server, openerp-web, openerp-client, addons, extra-addons, magentoerpconnect.

E-Junkie is the e-commerce provider chosen for selling digital media at openerpappliance.com. The download link will expire after 120 hours (5 days) or after 5 attempts, which ever event happens first

Openerp login credentials are set up during the database creation, by default admin/openerp (required for backup/restore from openerp clients) and demo/demo.

OpenERP source code is update-able by running openerp-update command inside ‘openerp’ linux acount. Remember to login as linux user acount “openerp” with default password “openerp. As an interesting feature, openerp-update offers the possibility of reverse updating openerp-server, openerp-web, openerp-client and addons (branches with bzr milestones).

Example of how to add a new community branch to openerp-update:

  1. cd /home/openerp/workspace/
  2. bzr branch lp:aeroo
  3. Update addons-path in /etc/openerp-server.conf by adding ‘/home/openerp/workspace/aeroo’
  4. openerp-update

List of available appliances:

  1. OpenERP 6.1rc1 Server Appliance
    • 32-bit architecture
    • File size: 1,1GB
    • Build Date: January 17th 2012
    • Ubuntu release: 10.04.1 LTS (Lucid)
    • TurnKey Linux release: TKL 11.3
    • GUI Desktop included?: No
    • confconsole included?: Yes
    • Workaround for openerp-client bug #674231?: No
    • Price: 6€

    Add to Cart

January 15, 2012 Posted by | Automated infrastructure, Deployment, Turnkey, Virtualization | | Leave a comment

OpenERP 6.0.3 appliance with addons_path and openerp-update with community branches

OpenERP Appliance Forum

OpenERP 6.0.3 Appliance is now available for sale. It is based on Turnkey Linux Library 11.3 (Ubuntu 10.04) and  includes an addons_path configuration in /etc/openerp-server.conf and the possibility of adding bzr branches to openerp-update (like  i.e. magentoerpconnect and openerp-spain, both of them already downloaded but only the former one included in addons_path). Thanks Angel Moya from Domatix for these two suggestions. Further details in openerp-update’s report.

The desktop appliance provides a GUI Desktop to developers, testers and newbies, while the server appliance is more suitable for production and cloud computing.

E-Junkie is the e-commerce provider chosen for selling digital media at openerpappliance.com. The download link will expire after 120 hours (5 days) or after 5 attempts, which ever event happens first

OpenERP branches included (click on the right links for source code revisions):

Openerp login credentials are set up during the database creation, by default admin/openerp (required for backup/restore from openerp clients) and demo/demo.

OpenERP source code is update-able by running openerp-update command inside ‘openerp’ linux acount. Remember to login as linux user acount “openerp” with default password “openerp. As an interesting feature, openerp-update offers the possibility of reverse updating openerp-server, openerp-web, openerp-client and addons (branches with bzr milestones).

A README document is available on each appliance explaining the following points of interest:

  • Howto update OpenERP branches
  • Howto change your keyboard layout
  • Information regarding VMware tools and VirtualBox Guest Additions installers:
    • vmware-tools-installer.sh
    • virtualbox-guest-additions-installer.sh (postgres, apache and openerp related services need to be started manually on each boot after adding Guest Additions on latest virtualbox releases)
    • Above scripts provide :
      • full screen resolution on VirtualBox and VMWare Player.
      • Clipboard support: cut/copy and paste between the guest and host OS
      • Shared folders require manual configuration
  • Howto reach OpenERP Appliance on a Virtual Machine from your windows host (VirtualBox,VMware and KVM)
  • Howto reach OpenERP Appliance on a Virtual Machine from your LAN (VirtualBox,VMware and KVM)

List of available appliances:

  1. OpenERP 6.0.3 Desktop Appliance
    • 32-bit architecture
    • File size: 1,11GB
    • Build Date: December 21st 2011
    • Ubuntu release: 10.04.1 LTS (Lucid)
    • TurnKey Linux release: TKL 11.3
    • GUI Desktop included?: Yes
    • confconsole included?: No
    • Workaround for openerp-client bug #674231?: Yes, openerp-client runs by clicking on Desktop icon
    • Issue: When installing VMware Tools or VirtualBox Guest Additions, the appliance might boot with text console login. Workaround: press ‘ALT-F7’ to switch back to GUI login.
    • At least 700MB of Virtual Memory required. Select 128MB of display memory in VirtualBox and “vga 9MB” as default video adapter in KVM.
    • Price: 6€

    Add to Cart

  2. OpenERP 6.0.3 Server Appliance

    • 32-bit architecture
    • File size: 906MB
    • Build Date: December 21st 2011
    • Ubuntu release: 10.04.1 LTS (Lucid)
    • TurnKey Linux release: TKL 11.3
    • GUI Desktop included?: No
    • confconsole included?: Yes
    • Workaround for openerp-client bug #674231?: Yes
      • openerp-client runs from command line if required by openerp admin (SSH X11 forwarding required)
      • openerp-client is usually installed and run on each Desktop PC/Laptop (openerp users)
    • Price: 6€

    Add to Cart

 

December 22, 2011 Posted by | Automated infrastructure, Deployment, Turnkey, Virtualization | , , , , , , , | 1 Comment

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

OpenERP-Magento-Facebook integration on Ubuntu

OpenERP Appliance & All-In-One & Magento Forum

Magento E-commerce management using OpenERP

The new magentoerpconnect module is now included in this release of OpenERP installer for Ubuntu. An installer for Magento 1.4.0.1 on Ubuntu >= 9.04 is also available on this post. Both scripts cannot be run on the same ubuntu system.

Social shopping: Magento-Facebook integration

Links of interest

https://launchpad.net/magentoerpconnect
Which openERP integration to use
Some basic questions about your magento-openerp connector
Magento extension for multiwebsite OpenERP connector by Open Labs
Zend and Varien Partner to Deliver an All-In-One PHP and Magento eCommerce Solution

November 6, 2009 Posted by | ERP, Scripting, Social Shopping, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 9 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: The rise of open-source business management software

September 27, 2009 Posted by | ERP, Presentation | , , , | 10 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

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

Follow

Get every new post delivered to your Inbox.

Join 32 other followers