1

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.

2

Re: Unhandled error response when change password in SoGo

PostgreSQL doesn't support update VIEW (the sql table "sogo.users" is actually a SQL VIEW).