Hello, @erounion
The passwords are not saved in plain-text due to security reasons. The passwords are encrypted with either SSHA512 or MD5 hash.
If you do not remember your password your can reset it by following iredmail’s official documentation:
https://docs.iredmail.org/reset.user.password.html
Reset password with SQL/LDAP command line
To generate password hash for new password, please use doveadm command.
Generate a SSHA512 password hash:
doveadm pw -s 'ssha512' -p '123456'
{SSHA512}jOcGSlKEz95VeuLGecbL0MwJKy0yWY9foj6UlUVfZ2O2SNkEExU3n42YJLXDbLnu3ghnIRBkwDMsM31q7OI0jY5B/5E=
Note: Replace 123456
with the actual password you want to use
To reset password for user user@domain.ltd, please login to SQL server as either SQL root user or vmailadmin user (note: sql user vmail has read-only privilege to vmail database, so you cannot use it to change user password), then execute SQL commands to reset password:
sql> USE vmail;
sql> UPDATE mailbox SET password='{SSHA512}jOcGSlKEz95VeuLGecbL0MwJKy0yWY9foj6UlUVfZ2O2SNkEExU3n42YJLXDbLnu3ghnIRBkwDMsM31q7OI0jY5B/5E=' WHERE username='user@domain.ltd';
You can also check the other methods listed in the docs.
Hope that this helps!
Regards,
Alex