Password array

[sasi]

HI Team,

      Please give me some idea to close this Issue,

    I have installed roundcube 0.3.1,now i want to enable the password plugin in the roundcube I have added password in array of main.php in configuration file so now the option have enabled.now i want the password plugin to join with mysql and to start the work i am attaching the file what i had done in the password plugin configuration file ,Please let me no what wrong is going on in the conf file and what is mistake i have done in the db_dsn and in the password query.


$rcmail_config['password_db_dsn'] ='mysql://forever:$informatics@localhost/roundcube';

// 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 your_domain_tld SET pw_passwd=%c, pw_clear_passwd=%p WHERE pw_name=%l LIMIT 1';

[rosali]

Could you please post the database table structure where you are trying to write into?

[sasi]

Could you please post the database table structure where you are trying to write into?

HI Rosali,
  Thanks for the quick responce  
This is my data
'mysql://forever:$informatics@localhost/roundcube';

forever = username for database
informatics = password of the database
roundcube   = database name
 Iam not aware of the password query i just copied one of the note from roundcube website
$rcmail_config['password_query'] = 'UPDATE your_domain_tld SET pw_passwd=%c, pw_clear_passwd=%p WHERE pw_name=%l LIMIT 1';

[rosali]

Please refer to your IMAP server manual. You have to know if and how your IMAP server saves the password in the IMAP server database. How could you expect to get it working by putting weird stuff into the query?

[sasi]

Please refer to your IMAP server manual. You have to know if and how your IMAP server saves the password in the IMAP server database. How could you expect to get it working by putting weird stuff into the query?

Hi Rosali,

   I can configure in outlook and they can change the password na

[rosali]

I don't understand exactly what you are talking about. May be your IMAP server supports POPASS protocol? You could check it by establishing a telnet connection on port 106 (if standard port is used).

In this case you have to use poppassd.php driver ($rcmail_config['password_driver'] = 'poppassd';).

Please check section 2.3 of the README file.

[sasi]

I don't understand exactly what you are talking about. May be your IMAP server supports POPASS protocol? You could check it by establishing a telnet connection on port 106 (if standard port is used).

In this case you have to use poppassd.php driver ($rcmail_config['password_driver'] = 'poppassd';).

Please check section 2.3 of the README file.

HI Rosali,
Please Guide

Iam new to linux and has well has to Roundcube so can you please tell me how to enable the password plugin for the users to change the password. In the plugins they are not having for the Password any procedure also please guide me how to finish up this.



Database =mysql
Mail services = Postfix with Dovecot
Rouncube = 0.3.1


Please

[rosali]

As stated before I'm not familiar with Postfix/Dovecot. Sorry.

[alec]

@sasi: How do you change passwords on your IMAP server (without Roundcube)? Do you have system or virtual users? Are you your IMAP server admin?