OpenERP v6.1 - Installation sur BlueOnyx - Centos 6.3
De wikiGite
Sommaire
Dépendances
Ajouter le depot epel :
yum install -y http://mirrors.ircam.fr/pub/fedora/epel/6/x86_64/epel-release-6-7.noarch.rpm sed -i 's/enabled = 1/enabled = 0/' /etc/yum.repos.d/rpmforge.repo
Installation :
yum install -y --enablerepo=epel python-devel pychart python-dateutil python-reportlab python-lxml python-psycopg2 python-mako python-setuptools pytz PyYAML \ graphviz pydot python-imaging pywebdav python-vobject vim system-config-firewall-tui wget python-babel python-gdata python-ldap python-openid python-werkzeug \ python-vatnumber python-simplejson
Postgresql 8.4
Installation
yum install postgresql-server
Initialiser postgresql :
service postgresql initdb
Démarer postgresql :
service postgresql start
Lancer postgresql au demarage
chkconfig postgresql on
Ajouter le superuser de postgresql et de openerp
useradd openerp passwd openerp
Ajouter cet utilisateur dans postgresql :
su -c 'createuser --superuser --no-createrole --createdb --pwprompt openerp' postgres
Postgresql 9.2 (conseillé: meilleures performances)
Ajout du Dépot :
yum install http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-centos92-9.2-5.noarch.rpm
Installation :
yum update -y yum install postgresql92-server
Initialiser postgresql :
service postgresql-9.2 initdb
Démarer postgresql :
service postgresql-9.2 start
Lancer postgresql au demarage
chkconfig postgresql-9.2 on
Ajouter le superuser de postgresql et de openerp
useradd openerp passwd openerp
Ajouter cet utilisateur dans postgresql :
su -c 'createuser --superuser --no-createrole --createdb --pwprompt openerp' postgres
Installer openerp
Télécharger les sources :
wget http://nightly.openerp.com/6.1/releases/openerp-6.1-latest.tar.gz tar xzvf openerp-6.1-latest.tar.gz cd openerp-6.1-$VERSION python setup.py install
Copier le script d'init dans /etc/init.d/ :
#!/bin/bash
# openerp-server This shell script takes care of starting and stopping
# OpenERP server
#
# chkconfig: 345 95 05
# description: OpenERP server
#
# pidfile: /var/run/openerp-server.pid
# config: /etc/openerp-server.conf
### BEGIN INIT INFO
# Provides: openerp-server
# Required-Start: postgresql-9.2
# Required-Stop: postgresql-9.2
# Should-Start: $network harddrake
# Default-Start: 345
# Short-Description: Launches the OpenERP server.
# Description: This startup script launches the OpenERP server.
### END INIT INFO
# Source function library.
. /etc/rc.d/init.d/functions
PIDFILE=/var/run/openerp/openerp-server.pid
LOCKFILE=/var/lock/subsys/openerp-server
LOGFILE=/var/log/openerp/openerp-server.log
DAEMON=/usr/bin/openerp-server
OPTS="--pidfile=$PIDFILE --logfile=$LOGFILE"
prog="openerp-server"
desc="OpenERP Server Daemon"
# check if the openerp-server conf file is present, then use it
if [ -f /etc/openerp-server.conf ]; then
OPTS="$OPTS -c /etc/openerp-server.conf"
fi
# check the existence of the openerp-server script
[ -z $DAEMON ] && exit 0
RETVAL=0
start() {
if [ -d /etc/openerp/start.d ] ; then
echo -n $"Preparing $desc: "
run-parts --exit-on-error /etc/openerp/start.d
RETVAL=$?
echo
[ $RETVAL -ne 0 ] && return $RETVAL
fi
echo -n $"Starting $desc ($prog): "
daemon --user openerp --check openerp-server \
"/usr/bin/setsid $DAEMON \
-c /etc/openerp-server.conf \
--pidfile=$PIDFILE \
--logfile=$LOGFILE &" 2>&1
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && touch $LOCKFILE
return $RETVAL
}
stop() {
echo -n $"Stopping $desc ($prog): "
kill -TERM `cat $PIDFILE` > /dev/null 2>&1
RETVAL=$?
if [ $RETVAL -eq 0 ] ; then
rm -f $LOCKFILE
echo_success
echo
else
echo_failure
echo
fi
if [ -d /etc/openerp/stop.d ] ; then
echo -n $"Clearing $desc: "
run-parts /etc/openerp/stop.d
echo
fi
return $RETVAL
}
restart() {
stop
start
}
condrestart() {
[ -e $LOCKFILE ] && restart || :
}
status() {
if [ -f $PIDFILE ] ; then
checkpid `cat $PIDFILE`
RETVAL=$?
if [ $RETVAL -eq 0 ] ; then
echo $"$prog is running..."
else
echo $"$prog is stopped"
fi
else
echo $"$prog is stopped"
fi
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart|reload)
restart
;;
condrestart)
condrestart
;;
status)
status
;;
probe)
exit 0
;;
*)
echo $"Usage: $0 {start|stop|status|restart|condrestart|reload}"
exit 1
esac
chmod +x /etc/init.d/openerp-server chkconfig /etc/init.d/openerp-server chkconfig openerp-server on
Donner les droit d'ecriture sur le fichier de log et de pid à l'utilisateur openerp
mkdir /var/log/openerp chown openerp:root /var/log/openerp mkdir /var/run/openerp chown openerp:root /var/run/openerp
Créer le fichier de configuration:
(Modifier en fonction des besoins. Faire attention à l'option addons_path qui varie entre les numeros de version)
vim /etc/openerp-server.conf
[options]
login_message = False
list_db = True
without_demo = False
admin_passwd = admin
pidfile = None
addons_path = /usr/lib/python2.6/site-packages/openerp-6.1_20120925_233125-py2.6.egg/openerp/addons
proxy_mode = True
timezone = False
logfile = None
syslog = False
logrotate = True
log_handler = [':INFO']
log_level = info
debug_mode = False
smtp_port = 25
smtp_password = False
smtp_server = localhost
smtp_ssl = False
smtp_user = False
email_from = False
db_template = template0
db_password = False
db_user = openerp
dbfilter = .*
db_host = False
db_maxconn = 64
db_port = False
db_name = False
pg_path = None
xmlrpcs = True
xmlrpcs_port = 8071
xmlrpcs_interface =
xmlrpc = True
xmlrpc_port = 8069
xmlrpc_interface = 127.0.0.1
netrpc = True
netrpc_port = 8070
netrpc_interface = 127.0.0.1
cpu_time_limit = 60
virtual_memory_reset = 671088640
virtual_memory_limit = 805306368
cache_timeout = 100000
osv_memory_count_limit = False
osv_memory_age_limit = 1.0
max_cron_threads = 4
static_http_enable = False
static_http_document_root = None
secure_cert_file = server.cert
static_http_url_prefix = None
test_file = False
test_disable = False
test_commit = False
test_report_directory = False
reportgz = False
secure_pkey_file = server.pkey
assert_exit_level = error
unaccent = False
demo = {}
import_partial =
csv_internal_sep = ,
translate_modules = ['all']
server_wide_modules = None
chown openerp:root /etc/openerp-server.conf service openerp-server start
Apache
Installation
yum install httpd mod_ssl openssl cd /tmp
Générer clés/certificat
Générer une nouvelle clé avec mot de passe :
openssl genrsa -des3 -out server.pkey 1024
Pour ne pas avoir a taper un mot de passe a cahque redemarage du serveur faire ceci :
penssl rsa -in server.pkey -out server.key
Générer un certificat avec cette clé :
openssl req -new -key server.key -out server.csr
Puis signer votre propre certificat :
openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt
Donner les droits au fichiers :
chown openerp:root server.crt server.key chmod 640 server.crt server.key
Puis copier les au bon endroit
mkdir /etc/ssl/openerp chown openerp:root /etc/ssl/openerp chmod 710 /etc/ssl/openerp mv server.crt server.key /etc/ssl/openerp/
Configuration
Créer le fichier de configurtation
vim /etc/httpd/conf.d/openerp.conf
ServerName openerp.kogite.local
<Proxy *>
Order deny,allow
Allow from all
</Proxy>
SSLProxyEngine on
SSLEngine on
SSLCertificateFile /etc/ssl/openerp/server.crt
SSLCertificateKeyFile /etc/ssl/openerp/server.key
SSLCACertificateFile /etc/ssl/openerp/server.crt
RequestHeader set "X-Forwarded-Proto" "https"
ProxyRequests Off
ProxyPass / http://127.0.0.1:8069/
ProxyPassReverse / http://127.0.0.1:8069/
ProxyErrorOverride off
TransferLog /var/log/httpd/transfer.web.openerp.log
SetEnv proxy-nokeepalive 1
Lancer Apache :
service httpd start chkconfig httpd on
TIPS
générer le fichier de configuration
su -c 'openerp-server -s -c /home/openerp/openerp-server.conf' openerp
Problèmes
==== DataError: encoding "UTF8" does not match locale "en_US" DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". ====
Si au moment de la création de la BDD sur l'interface web ce message d'erreur apparait : - Arrêter postgresql et openerp
service openerp-server stop service postgresql-9.2 stop
- Supprimer les bases
rm -Rf /var/lib/pgsql/9.2/data/*
- Reinitialiser la BDD :
su - postgres cd /usr/pgsql-9.2/bin/ ./initdb --locale=fr_FR.UTF-8 -D /var/lib/pgsql/9.2/data/ exit
- Relancer la base de donnée service postgresql-9.2 start
- Recréer l'utilisateur openerp dans postgres :
su -c 'createuser --superuser --no-createrole --createdb --pwprompt openerp' postgres
- Relancer openerp :
service openerp-server start
Sources
http://www.easyopenerp.com/installation-open-erp-server-et-web-6-1/
http://www.banym.de/linux/centos/install-openerp-on-centos-6-0-with-nginx-http-proxy
http://powerphil.wordpress.com/2011/01/28/how-to-install-and-configure-an-openerp-6-0-1-server-and-web-server-on-an-ubuntu-10-10-server/
http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,40/func,view/id,43407/