Important New Plesk webmail / SOGo Webmail extension

[AYamshanov]

Hi,

Just an update, the new version has been release, we get rid of some known limitations,

Changes​

0.2.0 (23 Feb 2023)​

• [+] It is now possible to customize the service configuration templates. For more information, see /usr/local/psa/var/modules/sogo/templates/README.md.
• [+] Added support for CourierIMAP.
  Note: Features based on the Sieve protocol will be unavailable if CourierIMAP is used.
• [+] The SOGo database is now backed up daily. SQL dumps are rotated to prevent excessive usage of disk space.
• [+] Switched the password storage to secure SSHA512 hashes, which enables to store longer passwords.
• Improved the UI of the extension's main screen.
• [-] The installation task now shows correct text upon completion. (EXTPLESK-4202)

Notes:

• It is still a beta because it is still not possible to protect the webmail by using SSL It! / Let's Encrypt),
• The extension still has English locale only.

Any feedback is welcomed!

 

[Achim Drees]

now: nightlys for ubuntu 22.04

0005511: Build packages for Ubuntu 22.04 LTS - SOGo | BTS

bugs.sogo.nu

Index of /nightly/5/ubuntu/dists/jammy

please can you make the nightlys available for plesk users on ubuntu 22.04?

 

[Achim Drees]

from developer:

0005511: Build packages for Ubuntu 22.04 LTS - SOGo | BTS

bugs.sogo.nu

 

[abashurov]

now: nightlys for ubuntu 22.04

0005511: Build packages for Ubuntu 22.04 LTS - SOGo | BTS

bugs.sogo.nu

Index of /nightly/5/ubuntu/dists/jammy

please can you make the nightlys available for plesk users on ubuntu 22.04?

We're looking into it; right now it seems like SOGo developers removed distro for Ubuntu 22.04, as there are no SOGo packages in nightly repo:

❯ curl -s https://packages.sogo.nu/nightly/5/ubuntu/dists/focal/focal/binary-amd64/Packages | grep -c sogo
15
❯ curl -s https://packages.sogo.nu/nightly/5/ubuntu/dists/jammy/jammy/binary-amd64/Packages | grep -c sogo
0

Hence, right now apt on Ubuntu 22.04 will install OS-provided 5.5.1 even if the nightly repos were configured.

 

[AYamshanov]

Hi,

please can you make the nightlys available for plesk users on ubuntu 22.04?

It seems the repository is now contain required packages, a small update of the extension has been published,

Changes​

0.2.1 (1 March 2023)​

• [+] Added support for nightly packages on Ubuntu 22.04.

 

[Achim Drees]

when I try to install the nightly under ubuntu 22.04 the following error is showing:

