ISPConfig 3 + RoundCube Mail 1.0 + Password Management

Most of the articles on the web are referring to older versions. Below are the steps to get it working.

Assumptions: This works on a Ubuntu Server 12.04 LTS updated with the latest patches, setup by following "Perfect Server" tutorial, then installed with RoundCube 1.0 as the Webmail. (SqurrielMail installation was skipped).

1. Enable the password plugin of RoundCube - The 1.0 version comes with the plugin in the package, but not activated.

Under config/config.inc.php

// ----------------------------------
// PLUGINS
// ----------------------------------
// List of active plugins (in plugins/ directory)
$config['plugins'] = array('password');

This tells you will activate the 'password' plugin which sits inside the plugins/ directory.

2. Then edit the plugins/password/config.inc.php

$config['password_db_dsn'] = 'mysql://ispconfig:password@localhost/dbispconfig';

"password" is stored in /usr/local/ispconfig/interface/lib/config.inc.php.

3. Edit $config['password_query'] in plugins/password/config.inc.php

$config['password_query'] = 'UPDATE mail_user SET password=%c WHERE email=%u LIMIT 1';

4. Test the service under RoundCube 1.0

Other reference:  

http://bashprompt.net/using-roundcube-webmail-with-ispconfig-3-on-debian-wheezy-apache2/
Not tried.

http://helidium.wordpress.com/2011/12/30/ispconfig3-roundcube-password-change/
Good reference, I also followed the steps on database update - not sure if I needed it. If the above does not work, then do the database update under phpmyadmin but skipped the final step.

P.S. Be careful with the config.inc.php - the RoundCube main config and the plugin config files have the same name. I overwrote my config by mistake. Almost got into a panic mode.