MySQL user user@adomain.com not found: /dspam/

[c4rdinal]

Hi,

I'm doing Debian Etch + Postfix + DSPAM + WebUI + MySQL auth.
My problem is I can’t pass thru the authorization window.

Root user can’t pass it either. Logs show:
/var/log/apache2/error.log
.
[Wed Apr 16 09:52:33 2008] [error] [client 192.168.1.222] MySQL user user@adomain.com not found: /dspam/

I added the /etc/dspam/admins

user@domain.com

Add the md5 method to functions.inc.php :

function pacrypt ($pw, $pw_db="")
{
   global $CONF;
   $password = "";
   $salt = "";

   if ($CONF['encrypt'] == 'md5')
   {
      $password = md5($pw);
   }

Under config.inc.php change the method used :

$CONF['encrypt'] = 'md5';

My Apache configuration:

/etc/apache2/sites-available/default :

                AuthName "DSPAM Authentication"
                AuthType Basic
                Require valid-user
                AuthUserFile /dev/null

                AuthBasicAuthoritative Off
                AuthMySQLAuthoritative on
                AuthMySQLHost 127.0.0.1
                AuthMySQLUser root
                AuthMySQLPassword pass
                AuthMySQLDB postfix
                AuthMySQLUserTable mailbox
                AuthMySQLNameField username
                AuthMySQLPasswordField password
                AuthMySQLPwEncryption md5

I can successfully log into Mysql using the following accounts but failed during web authentication.

Any thoughts?

TIA

[falko]

What happens if you store the password manually in the DB using the MySQL MD5 function (e.g. with phpMyAdmin)? Does it work then?

[c4rdinal]

Originally Posted by falko

What happens if you store the password manually in the DB using the MySQL MD5 function (e.g. with phpMyAdmin)? Does it work then?

Thank you for your reply.

Yes, manually storing the password in MySQL MD5 function is working via phpMyAdmin.

I'm stuck.

[falko]

Then it seems as if WebUI isn't storing the passwords correctly...

[c4rdinal]

Any known fix? I'm stuck.

[falko]

Please compare your configuration again with the one from the tutorial. Maybe you've made a typo somewhere?

[c4rdinal]

Originally Posted by falko

Please compare your configuration again with the one from the tutorial. Maybe you've made a typo somewhere?

Hi falko,

Just got it finally!

Thank you so much