1

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:
====

2

Re: cannot change password from roundcube

Any thoughts?

3

Re: cannot change password from roundcube

With PostgreSQL backend, you need this patch for Roundcube webmail:
https://bitbucket.org/zhb/iredmail/src/ … ndcubemail

4

Re: cannot change password from roundcube

That did the trick. Thanks!