Aug 5, 2024: iRedMail-1.7.1 has been released.

**pragpot** · 2021-09-08 18:47:42

pragpot
Member
Offline

Registered: 2016-11-18
Posts: 25

Topic: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.14
- Deployed with iRedMail Easy or the downloadable installer? downloadble installer
- Linux/BSD distribution name and version: Ubuntu 18.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,
Upgraded from version 1.4.0 to 1.41 and iredadmin pro from 4.8 to 4.9 and having errors with Sogo.
User email address changed to USER@DOMAIN.COM.
Any idea what may have gone wrong.
Sogo Log below

------------------------------------------------------------

Sep 08 06:43:58 sogod [28131]: [ERROR] <0x0x55fd5d1d1b20[SQLSource]> could not run SQL 'c_uid = 'USER@DOMAIN.COM'': <PostgreSQL72Exception: 0x55fd5d1f1150> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fd5ccbb640[PostgreSQL72Channel]: connection=<0x0x55fd5ce764a0[PGConnection]: connection=0x0x55fd5cb8fc80>>): ERROR: permission denied for relation users

Sep 08 06:43:58 sogod [28131]: <0x0x55fd5d212e20[SOGoDAVAuthenticator]> tried wrong password for user 'USER@DOMAIN.COM'!
Sep 08 06:43:58 sogod [28131]: localhost "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.002 - - 0 - 13
Sep 08 06:43:58 sogod [28131]: [ERROR] <0x0x55fd5d1d1b20[SQLSource]> could not run SQL 'c_uid = 'USER@DOMAIN.COM'': <PostgreSQL72Exception: 0x55fd5d231100> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fd5d21b000[PostgreSQL72Channel]: connection=<0x0x55fd5ce5f490[PGConnection]: connection=0x0x55fd5cb8fc80>>): ERROR: permission denied for relation users

Sep 08 06:43:58 sogod [28131]: <0x0x55fd5d212e20[SOGoDAVAuthenticator]> tried wrong password for user 'USER@DOMAIN.COM'!
Sep 08 06:43:58 sogod [28131]: localhost "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.015 - - 28K - 14
Sep 08 06:43:58 sogod [28131]: [ERROR] <0x0x55fd5d1d1b20[SQLSource]> could not run SQL 'c_uid = 'USER@DOMAIN.COM'': <PostgreSQL72Exception: 0x55fd5d230f20> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fd5d21b000[PostgreSQL72Channel]: connection=<0x0x55fd5ce5f490[PGConnection]: connection=0x0x55fd5cb8fc80>>): ERROR: permission denied for relation users

Sep 08 06:43:58 sogod [28131]: <0x0x55fd5d212e20[SOGoDAVAuthenticator]> tried wrong password for user 'USER@DOMAIN.COM'!
Sep 08 06:43:58 sogod [28131]: localhost "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.002 - - 0 - 14
Sep 08 06:44:03 sogod [28131]: [ERROR] <0x0x55fd5d1d1b20[SQLSource]> could not run SQL 'c_uid = 'USER@DOMAIN.COM'': <PostgreSQL72Exception: 0x55fd5d240de0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fd5d21b000[PostgreSQL72Channel]: connection=<0x0x55fd5ce5f490[PGConnection]: connection=0x0x55fd5cb8fc80>>): ERROR: permission denied for relation users

Sep 08 06:44:03 sogod [28131]: <0x0x55fd5d212e20[SOGoDAVAuthenticator]> tried wrong password for user 'USER@DOMAIN.COM'!
Sep 08 06:44:03 sogod [28131]: localhost "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 12/0 0.002 - - 0 - 14
Sep 08 06:44:03 sogod [28131]: [ERROR] <0x0x55fd5d1d1b20[SQLSource]> could not run SQL 'c_uid = 'USER@DOMAIN.COM'': <PostgreSQL72Exception: 0x55fd5d217830> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fd5d21b000[PostgreSQL72Channel]: connection=<0x0x55fd5ce5f490[PGConnection]: connection=0x0x55fd5cb8fc80>>): ERROR: permission denied for relation users

