Change E-Mail Password

[ManuKaracho]

Hello, Did it work for anyone? I tried the settings as described, including this one "$config['password_query'] = 'UPDATE mailbox SET password=%c,modified=NOW() WHERE username=%u LIMIT 1';"
But I still get the error cannot save new password. I also tried with the default value for this config. $rcmail_config['password_query'] = 'SELECT update_passwd(%c, %u)';
Still did not work for me.
Is there anything that I am missing, do you think? Would really love to have this option.

Thanks.

thanks mate!! awesome tutorial. should be part of the official wiki!
to vinnie: check if you provided the password in the format mysql://postfix:YOURPASSWORD@localhost/postfix
that made it work for me

I just done it on another server for my client and it still worked for me. 

The password query should work if you never set or change the default webmail database. Make sure you have the right settings on those config files OR you may check the error stated on log file.

Hope this help.

[Administrator]

instructions are here
http://wiki.centos-webpanel.com/roundcube-password-change-plugin

[crmgddn63]

To enable the email account password change option from roundcube, you can add the following in file:
/usr/local/apache/htdocs/roundcube/config/main.inc.php

Don't forget to replace your postfix user "PASSWORD"

$rcmail_config['plugins'] = array('password');
$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://postfix:PASSWORD@localhost/postfix';
$rcmail_config['password_query'] = "UPDATE mailbox SET password=CONCAT('{PLAIN-MD5}', MD5(%p)),modified=NOW() WHERE username=%u LIMIT 1";

what is my postfix user pass ?

[Administrator]

You can find your postfix password here:
grep pass /etc/postfix/mysql-virtual_mailbox_maps.cf