1 Topic by yaroslavkhmel

  • yaroslavkhmel
  • Member
  • Offline
  • Registered: 2022-05-04
  • Posts: 25

Topic: how to modify the create_mail_user_SQL.sh

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

We need to add Display Name while using the create_mail_user_SQL.sh

For example the email address is user.001@domain.mail
While the Display name is            User 001
at the moment we can use the create_mail_user_SQL.sh to create a billion users but without display names the email will come from user.001 so we must go in and manually create a billion Display names?

Next question is, is it possible to automatically create Filter rules and Forward rules for all users using a create_mail_user_SQL.sh script??

Thank you.

----

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

2 Reply by yaroslavkhmel

  • yaroslavkhmel
  • Member
  • Offline
  • Registered: 2022-05-04
  • Posts: 25

Re: how to modify the create_mail_user_SQL.sh

I guess the other option is for me to learn how to batch change the "name" in the "mailbox" table, of the "vmail" database.

3 Reply by yaroslavkhmel

  • yaroslavkhmel
  • Member
  • Offline
  • Registered: 2022-05-04
  • Posts: 25

Re: how to modify the create_mail_user_SQL.sh

I used the excel to generate the mysql command.

update mailbox set name='User 001' where name='user.001';
update mailbox set name='User 002' where name='user.002';
update mailbox set name='User 003' where name='user.003';
update mailbox set name='User 004' where name='user.004';
update mailbox set name='User 005' where name='user.005';
update mailbox set name='User 006' where name='user.006';
update mailbox set name='User 007' where name='user.007';
update mailbox set name='User 008' where name='user.008';
update mailbox set name='User 009' where name='user.009';
update mailbox set name='User 010' where name='user.010';

etc