On Wed, 2002-08-28 at 16:51, Gene Grimm wrote: > 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 >
It looks like the root account does not have permission to access the database in mysql, so I'd suggest you verify that. More info on that can be found here: http://www.mysql.com/doc/en/Adding_users.html. Teun