1 Topic by eng.hnaseri

  • eng.hnaseri
  • Member
  • Offline
  • Registered: 2019-06-13
  • Posts: 5

Topic: Forgot my username and password for iredamin panel

I have forgotten my username and password for the admin pannel. I also used this topic to change it however I  am not able to login with new username

https://forum.iredmail.org/topic11159-i … admin.html

Can someone help me to find my username and update its password?

----

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

2 Reply by eng.hnaseri (edited by eng.hnaseri 2019-06-13 21:30:03)

  • eng.hnaseri
  • Member
  • Offline
  • Registered: 2019-06-13
  • Posts: 5

Re: Forgot my username and password for iredamin panel

MariaDB [(none)]>  USE vmail;
MariaDB [vmail]>  INSERT INTO domain_admins (username, domain) VALUES ('postmaster@mydomain.com', 'ALL');
Query OK, 1 row affected (0.00 
MariaDB [vmail]> UPDATE mailbox SET password='{PLAIN}12345' WHERE username='postmaster@mydomain.com';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

This is my code, However I still cant login

3 Reply by eng.hnaseri

  • eng.hnaseri
  • Member
  • Offline
  • Registered: 2019-06-13
  • Posts: 5

Re: Forgot my username and password for iredamin panel

Can someone help me?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Forgot my username and password for iredamin panel

eng.hnaseri wrote:

MariaDB [vmail]> UPDATE mailbox SET password='{PLAIN}12345' WHERE username='postmaster@mydomain.com';

Please also set column "isglobaladmin=1" for this user.

5 Reply by eng.hnaseri

  • eng.hnaseri
  • Member
  • Offline
  • Registered: 2019-06-13
  • Posts: 5

Re: Forgot my username and password for iredamin panel

ZhangHuangbin wrote:
eng.hnaseri wrote:

MariaDB [vmail]> UPDATE mailbox SET password='{PLAIN}12345' WHERE username='postmaster@mydomain.com';

Please also set column "isglobaladmin=1" for this user.

yes I already did that by

UPDATE mailbox SET isadmin=1, isglobaladmin=1 WHERE username='postmaster@mydomain.com';

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Forgot my username and password for iredamin panel

does it work now?

7 Reply by eng.hnaseri

  • eng.hnaseri
  • Member
  • Offline
  • Registered: 2019-06-13
  • Posts: 5

Re: Forgot my username and password for iredamin panel

ZhangHuangbin wrote:

does it work now?

Unfortunately No. I'm still not able to login to my pannel.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Forgot my username and password for iredamin panel

Could you please try again with steps below:

- Reset user password: https://docs.iredmail.org/reset.user.password.html
- Promote user to be a global admin: https://docs.iredmail.org/promote.user. … admin.html