MySQL user [email protected] not found: /dspam/

Discussion in 'Installation/Configuration' started by c4rdinal, Apr 16, 2008.

  1. c4rdinal

    c4rdinal New Member


    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:
    [Wed Apr 16 09:52:33 2008] [error] [client] MySQL user [email protected] not found: /dspam/

    I added the /etc/dspam/admins

    [email protected]

    Add the md5 method to :

    function pacrypt ($pw, $pw_db="")
       global $CONF;
       $password = "";
       $salt = "";
       if ($CONF['encrypt'] == 'md5')
          $password = md5($pw);

    Under 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
                    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?

  2. falko

    falko Super Moderator ISPConfig Developer

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

    c4rdinal New Member

    Thank you for your reply.

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

    I'm stuck.
  4. falko

    falko Super Moderator ISPConfig Developer

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

    c4rdinal New Member

    Any known fix? I'm stuck.
  6. falko

    falko Super Moderator ISPConfig Developer

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

    c4rdinal New Member

    Hi falko,

    Just got it finally!

    Thank you so much
    Last edited: Apr 23, 2008

Share This Page