Skip to Content
Menu
This question has been flagged
1 Reply
2636 Views

i installed odoo 8 under debian 8 and postgresql 8.4 using that steps



1. Build your server######################
apt-get install openssh-server
apt-get updateapt-get dist-upgrade
2. Create the Odoo user that will own and run the application###############################################################
adduser --system --home=/opt/odoo --group odoo
3. Install and configure the database server, PostgreSQL##########################################################
apt-get install postgresql 

su - postgres
createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt odoo
exit
4. Install the necessary Python libraries for the server#########################################################
apt-get install python-cups python-dateutil python-decorator python-docutils python-feedparser python-gdata python-geoip python-gevent python-imaging python-jinja2 python-ldap python-libxslt1 python-lxml python-mako python-mock python-openid python-passlib python-psutil python-psycopg2 python-pybabel python-pychart python-pydot python-pyparsing python-pypdf python-reportlab python-requests python-simplejson python-tz python-unicodecsv python-unittest2 python-vatnumber python-vobject python-werkzeug python-xlwt python-yaml wkhtmltopdf
5. Install the Odoo server###########################
apt-get install git
su - odoo -s /bin/bash
git clone https://www.github.com/odoo/odoo --depth 1 --branch 8.0 --single-branch .
exit
6. Configuring the OpenERP application#######################################
cp /opt/odoo/debian/openerp-server.conf /etc/odoo-server.conf

chown odoo: /etc/odoo-server.conf

chmod 640 /etc/odoo-server.conf
nano /etc/odoo-server.confdb_password = password

 daddons_path = /opt/odoo/addons

logfile = /var/log/odoo/odoo-server.log
7. Start the server#####################
su - odoo -s /bin/bash/opt/odoo/openerp-server
CTL+C exit
8. Installing the boot script##############################
nano /etc/init.d/odoo-server
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; start of script
#!/bin/sh
### BEGIN INIT INFO# Provides:             odoo-server# Required-Start:       $remote_fs $syslog# Required-Stop:        $remote_fs $syslog# Should-Start:         $network# Should-Stop:          $network# Default-Start:        2 3 4 5# Default-Stop:         0 1 6# Short-Description:    Complete Business Application software# Description:          Odoo is a complete suite of business tools.
### END INIT INFO
PATH=/bin:/sbin:/usr/binDAEMON=/opt/odoo/openerp-serverNAME=odoo-serverDESC=odoo-server
# Specify the user name (Default: odoo).
USER=odoo
# Specify an alternate config file (Default: /etc/odoo-server.conf).
CONFIGFILE="/etc/odoo-server.conf"
# pidfilePIDFILE=/var/run/$NAME.pid
# Additional options that are passed to the Daemon.
DAEMON_OPTS="-c $CONFIGFILE"
[ -x $DAEMON ] || exit 0[ -f $CONFIGFILE ] || exit 0
checkpid() {    [ -f $PIDFILE ] || return 1    pid=`cat $PIDFILE`    [ -d /proc/$pid ] && return 0    return 1}
case "${1}" in        start)                echo -n "Starting ${DESC}: "
                start-stop-daemon --start --quiet --pidfile ${PIDFILE} \                        --chuid ${USER} --background --make-pidfile \                        --exec ${DAEMON} -- ${DAEMON_OPTS}
                echo "${NAME}."                ;;
        stop)                echo -n "Stopping ${DESC}: "
                start-stop-daemon --stop --quiet --pidfile ${PIDFILE} \                        --oknodo
                echo "${NAME}."                ;;
        restart|force-reload)                echo -n "Restarting ${DESC}: "
                start-stop-daemon --stop --quiet --pidfile ${PIDFILE} \                        --oknodo                      sleep 1
                start-stop-daemon --start --quiet --pidfile ${PIDFILE} \                        --chuid ${USER} --background --make-pidfile \                        --exec ${DAEMON} -- ${DAEMON_OPTS}
                echo "${NAME}."                ;;
        *)                N=/etc/init.d/${NAME}                echo "Usage: ${NAME} {start|stop|restart|force-reload}" >&2                exit 1                ;;
esac
exit 0

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; end of script
chmod 755 /etc/init.d/odoo-server

chown root: /etc/init.d/odoo-server
mkdir /var/log/odoo

chown odoo:root /var/log/odoo
9. Testing the server######################
/etc/init.d/odoo-server start
less /var/log/odoo/odoo-server.log
http://IP:8069
;default password is “admin”
/etc/init.d/odoo-server stop



when i am trying to install any module even the built in module it gives me that error



Traceback (most recent call last):
  File "/opt/odoo/openerp/http.py", line 544, in _handle_exception    return super(JsonRequest, self)._handle_exception(exception)  File "/opt/odoo/openerp/http.py", line 581, in dispatch    result = self._call_function(**self.params)  File "/opt/odoo/openerp/http.py", line 317, in _call_function    return checked_call(self.db, *args, **kwargs)  File "/opt/odoo/openerp/service/model.py", line 118, in wrapper    return f(dbname, *args, **kwargs)  File "/opt/odoo/openerp/http.py", line 314, in checked_call    return self.endpoint(*a, **kw)  File "/opt/odoo/openerp/http.py", line 810, in __call__    return self.method(*args, **kw)  File "/opt/odoo/openerp/http.py", line 410, in response_wrap    response = f(*args, **kw)  File "/opt/odoo/addons/web/controllers/main.py", line 948, in call_button    action = self._call_kw(model, method, args, {})  File "/opt/odoo/addons/web/controllers/main.py", line 936, in _call_kw    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)  File "/opt/odoo/openerp/api.py", line 268, in wrapper    return old_api(self, *args, **kwargs)  File "/opt/odoo/openerp/addons/base/module/module.py", line 447, in button_immediate_install    return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)  File "/opt/odoo/openerp/api.py", line 268, in wrapper    return old_api(self, *args, **kwargs)  File "/opt/odoo/openerp/addons/base/module/module.py", line 495, in _button_immediate_function    registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)  File "/opt/odoo/openerp/modules/registry.py", line 370, in new    openerp.modules.load_modules(registry._db, force_demo, status, update_module)  File "/opt/odoo/openerp/modules/loading.py", line 355, in load_modules    loaded_modules, update_module)  File "/opt/odoo/openerp/modules/loading.py", line 255, in load_marked_modules    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)  File "/opt/odoo/openerp/modules/loading.py", line 157, in load_module_graph    init_module_models(cr, package.name, models)  File "/opt/odoo/openerp/modules/module.py", line 290, in init_module_models    obj.init(cr)  File "/opt/odoo/openerp/api.py", line 268, in wrapper    return old_api(self, *args, **kwargs)  File "/opt/odoo/addons/crm/report/crm_lead_report.py", line 105, in init    )""")  File "/opt/odoo/openerp/sql_db.py", line 158, in wrapper    return f(self, *args, **kwargs)  File "/opt/odoo/openerp/sql_db.py", line 234, in execute    res = self._obj.execute(query, params)ProgrammingError: column "c.date_deadline" must appear in the GROUP BY clause or be used in an aggregate functionLINE 5:                     c.date_deadline,                            ^

Avatar
Discard
Best Answer

The problem is with the PostgreSQL. Please ensure that version PostgreSQL 9.2 or Later is installed.

Try the below on:

sudo apt-get install postgresql-9.6



Avatar
Discard