1 Topic by sscanavini

  • sscanavini
  • Member
  • Offline
  • Registered: 2022-02-06
  • Posts: 1

Topic: SoGo not showing emails after restore

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.5.1
- Deployed with iRedMail Easy or the downloadable installer? Downloadable Installer
- Linux/BSD distribution name and version: Ubuntu 20.04
- 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.
====

I finished to restore my mail server from an Ubuntu 16.04. I backupped all SQL files as shown in the procedure and restored them in the SQL database (apart from mysql database).

Now I'm able to log in SoGo but I see only the contacts, no email is present on the mailboxes.

I also moved the old vmail1 folder in the new one, but nothing changes.

Here is what I see: https://imgur.com/a/ZyyHkIS (sorry for the italian)

What did I do wrong?

----

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

2 Reply by d.payet (edited by d.payet 2022-02-08 16:23:30)

  • d.payet
  • Member
  • Offline
  • Registered: 2020-11-24
  • Posts: 15

Re: SoGo not showing emails after restore

Hello,

i think we have the same problem smile ( https://forum.iredmail.org/topic18733-m … -sogo.html )

The issue come from the view creation which doesn't insert the c_webmail column. Perhaps a answer today  smile

Edit : change your request to : 

CREATE VIEW users (c_uid, c_name, c_password, c_cn, mail, domain, c_webmail, c_calendar, c_activesync) AS SELECT username, username, password, name, username, domain, enablesogowebmail, enablesogocalendar, enablesogoactivesync FROM vmail.mailbox WHERE enablesogo=1 AND active=1;

(works for me)