1 (edited by saosborne9 2022-04-08 04:23:45)

Topic: Sogo lost connection

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

We had just closed a support ticket and the machine did not survive a reboot due to power failure. Any help appreciated!!

====
From sogo backup
<0x0x555c0991b500[SQLSource]> could not run SQL 'SELECT * FROM users WHERE (c_uid = 'myname') OR (mail = 'myname')': <PostgreSQL72Exception: 0x555c09a012d0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x555c099bdb00[PostgreSQL72Channel]: connection=<0x0x555c097d3d00[PGConnection]:  connection=0x0x555c09a204f0>>): ERROR:  could not establish connection
DETAIL:  FATAL:  password authentication failed for user "vmail"
FATAL:  password authentication failed for user "vmail"
I have many similar logs in other areas. All show a broken connection but I can easily connect with the same credentials listed in tips file using pgadmin. I have looked through the places listed in the forums for similar errors but they are for different versions or problems. I cannot trace where the issue originates. The proper credentials are listed everywhere I look. All the sogo.conf strings seem to use the sogo user but the errors are for vmail user(?). All of my sogo access is down but this should give an idea of where the fracture is.

All kinds in Sogo log:

Apr 05 01:07:01 sogod [1162]: <0x0x563efff0b0a0[SOGoDAVAuthenticator]> tried wrong password for user 'user@domain.com'!
Apr 05 01:07:01 sogod [1162]: mail.domain.com "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=user&DeviceId=xxxxxxxxxxxxxxxxxxxx&DeviceType=WindowsMail HTTP/1.0" 401 12/0 0.076 - - 604K - 12
Apr 05 01:07:01 sogod [1162]: <0x0x563efff0b0a0[SOGoDAVAuthenticator]> tried unknown authentication method: Bearer (B)
Apr 05 01:07:01 sogod [1162]: mail.domain.com "OPTIONS /SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 401 33/0 0.001 - - 0 - 12
Apr 05 01:16:54 sogod [1162]: [ERROR] <0x0x563efff10e10[SQLSource]> could not run SQL 'SELECT * FROM users WHERE (c_uid = 'user@domain.com') OR (mail = 'user@domain.com')': <PostgreSQL72Exception: 0x563efff44310> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x563effedead0[PostgreSQL72Channel]: connection=<0x0x563efff39370[PGConnection]:  connection=0x0x563efff3a000>>): ERROR:  could not establish connection
DETAIL:  FATAL:  password authentication failed for user "vmail"
FATAL:  password authentication failed for user "vmail"

Apr 05 01:16:54 sogod [1162]: 192.168.0.1 "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 401 0/683 0.059 - - 0 - 12
Apr 05 01:16:54 sogod [1162]: [ERROR] <0x0x563efff10e10[SQLSource]> could not run SQL 'c_uid = 'user@domain.com'': <PostgreSQL72Exception: 0x563efff5a110> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x563effedead0[PostgreSQL72Channel]: connection=<0x0x563efff39370[PGConnection]:  connection=0x0x563efff3a000>>): ERROR:  could not establish connection
DETAIL:  FATAL:  password authentication failed for user "vmail"
FATAL:  password authentication failed for user "vmail"

Apr 05 01:16:54 sogod [1162]: <0x0x563efff0b0a0[SOGoDAVAuthenticator]> tried wrong password for user 'user@domain.com'!
Apr 05 01:16:54 sogod [1162]: 192.168.0.1 "REPORT /SOGo/dav/user@domain.com/Calendar/personal/ HTTP/1.0" 401 12/683 0.022 - - 0 - 12
Apr 05 01:16:55 sogod [1162]: 192.168.0.1 "PROPFIND /SOGo/dav/user@domain.com/Contacts/personal/ HTTP/1.0" 401 0/304 0.002 - - 0 - 12
Apr 05 01:16:55 sogod [1162]: [ERROR] <0x0x563efff10e10[SQLSource]> could not run SQL 'c_uid = 'user@domain.com'': <PostgreSQL72Exception: 0x563efff33a40> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x563effedead0[PostgreSQL72Channel]: connection=<0x0x563efff39370[PGConnection]:  connection=0x0x563efff3a000>>): ERROR:  could not establish connection
DETAIL:  FATAL:  password authentication failed for user "vmail"
FATAL:  password authentication failed for user "vmail"

Apr 05 01:16:55 sogod [1162]: <0x0x563efff0b0a0[SOGoDAVAuthenticator]> tried wrong password for user 'user@domain.com'!
Apr 05 01:16:55 sogod [1162]: 192.168.0.1 "PROPFIND /SOGo/dav/user@domain.com/Contacts/personal/ HTTP/1.0" 401 12/304 0.034 - - 0 - 12

************************************************
Dovecot
*************************
Apr  5 00:52:30 mail dovecot: master: Dovecot v2.3.7.2 (3c910f64b) starting up for pop3, imap, sieve, lmtp (core dumps disabled)
Apr  5 00:52:42 mail dovecot: stats: Error: conn stats-reader (127.0.0.1:39688): didn't reply with a valid VERSION line: EXPORT#011global
Apr  5 00:52:42 mail dovecot: stats: Error: conn stats-reader (127.0.0.1:39690): didn't reply with a valid VERSION line: EXPORT#011global

**********************
Nginx Error
******************
2022/04/05 05:09:11 [error] 804#804: *1364 open() "/var/www/html/phpmyadmin" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: _, request: "GET /phpmyadmin HTTP/2.0", host: "mail.domain.com"
2022/04/05 05:09:15 [error] 804#804: *1364 open() "/var/www/html/phpmyadmin" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: _, request: "GET /phpmyadmin HTTP/2.0", host: "mail.domain.com"
2022/04/05 05:10:10 [error] 804#804: *1364 open() "/var/www/html/phpmyadmin" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: _, request: "GET /phpmyadmin HTTP/2.0", host: "mail.domain.com"
2022/04/05 00:53:36 [crit] 823#823: *44 SSL_do_handshake() failed (SSL: error:141CF06C:SSL routines:tls_parse_ctos_key_share:bad key share) while SSL handshaking, client: xxx.xxx.xxx.xxx, server: 0.0.0.0:443

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team.

2

Re: Sogo lost connection

saosborne9 wrote:

DETAIL:  FATAL:  password authentication failed for user "vmail"
FATAL:  password authentication failed for user "vmail"

You have wrong password for sql user "vmail" in /etc/sogo/sogo.conf?