Question

How to Install OpenERP 7 on Digital Ocean

  • Posted June 27, 2013

This is not a question, but a script to install OpenERP.

Here is the Gist with the script to install OpenERP 7 on a Digital Ocean Droplet with CentOS 6.4 32 bits.

https://gist.github.com/altuzar/5876873

And here is the script. If you know how to fix the encoding pgsql problems with the same script, please let me know. Thanks!

#!/bin/sh

Install OpenERP 7 on Digital Ocean

@altuzar

Modified script from Carlos E. Fonseca Zorrilla & Mario Gielissen

First: Create a Droplet with CentOS 6.4 x32

Then:

yum -y install wget unzip rpm -ivh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm rpm -ivh http://yum.pgrpms.org/9.2/redhat/rhel-6-i386/pgdg-centos92-9.2-6.noarch.rpm yum -y install python-psycopg2 python-lxml PyXML python-setuptools libxslt-python pytz
python-matplotlib python-babel python-mako python-dateutil python-psycopg2
pychart pydot python-reportlab python-devel python-imaging python-vobject
hippo-canvas-python mx python-gdata python-ldap python-openid
python-werkzeug python-vatnumber pygtk2 glade3 pydot python-dateutil
python-matplotlib pygtk2 glade3 pydot python-dateutil python-matplotlib
python python-devel python-psutil python-docutils make
automake gcc gcc-c++ kernel-devel byacc flashplugin-nonfree poppler-utils pywebdav
yum -y install postgresql92-libs postgresql92-server postgresql92 service postgresql-9.2 initdb chkconfig postgresql-9.2 on service postgresql-9.2 start su - postgres -c “createuser --superuser openerp” cd /tmp wget http://gdata-python-client.googlecode.com/files/gdata-2.0.17.zip unzip gdata-2.0.17.zip rm -rf gdata-2.0.17.zip cd gdata* python setup.py install cd /tmp adduser openerp mkdir /var/run/openerp chown openerp.openerp /var/run/openerp mkdir /var/log/openerp chown openerp.openerp /var/log/openerp rm -rf openerp* wget http://nightly.openerp.com/7.0/nightly/src/openerp-7.0-latest.tar.gz tar -zxvf openerp-7.0-latest.tar.gz --transform ‘s!^[^/]+($|/)!openerp\1!’ cd openerp python setup.py install rm -rf /usr/local/bin/openerp-server cp openerp-server /usr/local/bin cp install/openerp-server.init /etc/init.d/openerp cp install/openerp-server.conf /etc chown openerp:openerp /etc/openerp-server.conf chmod u+x /etc/init.d/openerp chkconfig openerp on service openerp start

If there is an error about a encoding UTF8 template when creating the company at OpenErp, use the following:

sudo su - postgres

psql -U postgres

update pg_database set datallowconn = TRUE where datname = ‘template0’;

\c template0

update pg_database set datistemplate = FALSE where datname = ‘template1’;

drop database template1;

create database template1 with template = template0 encoding = ‘UTF8’;

update pg_database set datistemplate = TRUE where datname = ‘template1’;

\c template1

update pg_database set datallowconn = FALSE where datname = ‘template0’;

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Two errors I saw with easy fixes. on the line before automake there should be a space after make and before the / also on the end of automake there is an unnecessary /

thanks for the script, got me going!

gist has the same errors Dan

@r.covington: It works fine for me, are you pasting it correctly?

This instruction returns 404 error (not found) http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm can you help? <br>

i just installed openerp in this Ubuntu droplet it works perfectly put i get this error when i try to create it’s database <br>" <br>Client Traceback (most recent call last): <br>File “/usr/lib/pymodules/python2.7/openerp/addons/web/http.py”, line 204, in dispatch <br>response[“result”] = method(self, **self.params) <br>File “/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py”, line 777, in create <br>params[‘create_admin_pwd’]) <br>File “/usr/lib/pymodules/python2.7/openerp/addons/web/session.py”, line 30, in proxy_method <br>result = self.session.send(self.service_name, method, *args) <br>File “/usr/lib/pymodules/python2.7/openerp/addons/web/session.py”, line 97, in send <br>raise xmlrpclib.Fault(‘AccessDenied’, openerp.tools.ustr(e)) <br> <br>Server Access denied. <br>" <br> <br>i googled it and this error means that the deb i installed didn’t configer is PostgreSQL database <br>any help? <br>thanks

nice to see it’s been done. So how did you find the performance of OpenERP on SSD? Tried to install it on nginx+gunicorn maybe? Would you recommend migrating from other hosting services?