Topic: Unhandled error response when change password in SoGo
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PostgreSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes 2.8.0
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
User password change in Roundcube works without issue.
Enabled password change in Sogo, when user changes password Web browser shows Unhandled error response.
Sogo configuration is iRedMail stock otherwise.
/var/log/sogo/sogo.log shows:
Mar 10 21:12:28 sogod [30266]: [ERROR] <0x0x55cd46907910[SQLSource]> could not run SQL 'UPDATE users SET c_password = '{ssha512}Pt*******' WHERE c_uid = 'tim@*********'': <PostgreSQL72Exception: 0x55cd46a4ffd0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55cd47524550[PostgreSQL72Channel]: connectio=<0x0x55cd46a4b1d0[PGConnection]: connection=0x0x55cd473ffbb0>>): ERROR: cannot update view "users"
HINT: You need an unconditional ON UPDATE DO INSTEAD rule or an INSTEAD OF UPDATE trigger.
Mar 10 21:12:28 sogod [30266]: 147******** "POST /SOGo/so/changePassword HTTP/1.0" 403 30/28 0.022 - - 108K
Any thoughts on what is going on here?
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.