1

Topic: how to save box's password as plaintext in mysql db

==== Provide required information to help troubleshoot and get quick answer ====
- Linux/BSD distribution name and version: centos 5.5
- iRedMail version and backend (LDAP/MySQL): mysql
- Any related log? Log is helpful for troubleshooting.
==

Out of security , I need to know each  box's password which stored in mysql db as encrypted  format.

How can I set to change the encrypted PW to plaintext ? thanks a lot .

2

Re: how to save box's password as plaintext in mysql db

With MySQL backend, all passwords are hashed as MD5.
If you want to store plain password for NEWLY created account or after resetting password, please see below setting in libs/settings.py:

# Allow to store password in plain text.
# It will show a HTML checkbox to allow admin to store newly created user
# password or reset password in plain text. If not checked, password
# will be stored as encrypted.
# See LDAP_DEFAULT_PASSWD_SCHEME and SQL_DEFAULT_PASSWD_SCHEME below.
STORE_PASSWORD_IN_PLAIN = False

Set STORE_PASSWORD_IN_PLAIN to True is what you need.

WARNING: It's NOT recommended to store password in plain text, especially on a production server.