Bug#491845: openser-postgres-module: Postgres auth problem with openserdbctl

[Alexander Beisig]

Package: openser-postgres-module
Version: 1.3.2-2
Severity: minor

The openserdbctl utility asked me for the password for the superuser
"postgres", but on my system the user "postgres" doesn't have a
password set and uses ident authentication over the local unix socket
instead.  I think this is the Debian default, too.

To make the authentication work without setting a password for the
superuser, I disabled the "-h $DBHOST" option to psql for local
connections.  These connections will then use the unix socket and
ident authentication will work as intended.

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.25-2-vserver-686 (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages openser-postgres-module depends on:
ii  libc6                         2.7-10     GNU C Library: Shared libraries
ii  libpq5                        8.3.3-1    PostgreSQL C client library
ii  openser                       1.3.2-2    very fast and configurable SIP pro
ii  postgresql-client             8.3.3-1    front-end programs for PostgreSQL 
ii  postgresql-client-8.3 [postgr 8.3.3-1    front-end programs for PostgreSQL 

openser-postgres-module recommends no packages.

-- no debconf information
-------------- next part --------------
--- openserdbctl.pgsql.old	2008-07-22 11:54:02.000000000 +0200
+++ openserdbctl.pgsql	2008-07-22 11:54:17.000000000 +0200
@@ -43,15 +43,21 @@
 # full privileges Postgres user
 if [ -z "$DBROOTUSER" ]; then
 	DBROOTUSER="postgres"
-	if [ ! -r ~/.pgpass ]; then
-		merr "~./pgpass does not exist, please create this file and support proper credentials for user postgres."
-		merr "Note: you need at least postgresql>= 7.3"
-		exit 1
-	fi
+	
+#	if [ ! -r ~/.pgpass ]; then
+#		merr "~./pgpass does not exist, please create this file and support proper credentials for user postgres."
+#		merr "Note: you need at least postgresql>= 7.3"
+#		exit 1
+#	fi
 fi
 
-CMD="psql -q -h $DBHOST -U $DBROOTUSER "
-DUMP_CMD="pg_dump -h $DBHOST -U $DBROOTUSER -c"
+if [ $DBHOST != localhost ] ; then
+	CMD="psql -q -h $DBHOST -U $DBROOTUSER "
+	DUMP_CMD="pg_dump -h $DBHOST -U $DBROOTUSER -c"
+else
+	CMD="psql -q -U $DBROOTUSER "
+	DUMP_CMD="pg_dump -U $DBROOTUSER -c"
+fi
 #################################################################