Long task executor: id=11755 completed with error: Command 'package' execution failed with exit code 1: [stdout: ] [stderr: ERROR:__main__:Command '['apt-get', '-q', '--assume-yes', '-o', 'Dpkg::Options::=--force-confdef', '-o', 'Dpkg::Options::=--force-confold', '-o', 'APT::Install-Recommends=no', '--purge', 'install', 'sogo', 'sogo-common']' returned non-zero exit status 100.
stdout: Reading package lists...
Building dependency tree...
Reading state information...
The following packages were automatically installed and are no longer required:
liboath0 libsope1
Use 'apt autoremove' to remove them.
The following additional packages will be installed:
libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9 libsope-ldap4.9
libsope-mime4.9 libsope-xml4.9 sope4.9-gdl1-mysql sope4.9-libxmlsaxdriver
Suggested packages:
mysql-server
The following NEW packages will be installed:
libsope-appserver4.9 libsope-core4.9 libsope-gdl1-4.9 libsope-ldap4.9
libsope-mime4.9 libsope-xml4.9 sogo sogo-common sope4.9-gdl1-mysql
sope4.9-libxmlsaxdriver
0 upgraded, 10 newly installed, 0 to remove and 18 not upgraded.
Need to get 0 B/46.5 MB of archives.
After this operation, 112 MB of additional disk space will be used.
(Reading database ...
(Reading database ... 5%
(Reading database ... 10%
(Reading database ... 15%
(Reading database ... 20%
(Reading database ... 25%
(Reading database ... 30%
(Reading database ... 35%
(Reading database ... 40%
(Reading database ... 45%
(Reading database ... 50%
(Reading database ... 55%
(Reading database ... 60%
(Reading database ... 65%
(Reading database ... 70%
(Reading database ... 75%
(Reading database ... 80%
(Reading database ... 85%
(Reading database ... 90%
(Reading database ... 95%
(Reading database ... 100%
(Reading database ... 179764 files and directories currently installed.)
Preparing to unpack .../0-libsope-xml4.9_4.9.r1664.20230301_amd64.deb ...
Unpacking libsope-xml4.9 (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/0-libsope-xml4.9_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/libDOM.so.4.9.24', which is also in package libsope1 5.5.1-1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Preparing to unpack .../1-libsope-core4.9_4.9.r1664.20230301_amd64.deb ...
Unpacking libsope-core4.9 (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/1-libsope-core4.9_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/libEOControl.so.4.9.74', which is also in package libsope1 5.5.1-1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Preparing to unpack .../2-libsope-mime4.9_4.9.r1664.20230301_amd64.deb ...
Unpacking libsope-mime4.9 (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/2-libsope-mime4.9_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/libNGMime.so.4.9.3', which is also in package libsope1 5.5.1-1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Preparing to unpack .../3-libsope-appserver4.9_4.9.r1664.20230301_amd64.deb ...
Unpacking libsope-appserver4.9 (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/3-libsope-appserver4.9_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/GNUstep/SoProducts-4.9/SoCore.sxp/Resources/Info-gnustep.plist', which is also in package libsope1 5.5.1-1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Preparing to unpack .../4-libsope-gdl1-4.9_4.9.r1664.20230301_amd64.deb ...
Unpacking libsope-gdl1-4.9 (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/4-libsope-gdl1-4.9_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/libGDLAccess.so.4.9.63', which is also in package libsope1 5.5.1-1
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Preparing to unpack .../5-libsope-ldap4.9_4.9.r1664.20230301_amd64.deb ...
Unpacking libsope-ldap4.9 (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/5-libsope-ldap4.9_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/libNGLdap.so.4.9.35', which is also in package libsope1 5.5.1-1
Preparing to unpack .../6-sope4.9-libxmlsaxdriver_4.9.r1664.20230301_amd64.deb ...
Unpacking sope4.9-libxmlsaxdriver (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/6-sope4.9-libxmlsaxdriver_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/GNUstep/SaxDrivers-4.9/libxmlSAXDriver.sax/Resources/Info-gnustep.plist', which is also in package libsope1 5.5.1-1
Preparing to unpack .../7-sope4.9-gdl1-mysql_4.9.r1664.20230301_amd64.deb ...
Unpacking sope4.9-gdl1-mysql (4.9.r1664.20230301) ...
dpkg: error processing archive /tmp/apt-dpkg-install-nH7vwf/7-sope4.9-gdl1-mysql_4.9.r1664.20230301_amd64.deb (--unpack):
trying to overwrite '/usr/lib/GNUstep/GDLAdaptors-4.9/MySQL.gdladaptor/MySQL', which is also in package libsope1 5.5.1-1
Selecting previously unselected package sogo.
Preparing to unpack .../8-sogo_5.8.0.20230301-1_amd64.deb ...
Unpacking sogo (5.8.0.20230301-1) ...
Selecting previously unselected package sogo-common.
Preparing to unpack .../9-sogo-common_5.5.1-1_all.deb ...
Unpacking sogo-common (5.5.1-1) ...
Errors were encountered while processing:
/tmp/apt-dpkg-install-nH7vwf/0-libsope-xml4.9_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/1-libsope-core4.9_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/2-libsope-mime4.9_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/3-libsope-appserver4.9_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/4-libsope-gdl1-4.9_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/5-libsope-ldap4.9_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/6-sope4.9-libxmlsaxdriver_4.9.r1664.20230301_amd64.deb
/tmp/apt-dpkg-install-nH7vwf/7-sope4.9-gdl1-mysql_4.9.r1664.20230301_amd64.deb

stderr:E: Sub-process /usr/bin/dpkg returned an error code (1)

]:
0: /opt/psa/admin/plib/Task/Async/Executor.php:46
Task_Async_Executor->execute()
1: /opt/psa/admin/plib/scripts/task-async-executor.php:6

 

[Achim Drees]

sorry, did sudo apt autoremove and now it is ok

 

[Achim Drees]

from plesk changelog:​

SSL It! 1.12.6​

8 March 2023

• Added support for the SOGo Webmail extension.

 

[AYamshanov]

JFYI, a new version of SOGo Webmail has been released!

Changes​

1.0.0 (13 March 2023)​

• [+] We are glad to announce that the SOGo Webmail extension has left beta.

 

[DerSchallwerker]

Hmm… someone too had Problems with SOGo and Litespeed? He only load the Text of the Page. With Apache i get the Full Login. All my normal Sites Are working with litspeed enabled.

 

[Yitzchok Wagner]

Cannot install SOGO on server with mysql 8 as database server (I'm not a developer but from what I can tell, it's because the script to configure it is using the PASSWORD function which was removed from MySQL 8.
Please make the extension compatible with MySQL 8.
Thanks

 

[AYamshanov]

Please make the extension compatible with MySQL 8.

Thank you for the report! To understand the root issue, could you please provide the output of the next three commands:

• plesk version
• plesk db 'SELECT @@VERSION_COMMENT'
• plesk db 'SELECT @@VERSION'

 

[Yitzchok Wagner]

Thank you for the report! To understand the root issue, could you please provide the output of the next three commands:

• plesk version
• plesk db 'SELECT @@VERSION_COMMENT'
• plesk db 'SELECT @@VERSION'

Thanks,
1.
plesk version
Product version: Plesk Obsidian 18.0.50.2
OS version: Ubuntu 22.04 x86_64
Build date: 2023/02/13 12:00
Revision: f4227d4e88b93929163c1468cb5fd589d935a2a
2.
plesk db 'SELECT @@VERSION_COMMENT'
+-------------------+
| @@VERSION_COMMENT |
+-------------------+
| (Ubuntu) |
+-------------------+
3.
plesk db 'SELECT @@VERSION'
+-------------------------+
| @@VERSION |
+-------------------------+
| 8.0.32-0ubuntu0.22.04.2 |

 

[abashurov]

plesk db 'SELECT @@VERSION_COMMENT'
+-------------------+
| @@VERSION_COMMENT |
+-------------------+
| (Ubuntu) |
+-------------------+

Gotcha; this causes non-detection of MySQL 8, because we rely on version_comment to contain either "mysql" or "percona", which is the case with MySQL 8 instances shipped by Oracle. For some reason, Debian maintainers (and Ubuntu maintainers kept this as-is) have decided to only keep the distribution name in this variable, leaving us with no reasonable anchor:

❯ rg COMPILATION_COMMENT debian/rules
93:        -DCOMPILATION_COMMENT="($(DISTRIBUTION))" \

In comparison to the original rules that Oracle uses for their distribution:

packaging/deb-in/rules.in
52:        -DCOMPILATION_COMMENT="MySQL @DEB_PRODUCTNAMEC@ - @DEB_LICENSENAME@" \
53:        -DCOMPILATION_COMMENT_SERVER="MySQL @DEB_PRODUCTNAMEC@ Server - @DEB_LICENSENAME@" \

Looks like we'll have to rethink the heuristic for this check.

 

[Mark_NLD]

We installed SOGo on Plesk 18.0.50. On one domain SOGo works fine but on a additional domain we are greeted with a 404 error.
I am not sure how to start debugging this issue. Anyone has any idea what the cause of this might be?

 

[AYamshanov]

Hi Mark_SQR,

Probably, in this case it is better to contact the Plesk Support team.

 

[Mark_NLD]

Hi Mark_SQR,

Probably, in this case it is better to contact the Plesk Support team.

I was being dumb. The test domain within Plesk was configured for different IP addresses

 

[WebCodePoet]

Hello, we have installed the new SOGo extension a few weeks ago. We are not able to synchronize the calendar to outlook via the CalDavSyncronizer plugin. Outlook can write but not read, if it has written, it will lose the written event while it stays in sogos webend.

The contacts are working fine.

Has anyone the same problem?

 

[salexes]

I have just seen this extension in Plesk and was wondering, since it left beta now, if when using this extension we can use Sogos ActiveSync feature?

Is it supported when using this extension?

 

[AYamshanov]

Is it supported when using this extension?

The "SOGo Webmail" extension helps to get an access to mail account through webmail client. Based on Installation and Configuration Guide, for ActiveSync feature some additional configurations required as well as installing additional packages into system.

All non-standard configurations are not tested, we cannot say that they work and thus we cannot say that they are supported.

For ActiveSync, I would recommend to look at Plesk Premium Email (paid version).