1

Topic: roundcube password plugin error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):  1.5.1 MARIADB
- Deployed with iRedMail Easy or the downloadable installer? downloadable
- Linux/BSD distribution name and version: CentOS Stream release 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I have update iredmail, including roundcube software. after that password change plugin doesn't work properly at the roundcube web gui.
I get on the password page:  could not save new password
at the log file i got:

Sep  2 01:37:26 server roundcube[281465]: <jcoeonu1> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '%D,passwordlastchange=NOW() WHERE username='user@domain.com'' at line 1 (SQL Query:
UPDATE mailbox SET password=%D,passwordlastchange=NOW() WHERE username='user@domain.com') in /opt/www/roundcubemail/program/lib/Roundc
ube/rcube_db.php on line 564 (POST /mail/?_task=settings&_action=plugin.password-save)

after i made some google , but with no luck, other password_query line produce same error:

Sep  2 02:19:56 server roundcube[283077]: <jcoeonu1> DB Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%c, modified=now() WHERE `username` = 'user@domain.com' LIMIT 1' at line 1 (SQL Query: UPDATE `mailbox` SET `password` = %c, modified=now() WHERE `username` = 'user@domain.com' LIMIT 1) in /opt/www/roundcubemail/program/lib/Roundcube/rcube_db.php on line 564 (POST /mail/?_task=settings&_action=plugin.password-save)

Can you please help with that?

Regards

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: roundcube password plugin error

Update of roundcube password plugin config was helpfull. I guess there was echo of update procedure.

< $config['password_algorithm'] = 'ssha512';
< $config['password_algorithm_prefix'] = '{SSHA512}';
< $config['password_query'] = 'UPDATE `mailbox` SET `password` = %P, modified=now() WHERE `username` = %u LIMIT 1';

Regards