Topic: cannot change password from roundcube
==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
====changing a password from the iredadmin interface works. From within roundcube, password changes error out.
The following appears in the maillog file:
Jun 6 10:52:40 package roundcube: MDB2 Error: syntax error (-2): _doQuery: [Err
or message: Could not execute statement]#012[Last executed query: SELECT * from
dblink_exec(E'host=\'127.0.0.1\' user=\'roundcube\' password=\'**SANITIZED**\' dbname=\'vmail\'', E'UPDATE mailbox SET password='$1$mA.E4vD.$TY
hmxTpvWxJkJlbH0rOdH.',passwordlastchange=NOW() WHERE username='test@envelope.cnf
.cornell.edu'')]#012[Native message: ERROR: syntax error at or near "$1"#012LIN
E 1: ...dbname=\'vmail\'', E'UPDATE mailbox SET password='$1$mA.E4vD...#012
^]
Jun 6 10:52:40 package roundcube: DB Error: MDB2 Error: syntax error Query: _do
Query: [Error message: Could not execute statement] [Last executed query: SELECT
* from dblink_exec(E'host=\'127.0.0.1\' user=\'roundcube\' password=\'**SANITIZED**\' dbname=\'vmail\'', E'UPDATE mailbox SET password='$1$mA.
E4vD.$TYhmxTpvWxJkJlbH0rOdH.',passwordlastchange=NOW() WHERE username='test@enve
lope.cnf.cornell.edu'')] [Native message: ERROR: syntax error at or near "$1" L
INE 1: ...dbname=\'vmail\'', E'UPDATE mailbox SET password='$1$mA.E4vD... ^] in
/var/www/roundcubemail-0.8.6/program/include/rcube_mdb2.php on line 727 (POST /
mail/?_task=settings&_action=plugin.password-save?_task=&_action=)
==== Required information ====
- iRedMail version: 0.8.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Linux/BSD distribution name and version: RHEL6.4/64-bit
- Related log if you're reporting an issue:
====
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.