1 Topic by nhapinde

  • nhapinde
  • Member
  • Offline
  • Registered: 2018-10-25
  • Posts: 6

Topic: Password change error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): v0.9.8
- Linux/BSD distribution name and version: Ubuntu 16.04.5 LTS
- 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: "Unhandled Error 21976"
====

Hi, I have been using Iredmail for 3 months now. And have always used SOGo as Webclient. In the begining users could change passwords but now they cannot.
This is only possyble via Ired Admin. The rest is absolutely fine. Could you help me find out whats going on?

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: Password change error

What do you mean user cannot change password? Any error in sogo log file?

3 Reply by nhapinde

  • nhapinde
  • Member
  • Offline
  • Registered: 2018-10-25
  • Posts: 6

Re: Password change error

ZhangHuangbin wrote:

What do you mean user cannot change password? Any error in sogo log file?

Oct 29 15:00:40 sogod [1716]: [ERROR] <0x0x55d89bc513b0[SQLSource]> could not ru                                                                                                             n SQL 'UPDATE users SET c_password = '{ssha512}8LJSD664SDV31SD21VS86eu34D6t7yno                                                                                                             4jRe2J91cy25hlgf1jsGmMi+z0irb2TcQZVdijmpkc/cNrKNDBfMX0GVqgM5xhX' WHERE c_uid = '                                                                                                             user@domain.com'': <PostgreSQL72Exception: 0x55d89e968d10> NAME:PostgreSQL72Fat                                                                                                             alError REASON:fatal pgsql error (channel=<0x0x55d89ea992d0[PostgreSQL72Channel]                                                                                                             : connection=<0x0x55d89df76d00[PGConnection]:  connection=0x0x55d89eaef5d0>>): E                                                                                                             RROR:  cannot update view "users"
DETAIL:  Views that do not select from a single table or view are not automatica                                                                                                             lly updatable.
HINT:  To enable updating the view, provide an INSTEAD OF UPDATE trigger or an u                                                                                                             nconditional ON UPDATE DO INSTEAD rule.

Oct 29 15:00:40 sogod [1716]: 41.94.117.3 "POST /SOGo/so/changePassword HTTP/1.0                                                                                                             " 403 34/24 0.073 - - 0
Oct 29 15:00:47 sogod [1641]: [WARN] <0x0x55d89b8b3020[WOWatchDogChild]> pid 1714 has been hanging in the same request for 8 minutes
Oct 29 15:00:50 sogod [1641]: [WARN] <0x0x55d89b8b30d0[WOWatchDogChild]> pid 1715 has been hanging in the same request for 4 minutes

4 Reply by nhapinde

  • nhapinde
  • Member
  • Offline
  • Registered: 2018-10-25
  • Posts: 6

Re: Password change error

nhapinde wrote:
ZhangHuangbin wrote:

What do you mean user cannot change password? Any error in sogo log file?

Oct 29 15:00:40 sogod [1716]: [ERROR] <0x0x55d89bc513b0[SQLSource]> could not ru                                                                                                             n SQL 'UPDATE users SET c_password = '{ssha512}8LJSD664SDV31SD21VS86eu34D6t7yno                                                                                                             4jRe2J91cy25hlgf1jsGmMi+z0irb2TcQZVdijmpkc/cNrKNDBfMX0GVqgM5xhX' WHERE c_uid = '                                                                                                             user@domain.com'': <PostgreSQL72Exception: 0x55d89e968d10> NAME:PostgreSQL72Fat                                                                                                             alError REASON:fatal pgsql error (channel=<0x0x55d89ea992d0[PostgreSQL72Channel]                                                                                                             : connection=<0x0x55d89df76d00[PGConnection]:  connection=0x0x55d89eaef5d0>>): E                                                                                                             RROR:  cannot update view "users"
DETAIL:  Views that do not select from a single table or view are not automatica                                                                                                             lly updatable.
HINT:  To enable updating the view, provide an INSTEAD OF UPDATE trigger or an u                                                                                                             nconditional ON UPDATE DO INSTEAD rule.

