1 Topic by whelpton

  • whelpton
  • Member
  • Offline
  • Registered: 2012-10-02
  • Posts: 5

Topic: Mysql storage password formats

Hi all,

I'm trying to create a php script that will add users to the mysql DB on the fly, I'm not too familiar with encryption types and have no idea what kindof encryption the password fields use, can you fill me in on this?

Thanks!

==== Required information ====
- iRedMail version: 0.8.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Linux/BSD distribution name and version: Centos 6
- Related log if you're reporting an issue: N/A
====

----

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: Mysql storage password formats

iRedMail stores (salted) MD5 encrypted passwords for MySQL and PostgreSQL backends by default. Example:

$1$ozdpg0V0$0fb643pVsPtHVPX8mCZYW/

- Plain MD5 is supported too. Example: 900150983cd24fb0d6963f7d28e17f72, {PLAIN-MD5}900150983cd24fb0d6963f7d28e17f72.
- Plain password is supported, but it's not recommended. Don't use it on production server.
- Upcoming iRedAdmin (both open source edition and iRedAdmin-Pro) supports SSHA and SSHA512 encrypted passwords.
  Reference: http://www.iredmail.org/forum/topic4220 … ha512.html

Refer to Dovecot wiki for more password schemes: http://wiki2.dovecot.org/Authentication/PasswordSchemes

3 Reply by whelpton

  • whelpton
  • Member
  • Offline
  • Registered: 2012-10-02
  • Posts: 5

Re: Mysql storage password formats

Thanks dude! Got it working smile