Bugzilla Bug 61200

After emerging dspam-3.1.1, running the ebuild config has the following error:

# ebuild /var/db/pkg/mail-filter/dspam-3.1.1/dspam-3.1.1.ebuild config
postgres
 * When prompted for a password, please enter your PgSQL postgres password
 *
 * Creating DSPAM PostgreSQL user "dspam"
 * Creating DSPAM PostgreSQL database "dspam"
 * Getting DSPAM PostgreSQL userid for "dspam"
 *   UserID: 100
 * Getting DSPAM PostgreSQL databaseid for "dspam"
 *   DBID: 1
 * Changing owner of DSPAM PostgreSQL database "dspam" to "dspam"
 * Creating DSPAM PostgreSQL tables
 * Grant privileges to DSPAM PostgreSQL objects to "dspam"
psql: FATAL:  user "root" does not exist

There is a missing '-U postgres' in the config calls to psql. Applying the following one-line diff will allow the config to complete without error. This should be applied to the original ebuild.

# diff -u /usr/portage/mail-filter/dspam/dspam-3.1.1.ebuild  /var/db/pkg/mail-filter/dspam-3.1.1/dspam-3.1.1.ebuild
--- /usr/portage/mail-filter/dspam/dspam-3.1.1.ebuild   2004-08-21 13:12:21.000000000 -0500
+++ /var/db/pkg/mail-filter/dspam-3.1.1/dspam-3.1.1.ebuild      2004-08-21 17:52:53.655031232 -0500
@@ -369,7 +369,7 @@
                PGUSER=${DSPAM_PgSQL_USER} PGPASSWORD=${DSPAM_PgSQL_PWD} /usr/bin/psql -d ${DSPAM_PgSQL_DB} -U ${DSPAM_PgSQL_USER} -f ${CONFIGDIR}/pgsql_virtual_users.sql 1>/dev/null 2>&1

                einfo "Grant privileges to DSPAM PostgreSQL objects to \"${DSPAM_PgSQL_USER}\""
-               for foo in $(/usr/bin/psql -t -d ${DSPAM_PgSQL_DB} -c "SELECT tablename FROM pg_tables WHERE tablename LIKE 'dspam\%';")
+               for foo in $(/usr/bin/psql -t -d ${DSPAM_PgSQL_DB} -U postgres -c "SELECT tablename FROM pg_tables WHERE tablename LIKE 'dspam\%';")
                do
                        /usr/bin/psql -d ${DSPAM_PgSQL_DB} -U postgres -c "GRANT ALL PRIVILEGES ON TABLE ${foo} TO ${DSPAM_PgSQL_USER};" 1>/dev/null 2>&1
                done


Reproducible: Always
Steps to Reproduce:
1.
2.
3.

Hi,
  Thanx for the fix.  Committing now.

Ciao
ST Lim