Re: [SM-USERS] passwd changing

Rajiv Sharma Sat, 29 May 2004 11:37:58 -0700

Hello,

Here i ve pasted my config.php file of change_mysql plugin.

               $mysql_password_change_field, $mysql_password_change_field_delimiter,
               $mysql_password_change_yes_value, $mysql_password_change_no_value,
               $split_username_query, $split_username_expression,
               $split_username_domain_field, $debug, $update_clear_passwd_field;

// The MySQL Server that SASL uses
$mysql_server = 'localhost';

        // Database and table that SASL uses for auth
        $mysql_database = 'vpopmail';
        $mysql_table = 'infobrain_tech';

        // The names of the user ID and password columns
        $mysql_userid_field = 'pw_name';
        $mysql_password_field ='pw_passwd';

        // The user to log into MySQL with (must have rights)
        $mysql_manager_id = 'vpopmail';
        $mysql_manager_pw = '*****';

        //---------------------------------------------------------
        // Password encryption (or lack thereof)
        //---------------------------------------------------------

// Set only one of the options below to 1.

        // Set to 1 if the password column is encrypted
        // using the MySQL password() function.
        $mysql_saslcrypt = 0;

        // Set to 1 if the password column is encrypted
        // using the UNIX crypt() function.
        //$mysql_unixcrypt = 0;

// Set to 1 if the password column is to use MD5 encryption
//$mysql_MD5crypt = 0;

// Set both to 0 if the password is stored in the
// column in plaintext.

        //---------------------------------------------------------
        // SSL encryption during password change
        //---------------------------------------------------------
        // Set to 1 to enforce SSL connections when
        // changing passwords. NOTE - This should be
        // turned OFF if you serve your entire webmail
        // in https!
        $use_ssl_for_password_change = 1;

        //---------------------------------------------------------
        // Force password change mode
        //---------------------------------------------------------
        // Enable functionality to force users to change
        // their passwords
         //$mysql_password_force = 1;

// Force password change field
//$mysql_password_change_field = 'pw_passwd';

        // Set this as a double quote if the above-defined
        // field is a character data field, otherwise,
        // set it to an empty string
        //$mysql_password_change_field_delimiter = '"';
        //$mysql_password_change_field_delimiter = '';

        // Force password YES and NO values
        // the value the above-defined field will be set to
        // to indicate that the user must change passwords
        // upon next login (and not)
        //
       // $mysql_password_change_yes_value = 'Y';
       // $mysql_password_change_no_value = 'N';
        //$mysql_password_change_yes_value = 1;
        //$mysql_password_change_no_value = 0;

        //---------------------------------------------------------
        // Multiple database field setup
        //---------------------------------------------------------
        // The following settings ONLY apply if your IMAP
        // login is comprised of a join between two separate
        // database columns
        //
        // Set this to 1 to turn such functionality on
        //
       // $split_username_query = 0;

        // This is typically the @ sign, although it can be any
        // regular _expression_ which should be used to split the
        // full user name into two separate pieces (for example,
        // using @, "[EMAIL PROTECTED]" becomes "jose" and
        // "myowndomain.com")
        //
       // $split_username_expression = '@';

        // This is the name of the second database column to query
        //
        //$split_username_domain_field = 'domain';

        //---------------------------------------------------------
        // Multiple password fields
        //---------------------------------------------------------
        // The following settings ONLY apply if you keep
        // a cleartext copy of users' passwords along with
        // an encrypted one (CAREFUL!). Set this variable
        // to the name of the cleartext password field
        // and it will be updated IN ADDITION to the encrypted
        // field indicated above. Others should leave this
        // setting as an empty string.
        //
        $update_clear_passwd_field = 'pw_clear_passwd';

        //---------------------------------------------------------
        // Debug mode
        //---------------------------------------------------------
        // Debug
        $debug = 0;

i m using squirrelmail latest version 1.4.x with compatibiltiy plugin 1.3

which i ve added to plugin list.

after doing all this when i want to change passwd from change passwd option.

i m getting error message

SQL call failed, try again later.

this is all i ve done to accomplish this.

can u let me know how to get output from debugger plugin.

so i can provide u clear picture.

regards

Rajeev

---------------------------------------------------------------

Rajeev Sharma