ISPConfig - NutsMail and change password

Discussion in 'Installation/Configuration' started by DKLeader, Jan 29, 2012.

  1. DKLeader

    DKLeader New Member

    Hi,

    Followed the guide here : http://www.howtoforge.com/how-to-co...heir-email-passwords-on-an-ispconfig-3-server , but when I try to change the password I get this :

    I have checked the config.php and it is the correct settings in the $csp_dsn line.

    Noticed that after I followed the guide I had to manually add
    Code:
    $plugins[] = 'change_sqlpass';
    to squirrelmail/config/config.php.

    Further I had to modify the file /usr/share/squirrelmail/functions/page_header.php as I got this error when I selected "Change Password" :
    Password is not changed.

    I am using multiserver setup using ISPConfig 3.0.4.2 and NutsMail 4.0 on a Debian Lenny system.

    Anyone got a solution to what I can do with the errors and if these are the reason why password is not changed?
     
  2. falko

    falko Super Moderator ISPConfig Developer

    What's in line 268 of /usr/share/squirrelmail/plugins/change_sqlpass/config.php?
     
  3. DKLeader

    DKLeader New Member

    The file I have is only 266 lines long.
    Below is my file - I have removed all lines with explanations just to reduce the amount of lines inserted here.
    Code:
    <?php
    
       // Global Variables, don't touch these unless you want to break the plugin
       //
       global $csp_dsn, $password_update_queries, $lookup_password_query,
              $force_change_password_check_query, $password_encryption,
              $csp_salt_query, $csp_salt_static, $csp_secure_port,
              $csp_non_standard_http_port, $csp_delimiter, $csp_debug,
              $min_password_length, $max_password_length, $include_digit_in_password,
              $include_uppercase_letter_in_password, $include_lowercase_letter_in_password,
              $include_nonalphanumeric_in_password;
    
       // csp_dsn
       //
       $csp_dsn = 'mysql://root:[email protected]/dbispconfig';
    
       // lookup_password_query
       //
       //$lookup_password_query = '';
       // TERRIBLE SECURITY: $lookup_password_query = 'SELECT count(*) FROM users WHERE username = "%1" AND plain_password = "%5"';
       $Lookup_Password_Query = 'SELECT count(*) FROM mail_user WHERE email = "%1" AND crypt_password = %4';
       //$Lookup_Password_Query = '';
    
       // password_update_queries
       //
       $password_update_queries = array(
                     'UPDATE mail_user SET password = %4 WHERE email = "%1"',
       //            'UPDATE users SET crypt_password = %4 WHERE username = "%1"',
       //            'UPDATE user_flags SET force_change_pwd = 0 WHERE username = "%1"',
       //            'UPDATE users SET crypt_password = %4, force_change_pwd = 0 WHERE username = "%1"',
                                       );
       // force_change_password_check_query
       //
       //$force_change_password_check_query = 'SELECT IF(force_change_pwd = "yes", 1, 0) FROM users WHERE username = "%1"';
       //$force_change_password_check_query = 'SELECT force_change_pwd FROM users WHERE username = "%1"';
       //$force_change_password_check_query = 'SELECT force_change_pwd FROM mail_user WHERE email = "%1"';
       $force_change_password_check_query = '';
    
       // password_encryption
       //
       $password_encryption = 'MD5CRYPT';
    
       // csp_salt_query
       // csp_salt_static
       //
       //$csp_salt_static = 'LEFT(crypt_password, 2)';
       //$csp_salt_static = '"a4"';  // use this format with MYSQLENCRYPT
       //$csp_salt_static = '$2$blowsomefish$';  // use this format with PHPCRYPT
       //$csp_salt_query = 'SELECT SUBSTRING_INDEX(crypt_password, '$', 1) FROM mail_user WHERE email = "%1"';
       //$csp_salt_query = 'SELECT SUBSTRING(crypt_password, (LENGTH(SUBSTRING_INDEX(crypt_password, '$', 2)) + 2)) FROM users WHERE username = "%1"';
       //$csp_salt_query = 'SELECT salt FROM users WHERE username = "%1"';
       $csp_salt_query = 'SELECT SUBSTRING(PASSWORD, 4, 8) FROM mail_user WHERE email = "%1"';
    
       // csp_secure_port
       //
       $csp_secure_port = 0;
       //$csp_secure_port = 443;
    
       // csp_non_standard_http_port
       //
       //$csp_non_standard_http_port = 8080;
       $csp_non_standard_http_port = 0;
    
       // min_password_length
       // max_password_length
       // include_digit_in_password
       // include_uppercase_letter_in_password
       // include_lowercase_letter_in_password
       // include_nonalphanumeric_in_password
       //
       $min_password_length = 6;
       $max_password_length = 0;
       $include_digit_in_password = 0;
       $include_uppercase_letter_in_password = 0;
       $include_lowercase_letter_in_password = 0;
       $include_nonalphanumeric_in_password = 0;
    
       // csp_delimiter
       //
       //$csp_delimiter = '|';
       $csp_delimiter = '@';
    
       // debug mode
       //
       $csp_debug = 0;
    ?>
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Can you check if the file ends with
    Code:
    ?>
    ? Maybe you have some blank lines at the end...
     
  5. DKLeader

    DKLeader New Member

    Thanks, had 2 lines at the end.

    But this just leaves a new issue.
    I entered "Old", "New" and "Verify" password and pressed "Submit". The page that shows is blank/white except for the menu to the left.
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Did you check your logs?

    Can you go to the login screen and log in?
     
  7. DKLeader

    DKLeader New Member

    I have no problem logging in. After I press submit I get this :http://superweb.dk/images/nutsmail.jpg
    I have to reload the page and can then use the new password.
    Shouldn't it reload to the login page by itself?
     
  8. falko

    falko Super Moderator ISPConfig Developer

    I'm not sure, but maybe this is a Nutsmail problem. SquirrelMail does reload the page by itself.
     

Share This Page