mirror of
https://github.com/iredmail/iRedMail
synced 2026-06-08 14:51:59 +00:00
Zhang Huangbin
87eb9c27dd
- Ubuntu 24.04 - OpenBSD 7.5 Dropped distribution releases: - Debian 11 (bullseye). Please use the latest stable release Debian 12. - Ubuntu 20.04 (focal). Please use the latest stable release Ubuntu 24.04 (recommended) or 22.04 instead. - OpenBSD 7.3, 7.4. Please use 7.5 instead. Improvements: - Disable multi-threaded database reload in ClamAV (with parameter "ConcurrentDatabaseReload no"). Updated packages: + netdata -> 1.45.4 + mlmmjadmin -> 3.2.1 + iRedAPD -> 5.6.0 + uwsgi -> 2.0.25.1 (OpenBSD only)
35 lines
1.2 KiB
SQL
35 lines
1.2 KiB
SQL
-- Connect as vmailadmin
|
|
-- \c PH_VMAIL_DB_NAME PH_VMAIL_DB_ADMIN_USER;
|
|
\c PH_VMAIL_DB_NAME;
|
|
|
|
-- Add your first domain
|
|
INSERT INTO domain (domain, transport, settings, created)
|
|
VALUES ('PH_FIRST_DOMAIN', 'PH_TRANSPORT', 'default_user_quota:1024;', NOW());
|
|
|
|
-- Add your first normal user
|
|
INSERT INTO mailbox (username,
|
|
password,
|
|
name,
|
|
maildir,
|
|
quota,
|
|
domain,
|
|
isadmin,
|
|
isglobaladmin,
|
|
created)
|
|
VALUES ('PH_DOMAIN_ADMIN_EMAIL',
|
|
'PH_DOMAIN_ADMIN_PASSWD_HASH',
|
|
'PH_DOMAIN_ADMIN_NAME',
|
|
'PH_DOMAIN_ADMIN_MAILDIR_HASH_PART',
|
|
1024,
|
|
'PH_FIRST_DOMAIN',
|
|
0,
|
|
1,
|
|
NOW());
|
|
|
|
INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)
|
|
VALUES ('PH_DOMAIN_ADMIN_EMAIL', 'PH_DOMAIN_ADMIN_EMAIL', 'PH_FIRST_DOMAIN', 'PH_FIRST_DOMAIN', 1);
|
|
|
|
-- Mark first mail user as global admin
|
|
INSERT INTO domain_admins (username, domain, created)
|
|
VALUES ('PH_DOMAIN_ADMIN_EMAIL', 'ALL', NOW());
|