1

Topic: Cannot log into iredadmin

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  0.9.7
- Linux/BSD distribution name and version:  Ubuntu 16.04.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro?  no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

I know this has been asked before.   Suddenly after months of smooth operation I cannot log into my admin panel.  INVALID CREDENTIALS.   Just happened yesterday.    I am looking fo the simplest approach.   I see many answers that are quite complex.  I tried CLI MYSQL changes.  Nothing.   The server works fine.  I just can log into the Admin panel

Is this a certificate problem?
[Fri Nov 17 06:25:04.416599 2017] [ssl:warn] [pid 1475] AH01909: myserver.com:443:0 server certificate does NOT include an ID which matches the server name

----

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

2 (edited by bodywise 2017-11-20 05:01:49)

Re: Cannot log into iredadmin

Waiting for an answer.   I answered my own question.    So often it is a simple answer or routine, while buried deep in the docs.

go to https://yourserver.com/phpmyadmin.   Database vmail   Table mailbox.  "Search" for your login name and the response will contain the password.    User and Password fields.

or -- SSH and CLI to generate a new password (very strong)

$ doveadm pw -s 'ssha512' -p '123456'
{SSHA512}jOcGSlKEz95VeuLGecbL0MwJKy0yWY9foj6UlUVfZ2O2SNkEExU3n42YJLXDbLnu3ghnIRBkwDMsM31q7OI0jY5B/5E=

followed by:

Mysql> USE vmail;
Mysql> UPDATE mailbox SET password='{SSHA512}jOcGSlKEz95VeuLGecbL0MwJKy0yWY9foj6UlUVfZ2O2SNkEExU3n42YJLXDbLnu3ghnIRBkwDMsM31q7OI0jY5B/5E=' WHERE username='user@domain.ltd';

Either way works.  CLI or directly in the database (which I find more visual).