Author Topic: Unable to change the password  (Read 2784 times)

Offline sasi

  • Jr. Member
  • **
  • Posts: 17
Unable to change the password
« on: July 20, 2010, 05:59:26 AM »
HI Team,

        My users are not able to change there own password.The error what iam getting is iam not able to change the new password.I had made two changes one i enabled the password option in main.inc.php and another one in plugin i have pasted the content what i changed in Plugin.

My Domain name is : rix.informatics.com Please help me to finish  up this issue.

// SQL Driver options
// ------------------
// PEAR database DSN for performing the query. By default
// Roundcube DB settings are used.
$rcmail_config['password_db_dsn'] = 'mysql://roundcubemail:forever@rix.informatics.com/hmail';

// The SQL query used to change the password.
// The query can contain the following macros that will be expanded as follows:
//      %p is replaced with the plaintext new password
//      %c is replaced with the crypt version of the new password, MD5 if available
//         otherwise DES.
//      %o is replaced with the password before the change
//      %n is replaced with the hashed version of the new password
//      %q is replaced with the hashed password before the change
//      %h is replaced with the imap host (from the session info)
//      %u is replaced with the username (from the session info)
//      %l is replaced with the local part of the username
//         (in case the username is an email address)
//      %d is replaced with the domain part of the username
//         (in case the username is an email address)
// Escaping of macros is handled by this module.
// Default: "SELECT update_passwd(%c, %u)"
$rcmail_config['password_query'] = 'update hm_accounts set accountpassword = md5(%p) where accountaddress = %u limit 1';

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Unable to change the password
« Reply #1 on: July 20, 2010, 07:08:01 AM »
You could try the following:

#1-
$rcmail_config['password_query'] = 'update hm_accounts set accountpassword=md5(%p), accountpwencryption=2 where accountaddress=%u limit 1';

[NOTICE: hmail default password encryption is not md5 anymore! May be you have to qouto %p and %u ('%p').]

#2-
Alternatively download password plugin from current SVN trunk (Roundcube Webmail). There is hmail driver available now.
« Last Edit: July 20, 2010, 07:13:10 AM by rosali »
Regards,
Rosali
__________________
MyRoundcube Project (commercial)