Oct 29 15:00:40 sogod [1716]: 41.94.117.3 "POST /SOGo/so/changePassword HTTP/1.0                                                                                                             " 403 34/24 0.073 - - 0
Oct 29 15:00:47 sogod [1641]: [WARN] <0x0x55d89b8b3020[WOWatchDogChild]> pid 1714 has been hanging in the same request for 8 minutes
Oct 29 15:00:50 sogod [1641]: [WARN] <0x0x55d89b8b30d0[WOWatchDogChild]> pid 1715 has been hanging in the same request for 4 minutes




THIS IS IS LOG FROM SOGO WHEN TRYING TO CHANGE THE PASSWORD

5 Reply by nhapinde

  • nhapinde
  • Member
  • Offline
  • Registered: 2018-10-25
  • Posts: 6

Re: Password change error

On the other hand when I run upgrade on the OS I get this :

SOGo database schemas are _not_ automatically upgraded by
the packaging system.

Please check the list of database schema upgrade scripts
inside /usr/share/doc/sogo/ and apply them if needed.

Would these 2 have anything to do with the error I´m getting?

6 Reply by vzer.zhang

  • vzer.zhang
  • Member
  • Offline
  • Registered: 2018-05-02
  • Posts: 12

Re: Password change error

nhapinde wrote:
nhapinde wrote:
ZhangHuangbin wrote:

What do you mean user cannot change password? Any error in sogo log file?

Oct 29 15:00:40 sogod [1716]: [ERROR] <0x0x55d89bc513b0[SQLSource]> could not ru                                                                                                             n SQL 'UPDATE users SET c_password = '{ssha512}8LJSD664SDV31SD21VS86eu34D6t7yno                                                                                                             4jRe2J91cy25hlgf1jsGmMi+z0irb2TcQZVdijmpkc/cNrKNDBfMX0GVqgM5xhX' WHERE c_uid = '                                                                                                             user@domain.com'': <PostgreSQL72Exception: 0x55d89e968d10> NAME:PostgreSQL72Fat                                                                                                             alError REASON:fatal pgsql error (channel=<0x0x55d89ea992d0[PostgreSQL72Channel]                                                                                                             : connection=<0x0x55d89df76d00[PGConnection]:  connection=0x0x55d89eaef5d0>>): E                                                                                                             RROR:  cannot update view "users"
DETAIL:  Views that do not select from a single table or view are not automatica                                                                                                             lly updatable.
HINT:  To enable updating the view, provide an INSTEAD OF UPDATE trigger or an u                                                                                                             nconditional ON UPDATE DO INSTEAD rule.

Oct 29 15:00:40 sogod [1716]: 41.94.117.3 "POST /SOGo/so/changePassword HTTP/1.0                                                                                                             " 403 34/24 0.073 - - 0
Oct 29 15:00:47 sogod [1641]: [WARN] <0x0x55d89b8b3020[WOWatchDogChild]> pid 1714 has been hanging in the same request for 8 minutes
Oct 29 15:00:50 sogod [1641]: [WARN] <0x0x55d89b8b30d0[WOWatchDogChild]> pid 1715 has been hanging in the same request for 4 minutes




THIS IS IS LOG FROM SOGO WHEN TRYING TO CHANGE THE PASSWORD


DB backend is postgresql ? postgreSQL cannot update view in iRedMail.

7 Reply by nhapinde

  • nhapinde
  • Member
  • Offline
  • Registered: 2018-10-25
  • Posts: 6

Re: Password change error

Hi,
yes its Postgres. I used it for at least 3 months without any problem until suddenly it started showing this error when trying to change the password.
Is there a way I can solve this?

vzer.zhang wrote:
nhapinde wrote:
nhapinde wrote:

