1 Topic by murali

  • murali
  • Member
  • Offline
  • Registered: 2019-01-25
  • Posts: 38

Topic: SOGO is not showing mailbox after restoring

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.5.2
- Deployed with iRedMail Easy or the downloadable installer?Downloadable Installer
- Linux/BSD distribution name and version: Debia 11
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
We have upgraded our os from debian 10 to 11 and installed iredmail 1.5.2 and upgraded to  iRedAdmin-Pro-SQL-5.1. After we restore our vmail and sogo db from old backup to the new iredadmin, sogo is not showing the mailbox . We tried to update the settings for sogo from admin panel for users and it gives the  below error
Error: InternalError(1054, "Unknown column 'enablesogoactivesync' in 'field list'").

Any help would be appreciated.
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 Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: SOGO is not showing mailbox after restoring

when you restore an old database which has a different database structure, you need to run the database update script afterwards

since it is related to enablesogoactivesync, i guess this is the correct one:

https://docs.iredmail.org/upgrade.iredm … 1.4.2.html
-> https://raw.githubusercontent.com/iredm … mail.mysql


since the column is unknown, you aswell need to use the script which added it.

you need to know which release you had when you made a backup and then update one by one to the newest to get it to work