1

Topic: Importing user/accounts from an existing mail system

Hi,

How do I import users/mail accounts from an existing mail system. What if I have a CSV file with all the names and passwords of users? I don't want to create all my users (more than 500) one by one. Will a mere import into MySQL database will do the job?

Please advice

Thanks in advance

Azad

----

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

2

Re: Importing user/accounts from an existing mail system

Here's sample script used to create new mail users for MySQL backend, you can modify it to fit your need:
http://code.google.com/p/iredmail/sourc … r_MySQL.sh

3

Re: Importing user/accounts from an existing mail system

Thank you very much. I will look into it

4

Re: Importing user/accounts from an existing mail system

ZhangHuangbin wrote:

Here's sample script used to create new mail users for MySQL backend, you can modify it to fit your need:
http://code.google.com/p/iredmail/sourc … r_MySQL.sh


What kind of password hashing are you using? It doesn't seem like MD5

5

Re: Importing user/accounts from an existing mail system

Search 'CRYPT_PASSWD' in that file, it's created by command:

# openssl passwd -1 'PLAIN_PASSWD'

6

Re: Importing user/accounts from an existing mail system

ZhangHuangbin wrote:

Search 'CRYPT_PASSWD' in that file, it's created by command:

# openssl passwd -1 'PLAIN_PASSWD'

Yeah I saw that. I was trying to create an interface for mailbox database in Delphi. The MD5 I generate with Delphi is different from OpenSSL's MD5. Do you have any idea how to do that in Delphi?