ISPConfig - NutsMail and change password

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?

 

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

 

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

 

Can you check if the file ends with

Code:

?>

? Maybe you have some blank lines at the end...

 

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.

 

Did you check your logs?

Can you go to the login screen and log in?

 

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?

 

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