Topic: Adding Sogo on Ubuntu 22.04
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Dear all,
I tried to add SOGO to my current Ubuntu 22.04 installation. It bases originally on iRedMail version 1.6.2 and was continuously updated to the currently most recent version 1.6.8. It is the LDAP version.
For this I read through the following two main documents:
forum.iredmail.org/topic10440-installation-of-sogo-after-initial-install.html and
docs.iredmail.org/sogo-centos-6-mysql.html
As it was not clear to me if I need to download the full installer of iRedmail 1.6.8 for adding the new feature, I decided to go with the manual one basing on CentOS6 and altering the corresponding information.
So I added the repository in a way, that overcomes the "apt-key depreciated" issue in Ubuntu 22.04. Also the repository installation on the Sogo website didn't fully support me:
sudo wget -O- "keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9" | sudo gpg --dearmor | sudo tee /usr/share/keyrings/sogo_nightly.pgpand created a sogo.list file in /etc/apt/sources.list.d/ containing
deb [signed-by=/usr/share/keyrings/sogo_nightly.gpg] packages.sogo.nu/nightly/5/ubuntu/ jammy jammyThis links the repository to the corresponding keyfile for security reasons.
Now, things started to become tricky. For CentOS6, the following packages were supposed to be installed:
sogo sope49-gdl1-mysql sogo-activesync sogo-ealarms-notify sogo-tool
Only sogo and sogo-activesync have been found in the current Ubuntu repository. Nevertheless I continued.
Now, when creating the database, the following commands after generating the database are provided:
GRANT SELECT ON vmail.mailbox TO sogo@localhost; CREATE VIEW sogo.users (c_uid, c_name, c_password, c_cn, mail, domain) AS SELECT username, username, password, name, username, domain FROM vmail.mailbox WHERE enablesogo=1 AND active=1;
Actually in my installation, (LDAP) there is no vmail database existing or it is at least not listed to me when showing me all databases.
So, how can / should I continue?
I hope, with all the explanation, I showed that I was digging into the topic for quite a while by myself before asking for help.
P.S.: As no urls are allowed in the forum any more, I had to remove all https in front of the internet addresses. So the code is not always complete.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.