Hello Everybody,
i'm having a hard time getting RC to work with the "password"-Plugin.
Even though the DSN is set to @10.0.1.51 (MySQL with the Users/PW) RC tries to connect to the DB @10.0.1.52, it's own IP-Address (RC with local MySQL), where it obviously fails with the error message stated below, when trying to change the password.
In ~/plugins/password/config.inc.php i have defined:
$rcmail_config['password_db_dsn'] = 'mysql://mailuser:passwd@10.0.1.51/mailserver'; $rcmail_config['password_query'] = 'UPDATE mailserver.virtual_users SET password=ENCRYPT(%p,concat(_utf8'$6$',right(sha(rand()),8),_utf8'$')) WHERE email=%u LIMIT 1'; $rcmail_config['password_crypt_hash'] = 'sha512';
DB Error: [1142] UPDATE command denied to user 'mailuser'@'10.0.1.52' for table 'virtual_users' (SQL Query: UPDATE mailserver.virtual_users SET password=ENCRYPT('passwd',concat(_utf8'$6$',right(sha(rand()),8),_utf8'$')) WHEREemail='mail@example.com' LIMIT 1) in /var/www/program/lib/Roundcube/rcube_db.php on line 416 (POST /?_task=settings&_action=plugin.password-save?_task=&_action=)
I am running RC 0.9.5 on Debian Wheezy (7.0) Machines with PHP 5.4, MySQL 5.5 and Apache 2.2.
Cheers, S.