Squirrelmail + Change_SQLPass Error: Warning: Cannot modify header information

Discussion in 'HOWTO-Related Questions' started by bluegrass, Apr 26, 2010.

  1. bluegrass

    bluegrass New Member

    Hi,

    I have been looking for the answer on how to address this error. But unfortunately couldn't find any.

    I have a Debian Lenny, and installed using the "Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Debian Lenny), by Falko"

    It was a successful installation and configuration. But at the change_sqlpass plugin, wherein it is not included on the said tutorial, about activating the force_change_password_check_query, I activated this, and changing necessary entries:

    Code:
    ..
    $password_update_queries = array('UPDATE users SET password = %4, force_change_pwd = 0 WHERE email = "%1",)
    ..
    $force_change_password_check_query = 'SELECT force_change_pwd FROM users WHERE email = "%1";
    //$force_change_password_check_query = "";
    
    I added the "force_change_pwd" field on the users table.

    I activated this because I wanted my users to change their passwords upon login in special times.

    Necessary changes are successful, but I get this error afterwhich:

    Code:
    Warning: Cannot modify header information - headers already sent by (output started at /usr/share/squirrelmail/functions/page_header.php:32) in /usr/share/squirrelmail/functions/global.php on line 530
    
    Warning: Cannot modify header information - headers already sent by (output started at /usr/share/squirrelmail/functions/page_header.php:32) in /usr/share/squirrelmail/plugins/change_sqlpass/functions.php on line 943
    
    Does anyone had a solution for this?
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Can you post the full config.php of the change_sqlpass plugin? Maybe you introduced a PHP syntax error.
     
  3. bluegrass

    bluegrass New Member

    Hi, Falco. Below is the config.php of the change_sqlpass plugin, I have removed the remarks lines.


    Code:
    <?php
    
       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 = 'mysql://mail_admin:scientia@localhost/mail';
    
    
    
       $lookup_password_query = 'SELECT count(*) FROM users WHERE email = "%1" AND password = %4';
    
    
    
       $password_update_queries = array(
                'UPDATE users SET password = %4, txt_password = "%5", force_change_pwd = 0  WHERE email = "%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 = 'SELECT force_change_pwd FROM users WHERE email = "%1"';
       //$force_change_password_check_query = '';
    
    
    
       $password_encryption = 'MYSQLENCRYPT';
    
    
    
       $csp_salt_static = 'LEFT(password, 2)';
       $csp_secure_port = 0;
       //$csp_secure_port = 443;
    
    
    
       $csp_non_standard_http_port = 0;
    
    
    
       $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_debug = 0;
    
    
    
    ?>
    
     
  4. falko

    falko Super Moderator Howtoforge Staff

    As fas as I can see, there's no PHP syntax error. I guess the problem has something to do with $force_change_password_check_query, but I'm not sure... :confused:
     

Share This Page