altuzar
By:
altuzar

How to Install OpenERP 7 on Digital Ocean

June 27, 2013 10k 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. 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';
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/http.py", line 204, in dispatch
response["result"] = method(self, **self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 777, in create
params['create_admin_pwd'])
File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 97, in send
raise xmlrpclib.Fault('AccessDenied', openerp.tools.ustr(e))

Server Access denied.
"

i googled it and this error means that the deb i installed didn't configer is PostgreSQL database
any help?
thanks
@sherif: https://www.digitalocean.com/community/questions/openerp-postgresql-issue
This instruction returns 404 error (not found) http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm 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
Dan

Have another answer? Share your knowledge.