Allow user changes their password in RoundCube webmail

After installed RoundCube for my customer, they asked: user can change their own password

To do this, we have to enable password plugin of RoundCube

1. cd plugins/password

2. cp config.inc.php.dist config.inc.php

3. nano config.inc.php

4. Set $rcmail_config['password_driver'] = 'sql';

5. Save file

6. cd ../config

7. nano main.inc.php

8. Find the line $rcmail_config['plugins'] = array(); and change to $rcmail_config['plugins'] = array( 'password');

9. Save file

If you finish 9 steps above and access to RoundCube, you will see the Password tab in Settings section. However, you maybe meet the error:

[1305] FUNCTION xxx_roundcube.update_passwd does not exist (SQL Query: SELECT update_passwd('', '@'))

The simplest way is modify password_query:

1. Find $rcmail_config['password_query'] in plugins/password/config.inc.php

2. Change $rcmail_config['password_query'] = 'SELECT update_passwd(%c, %u)'; to $rcmail_config['password_query'] = 'UPDATE zpanel_postfix.mailbox SET password=CONCAT(\'{PLAIN-MD5}\',MD5(%p)) WHERE username=%u AND password=CONCAT(\'{PLAIN-MD5}\',MD5(%o)) LIMIT 1';

All done!