[Pkg-dspam-misc] Workaround for: ERROR 1045 (28000): Access denied for user 'libdspam7-drv-my'@'localhost' (using password: YES)

Brecht Sanders brecht at sanders.org
Thu Mar 6 08:29:30 UTC 2008


Hi,
I maintain several systems running DSPAM on Debian Etch.
Since a recent apt-get upgrade however the cron deamon sends me errors 
like this:
    /etc/cron.daily/libdspam7-drv-mysql:
    ERROR 1045 (28000): Access denied for user 
'libdspam7-drv-my'@'localhost' (using password: YES)
Though I don't really understand why this happens I have been able to 
make some minor changes to /etc/cron.daily/libdspam7-drv-mysql which do 
allow it to work correctly.
I replace:
    echo -e "[client]\npassword=$MYSQL_PASS" > "$MYSQLCONF_PASSWD"
with:
    echo -e "[client]\nuser=MYSQL_USER\npassword=$MYSQL_PASS" > 
"$MYSQLCONF_PASSWD"
and then remove
    --user=$MYSQL_USER
wherever it occurs.
This fixed it for me.
The functionality remains the same, but it beats me why this works and 
the original version doesn't.
Maybe it's a MySQL issue?
Regards
    Brecht Sanders




More information about the Pkg-dspam-misc mailing list