SpamAssassin PHP-MySQL User Interface Problems
I recently installed the SpamAssassin php-sa-mysql module to allow clients
access to their userprefs options. It authenticates against shadow passwords
using "validate" from libapache-mod-auth-shadow. The login script validates
the username and password then redirects the browser to the phpsa.php page.
I added the user name "spamby" to MySQL via webmin and set this in
config.inc.php as per the readme file. I confirmed the configured host, user
and password by inserting an echo statement in the phpsa file. The problem
is that I get the below error messages and can't figure out why it is trying
to connect as root.
Warning: Access denied for user: 'root@localhost' (Using password: NO) in
/var/www/phpsa/phpsa.php on line 16
Warning: MySQL Connection Failed: Access denied for user: 'root@localhost'
(Using password: NO) in /var/www/phpsa/phpsa.php on line 16
Could not connect