1 Topic by dropestein (edited by dropestein 2020-07-08 23:16:42)

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Topic: SOGo broken after changing my email signature

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.2.1 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer? Downloadable
- Linux/BSD distribution name and version: Debian GNU/Linux 10 (buster)
- 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.
====

Hi guys. I'm freaking out with this, please help me. I just created a new accound from iRedAdmin* and then signed in through SOGo. Then I went to the settings, IMAP, identity... added a signature, accepted the changes, then I clicked on the round Save button and an error popped out.

(*): a couple of minutes before I added the organization name to that domain, that I noticed it was blank.

Now I see this:
https://i.ibb.co/3yDnwc6/Screenshot-from-2020-07-08-09-44-46.png

And if I logout, I can't login again from other accounts (and I use this for work!)

In the logs I just see trillions of:

Jul 08 09:44:03 sogod [15407]: <0x0x55fa68a42850[NGSieveClient]> WARNING: got exception try to restore connection: <NGStreamWriteErrorException: 0x55fa68bb8d50> $
2020-07-08 09:44:03.022 sogod[15407:15407] ERROR(-[NGActiveSSLSocket startTLS]): couldn't setup SSL connection on host 127.0.0.1 (error:00000001:lib(0):func(0):r$
Jul 08 09:44:03 sogod [15407]: <0x0x55fa68a42850[NGSieveClient]> Could not start TLS.

I see something about TLS, should I restart it? (how?)
And most of all... how is it possible that for changing a signature everything breaks apart? sad

