[Pkg-dspam-misc] Bug#388140: libdspam7-drv-mysql: cleanup cron job
doesn't work if database server is remote
root
root at scanner.koumbit.net
Mon Sep 18 19:58:35 UTC 2006
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
More information about the Pkg-dspam-misc
mailing list