Create an iRedMail Domain Admin: Difference between revisions
From KlavoWiki
Jump to navigationJump to search
Created page with "To create an administrator that can only administer a particular domain. Create the user as normal. As an example we'll create a user called her@justme.com. Once the user h..." |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
To | To allow an account to administrator a specific or group of domains. Firstly create the user as normal. As an example we'll create a user called her@justme.com. Once the user has been created: | ||
= Open Database = | |||
Open SQL CLI into vmail database. | Open SQL CLI into vmail database. | ||
<pre> | <pre> | ||
| Line 6: | Line 7: | ||
</pre> | </pre> | ||
= Set user as Admin = | |||
Set the isadmin parameter for the required user. | Set the isadmin parameter for the required user. | ||
Changing the isadmin to 0 would mean the user can no longer administer domains even though the user is still listed in the domain_admins table. | |||
<pre> | <pre> | ||
update mailbox set isadmin=1 where username='her@justme.com'; | update mailbox set isadmin=1 where username='her@justme.com'; | ||
</pre> | </pre> | ||
= Define which domains can be administed = | |||
Set the user as a domain admin. | Set the user as a domain admin. | ||
<pre> | <pre> | ||
| Line 16: | Line 21: | ||
</pre> | </pre> | ||
[[Category : | Adding multiple entries for the same user for different domains allows the user to manage multiple domains. | ||
<pre> | |||
insert into domain_admins (username, domain, created) values('her@justme.com', 'justme.com', now()); | |||
insert into domain_admins (username, domain, created) values('her@justme.com', 'another.com', now()); | |||
</pre> | |||
The user her@justme.com can now administer accounts in the domains justme.com and another.com. | |||
It also means that a user account within one domain can administer another domain. | |||
[[Category : iRedMail]] | |||
Latest revision as of 09:27, 5 July 2016
To allow an account to administrator a specific or group of domains. Firstly create the user as normal. As an example we'll create a user called her@justme.com. Once the user has been created:
Open Database
Open SQL CLI into vmail database.
mysql -pMyLongandComplexSQLPassword vmail
Set user as Admin
Set the isadmin parameter for the required user.
Changing the isadmin to 0 would mean the user can no longer administer domains even though the user is still listed in the domain_admins table.
update mailbox set isadmin=1 where username='her@justme.com';
Define which domains can be administed
Set the user as a domain admin.
insert into domain_admins (username, domain, created) values('her@justme.com', 'justme.com', now());
Adding multiple entries for the same user for different domains allows the user to manage multiple domains.
insert into domain_admins (username, domain, created) values('her@justme.com', 'justme.com', now());
insert into domain_admins (username, domain, created) values('her@justme.com', 'another.com', now());
The user her@justme.com can now administer accounts in the domains justme.com and another.com.
It also means that a user account within one domain can administer another domain.
