1 (edited by pasaisea 2015-12-15 19:18:08)

Topic: Accidentally deleted postmaster@olddomain Cannot login to iRedAdmin

==== Required information ====
- iRedMail version (check /etc/iredmail-release):  0.9.2
- Linux/BSD distribution name and version: Ubuntu 15.10
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Free
- Related log if you're reporting an issue:
====

I usually can login to https://domain/iredadmin using postmaster@olddomain but I decided want to delete the old domain and use the new one. But before that, I create a new user email in new domain and created admin based on that new user too. Then I deleted all the old domain and the result was postmaster@olddomain was deleted too.

I can login to webmail using the newuser@newdomain.com credential but I CANNOT login to https://domain/iredadmin using the newuser@newdomain.com that I have setup as admin. both user and admin has the precise email and password yet i cannot login in iredadmin.

I have edited the newuser in vmail.mailbox in MySQL

isadmin=1
isglobaladmin=1

vmail.domain_admins newuser was already set to ALL

even I copied the vmail.mailbox.newuser MD5 password {CRYPT}$1$RscZ37kQ$bNbkFSKlWDkfPYciUixls/ to vmail.admin.newuser and it still not worked.

Everytime i tried to login to iredadmin using the newuser always failed

msg=INVALID_CREDENTIALS

---

I also tried using the terminal sudo iRedMail-0.9.2/tools/create_mail_user_SQL.sh but it returns "Command not found"

Please help

----

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

2

Re: Accidentally deleted postmaster@olddomain Cannot login to iRedAdmin

Follow this tutorial to create a new mail user:
http://www.iredmail.org/docs/sql.bulk.c … users.html

Login to SQL server, update table `vmail.mailbox` to mark this new user as global admin:

sql> UPDATE mailbox SET isadmin=1,isglobaladmin=1 WHERE username='new_email_address';

Add new record in sql table `vmail.domain_admins` (of course you should replace `new_email_address` below by the real email address):

sql> INSERT INTO domain_admins (username, domain) VALUES ('new_email_address', 'ALL');

Now you can login to iRedAdmin-Pro as global admin with this newly created user.

3

Re: Accidentally deleted postmaster@olddomain Cannot login to iRedAdmin

Thank Goodness this solution works. I was almost crying because I cannot login to iredadmin. Thank you so much for the tutorial

4

Re: Accidentally deleted postmaster@olddomain Cannot login to iRedAdmin

I published this tip as a short tutorial here:
http://www.iredmail.org/docs/sql.mark.u … admin.html

[topic closed]