[Pkg-dspam-misc] Bug#498888: Missing database name in /etc/cron.daily/libdspam7-drv-mysql

[Julien Valroff]

Package: libdspam7-drv-mysql
Version: 3.6.8-8.1
Severity: normal
Tags: patch

Hi,

Database name is missing in /etc/cron.daily/libdspam7-drv-mysql, which fails with
the following error:
ERROR 1046 (3D000) at line 5: No database selected

The following patch solves the issue:

diff -urN libdspam7-drv-mysql.orig  libdspam7-drv-mysql
--- libdspam7-drv-mysql.orig	2008-09-14 08:48:52.000000000 +0200
+++ libdspam7-drv-mysql	2008-09-14 08:45:21.000000000 +0200
@@ -26,7 +26,7 @@
         /usr/bin/mysql --defaults-file=$MYSQLCONF_PASSWD \
 	               --user=$MYSQL_USER $MYSQL_DB < $PURGE
     else
-        /usr/bin/mysql --defaults-file=$MYSQLCONF_PASSWD --host=$MYSQL_HOST --user=$MYSQL_USER < $PURGE
+        /usr/bin/mysql --defaults-file=$MYSQLCONF_PASSWD --host=$MYSQL_HOST --user=$MYSQL_USER $MYSQL_DB < $PURGE
     fi
 
     rm "$MYSQLCONF_PASSWD"

Cheers,
Julien

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (100, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash