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: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/phpsa/phpsa.php on line 16 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/phpsa/phpsa.php on line 16 Could not connect