[Pkg-dspam-misc] Bug#388140: libdspam7-drv-mysql: cleanup cron job doesn't work if database server is remote

[root]

Package: libdspam7-drv-mysql
Version: 3.6.8-2
Severity: important

Simply:

/etc/cron.daily/libdspam7-drv-mysql:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

mysqld is on a remote host.

Here is a naive patch that works:

--- libdspam7-drv-mysql.orig	2006-09-18 15:57:54.351747240 -0400
+++ libdspam7-drv-mysql	2006-09-18 15:54:05.493538976 -0400
@@ -11,7 +11,12 @@
     MYSQL_USER="`grep "^MySQLUser" $MYSQLCONF | awk '{print $2}'`"
     MYSQL_PASS="`grep "^MySQLPass" $MYSQLCONF | awk '{print $2}'`"
     MYSQL_DB="`grep "^MySQLDb" $MYSQLCONF | awk '{print $2}'`"
-    /usr/bin/mysql --user=$MYSQL_USER --password=$MYSQL_PASS $MYSQL_DB < $PURGE
+    MYSQL_HOST="`grep "^MySQLServer" $MYSQLCONF | awk '{print $2}'`"
+    if [ -z "$MYSQL_HOST" ] ; then
+    	/usr/bin/mysql --user=$MYSQL_USER --password=$MYSQL_PASS $MYSQL_DB < $PURGE
+    else
+    	/usr/bin/mysql --host $MYSQL_HOST --user=$MYSQL_USER --password=$MYSQL_PASS $MYSQL_DB < $PURGE
+    fi
   fi
 fi
 



-- System Information:
Debian Release: 3.1
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.8-romulus-em64t-p4-smp+vserver
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages libdspam7-drv-mysql depends on:
ii  dbconfig-common       1.8.21~bpo.1       common framework for packaging dat
ii  debconf [debconf-2.0] 1.4.30.13          Debian configuration management sy
ii  libc6                 2.3.2.ds1-22sarge4 GNU C Library: Shared libraries an
ii  libdspam7             3.6.8-2            DSPAM is a scalable and statistica
ii  libldap2              2.1.30-8           OpenLDAP libraries
ii  libmysqlclient14      4.1.11a-4sarge7    mysql database client library
ii  mysql-client          4.0.24-10sarge2    mysql database client binaries
ii  ucf                   1.17               Update Configuration File: preserv
ii  zlib1g                1:1.2.2-4.sarge.2  compression library - runtime

-- debconf information:
  libdspam7-drv-mysql/password-confirm: (password omitted)
  libdspam7-drv-mysql/mysql/app-pass: (password omitted)
  libdspam7-drv-mysql/app-password-confirm: (password omitted)
  libdspam7-drv-mysql/mysql/admin-pass: (password omitted)
  libdspam7-drv-mysql/passwords-do-not-match:
  libdspam7-drv-mysql/internal/reconfiguring: false
  libdspam7-drv-mysql/remote/host:
  libdspam7-drv-mysql/db/app-user:
  libdspam7-drv-mysql/remove-error: abort
  libdspam7-drv-mysql/db/dbname:
  libdspam7-drv-mysql/mysql/method: unix socket
  libdspam7-drv-mysql/database-type: mysql
  libdspam7-drv-mysql/dbconfig-remove:
  libdspam7-drv-mysql/remote/newhost:
  libdspam7-drv-mysql/upgrade-backup: true
  libdspam7-drv-mysql/mysql/admin-user:
  libdspam7-drv-mysql/install-error: abort
  libdspam7-drv-mysql/remote/port:
  libdspam7-drv-mysql/dbconfig-upgrade: true
  libdspam7-drv-mysql/purge: false
  libdspam7-drv-mysql/upgrade-error: abort
  libdspam7-drv-mysql/dbconfig-reinstall: false
* libdspam7-drv-mysql/dbconfig-install: false