1 Topic by azad_e_s

  • azad_e_s
  • Member
  • Offline
  • Registered: 2011-06-28
  • Posts: 7

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 Reply by ZhangHuangbin

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

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 Reply by azad_e_s

  • azad_e_s
  • Member
  • Offline
  • Registered: 2011-06-28
  • Posts: 7

Re: Importing user/accounts from an existing mail system

Thank you very much. I will look into it

4 Reply by azad_e_s

  • azad_e_s
  • Member
  • Offline
  • Registered: 2011-06-28
  • Posts: 7

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 Reply by ZhangHuangbin

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

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 Reply by azad_e_s

  • azad_e_s
  • Member
  • Offline
  • Registered: 2011-06-28
  • Posts: 7

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?