I will write how to enable the password plugin for roundcube on ISPConfig3 server configuration:
In roundcube, you first have to enable the password plugin. You can do so by editing the config.inc.php in roundcube/config directory.
Edit this line: $rcmail_config['plugins'] = array();
to: $rcmail_config['plugins'] = array(‘password’);
And save the configuration.
After that what you have to do is set the password plugin, so it connects to the database and changes the password.
Go into roundcube/plugins/password and copy config.inc.php.dist to config.inc.php
Firsts make sure you are using SQL driver by having the password driver set to: $rcmail_config['password_driver'] = ‘sql’;
Now what you have to do is edit the connector so that the plugin knows on what database to run the function to change the password
you do this by editing this line: $rcmail_config['password_db_dsn'] = ‘mysql://username:password@localhost/databasename’; (default installation: $rcmail_config['password_db_dsn'] = ‘mysql://ispconfig:password@localhost/dbispconfig’;) where you change the username, password and databasename according to your installation configuration.
You can find the database password in /usr/local/ispconfig/interface/lib/config.inc.php
After all of that is done, roundcube will run the update_password function that is stored in your database. Currently none is existing so you can do it 2 ways. If you have ssh access you can do so by simply use sql prompt or you can use phpmyadmin and write sql query in there.
What you have to so is:
USE databasename; # Default: dbispconfig
DELIMITER //
CREATE FUNCTION update_passwd (pwd varchar(100), usr varchar(100)) RETURNS INT
BEGIN
UPDATE databasename.mail_user SET password=pwd WHERE login=usr LIMIT 1; # Default: UPDATE dbispconfig.mail_user SET password=pwd WHERE login=usr LIMIT 1;
RETURN ROW_COUNT();
END//
DELIMITER ;
Where you change databasename according to your installation configuration
There you go, now login to you email account using roundcube and click on settings, you should be able to see the password tab and change the password. In case you run into problems you can trace them in roundcube/logs/error
I hope you set the plugin without problems.
