Sohaib's Tech Blog

Something for every one

Odoo9 Community to Odoo9 Enterprise Database Upgrade — 2016

Odoo9 Community to Odoo9 Enterprise Database Upgrade

Today I’ve purchase Odoo9 Enterprise therefore I need to move my database from Odoo9 community to Odoo9 Enterprise at first I was getting Internal server error then after some research I realize that I need to upgrade my database here are the steps I took.

You need to restore your Odoo9 Community Database to Odoo9 Enterprise and then perform the following task.

Step 1

service odoo stop

Step 2

sudo su odoo -s /bin/bash

Step 3

/usr/bin/odoo.py --addons=/usr/lib/python2.7/dist-packages/openerp/addons -u all

Now Odoo9 Enterprise is started, Next step is you need to access Odoo from the web so it can start the upgrade process, It will start and you exit terminal and start odoo manually or simply reboot your server and walla its done.

Advertisements
Install OpenERP v7 on Ubuntu 12.10 Server — 2013

Install OpenERP v7 on Ubuntu 12.10 Server

Openerp 7 Install on Ubuntu

Next, download my script. from here

Or, at the command prompt, type the following ;

  1. cd /tmp
  2. chmod +x install_fresh_openerp.sh
  3. sudo ./install_fresh_openerp.sh

The script will do the following ;

  1. Update the Ubuntu installation with all new updates and patches.
  2. Install all necessary Python library dependencies for OpenERP 7.0
  3. Download the latest nightly build of OpenERP 7.0 all-in-one .deb file
  4. Install OpenERP 7.0

All you need to do then is point your browser to http://ipaddress:8069 on your server and you should have the logon screen for OpenERP 7.0.

Special Thanks and all credits goes to stewartstacey.com

Openerp Automated Install on Centos 6.3 — 2013

Openerp Automated Install on Centos 6.3

This script installs OpenERP v7.0 on a Centos 6.3 server (minimal i386) with PostgreSQL 9.2

#!/bin/sh
# Modified script from Carlos E. Fonseca Zorrilla
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
DIR=”/var/run/openerp /var/log/openerp”
for NAME in $DIR
do
if [ ! -d $NAME ]; then
mkdir $NAME
chown openerp.openerp $NAME
fi
done
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!^[^/]+($|/)!openerp1!’
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

 

Credit goes to Openerp FORUM

Openerp Automated Install Script v7.0 — 2013

Openerp Automated Install Script v7.0

I will assume you have installed Ubuntu 12.04 precise.

There are PLENTY of resources on the web if you need detailed help with that!

Simple Openerp Installation to make your life easier

Start by updating the package index:

yes | sudo apt-get update

 

Then, upgrade any outdated packages:

yes| sudo apt-get upgrade

 

Once you have done this, you will be able to copy and paste the following into your console, or paste it into a script to run:

#create the install directory for OpenERP

sudo mkdir /opt/openerp
sudo chown ubuntu /opt/openerp
sudo chgrp ubuntu /opt/openerp
cd /opt/openerp

#install PostgreSQL

yes | sudo apt-get install postgresql

#create a postgres user for OpenERP

sudo su postgres
createuser -s -e ubuntu
exit

#install Python dependencies

yes | sudo apt-get install python-dateutil python-docutils python-feedparser python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-psycopg2 python-psutil python-pybabel python-pychart python-pydot python-pyparsing python-reportlab python-simplejson python-tz python-unittest2 python-vatnumber python-vobject python-webdav python-werkzeug python-xlwt python-yaml python-zsi poppler-utils

#install GDATA

wget http://gdata-python-client.googlecode.com/files/gdata-2.0.17.tar.gz
tar zxvf gdata-2.0.17.tar.gz
cd gdata-2.0.17/
sudo python setup.py install
cd ..

#install bazaar

yes | sudo apt-get install bzr
yes | sudo apt-get install bzrtools

#install the three OpenERP branches this process wil take 15 to 20 minutes

bzr co lp:openerp-web/7.0 web
bzr co lp:openobject-server/7.0 server
bzr co lp:openobject-addons/7.0 addons

#setup logfile

sudo mkdir /var/log/openerp
sudo chown ubuntu:root /var/log/openerp

#setup configuration file

sudo cp /opt/openerp/server/install/openerp-server.conf /etc/
sudo chown ubuntu: /etc/openerp-server.conf
sudo chmod 640 /etc/openerp-server.conf
sudo sed -i'' 's/db_user = .*/db_user = ubuntu/g' /etc/openerp-server.conf
sudo echo "logfile = /var/log/openerp/openerp-server.log" >> /etc/openerp-server.conf
sudo echo "addons_path=/opt/openerp/addons,/opt/openerp/web/addons" >> /etc/openerp-server.conf

#setup auto-startup

cd /etc/init.d
sudo curl -O http://www.sohaib.com/download.sh
sudo sed -i'' 's/USER=.*/USER=ubuntu/g' /etc/init.d/openerp-server

sudo chmod 755 /etc/init.d/openerp-server
sudo chown root: /etc/init.d/openerp-server
sudo update-rc.d openerp-server defaults
sudo /etc/init.d/openerp-server start

chmod -R 777 /opt/openerp/server/openerp/

sudo reboot -h now

 

Full Installation will take approx 20/30 minutes let it run and grap a coffee, once its done simply login to your webserver oh yea and make sure to allow port 8069

http://YOURDOMAIN.COM:8069

If you see the following, it worked!

Openerp

 

Thanks to Ursainfosystems