Go to your roundcubemail directory.

cd plugins/password

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

vi config.inc.php

$rcmail_config[‘password_driver’] = ‘sql’;

$rcmail_config[‘password_db_dsn’] = ‘mysql://dbuser:dbpass@localhost/vpopmail’;

$emailuser=$SESSION[‘username’];
$domain=split(“@”,$emailuser);
$dom_table=str_replace(“.”,”
”,$domain[1]);
$rcmail_config[‘password_query’]=”UPDATE $dom_table SET pw_passwd=%c, pw_clear_passwd=%p WHERE pw_name=%l LIMIT 1″;