How to Install OpenERP 7 on Digital Ocean

June 27, 2013 8.9k views
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. 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 rpm -ivh 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 unzip rm -rf cd gdata* python 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 tar -zxvf openerp-7.0-latest.tar.gz --transform 's!^[^/]\+\($\|/\)!openerp\1!' cd openerp python 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';
6 Answers
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?
i just installed openerp in this Ubuntu droplet it works perfectly put i get this error when i try to create it's database
Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/", line 204, in dispatch
response["result"] = method(self, **self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/", line 777, in create
File "/usr/lib/pymodules/python2.7/openerp/addons/web/", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/", line 97, in send
raise xmlrpclib.Fault('AccessDenied',

Server Access denied.

i googled it and this error means that the deb i installed didn't configer is PostgreSQL database
any help?
This instruction returns 404 error (not found) can you help?
@r.covington: It works fine for me, are you pasting it correctly?

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

Have another answer? Share your knowledge.