1 Topic by KNERD

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Topic: SoGo post install after setup

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

So I got another mail server I set up a while back. When selecting SoGO, the install would fail due to some dependencies in the repos it could not find. To resolve this in the meantime, I just unselected SoGo from the install.

I see one thread on this subject, but it is from 2016 for version 0.9.3, and the advised method is no longer valid as there is no "/root/iRedmail-0.9.8/config" file located there as the thread mentions. I do see a "conf" folder filled with various files.

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

Re: SoGo post install after setup

In this case, it's better to install SOGo manually.

3 Reply by KNERD (edited by KNERD 2019-03-02 03:50:14)

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

Yes, I figured that, but your guide on doing the manual install is a bit outdated, and only covers CentOS 6, if I am not mistaken.

4 Reply by ZhangHuangbin

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

Re: SoGo post install after setup

Yes it's kind of outdated, but the whole procedure is still same, just replace 'yum' by 'apt/apt-get'. smile

5 Reply by KNERD

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

Okay, thanks a bunch! I will give it a try

6 Reply by KNERD

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

ZhangHuangbin wrote:

Yes it's kind of outdated, but the whole procedure is still same, just replace 'yum' by 'apt/apt-get'. smile


Actually VERY outdated,

From  the SoGO site:


"This repository hosts official binary packages for SOGo and PacketFence software, provided by Inverse inc.

Note that from 2016/07/19 onwards, Inverse will not publicly offer official SOGo releases as binaries anymore; non-customers still can build from source or get the nightly builds from the SOGo nightly repository."

7 Reply by KNERD (edited by KNERD 2019-03-16 06:31:56)

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

I did find a repo helper at the bottom of the download page at https://sogo.nu/download.html

For Debian 9 it shows (dirmngr must be installed),

gpg --keyserver keys.gnupg.net --recv-key 0x810273C4
gpg --armor --export 0x810273C4 | sudo apt-key add -
sudo apt-get update
sudo apt-get install apt-transport-https
sudo tee /etc/apt/sources.list.d/SOGo.list <<EOF
deb https://packages.inverse.ca/SOGo/nightly/4/debian/ stretch stretch
EOF
sudo apt-get update
sudo apt-get install sogo

8 Reply by KNERD (edited by KNERD 2019-03-16 07:33:02)

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

Can you check your guide for outdated information?? 

https://docs.iredmail.org/sogo-centos-6 … l-database


Create required SQL database

GRANT SELECT ON vmail.mailbox TO sogo@localhost;

MariaDB [(none)]> GRANT SELECT ON vmail.mailbox TO sogo@localhost;
ERROR 1146 (42S02): Table 'vmail.mailbox' doesn't exist


Are there some tables we should of created, or some script to do it for us?

The database vmail does not even exist

Thank you

9 Reply by ZhangHuangbin

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

Re: SoGo post install after setup

If you're running MySQL/MariaDB backend, table "vmail.mailbox" MUST be present, because it's used to store mail domains and accounts.

10 Reply by KNERD

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

I could of made a mistaken and accidentally chosen another database. I know I should have chosen MySQL/MariaDB. How can I be sure of which one I chose? The .tips file is not of much use on that issue.

11 Reply by ZhangHuangbin

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

Re: SoGo post install after setup

Run "postconf smtpd_sender_login_maps", do you see string "proxy:ldap:" or "proxy:mysql:" in the output?

12 Reply by KNERD (edited by KNERD 2019-03-21 12:01:32)

  • KNERD
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 68

Re: SoGo post install after setup

Yes, i got the LDAP response.

Thank you Kindly