1 Topic by pnjo23

  • pnjo23
  • Member
  • Offline
  • Registered: 2017-02-11
  • Posts: 46

Topic: Migrate LDAP to Mysql

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.97
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Is it possible to migrate user accounts+passwords+mailboxes from LDAP to MYSQL backend?

----

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

Re: Migrate LDAP to Mysql

Sure, but you need to write some shell/python/perl/... scripts to convert and migrate the mail accounts first.

3 Reply by pnjo23

  • pnjo23
  • Member
  • Offline
  • Registered: 2017-02-11
  • Posts: 46

Re: Migrate LDAP to Mysql

ZhangHuangbin wrote:

Sure, but you need to write some shell/python/perl/... scripts to convert and migrate the mail accounts first.

Right, how does one do that? Any guide available?

4 Reply by ZhangHuangbin

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

Re: Migrate LDAP to Mysql

pnjo23 wrote:

Any guide available?

Unfortunately, no.

You need to convert/migrate each LDAP attribute/value pair to SQL column/value.