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.