1 Topic by d.payet

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

Topic: Migration and SOGo

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

Hello,

i'm migrating a iredmail installation to another server. I've read the tutorial to migrate but there is a problem with SOGo, users have not all features (no mail, no calendar).
When i create the views, i see there is no field "c_webmail" "c_calendar" "c_activesync"
Can we add it simply ?

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

Re: Migration and SOGo

You'd better upgrade the SQL structure to the latest iRedMail version first, then you get the sql columns in "vmail.mailbox" which are used to map to "c_webmail", "c_calendar", "c_activesync".

3 Reply by d.payet

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

Re: Migration and SOGo

hello,

it's already the last version, or I've missed something (which is possible smile ).
It's not on the "create view" part ?

Thanks

4 Reply by d.payet (edited by d.payet 2022-02-08 16:24:03)

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

Re: Migration and SOGo

I think i've found the solution. According to the doc, changing the 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;

does the job.

Thanks