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

[Daniel Kahn Gillmor]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On September 24, jesus.climent at hispalinux.es said:

> On Mon, Sep 18, 2006 at 03:58:35PM -0400, root wrote:
> > Package: libdspam7-drv-mysql
> > 
> > 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
> 
> +1 for this patch.. Anyone against?

Looks good to me.

	--dkg
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.8+ <http://mailcrypt.sourceforge.net/>

iD8DBQFFGEPSiXTlFKVLY2URAt84AJ9bQYA/CJ1grHvvy2b0AC69qnaN/QCfcWcB
53gzVYFJDIKXfv/UY/5xiQs=
=W1Lt
-----END PGP SIGNATURE-----