[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