1

Topic: Sogo signin issue

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.0
- Deployed with iRedMail Easy or the downloadable installer? Download
- Linux/BSD distribution name and version: Ubuntu Server 20.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- 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.
====

I'm having an issue in logging in on any new user created besides the default postmaster. Any user I create, I am able to login on roundcube, but not use sogo on the new user. Below is one of the logs from sogo.

Aug 01 21:52:41 sogod [1321]: [ERROR] <0x0x5588dc6c2040[SQLSource]> could not run SQL 'c_uid = '[EMAIL ADDRESS]'': <PostgreSQL72Exception: 0x5588dc5a7960> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x5588dc6a2970[PostgreSQL72Channel]: connection=<0x0x5588dc6b9da0[PGConnection]:  connection=0x0x5588dc639740>>): ERROR:  relation "users" does not exist
LINE 1: SELECT c_password FROM users WHERE c_uid = '[EMAIL ADDRESS]'

Aug 01 21:52:41 sogod [1321]: SOGoRootPage Login from 'X.X.X.X' for user '[EMAIL ADDRESS]' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
Aug 01 21:52:41 sogod [1321]: X.X.X.X "POST /SOGo/connect HTTP/1.0" 403 34/85 0.005 - - 0 - 12
Aug 01 21:53:27 sogod [1321]: [ERROR] <0x0x5588dc6c2040[SQLSource]> could not run SQL 'c_uid = '[EMAIL ADDRESS]'': <PostgreSQL72Exception: 0x5588dc64f560> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x5588dc6a2970[PostgreSQL72Channel]: connection=<0x0x5588dc6b9da0[PGConnection]:  connection=0x0x5588dc639740>>): ERROR:  relation "users" does not exist
LINE 1: SELECT c_password FROM users WHERE c_uid = '[EMAIL ADDRESS]'

----

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

2

Re: Sogo signin issue

It's a known bug of iRedMail-1.6.0 with PGSQL backend. Please follow this tutorial to fix it:
https://docs.iredmail.org/upgrade.iredm … able-names