Roundcube 1.0.2 - Password plugin issue

[lvletei]

I know, you must get a million of these a day, but I've run out of ideas on where this blasted bug is.

Using the password plugin I try to submit the new password, and it gives the lovely 'Could not save password' error.

My config for that part is as follows:

Code Select Expand

$config['password_query'] = 'UPDATE virtual_users SET password=ENCRYPT(%p,concat("$6$", $substr, -16))) WHERE email=%u LIMIT 1';.
$config['password_crypt_hash'] = 'sha512';
$config['password_idn_ascii'] = false;
$config['password_dovecotpw'] = '/usr/sbin/dovecotpw';
$config['password_dovecotpw_method'] = 'CRAM-MD5';
$config['password_dovecotpw_with_method'] = false;
$config['password_hash_algorithm'] = 'sha1';
$config['password_hash_base64'] = false;

I've read through this post: http://www.roundcubeforum.net/index.php?topic=15291.0 and the individual there has had the same issue, after following the same tutorial.
I tried what they've suggested that worked for them with no results. I still receive the following error in my logs even with $config['password_query'] set.

Code Select Expand

DB Error: [1305] FUNCTION servermail.update_passwd does not exist (SQL
Query: SELECT update_passwd('$1$f.GOoBw0$CDWXMh247GA4Z7cAx2/gp1', '<email redacted>')) in
/var/www/roundcube/program/lib/Roundcube/rcube_db.php on line 467 (POST /roundcube/?_task=settings&_
action=plugin.password-save?_task=&_action=)

[JohnDoh]

Are there any errors in you log about a problem loading the config file? Make sure you edited the correct config file, and that you took the .dist off the end of the name

[lvletei]

Thanks for the response, John.

No, there aren't any errors about a problem loading the config file.
The config I'm editing is in /plugins/password/
Now, here's the strange thing. If I remove the .dist from the file the password link in settings disappears completely, and I start receiving the service currently not available error. I just figured that was the way the code was written. If that's the problem, how do I prevent the error with it being just a .php file? The Error number that it gives me is 524, and the logs show no handler found for action plugin.password.

[JohnDoh]

That is strange. Are there no other errors in the log? Can you post your (anonymised) config, may be there is an error in it.