----

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

**Quack66** · 2021-09-08 21:20:22

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Same issue. It seems to be related to wrong permission for the view (owned by postgres instead of sogo). I was able to log in after running the following command on the server.

su - postgres
\c sogo
ALTER VIEW users OWNER TO sogo;
exit

Now the issue I'm facing is that the calendar and email doesn't work in sogo now with the following error:

2021-09-08 09:32:33.868 sogod[2466271:2466271] ERROR(-[PostgreSQL72Channel primaryFetchAttributes:withZone:]): <0x0x5648e037c5a0[PostgreSQL72Channel]: connection=<0x0x5648e03a61d0[PGConnection]:  connection=0x0x5648e03a63f0>>: got no value class for column:
  attribute=c_calendar
  type=(null)

**pragpot** · 2021-09-08 21:34:52

pragpot
Member
Offline

Registered: 2016-11-18
Posts: 25

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Hi,
Applied the solution you proposed. I can now logon to Sogo WebMail, which was not working before. However when trying to use Active Sync on Mobile, I have the following error.

Sep 08 09:31:12 sogod [29791]: SOGoRootPage successful login from '192.168.1.10' for user 'USER@DOMAIN.COM' - expire = -1 grace = -1
Sep 08 09:31:12 sogod [29791]: 192.168.1.10 "POST /SOGo/connect HTTP/1.0" 200 51/78 0.110 - - 0 - 16
Sep 08 09:31:13 sogod [29791]: 192.168.1.10 "GET /SOGo/USER%40DOMAIN.COM HTTP/1.0" 302 0/0 0.002 - - 0 - 16
Sep 08 09:31:13 sogod [29791]: [ERROR] SOGoUserHomePage login module 'Mail' not accepted (must be'Calendar', 'Contacts' or 'Mail')
Sep 08 09:31:13 sogod [29791]: 192.168.1.10 "GET /SOGo/USER%40DOMAIN.COM/view HTTP/1.0" 302 0/0 0.013 - - 252K - 16
Sep 08 09:31:13 sogod [29791]: 192.168.1.10 "GET /SOGo/so/USER@DOMAIN.COM/Contacts HTTP/1.0" 302 0/0 0.002 - - 0 - 16
Sep 08 09:31:13 sogod [29791]: 192.168.1.10 "GET /SOGo/so/USER@DOMAIN.COM/Contacts/view HTTP/1.0" 200 15589/0 0.258 68094 77% 2M - 16
Sep 08 09:31:14 sogod [29791]: 192.168.1.10 "POST /SOGo/so/USER@DOMAIN.COM/Contacts/personal/view HTTP/1.0" 200 146/46 0.055 - - 0 - 16
Sep 08 09:31:41 sogod [29791]: <0x0x55da727666b0[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:41 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.004 - - 0 - 16
Sep 08 09:31:44 sogod [29791]: localhost "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.003 - - 0 - 16
Sep 08 09:31:44 sogod [29791]: <0x0x55da72777a20[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:44 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.004 - - 0 - 16
Sep 08 09:31:45 sogod [29791]: <0x0x55da72652580[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:45 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.002 - - 0 - 16
Sep 08 09:31:49 sogod [29791]: <0x0x55da72655460[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:49 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.002 - - 0 - 16
Sep 08 09:31:50 sogod [29791]: <0x0x55da727cd0e0[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:50 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.002 - - 0 - 16
Sep 08 09:31:50 sogod [29791]: <0x0x55da72749370[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:50 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.002 - - 0 - 16
Sep 08 09:31:55 sogod [29791]: <0x0x55da71e82ba0[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:55 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/113 0.003 - - 0 - 16
Sep 08 09:31:55 sogod [29791]: <0x0x55da72655460[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:31:55 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/115 0.002 - - 0 - 16
Sep 08 09:32:00 sogod [29791]: <0x0x55da726bbe70[SOGoActiveSyncDispatcher]> EAS - Forbidden access for user USER@DOMAIN.COM
Sep 08 09:32:00 sogod [29791]: localhost "POST /SOGo/Microsoft-Server-ActiveSync?User=USER@DOMAIN.COM&DeviceId=0BJJ4R8LAT5V783LPL2P0TSONK&DeviceType=iPhone&Cmd=Sync HTTP/1.0" 403 0/113 0.002 - - 0 - 16

**Quack66** · 2021-09-08 21:42:37

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Yeah this is the same issue I'm facing now. Mail, Calendar and Activesync doesn't work. It's related to some error where it can't read the column that says if you are authorized to use those services or not (See my previous post)

**Cthulhu** · 2021-09-08 21:50:11

Cthulhu
Member
Offline

Registered: 2019-06-04
Posts: 907

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

There was an update:

https://github.com/iredmail/iRedMail/co … 17a2862a09

https://github.com/iredmail/iRedMail/co … adf610d3cd

Fixing these lines should resolve it

**Quack66** · 2021-09-08 21:54:24

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Cthulhu wrote:

There was an update:
https://github.com/iredmail/iRedMail/co … 17a2862a09
https://github.com/iredmail/iRedMail/co … adf610d3cd
Fixing these lines should resolve it

I downloaded the update today so all these changes are included but it still not working.

**Quack66** · 2021-09-08 23:45:07

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

After changing the columns to VARCHAR(1) instead or CHAR(1)

c_webmail     VARCHAR(1),
c_calendar    VARCHAR(1),
c_activesync  VARCHAR(1));

it got rid of the errors in the logs but turning off sogo calendar,mail or active in iredmail pro does nothing. It always stay activated no matter what I check. At least in the meantime the calendar, activesync and email work in SOGo

**ZhangHuangbin** · 2021-09-09 08:15:19

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Hi @Quack66,

Sorry about this trouble. Is everything ok now?

**Quack66** · 2021-09-09 21:10:13

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

ZhangHuangbin wrote:

Hi @Quack66,
Sorry about this trouble. Is everything ok now?

Hey Zhang,

Unfortunately not everything is still working correctly. The only thing that is not working now is in iRedmailPro the checkbox to enable/disable sogo (see attached screenshot) does nothing.

Thanks

Post's attachments

sogo.png
sogo.png 107.03 kb, file has never been downloaded.

You don't have the permssions to download the attachments of this post.

**ZhangHuangbin** · 2021-09-10 00:29:12

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

could you please show me output of SQL commands below?

USE vmail;
DESC mailbox;

**pragpot** · 2021-09-10 13:05:24

pragpot
Member
Offline

Registered: 2016-11-18
Posts: 25

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Hi Zhang,
Applied the fix as proposed by Quack66, that is, changing the colums to VARCHAR instead of CHAR. Also changed the VIEW users OWNNER to sogo;
Active Sync is working now and it seems ok on my system. I do not have the issue of quack66 where he could not enable/disbale the SOGO groupware features. Our isues seems to be solved.

Output of the table describtion is below:

postgres=# \c vmail
You are now connected to database "vmail" as user "postgres".
vmail=# \d mailbox;
passwordlastchange | timestamp without time zone | | not null | '1970-01-01 00:00:00'::timestamp without time zone
created | timestamp without time zone | | not null | '1970-01-01 00:00:00'::timestamp without time zone
modified | timestamp without time zone | | not null | '1970-01-01 00:00:00'::timestamp without time zone
expired | timestamp without time zone | | not null | '9999-12-31 00:00:00'::timestamp without time zone
active | smallint | | not null | 1
enableimaptls | smallint | | not null | 1
enablepop3tls | smallint | | not null | 1
enablesievetls | smallint | | not null | 1
mailboxformat | character varying(50) | | not null | 'maildir'::character varying
mailboxfolder | character varying(50) | | not null | 'Maildir'::character varying
enablequota-status | smallint | | not null | 1
enablesogowebmail | character(1) | | not null | 'y'::bpchar
enablesogocalendar | character(1) | | not null | 'y'::bpchar
enablesogoactivesync | character(1) | | not null | 'y'::bpchar
Indexes:
"mailbox_pkey" PRIMARY KEY, btree (username)
"idx_mailbox_active" btree (active)
"idx_mailbox_department" btree (department)
"idx_mailbox_domain" btree (domain)
"idx_mailbox_employeeid" btree (employeeid)
"idx_mailbox_enabledeliver" btree (enabledeliver)
"idx_mailbox_enabledoveadm" btree (enabledoveadm)
"idx_mailbox_enabledsync" btree (enabledsync)
"idx_mailbox_enableimap" btree (enableimap)
"idx_mailbox_enableimapsecured" btree (enableimapsecured)
"idx_mailbox_enableimaptls" btree (enableimaptls)
"idx_mailbox_enableindexer_worker" btree ("enableindexer-worker")
"idx_mailbox_enableinternal" btree (enableinternal)
"idx_mailbox_enablelda" btree (enablelda)
"idx_mailbox_enablelib_storage" btree ("enablelib-storage")
"idx_mailbox_enablelmtp" btree (enablelmtp)
"idx_mailbox_enablemanagesieve" btree (enablemanagesieve)
"idx_mailbox_enablemanagesievesecured" btree (enablemanagesievesecured)
"idx_mailbox_enablepop3" btree (enablepop3)
"idx_mailbox_enablepop3secured" btree (enablepop3secured)
"idx_mailbox_enablepop3tls" btree (enablepop3tls)
"idx_mailbox_enablequota_status" btree ("enablequota-status")
"idx_mailbox_enablesieve" btree (enablesieve)
"idx_mailbox_enablesievesecured" btree (enablesievesecured)
"idx_mailbox_enablesievetls" btree (enablesievetls)
"idx_mailbox_enablesmtp" btree (enablesmtp)
"idx_mailbox_enablesmtpsecured" btree (enablesmtpsecured)
"idx_mailbox_enablesogo" btree (enablesogo)
"idx_mailbox_expired" btree (expired)
"idx_mailbox_isadmin" btree (isadmin)
"idx_mailbox_isglobaladmin" btree (isglobaladmin)
"idx_mailbox_passwordlastchange" btree (passwordlastchange)

(END)

Quack66 wrote:

ZhangHuangbin wrote:
Hi @Quack66,
Sorry about this trouble. Is everything ok now?

Hey Zhang,
Unfortunately not everything is still working correctly. The only thing that is not working now is in iRedmailPro the checkbox to enable/disable sogo (see attached screenshot) does nothing.
Thanks

**Quack66** · 2021-09-10 22:58:39

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

ZhangHuangbin wrote:

could you please show me output of SQL commands below?
USE vmail;
DESC mailbox;

I'm using postgres but here are the infos:

                                                       Table "public.mailbox"
          Column          |            Type             | Collation | Nullable |                      Default
--------------------------+-----------------------------+-----------+----------+----------------------------------------------------
 username                 | character varying(255)      |           | not null |
 password                 | character varying(255)      |           | not null | ''::character varying
 name                     | character varying(255)      |           | not null | ''::character varying
 language                 | character varying(5)        |           | not null | ''::character varying
 storagebasedirectory     | character varying(255)      |           | not null | '/var/vmail'::character varying
 storagenode              | character varying(255)      |           | not null | 'vmail1'::character varying
 maildir                  | character varying(255)      |           | not null | ''::character varying
 quota                    | bigint                      |           | not null | 0
 domain                   | character varying(255)      |           | not null | ''::character varying
 transport                | character varying(255)      |           | not null | ''::character varying
 department               | character varying(255)      |           | not null | ''::character varying
 rank                     | character varying(255)      |           | not null | 'normal'::character varying
 employeeid               | character varying(255)      |           |          | ''::character varying
 isadmin                  | smallint                    |           | not null | 0
 isglobaladmin            | smallint                    |           | not null | 0
 enablesmtp               | smallint                    |           | not null | 1
 enablesmtpsecured        | smallint                    |           | not null | 1
 enablepop3               | smallint                    |           | not null | 1
 enablepop3secured        | smallint                    |           | not null | 1
 enableimap               | smallint                    |           | not null | 1
 enableimapsecured        | smallint                    |           | not null | 1
 enabledeliver            | smallint                    |           | not null | 1
 enablelda                | smallint                    |           | not null | 1
 enablemanagesieve        | smallint                    |           | not null | 1
 enablemanagesievesecured | smallint                    |           | not null | 1
 enablesieve              | smallint                    |           | not null | 1
 enablesievesecured       | smallint                    |           | not null | 1
 enableinternal           | smallint                    |           | not null | 1
 enabledoveadm            | smallint                    |           | not null | 1
 enablelib-storage        | smallint                    |           | not null | 1
 enableindexer-worker     | smallint                    |           | not null | 1
 enablelmtp               | smallint                    |           | not null | 1
 enabledsync              | smallint                    |           | not null | 1
 enablesogo               | smallint                    |           | not null | 1
 allow_nets               | text                        |           |          |
 lastlogindate            | timestamp without time zone |           | not null | '1970-01-01 00:00:00'::timestamp without time zone
 lastloginipv4            | inet                        |           | not null | '0.0.0.0'::inet
 lastloginprotocol        | character(255)              |           | not null | ''::bpchar
 disclaimer               | text                        |           | not null | ''::text
 settings                 | text                        |           | not null | ''::text
 passwordlastchange       | timestamp without time zone |           | not null | '1970-01-01 00:00:00'::timestamp without time zone
 created                  | timestamp without time zone |           | not null | '1970-01-01 00:00:00'::timestamp without time zone
 modified                 | timestamp without time zone |           | not null | '1970-01-01 00:00:00'::timestamp without time zone
 expired                  | timestamp without time zone |           | not null | '9999-12-31 00:00:00'::timestamp without time zone
 active                   | smallint                    |           | not null | 1
 enableimaptls            | smallint                    |           | not null | 1
 enablepop3tls            | smallint                    |           | not null | 1
 mailboxformat            | character varying(50)       |           | not null | 'maildir'::character varying
 mailboxfolder            | character varying(50)       |           | not null | 'Maildir'::character varying
 enablequota-status       | smallint                    |           | not null | 1
 enablesievetls           | smallint                    |           | not null | 1
 enablesogowebmail        | character(1)                |           | not null | 'y'::bpchar
 enablesogocalendar       | character(1)                |           | not null | 'y'::bpchar
 enablesogoactivesync     | character(1)                |           | not null | 'y'::bpchar
Indexes:
    "mailbox_pkey" PRIMARY KEY, btree (username)
    "idx_mailbox_active" btree (active)
    "idx_mailbox_department" btree (department)
    "idx_mailbox_domain" btree (domain)
    "idx_mailbox_employeeid" btree (employeeid)
    "idx_mailbox_enabledeliver" btree (enabledeliver)
    "idx_mailbox_enabledoveadm" btree (enabledoveadm)
    "idx_mailbox_enabledsync" btree (enabledsync)
    "idx_mailbox_enableimap" btree (enableimap)
    "idx_mailbox_enableimapsecured" btree (enableimapsecured)
    "idx_mailbox_enableimaptls" btree (enableimaptls)
    "idx_mailbox_enableindexer_worker" btree ("enableindexer-worker")
    "idx_mailbox_enableinternal" btree (enableinternal)
    "idx_mailbox_enablelda" btree (enablelda)
    "idx_mailbox_enablelib_storage" btree ("enablelib-storage")
    "idx_mailbox_enablelmtp" btree (enablelmtp)
    "idx_mailbox_enablemanagesieve" btree (enablemanagesieve)
    "idx_mailbox_enablemanagesievesecured" btree (enablemanagesievesecured)
    "idx_mailbox_enablepop3" btree (enablepop3)
    "idx_mailbox_enablepop3secured" btree (enablepop3secured)
    "idx_mailbox_enablepop3tls" btree (enablepop3tls)
    "idx_mailbox_enablequota_status" btree ("enablequota-status")
    "idx_mailbox_enablesieve" btree (enablesieve)
    "idx_mailbox_enablesievesecured" btree (enablesievesecured)
    "idx_mailbox_enablesievetls" btree (enablesievetls)
    "idx_mailbox_enablesmtp" btree (enablesmtp)
    "idx_mailbox_enablesmtpsecured" btree (enablesmtpsecured)
    "idx_mailbox_enablesogo" btree (enablesogo)
    "idx_mailbox_expired" btree (expired)
    "idx_mailbox_isadmin" btree (isadmin)
    "idx_mailbox_isglobaladmin" btree (isglobaladmin)
    "idx_mailbox_passwordlastchange" btree (passwordlastchange)

**ZhangHuangbin** · 2021-09-13 10:37:01

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Please change the SQL column type to `VARCHAR(1)` (instead of `CHAR(1)`), then re-create SQL view "sogo.users". This will fix the issue.

I updated the upgrade tutorial to mention this change (in "ChangeLog" section), also re-tagged iRedMail-1.4.1 version.

Note: Since SOGo uses memcached for cache, you may need to wait for up to 5 minutes until to cache expired.

**ZhangHuangbin** · 2021-09-13 11:18:15

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

New iRedMail release 1.4.2 is out, with this issue fixed. Also removed few unused SQL columns and LDAP attributes.
FYI: https://docs.iredmail.org/upgrade.iredm … 1.4.2.html

**Quack66** · 2021-09-14 02:44:04

Quack66
Member
Offline

Registered: 2017-05-18
Posts: 38

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Thanks for the correction Zhang ! I can confirm that after deploying the 1.4.2 update and waiting 5 min for memcache to refresh all my issues are fixed ! Thanks !

**ZhangHuangbin** · 2021-09-16 15:39:47

ZhangHuangbin
iRedMail Developers
Offline

Registered: 2009-05-06
Posts: 31,088

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Sorry about this trouble. And thanks for your feedback.

Aug 5, 2024: iRedMail-1.7.1 has been released.

[ Closed ] After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Posts: 16

1 Topic by pragpot 2021-09-08 18:47:42

Topic: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

2 Reply by Quack66 2021-09-08 21:20:22 (edited by Quack66 2021-09-08 21:33:32)

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

3 Reply by pragpot 2021-09-08 21:34:52

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

4 Reply by Quack66 2021-09-08 21:42:37

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

5 Reply by Cthulhu 2021-09-08 21:50:11

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

6 Reply by Quack66 2021-09-08 21:54:24

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

7 Reply by Quack66 2021-09-08 23:45:07

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

8 Reply by ZhangHuangbin 2021-09-09 08:15:19

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

9 Reply by Quack66 2021-09-09 21:10:13

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

10 Reply by ZhangHuangbin 2021-09-10 00:29:12

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

11 Reply by pragpot 2021-09-10 13:05:24

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

12 Reply by Quack66 2021-09-10 22:58:39

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

13 Reply by ZhangHuangbin 2021-09-13 10:37:01

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

14 Reply by ZhangHuangbin 2021-09-13 11:18:15

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

15 Reply by Quack66 2021-09-14 02:44:04 (edited by Quack66 2021-09-14 02:44:20)

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

16 Reply by ZhangHuangbin 2021-09-16 15:39:47

Re: After upgrading to 1.4.1 from 1.4.0, Sogo Login Fails

Posts: 16