Hello,
Following the steps in the earlier mail, I have downloaded OpenERP
v5.0.0 from launchpad using bazaar and symlinked the addons in the
server/bin/addons directory. Launching OpenERP server goes smooth from
the command line.
Now, I copied the server, client and addons directory to
/usr/lib/python2.5/site-packages/ as openerp-server, openerp-client and
openerp-addons; and then symlinked the files in openerp-addons to
openerp-server/bin/addons.
After doing this, I used the files from TinyERP v4.2.3 installed
from Fedora 10 repositories, the files being /etc/init.d/tinyerp-server,
/usr/bin/tinyerp-server and /etc/tinyerp-server.conf and created files
/etc/init.d/openerp-server, /usr/bin/openerp-server and
/etc/openerp-server.conf , where I have substituted all instances of
tinyerp with openerp except for the tinyerp user.
I am pasting my errors and configuration and init files below
/etc/init.d/openerp-server
-----xxxxx------
#!/bin/bash
# openerp-server This shell script takes care of starting and
stopping
# TinyERP server
#
# chkconfig: - 95 05
# description: TinyERP Server
#
# pidfile: /var/run/openerp-server.pid
# config: /etc/openerp-server.conf
### BEGIN INIT INFO
# Provides: openerp-server
# Required-Start: $local_fs $network
# Required-Stop: $local_fs $network
# Default-Start:
# Default-Stop: 0 1 2 3 4 5 6
# Short-Description: start and stop openerp-server
# Description: TinyERP Server
### END INIT INFO
PATH=/usr/bin:/sbin:/bin:/usr/sbin
export PATH
# Source function library.
. /etc/rc.d/init.d/functions
PIDFILE=/var/spool/openerp/openerp-server.pid
LOCKFILE=/var/lock/subsys/openerp-server
LOGFILE=/var/log/openerp/openerp-server.log
OPTS="--pidfile=$PIDFILE --logfile=$LOGFILE"
prog="openerp-server"
# 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 "/usr/bin/openerp-server" ] && exit 0
RETVAL=0
start() {
echo -n $"Starting $prog: "
daemon --user tinyerp --check openerp-server "/usr/bin/setsid
/usr/bin/openerp-server $OPTS &"
RETVAL=$?
[ $RETVAL -eq 0 ] && touch $LOCKFILE
echo
return $RETVAL
}
stop() {
echo -n $"Stopping $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
return $RETVAL
}
restart() {
stop
start
}
condrestart() {
[ -e $LOCKFILE ] && restart || :
}
rhstatus() {
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)
restart
;;
echo $"$prog is stopped"
fi
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart)
restart
;;
condrestart)
condrestart
;;
status)
rhstatus
;;
probe)
exit 0
;;
*)
echo $"Usage: $0 {start|stop|status|restart|condrestart}"
exit 1
esac
exit $?
-----xxxxx-----
/etc/openerp-server.conf
-----xxxxx-----
[options]
without_demo = False
upgrade = False
verbose = False
xmlrpc = True
db_user = oerp
db_password = abcdef
root_path = None
soap = False
translate_modules = ['all']
db_name = template1
netrpc = True
demo = {}
interface =
db_host = False
db_port = False
port = 8069
addons_path = None
reportgz = False
-----xxxxx-----
Error while running init script
-----xxxxx------
[2009-02-10 09:48:57,862] ERROR:dbpool:Unable to connect to template1:
FATAL: Ident authentication failed for user "oerp"
Traceback (most recent call last):
File "./openerp-server.py", line 108, in <module>
pooler.get_db_and_pool(db, update_module=tools.config['init'] or
tools.config['update'])
File "/usr/lib/python2.5/site-packages/openerp-server/bin/pooler.py",
line 29, in get_db_and_pool
db = get_db_only(db_name)
File "/usr/lib/python2.5/site-packages/openerp-server/bin/pooler.py",
line 71, in get_db_only
db = sql_db.db_connect(db_name)
File "/usr/lib/python2.5/site-packages/openerp-server/bin/sql_db.py",
line 239, in db_connect
return PoolManager.get(db_name)
File "/usr/lib/python2.5/site-packages/openerp-server/bin/sql_db.py",
line 223, in get
cls._pools[db_name] = ConnectionPool(ThreadedConnectionPool(1,
cls.maxconn, cls.dsn(db_name)), db_name)
File "/usr/lib/python2.5/site-packages/psycopg2/pool.py", line 161, in
__init__
self, minconn, maxconn, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/psycopg2/pool.py", line 76, in
__init__
self._connect()
File "/usr/lib/python2.5/site-packages/psycopg2/pool.py", line 80, in
_connect
conn = psycopg2.connect(*self._args, **self._kwargs)
psycopg2.OperationalError: FATAL: Ident authentication failed for user
"oerp"
-----xxxxx-----
PS:- I have created postgresql user oerp using the following command
createuser --createdb --no-createrole --pwprompt oerp
Same error occurs with postgresql user tinyerp, which works for v4.2.3
I believe it's a postgresql problem rather than openerp problem. Still
it would be good to get input from knowledgeable people on the list, as
I have not been able to find the solution to this problem.
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users
