1

Topic: Server Migration to 1.6.7 - Sogo Sync Outlook Issues

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.7
- Deployed with iRedMail Easy or the downloadable installer? Downloadable Installer
- Linux/BSD distribution name and version: Linux Ubuntu 22.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- 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 finally spent the weekend following documentation to migrate from 18.04 to Ubuntu 22.04. Initially I upgraded my iRedmail on Ubuntu 18.04 to 1.6.7 bringing it in line with the newly installed iRedmail version 1.6.7 on Ubuntu 22.04.

It was a clean install on 22.04. Vmail was export and imported. Rsync was used to sync mail within AWS vnet.

All went well following the migration document:

https://docs.iredmail.org/migrate.to.ne … erver.html

As Sogo was an earlier version on the old server, we did not export and import into new server which is running version 5.9.0. We simply went with default Sogo install that comes with 1.6.7 fresh install of iRedmail.

This could be our downfall.

Sogo syncs work well with IOS devices however with Outlook we are having issues.

When opening Outlook, all cached emails in current ost file are removed and the sync starts again. Leaving Outlook open will sync all mail as expected. However upon restarting Outlook, it will begin the whole process again, clearing all emails and syncing afresh.

Its as if Sogo isnt saving the state of a users sync on the new server.

Here are some of the errors I can see in sogo.log

ERROR] |SOGo| No value specified for 'SOGoProfileURL'


'sogo_folder_info' creation failed! Reason: <MySQL4Exception: 0x55f85158b740> NAME:ExecutionFailed REASON:Table 'sogo_folder_info' already e>
Nov 11 00:06:51 sogod [26907]: |SOGo| table 'sogo_store' creation failed! Reason: <MySQL4Exception: 0x55f85131f9a0> NAME:ExecutionFailed REASON:Table 'sogo_store' already exists
Nov 11 00:06:51 sogod [26906]: |SOGo| table 'sogo_store' successfully created!
Nov 11 00:06:51 sogod [26902]: |SOGo| table 'sogo_store' creation failed! Reason: <MySQL4Exception: 0x55f8515a8a50> NAME:ExecutionFailed REASON:Table 'sogo_store' already exists
Nov 11 00:06:51 sogod [26907]: |SOGo| table 'sogo_acl' successfully created!
Nov 11 00:06:51 sogod [26906]: |SOGo| table 'sogo_acl' creation failed! Reason: <MySQL4Exception: 0x55f8515a8cd0> NAME:ExecutionFailed REASON:Table 'sogo_acl' already exists
Nov 11 00:06:51 sogod [26902]: |SOGo| table 'sogo_acl' creation failed! Reason: <MySQL4Exception: 0x55f851657820> NAME:ExecutionFailed REASON:Table 'sogo_acl' already exists
Nov 11 00:06:51 sogod [26910]: |SOGo| table 'sogo_cache_folder' creation failed! Reason: <MySQL4Exception: 0x55f85131fd70> NAME:ExecutionFailed REASON:Table 'sogo_cache_folder' already>
Nov 11 00:06:51 sogod [26902]: |SOGo| table 'sogo_cache_folder' successfully created!
Nov 11 00:06:51 sogod [26907]: |SOGo| table 'sogo_cache_folder' creation failed! Reason: <MySQL4Exception: 0x55f8515a79e0> NAME:ExecutionFailed REASON:Table 'sogo_cache_folder' already>
Nov 11 00:06:51 sogod [26906]: |SOGo| table 'sogo_cache_folder' creation failed! Reason: <MySQL4Exception: 0x55f8515a7a90> NAME:ExecutionFailed REASON:Table 'sogo_cache_folder' already>
Nov 11 00:06:51 sogod [26910]: |SOGo| sogo quick table 'sogo_quick_contact' creation failed! Reason: <MySQL4Exception: 0x55f8513474a0> NAME:ExecutionFailed REASON:Table 'sogo_quick_con>
Nov 11 00:06:51 sogod [26902]: |SOGo| sogo quick table 'sogo_quick_contact' successfully created!
Nov 11 00:06:51 sogod [26907]: |SOGo| sogo quick table 'sogo_quick_contact' creation failed! Reason: <MySQL4Exception: 0x55f851494710> NAME:ExecutionFailed REASON:Table 'sogo_quick_con>
Nov 11 00:06:51 sogod [26906]: |SOGo| sogo quick table 'sogo_quick_contact' creation failed! Reason: <MySQL4Exception: 0x55f851494940> NAME:ExecutionFailed REASON:Table 'sogo_quick_con>
Nov 11 00:06:51 sogod [26910]: |SOGo| sogo quick table 'sogo_quick_appointment' successfully created!
Nov 11 00:06:51 sogod [26902]: |SOGo| sogo quick table 'sogo_quick_appointment' creation failed! Reason: <MySQL4Exception: 0x55f85141e190> NAME:ExecutionFailed REASON:Table 'sogo_quick>
Nov 11 00:06:51 sogod [26904]: |SOGo| sogo quick table 'sogo_quick_appointment' creation failed! Reason: <MySQL4Exception: 0x55f8514559f0> NAME:ExecutionFailed REASON:Table 'sogo_quick>
Nov 11 00:06:51 sogod [26911]: |SOGo| sogo quick table 'sogo_quick_appointment' creation failed! Reason: <MySQL4Exception: 0x55f851455a50> NAME:ExecutionFailed REASON:Table 'sogo_quick>
Nov 11 00:06:51 sogod [26907]: |SOGo| sogo quick table 'sogo_quick_appointment' creation failed! Reason: <MySQL4Exception: 0x55f85141ea60> NAME:ExecutionFailed REASON:Table 'sogo_quick>
Nov 11 00:06:51 sogod [26906]: |SOGo| sogo quick table 'sogo_quick_appointment' creation failed! Reason: <MySQL4Exception: 0x55f85141ee00> NAME:ExecutionFailed REASON:Table 'sogo_q

[ERROR] <0x0x55b92ff648a0[WOWatchDog]> No child available to handle incoming request!


Any advice to sort this issue would be greatly appreciated.

----

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

2

Re: Server Migration to 1.6.7 - Sogo Sync Outlook Issues

I noticed that Outlook would sync on initial opening of a fresh Outlook profile with no ost file.

However Outlook would remain in waiting for server mode with a yellow exclamation mark on the taskbar icon.

Opening Outlook in safe mode fixed this. I then disabled all Outlook add-ins which sorted this issue.

Updating to hopefully help someone else who experiences this after an upgrade.

Please close.

3

Re: Server Migration to 1.6.7 - Sogo Sync Outlook Issues

Thanks for sharing. smile