Your message dated Sat, 29 Mar 2008 19:47:03 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#472926: fixed in wwwconfig-common 0.1.0 has caused the Debian Bug report #472926, regarding psql 8.X breaks pgsql.get to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [EMAIL PROTECTED] immediately.) -- 472926: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=472926 Debian Bug Tracking System Contact [EMAIL PROTECTED] with problems
--- Begin Message ---Package: wwwconfig-common Version: 0.0.48 Severity: normal Tags: patch Hi, from postgres 8.X, the client (psql) use getpwuid_r to find the .dbpass-file, not the environment variable HOME as it used to in postgres 7.4. This breaks the part of pgsql.get in wwwconfig-common that creates a temporary HOME where a .dbpass is created (and removed). IMO it would be more elegant to use the PGPASSFILE environment variable than changing HOME anyway, so I have written and tested a patch that does this. - Werner diff -ruN wwwconfig-common-0.0.48.orig/pgsql.get wwwconfig-common-0.0.48/pgsql.get --- wwwconfig-common-0.0.48.orig/pgsql.get 2004-08-06 14:04:41.000000000 +0200 +++ wwwconfig-common-0.0.48/pgsql.get 2008-03-27 09:46:51.000000000 +0100 @@ -60,24 +60,23 @@ if [ -z "$hostopt" -a \( "$MYUID" = root -o "$UID" = "$user" \) ] && grep -q ^"$user": /etc/passwd ; then su -s /bin/sh $user -c "psql $hostopt $_psql_args" else - OLDHOME=$HOME - HOME=`mktemp -d` + PGPASSDIR=`mktemp -d` if [ $? -ne 0 ]; then exit 1 fi - export HOME + PGPASSFILE=$PGPASSDIR/.pgpass + export PGPASSFILE if [ ! -z "$pass" ] ; then OLDUMASK=`umask` umask 077 - echo "*:*:*:$user:$pass" > $HOME/.pgpass + echo "*:*:*:$user:$pass" > $PGPASSFILE umask $OLDUMASK fi eval psql -U "$user" $hostopt $_psql_args - rm -rf "$HOME" - HOME=$OLDHOME + rm -rf "$PGPASSDIR" fi }
--- End Message ---
--- Begin Message ---Source: wwwconfig-common Source-Version: 0.1.0 We believe that the bug you reported is fixed in the latest version of wwwconfig-common, which is due to be installed in the Debian FTP archive: wwwconfig-common_0.1.0.dsc to pool/main/w/wwwconfig-common/wwwconfig-common_0.1.0.dsc wwwconfig-common_0.1.0.tar.gz to pool/main/w/wwwconfig-common/wwwconfig-common_0.1.0.tar.gz wwwconfig-common_0.1.0_all.deb to pool/main/w/wwwconfig-common/wwwconfig-common_0.1.0_all.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Ola Lundqvist <[EMAIL PROTECTED]> (supplier of updated wwwconfig-common package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Sat, 29 Mar 2008 20:35:11 +0100 Source: wwwconfig-common Binary: wwwconfig-common Architecture: source all Version: 0.1.0 Distribution: unstable Urgency: low Maintainer: Ola Lundqvist <[EMAIL PROTECTED]> Changed-By: Ola Lundqvist <[EMAIL PROTECTED]> Description: wwwconfig-common - Debian web auto configuration Closes: 472926 Changes: wwwconfig-common (0.1.0) unstable; urgency=low . * Applied patch from Morten Werner Forsbring <[EMAIL PROTECTED]> to support postgres 8.X. Closes: #472926. This change is not backwards compatible with earlier versions which means that it should not be backported to etch. Files: 63899648cea3d765dafa0908a30fee79 515 web optional wwwconfig-common_0.1.0.dsc 394e7c62b15171a9dd1b25538c925b07 50914 web optional wwwconfig-common_0.1.0.tar.gz a76c8b177df9bf0f0813fdb6f1c6849d 21596 web optional wwwconfig-common_0.1.0_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH7puZGKGxzw/lPdkRAnM6AJ4i73b1NwwIF7BpzzHoG2HX42ahdwCcDqsY FkYvecjdoMeFY2E7zg/1GmY= =0bI7 -----END PGP SIGNATURE-----
--- End Message ---
