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!!
21 Comments
Sorry, the comment form is closed at this time.
About
Advantages of OpenERP Appliance
The weakest link of the free of charge OpenERP All-In-One for Linux is its dependence on the network and on launchpad.net repository, failing in case the Internet or Launchpad connection gets in trouble and requiring then a new deployment from scratch (with a fresh install of Ubuntu Linux included). Also, this All-In-One installer for Linux lasts longer than 40 minutes, downloading all the required python libraries and OpenERP source code. OpenERP All-In-One for Windows is easy-to-use and fast-to-deploy but is not update-able and not recommended for production either.
On the other hand, the purchase of these inexpensive OpenERP Appliances will save you precious time and money by including OpenERP source code without the need of an Internet connection for downloading OpenERP. The full installation processends in less than 5 minutes, and can be deployed on virtual machines, in cloud computing infrastructures or installed in physical computers. The appliances also offer a professional well tuned and tested installation with ease of use, latest OpenERP updates with full logging, and guarantee of success without licence costs. Actually this is the number one choice for mission-critical computing (production), testing and demonstrations.
Now you can get the performance, reliability, scalability and usability of propietary ERPs for up to 99,99 percent less!! 🙂
Pricing
- OpenERP 6 Desktop Appliance: 6€
- OpenERP 6 Server Appliance: 6€
- OpenERP 6.1rc1 Server Appliance: 6€
- OpenERP 6.1.1 Server Appliance: 10€
Community vs Enterprise pricing
Pricing of services offered by the Editor: click here and here
Where to purchase and download OpenERP Appliance
‘Add to cart’ buttons available here via e-junkie.com purchases. PayPal, credit card and debit card payments.
The downloading should take around 9 minutes. Bear in mind that any download is only as fast as the slowest link in the network route, which is usually the buyer’s own ISP connection — e.g., a 500MB file would take several hours, and a 2GB file would take a day or two, to download to completion over a 256kbps basic residential DSL connection. Files are zipped for Simple File Verification.
Community Support Forum
Blog comments are turned off. Click here for OpenERP Appliance Forum
Key points
- A pre-packaged Installable Live CD OpenERP server on IA 32-bit Ubuntu Linux: an ISO image which installs on both bare metal (I.e., a non-virtualized physical machine) and virtual machines, including VMware, Xen, VirtualBox, and KVM. This image can also run live in non-persistent demo mode
- From the Desktop to the data center: deploys on both physical and virtual machines and in cloud computing infrastructure
- Based on TurnKey Linux Virtual Appliance Library
- Administrators gain an easy method of setting up a dedicated OpenERP server
- OpenERP branches included: openerp-server, openerp-web, openerp-client, addons, extra-addons.
- Apply latest OpenERP bug fixes available on Launchpad.net repository via openerp-update script in ‘openerp’ linux account.
- Its web based tools make it perfect for cloud computing and hosting services
- Desktop appliances offer a GUI Desktop to developers, testers and newbies
- Server appliances lack of GUI Desktop, being more suitable for cloud computing and hosting services
- Open source means no license cost, no vendor lock-in and no forced upgrades, resulting in lower costs and higher return on investment
Web based Tools (screenshot)
- OpenERP Web interface
- Web Shell: a web-based ssh shell. It runs on any browser capable of JavaScript and AJAX. You can use it from any computer or iPhone/smartphone
- Webmin: a web-based configuration tool for system administration. User accounts, Apache, DNS, software packages, backup, file sharing and much more can be configured remotely using a web browser
- phpPgAdmin: a web-based administration tool for PostgreSQL
- TLKBAM: TurnKey Linux Backup and Migration, a simple and powerful system-level backup (not yet available on postgresql appliances like this one. Postgresql support is in the works according to turnkeylinux.org FAQ)
Cloud Technologies, Cloud Providers and Hosting Providers
Physical Machines where openerp appliance has been deployed successfully
- HP ProLiant MicroServer AMD Turion II N40L/2GB/250GB. Due to its lack of a DVD drive, this openerp appliance needs to be installed from USB, for which UNetbootin can be used.
- etc.
Desktop virtualization tips and Howtos
- Install in a physical machine if you’re not familiar with virtualization
- Burn the ISO image to a DVD: The installation process will be much faster if the appliance is installed from a DVD
- Documentation: Example of how to deploy this appliance on VirtualBox (also applies to VMware): Read “Third, install the generic ISO image (#2 alternative)“ (external link)
- Deploy on the latest free of charge VMware player for windows (VMware Fusion on Mac OS X). VMware player default settings allow to reach the appliance from your windows browser, while virtualbox requires customization.
- The desktop appliance runs LXDE, a light weight X11 window manager suitable for netbooks
- VirtualBox and VMware Player can be installed on the same Windows system and run simultaneously.
- Desktop Appliances on VirtualBox or VMware Player: Set up full screen resolution, clipboard (copy/paste) support, and shared folders between the Virtual Machine and the Windows Host. Dual Monitor configuration: one monitor with a full screen Virtual Machine (openerpappliance), and the other monitor (i.e. laptop’s monitor) with the Windows host.
- VMware Player Settings:
- How to reach the Virtual Machine from a windows host: Its default network configuration (NAT) will allow you to reach the virtual machine from your windows host.
- How to reach the Virtual Machine from the LAN: Set up a Bridged network adapter. A DHCP server available in the LAN is required, like i.e. your wireless router.
- Desktop Appliance: At least 700MB of VM memory required.
- VirtualBox Settings:
- How to reach the Virtual Machine from a windows host: VirtualBox requires a non default configuration. Set up two network adapters:
- NAT adapter, required to reach Internet from inside the Virtual Machine. This is the default adapter.
- Host-only adapter, required to reach the Virtual Machine from the windows host. It has to be added manually.
- How to reach the Virtual Machine from the LAN: Set up a Bridged network adapter. A DHCP server available in the LAN is required, like i.e. your wireless router.
- Desktop Appliance: At least 700MB of VM memory required. Select 128MB of display memory.
- How to reach the Virtual Machine from a windows host: VirtualBox requires a non default configuration. Set up two network adapters:
- KVM on Linux hosts Settings:
- Desktop Appliance and virt-manager: Set up “vga 9MB” as default video adaptor before starting the KVM virtual machine. This fixes major display issues.
The author
A Senior IT professional with 11 years of experience in Public and Telecommunications sectors as Systems and Automation Engineer. He holds a Honours of Bachelor Computer Science degree from the University of the Basque Country (2000) in Donostia – San Sebastian, Spain. His career began in Ireland in the beginning of 2001, returning to Spain in 2002 after the dot-com bubble burst, and became contractor for final customers since then. He grew up in Bilbao area, and lives permanently in Madrid since late 2003.
OpenERP Appliance 
Hi
This looks very interesting. Can I just confirm that we can use this script and replace the previous one https://opensourceconsulting.wordpress.com/2009/09/15/openerp-all-in-one-installer-update-for-dummies/ ?
Julian
Hi Julie,
This new script can be used on an existing installation of openerp if it was previously set up with the old version.
This release replaces the previous one at the same post/URL.
I have a problem
Installing the OpenOffice Reporting engine on a fresh install of Ubuntu 8.04 and Stable of OpenERP, gives an error when trying to use the report I’ve created as per the instructions.
This is what I posted here http://kndati.lv/forum/viewtopic.php?f=11&t=49
Hi
I’m using the script from here http://opensourceconsulting.wordpress.c … or-ubuntu/ with OpenOffice.org Reporting installed as part of the script on a 8.0.4 Ubuntu virtual machine. The script pulls in all required python modules such as relatorio. I am using the stable install, ie using 5.0.6
But I still get the error above which is odd, as the VM is a completely fresh install ..
There is mention in these forums viewtopic.php?f=11&t=43 that I might need a newer lxml but also in the fourms it implies that a different call should be used.
Please can you help ? I have also posted this in the comments section of the script I have used to make them aware that a default install doesnt quite seem to work.
Julian
Thanks for you help Julian. I’ve just googled it and got this link:
http://www.willmer.com/kb/2007/12/attributeerror-module-object-has-no-attribute-blah/
Hi,
very useful blog! I am trying to work out report_openoffice module but without luck. Script installs openerp perfectly .
I can install report_openoffice & report_openoffice_samples .
But after install I get error when creating invoces openerp complains about badzip file…
to be honest I did not quite understood what needs to be done to install report_openoffice besides through openerp administration.
Could someone confirm that it can be done and please post the solution (for dummies 🙂 )
Best regards, and many many thanks in advance!
Hi Vladimir, hopefully this known issue will be fixed by Kaspars…
Hi again,
I finally got it working…and I will try to explain how…
there were several failures…but with the help of the VM I went the right way…
After fresh install with the above script and initial setup of the database and basic elements (customer, supplier and 1 product) , I have installed only this modules:
base_report_designer (interface for downloading and editing original reports in sxw format)
base_report_unicode (support for other font latin2 & etc)
Then I (re)moved original report_openoffice that is installed with the script and downloaded from developer site
http://kndati.lv/index.php/en/web-links/44-openerp-addons/34-openofficeorg-reporting-engine-for-openerp and placed it in addons folder (unziped). Updated module list, installed the module and created the connection to openoffice like in the instructions. Besides that I did nothing.
I think that it is good not to install report_openoffice_samples because I think they change something in the configuration and then it does not work.
Hope that I will help someone…
regards, Vladimir
Hi After trying your instructions and removing the original module and using one from kndati.klv and importing that, i end up with the same problem as originally, ie in post 1 here ie
AttributeError: ‘etree._ElementTree’ object has no attribute ‘iter’
Hi Julian,
I did not mention that I have 64bit ubuntu 9.10 installation and I think they are different in some of the packages…
I am not an expert….just a power user…so if you can send me email to vladimir@kosacrta.hr with the error and I will try to reproduce the same thing with ubuntu 8.04 version…
or you can try install with 9.10, this script makes it to easy…
regards, Vladimir
Hi Vladimir and Julian,
In my opinion both Ubuntu 32 bits and 64 bits have exactly the same packages…
Should “base_report_designer” and “base_report_unicode” be dependencies in report-openoffice?
I don’t understand the difference between downloading report-openoffice from kndati.lv and launchpad.net. Good to know your workaround fixes the issue.
On the other hand, packages differ from 8.04 to 9.10. For example 9.10 includes more python packages than 8.04, and this script installs them by running “easy_install” instead of “apt-get”.
The key is to setup the correct release for each python library required by report-openoffice.
Julian,
or even better I can send you download link with virtual machine.
regards, Vladimir
It may be an idea I can download the VM, if you have a url for it …. Its funny as I normally use 9.10, but as its for a server application, i used 8.04 as OpenERP 5.0.6 doesnt install by apt-get easily on 9.10, so thats why i chose 8.0.4.
OK, I will send you link tommorrow….just send me an email…
I have limited bandwidth so I really do not want make it public….but if you work with VM , why do not try with 9.10 and the script it just works…
Julian,
According to REQUIRES.txt file, report-openoffice requires two packages: 1) relatorio 2)openoffice-python
The second one is not included in this script…
8.04 : sudo easy_install openoffice-python
9.10 : sudo apt-get install -y python-openoffice
After reading your comments on kaspars’ blog, I’ve figured out how to install python lxml 2.2.4 on Ubuntu 8.04:
sudo apt-get install -y libxml2-dev libxslt1-dev
sudo easy_install “lxml>2.0”
Hi,
When I metioned 64bit 9.10 the emphasis was on 9.10
I did not get the error that Julian got but badzipfile error that is also mentioned in developer forum.
I do not know what made my configuration work, rather what course of actions made my config work.
I tried to install the samples and then got some errors.
Reason why I used developer download was just lucky guess.
Also I thought that developer version from developer site is the freshest one.
And the developer forum posted some corrections.
report_openoffice seems to be working without the previous errors 😉
Anyone used this script for Ubuntu 10.04?
Should it work?
I am now at the stage of “OpenERP Server:Downloading latest stable branch from launchpad.net”. 30min has passed, how long does it takes to complete this stage?
Hi Alex,
The weakest link of this all-in-one is its dependence on network. I recommend you to buy my OpenERP appliance that already includes all necessary source code without the need of an Internet connection. It only costs $1.5 and success is guaranteed!!
[…] New release of OpenERP All-in-one installer & updater for Ubuntu (openerpappliance.com) […]
Pingback by openerp-server 5.0 and Python 2.7 « Experiences with an Open Source ERP system | May 3, 2011