i already setup dovecot,exim,roundcube. then i add password plugin into my roundcube plugin array.
but when i test it, i just got "Could not save new password." error box
i investigate my roundcube error log and found:
Code DB Error: [1305] FUNCTION roun468.update_passwd does not exist (SQL Query: SELECT update_passwd('$1$<hash>/', '<user>@<my domain>')) in /home/admin/public_html/webmail/program/lib/Roundcube/rcube_db.php on line 543 (POST /?_task=settings&_action=plugin.password-save)
i think i need reconfigure the "password_query" in "config.inc.php" to fit my db structure
Code $config['password_query'] = 'SELECT update_passwd(%c, %u)';
but i dont know how to do it, or maybe there is another way
my roundcube db stucture in the attachment
|