Hi.
When creating user specify the host (-h) option. Then try to login (psql) using
the user just created (with -h option as well).
Postgres assumes intend authentication if the hostname is not specified.
Cheers.
Mugoma,
Yengas.
Mehul Ved wrote:
> 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
_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users
