Topic: Unhandled error response when change password in SoGo

- 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?


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).


Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee