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 [email protected] not found: /dspam/ I added the /etc/dspam/admins [email protected] Add the md5 method to functions.inc.php : Code: function pacrypt ($pw, $pw_db="") { global $CONF; $password = ""; $salt = ""; if ($CONF['encrypt'] == 'md5') { $password = md5($pw); } Under config.inc.php change the method used : Code: $CONF['encrypt'] = 'md5'; My Apache configuration: /etc/apache2/sites-available/default : Code: 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
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.
Please compare your configuration again with the one from the tutorial. Maybe you've made a typo somewhere?