And every day I see a couple of notifications in my email about automatic backups. Does it mean that I could just reinstall everything and restore everything as it was yesterday? (I'll start making rsync backups every single day)

Thanks!!!

----

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,088

Re: SOGo broken after changing my email signature

dropestein wrote:

I just created a new accound from iRedAdmin and then signed in through SOGo. Then I went to the settings, IMAP, identity... added a signature, accepted the changes, then I clicked on the round Save button and an error popped out.

Did you change any config files before this issue occurred?
Or, did you just upgrade SOGo packages?

dropestein wrote:

And every day I see a couple of notifications in my email about automatic backups. Does it mean that I could just reinstall everything and restore everything as it was yesterday? (I'll start making rsync backups every single day)

It's backup of SQL databases, it does NOT backup mailboxes.

3 Reply by dropestein (edited by dropestein 2020-07-08 23:15:43)

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

Ok, this is horrible.

Now, after some minutes, for some reason I can access to my account, but it looks empty. No folders at all:

https://i.ibb.co/FxC5wpv/Screenshot-from-2020-07-08-10-10-21.png

Aaaaand now I was trying to do more things to look for more symptoms, but the server just went down (what is happening?)

4 Reply by dropestein

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

ZhangHuangbin wrote:
dropestein wrote:

I just created a new accound from iRedAdmin and then signed in through SOGo. Then I went to the settings, IMAP, identity... added a signature, accepted the changes, then I clicked on the round Save button and an error popped out.

Did you change any config files before this issue occurred?
Or, did you just upgrade SOGo packages?

dropestein wrote:

And every day I see a couple of notifications in my email about automatic backups. Does it mean that I could just reinstall everything and restore everything as it was yesterday? (I'll start making rsync backups every single day)

It's backup of SQL databases, it does NOT backup mailboxes.

Nothing. Just that.

Well, before creating that new account, I added the company name in the domain options. And that's it.

5 Reply by dropestein (edited by dropestein 2020-07-08 23:24:37)

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

ZhangHuangbin wrote:
dropestein wrote:

And every day I see a couple of notifications in my email about automatic backups. Does it mean that I could just reinstall everything and restore everything as it was yesterday? (I'll start making rsync backups every single day)

It's backup of SQL databases, it does NOT backup mailboxes.

Ok, wait. Could I restore the database to how it was yesterday then? Maybe that could fix the problem. Where could I find a guide on how to do that? Is a plain db restore from MariaDB?

6 Reply by dropestein

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

Update

In the SOGo log file I found tens of thousands repeats of this line now:

Jul 08 10:10:27 sogod [15407]: [ERROR] <0x0x55fa693b0530[_WOStringTable]> could not read strings file: /usr/lib/GNUstep/SOGo/PreferencesUI.SOGo/Resources/Spanish$

7 Reply by dropestein

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

Ok, I think I finally isolated the problem.

I did a fresh install of iRedMail with SOGo in a different VPS and the problem appeared again (maybe a bug?)
I followed this guide: https://www.linuxbabe.com/mail-server/d … ail-server

Then I created some domains and users in iRedAdmin

After that, I logged in via SOGo

I can see my inbox fine. But if I click the settings button (the cog icon) that "missing component" of my firsts screenshots appears.

And I found something in sogo.log that repeats every time I replicate the problem:

It starts with these lines:

2020-07-08 20:47:13.790 sogod[11482:11482] ERROR(-[NGActiveSSLSocket startTLS]): couldn't setup SSL connection on host 127.0.0.1 (error:00000001:lib(0):func(0):reason(1))...
Jul 08 20:47:13 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> Could not start TLS.
Jul 08 20:47:13 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> WARNING: got exception try to restore connection: <NGStreamWriteErrorException: 0x562cf4767df0> NAME:NGStreamWriteErrorException REASON:stream error occured, errno=9 error=Bad file descriptor INFO:{errno = 9; error = "Bad file descriptor"; stream = "{object = 0x562cf46fe2a0;}"; }
2020-07-08 20:47:13.802 sogod[11482:11482] ERROR(-[NGActiveSSLSocket startTLS]): couldn't setup SSL connection on host 127.0.0.1 (error:00000001:lib(0):func(0):reason(1))...
Jul 08 20:47:13 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> Could not start TLS.
Jul 08 20:47:13 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> WARNING: got exception try to restore connection: <NGStreamWriteErrorException: 0x562cf47668e0> NAME:NGStreamWriteErrorException REASON:stream error occured, errno=9 error=Bad file descriptor INFO:{errno = 9; error = "Bad file descriptor"; stream = "{object = 0x562cf460fe80;}"; }
2020-07-08 20:47:13.814 sogod[11482:11482] ERROR(-[NGActiveSSLSocket startTLS]): couldn't setup SSL connection on host 127.0.0.1 (error:00000001:lib(0):func(0):reason(1))...
Jul 08 20:47:13 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> Could not start TLS.

And it repeats with a different <NGStreamWriteErrorException: 0x562cf47668e0> number more than three thousand times.

And it ends with these lines:

Jul 08 20:47:24 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> Could not start TLS.
Jul 08 20:47:24 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> WARNING: got exception try to restore connection: <NGStreamWriteErrorException: 0x562cf56ac380> NAME:NGStreamWriteErrorException REASON:stream error occured, errno=9 error=Bad file descriptor INFO:{errno = 9; error = "Bad file descriptor"; stream = "{object = 0x562cf57ac130;}"; }
2020-07-08 20:47:24.847 sogod[11482:11482] ERROR(-[NGActiveSSLSocket startTLS]): couldn't setup SSL connection on host 127.0.0.1 (error:00000005:lib(0):func(0):DH lib)...
Jul 08 20:47:24 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> Could not start TLS.
Jul 08 20:47:24 sogod [11482]: <0x0x562cf45fb7e0[NGSieveClient]> WARNING: got exception try to restore connection: <NGStreamWriteErrorException: 0x562cf56abff0> NAME:NGStreamWriteErrorException REASON:stream error occured, errno=9 error=Bad file descriptor INFO:{errno = 9; error = "Bad file descriptor"; stream = "{object = 0x562cf56ac2f0;}"; }
Jul 08 20:47:24 sogod [11482]: [ERROR] <0x0x562cf4701ca0[SOGoSieveManager]> Sieve connection failed on sieve://127.0.0.1:4190/?tls=YES
Jul 08 20:47:24 sogod [11482]: [WARN] [RM:PreferencesUI] (-[WOResourceManager definitionForComponent:inFramework:languages:]): could not load component definition of 'UIxSidenavToolbarTemplate' from component wrapper: 'file:///usr/lib/GNUstep/SOGo/Templates/UIxSidenavToolbarTemplate.wox'
Jul 08 20:47:24 sogod [11482]: <0x0x562cf452e670[WOComponentFault]> could not resolve fault for component: UIxSidenavToolbarTemplate
Jul 08 20:47:24 sogod [11482]: <0x0x562cf452e670[WOComponentFault]>   resource-manager: <SoProductResourceManager[0x0x562cf3f1b890]: product='PreferencesUI'>
Jul 08 20:47:24 sogod [11482]: <0x0x562cf452e670[WOComponentFault]>   parent:           <0x0x562cf44f2f60[UIxPreferences]: name=UIxPreferences #subs=3 awake=0x0x562cf3d5dcc0>
Jul 08 20:47:24 sogod [11482]: [WARN] UIxPreferences Could not resolve component fault: R.0.5.1.1.1
Jul 08 20:47:24 sogod [11482]: [WARN] <0x0x562cf45386c0[WOChildComponentReference]> did not find child component R.0.5.1.1.1 of parent UIxPreferences
Jul 08 20:47:24 sogod [11482]: [WARN] [RM:PreferencesUI] (-[WOResourceManager definitionForComponent:inFramework:languages:]): could not load component definition of 'UIxTopnavToolbar' from component wrapper: 'file:///usr/lib/GNUstep/SOGo/Templates/UIxTopnavToolbar.wox'
Jul 08 20:47:24 sogod [11482]: <0x0x562cf44bd480[WOComponentFault]> could not resolve fault for component: UIxTopnavToolbar
Jul 08 20:47:24 sogod [11482]: <0x0x562cf44bd480[WOComponentFault]>   resource-manager: <SoProductResourceManager[0x0x562cf3f1b890]: product='PreferencesUI'>
Jul 08 20:47:24 sogod [11482]: <0x0x562cf44bd480[WOComponentFault]>   parent:           <0x0x562cf44f2f60[UIxPreferences]: name=UIxPreferences #subs=3 awake=0x0x562cf3d5dcc0>
Jul 08 20:47:24 sogod [11482]: [WARN] UIxPreferences Could not resolve component fault: R.0.5.1.3.3.1
Jul 08 20:47:24 sogod [11482]: [WARN] <0x0x562cf45be360[WOChildComponentReference]> did not find child component R.0.5.1.3.3.1 of parent UIxPreferences
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Arabic
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Basque
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: BrazilianPortuguese
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Catalan
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: ChineseChina
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: ChineseTaiwan
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Croatian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Czech
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Danish
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Dutch
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Finnish
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: French
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: German
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Hebrew
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Hungarian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Icelandic
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Indonesian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Italian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Japanese
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Latvian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Lithuanian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Macedonian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: NorwegianBokmal
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: NorwegianNynorsk
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Polish
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Portuguese
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Romanian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Russian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Serbian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Slovak
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Slovenian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: SpanishArgentina
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: SpanishSpain
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Swedish
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: TurkishTurkey
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Ukrainian
Jul 08 20:47:24 sogod [11482]: [ERROR] [RM:PreferencesUI] did not find locale for language: Welsh
2020-07-08 20:47:24.999 sogod[11482:11482] ERROR: could not open MySQL4 connection to database 'sogo': Can't create TCP/IP socket (24)
Jul 08 20:47:24 sogod [11482]: [ERROR] <0x0x562cf3f314d0[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x562cf57f6410] connection=0x(null)> for mysql://127.0.0.1/sogo/sogo_folder_info
Jul 08 20:47:24 sogod [11482]: [WARN] <0x0x562cf3f314d0[GCSChannelManager]>   will prevent opening of this channel 5 seconds after 2020-07-08 20:47:24 -0400
Jul 08 20:47:24 sogod [11482]: <0x0x562cf3d4cc30[GCSFolderManager]> ERROR(-[GCSFolderManager folderExistsAtPath:]): executing SQL failed: 'SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pedro@pedrosg.com' AND c_path3 = 'Contacts' AND c_path4 = 'personal''
Jul 08 20:47:25 sogod [11482]: [ERROR] <0x0x562cf58699b0[_WOStringTable]> could not read strings file: /usr/lib/GNUstep/SOGo/PreferencesUI.SOGo/Resources/English.lproj/Localizable.strings
Jul 08 20:47:25 sogod [11482]: 2800:370:c2:4b50:9d8:e0e1:6de3:b538 "GET /SOGo/so/pedro@pedrosg.com/Preferences HTTP/1.0" 200 19795/0 11.284 97305 79% 23M - 1026
2020-07-08 20:47:25.989 sogod[11482:11482] -[NSProcessInfo(misc) procStatDictionary]: couldn't scan /proc-info ...
Jul 08 20:47:25 sogod [11482]: [ERROR] <0x0x562cf3ccf5c0[SOGoSQLUserProfile]> failed to acquire channel for URL: mysql://sogo:w16HwsKlfh9W9hq8Ys2MsbIBT4kTM3iK@127.0.0.1:3306/sogo/sogo_user_profile
Jul 08 20:47:25 sogod [11482]: 2800:370:c2:4b50:9d8:e0e1:6de3:b538 "GET /SOGo/so/pedro@pedrosg.com/Calendar/alarmslist?browserTime=1594255645 HTTP/1.0" 200 63/0 0.007 - - -
2020-07-08 20:47:26.185 sogod[11482:11482] -[NSProcessInfo(misc) procStatDictionary]: couldn't scan /proc-info ...
Jul 08 20:47:26 sogod [11482]: [ERROR] <0x0x562cf4090b90[SOGoSQLUserProfile]> failed to acquire channel for URL: mysql://sogo:w16HwsKlfh9W9hq8Ys2MsbIBT4kTM3iK@127.0.0.1:3306/sogo/sogo_user_profile
Jul 08 20:47:26 sogod [11482]: [WARN] [RM:PreferencesUI] (-[WOResourceManager definitionForComponent:inFramework:languages:]): could not load component definition of 'UIxJSONPreferences' from component wrapper: 'file:///usr/lib/GNUstep/SOGo/Templates/PreferencesUI/UIxJSONPreferences.wox'
Jul 08 20:47:26 sogod [11482]: [ERROR] [so-page 0x0x562cf3f22fa0 UIxJSONPreferences] did not find method 'UIxJSONPreferences'
Jul 08 20:47:26 sogod [11482]: [ERROR] [so-page 0x0x562cf3f22fa0 UIxJSONPreferences] did not find method 'UIxJSONPreferences'
Jul 08 20:47:26 sogod [11482]: 2800:370:c2:4b50:9d8:e0e1:6de3:b538 "GET /SOGo/so/pedro@pedrosg.com/activeExternalSieveScripts HTTP/1.0" 500 36/0 0.004 - - -

I see a lot of different things there, and I'm not an expert so I don't know how to interpret them. It seems to me that many different things are failing, like TLS, something abut MySQL, locales... so I'd guess that there's some one particular problem that provoked all of that.

Weird thing is that this is a fresh install. And I followed the same guide I used weeks ago and that worked fine until this error appeared.

Should I report this as a bug? Because I've been searching for this in Google all day and seems that nobody else has this problem.

Any help would be greatly appreciated, seriously.

8 Reply by cf

  • cf
  • Member
  • Offline
  • Registered: 2020-05-16
  • Posts: 10

Re: SOGo broken after changing my email signature

I had the same/similar problem a couple of days ago after upgrading SOGo from the nightly repositories. In my case it was apparently caused by a recent change so that SOGo now actually does hostname validation for TLS connections (see https://github.com/inverse-inc/sope/pull/52 and https://github.com/inverse-inc/sope/pull/56).

After some experimentation (I am no expert in any of this), I found the cause in my case was the configuration for the sieve scripts. So if you have those enabled (see https://docs.iredmail.org/why.no.sieve. … sogo.html) this might help: In /etc/sogo/sogo.conf I changed the line 

SOGoSieveServer = "sieve://127.0.0.1:4190/?tls=YES";

to 

SOGoSieveServer = "sieve://127.0.0.1:4190/?tls=NO";

And that was it. You don't mention if you have sieve scripts enabled (I understand in a standard installation, if roundcubemail is also installed, this would be disabled), but if you have you can give it a try and maybe it helps.

9 Reply by ZhangHuangbin

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

Re: SOGo broken after changing my email signature

SOGo nightly build is not always stable. sad

10 Reply by dropestein

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

ZhangHuangbin wrote:

SOGo nightly build is not always stable. sad

How could I move to stable? I use the standard install, has it nighly builds enabled by default?

cf wrote:

And that was it. You don't mention if you have sieve scripts enabled (I understand in a standard installation, if roundcubemail is also installed, this would be disabled), but if you have you can give it a try and maybe it helps.

I'll give it a try. I'm not sure, as I only did a standard installation (but with SOGo).

11 Reply by ZhangHuangbin

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

Re: SOGo broken after changing my email signature

dropestein wrote:

How could I move to stable?

Check this page: https://sogo.nu/download.html
It requires an annual support package.

12 Reply by dropestein

  • dropestein
  • Member
  • Offline
  • Registered: 2020-06-24
  • Posts: 20

Re: SOGo broken after changing my email signature

ZhangHuangbin wrote:
dropestein wrote:

How could I move to stable?

Check this page: https://sogo.nu/download.html
It requires an annual support package.

Oh, got it. So the free version is officialy nithly builds and stable is part of the paid service. Make sense.

Well, now reinstalled it without SOGo (or Roundcube) and I'm using only IMAP clients. Is not that sofisticated but it's a little bit more controlable.

Thanks!