1 Topic by trent3

  • trent3
  • Member
  • Offline
  • Registered: 2014-09-01
  • Posts: 10

Topic: switching from mysql to ldap?

==== Required information ====
- iRedMail version: 0.3.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian 7.6.0
- Related log if you're reporting an issue:
====

I installed iRedMail and am wanting to switch from MySQL over to LDAP.  What would be involved in doing this?   It doesn't necessarily matter if I lose the data in the mail configuration, but can a clean change be done?   Does the php interface look any different under LDAP?

----

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: switching from mysql to ldap?

trent3 wrote:

I installed iRedMail and am wanting to switch from MySQL over to LDAP.  What would be involved in doing this?   It doesn't necessarily matter if I lose the data in the mail configuration, but can a clean change be done?   Does the php interface look any different under LDAP?

Unfortunately, we don't have a clean way to switch backends. But here's references:

*) Password hashes: http://www.iredmail.org/docs/password.hashes.html
You may need to write some scripts to migrate mail accounts, but you won't lose old passwords.

*) Migrate to a new iRedMail server: http://www.iredmail.org/docs/migrate.to … erver.html
You can migrate mailboxes and other application data.

Important note: if you want to migrate mailboxes, please make sure the maildir path stored in SQL/LDAP is same as the one on file system (path to mailboxes).

3 Reply by trent3

  • trent3
  • Member
  • Offline
  • Registered: 2014-09-01
  • Posts: 10

Re: switching from mysql to ldap?

I haven't fully-configured the system so it wouldn't be a problem to lose the  mailbox or other configurations.   What is the easiest way to move over without having to migrate?   Can the packages be un-installed and re-installed?

I'm just getting started with Linux so as detailed info as possible would be appreciated regarding commands. 

ZhangHuangbin wrote:
trent3 wrote:

I installed iRedMail and am wanting to switch from MySQL over to LDAP.  What would be involved in doing this?   It doesn't necessarily matter if I lose the data in the mail configuration, but can a clean change be done?   Does the php interface look any different under LDAP?

Unfortunately, we don't have a clean way to switch backends. But here's references:

*) Password hashes: http://www.iredmail.org/docs/password.hashes.html
You may need to write some scripts to migrate mail accounts, but you won't lose old passwords.

*) Migrate to a new iRedMail server: http://www.iredmail.org/docs/migrate.to … erver.html
You can migrate mailboxes and other application data.

Important note: if you want to migrate mailboxes, please make sure the maildir path stored in SQL/LDAP is same as the one on file system (path to mailboxes).

4 Reply by ZhangHuangbin

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

Re: switching from mysql to ldap?

trent3 wrote:

What is the easiest way to move over without having to migrate?   Can the packages be un-installed and re-installed?

No.

The easiest way is re-installing OS, then install iRedMail if you don't have accounts/mailboxes need to migrate.

5 Reply by trent3

  • trent3
  • Member
  • Offline
  • Registered: 2014-09-01
  • Posts: 10

Re: switching from mysql to ldap?

wow, really?   re-install the os?

So can you give me an indication of whether this is something that should be done?  What are the pros/cons of mysql verses LDAP?

6 Reply by ZhangHuangbin

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

Re: switching from mysql to ldap?

For iRedMail, no big difference between MySQL/PostgreSQL/OpenLDAP. But you should consider how to maintain them. Which one is easier (for you) to maintain?