1

Topic: How email alias without iredadmin pro

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): rocky linux 8
- Deployed with iRedMail Easy or the downloadable installer? download installer
- Linux/BSD distribution name and version: rocky linux 8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Dear All,

I deployed new iredmail server through download installer on Rocky Linux 8.7 with MySQL backend without iRedAdmin-Pro

My problem is that how can i create email alias  to send email to all users and i am running more than 500 users.

i am creating email alias through this command:
INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_list, active) VALUES ('all@example.com', 'someone@example.com', 'example.com', 'example.com', 1, 1);

Above command is working with single target but i want to add more receipient through single command.

Please guide.

Regards
Linuxtechguy

----

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

2

Re: How email alias without iredadmin pro

Search "SQL:" here: https://docs.iredmail.org/

3

Re: How email alias without iredadmin pro

I solved my problem through this command

INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_list, active)
select 'all@example.org', address, 'exampl.org', 'example.org', 1, 1 from forwardings;