Oct 29 15:00:40 sogod [1716]: [ERROR] <0x0x55d89bc513b0[SQLSource]> could not ru                                                                                                             n SQL 'UPDATE users SET c_password = '{ssha512}8LJSD664SDV31SD21VS86eu34D6t7yno                                                                                                             4jRe2J91cy25hlgf1jsGmMi+z0irb2TcQZVdijmpkc/cNrKNDBfMX0GVqgM5xhX' WHERE c_uid = '                                                                                                             user@domain.com'': <PostgreSQL72Exception: 0x55d89e968d10> NAME:PostgreSQL72Fat                                                                                                             alError REASON:fatal pgsql error (channel=<0x0x55d89ea992d0[PostgreSQL72Channel]                                                                                                             : connection=<0x0x55d89df76d00[PGConnection]:  connection=0x0x55d89eaef5d0>>): E                                                                                                             RROR:  cannot update view "users"
DETAIL:  Views that do not select from a single table or view are not automatica                                                                                                             lly updatable.
HINT:  To enable updating the view, provide an INSTEAD OF UPDATE trigger or an u                                                                                                             nconditional ON UPDATE DO INSTEAD rule.

Oct 29 15:00:40 sogod [1716]: 41.94.117.3 "POST /SOGo/so/changePassword HTTP/1.0                                                                                                             " 403 34/24 0.073 - - 0
Oct 29 15:00:47 sogod [1641]: [WARN] <0x0x55d89b8b3020[WOWatchDogChild]> pid 1714 has been hanging in the same request for 8 minutes
Oct 29 15:00:50 sogod [1641]: [WARN] <0x0x55d89b8b30d0[WOWatchDogChild]> pid 1715 has been hanging in the same request for 4 minutes




THIS IS IS LOG FROM SOGO WHEN TRYING TO CHANGE THE PASSWORD


DB backend is postgresql ? postgreSQL cannot update view in iRedMail.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: Password change error

With PostgreSQL, SOGo cannot change user password.

9 Reply by nhapinde

  • nhapinde
  • Member
  • Offline
  • Registered: 2018-10-25
  • Posts: 6

Re: Password change error

I see. I have been trying to see sort this but cant get itt done.
Could you point me how to do it?

ZhangHuangbin wrote:

With PostgreSQL, SOGo cannot change user password.

10 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: Password change error

nhapinde wrote:

Could you point me how to do it?

It depends on the SQL VIEW created in "sogo" database ("sogo.users").
Check PostgreSQL document to see whether it supports updating VIEW, maybe new postgresql version supports it now.

11 Reply by s.sari

  • s.sari
  • Member
  • Offline
  • Registered: 2022-10-16
  • Posts: 5

Re: Password change error

hello,
please any update on this issue im running iredmail with backend postgres and last sogo 5.7.1
and have same problem of password changes, it worked at begining but now getting errors user can't change their password via sogo. only using iredadmin.

this is sogo.log after i hit change password on sogo

= <0x0x55eb72d13ae0[NGImap4Client]: login=s.sari@domain(pwd) socket=<NGActiveSSLSocket[0x0x55eb72837d60]: mode=rw address=(null)>>
Oct 16 13:58:10 sogod [164331]: <0x55eb72d7e8b0[SOGoMailAccount]:0> renewing imap4 password
Oct 16 13:58:10 sogod [164331]: <0x0x55eb724da9a0[NGImap4Client]> TLS started successfully.
Oct 16 13:58:16 sogod [164331]: [ERROR] <0x0x55eb71472430[NGImap4ConnectionManager]> IMAP4 login failed:
  host=127.0.0.1, user=s.sari@domain.dz, pwd=yes
  url=imaps://s.sari%40domain.dz@127.0.0.1/?tls=YES&tlsVerifyMode=allowInsecureLocalhost
  base=(null)
  base-class=(null))
  = <0x0x55eb724da9a0[NGImap4Client]: login=s.sari@domain.dz(pwd) socket=<NGActiveSSLSocket[0x0x55eb72b26900]: mode=rw address=(null)>>
Oct 16 13:58:16 sogod [164331]: [ERROR] <0x55eb72d7e8b0[SOGoMailAccount]:0> Could not connect IMAP4
Oct 16 13:58:16 sogod [164331]: 193.194.91.134 "POST /SOGo/so/s.sari@domain.dz/Mail/0/folderINBOX/changes HTTP/1.0" 200 19/143 7.539 - - 0 - 32



any help please thanks,

12 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: Password change error

s.sari wrote:

im running iredmail with backend postgres and last sogo 5.7.1
and have same problem of password changes

Which iRedMail release are you running?
Also which linux distribution and release?

Please create a new forum topic for your own issue, not hijack other's (years-old) thread.