ce364bc2d2
Switch row format of vmail.mailbox to Dynamic.
2025-04-30 17:40:07 +08:00
53aa23550e
Introduce new ldap schema, new columns in vmail.mailbox, vmail.deleted_mailboxes, iredadmin.deleted_mailboxes.
2025-03-22 17:34:05 +08:00
b08499bb2b
Typo
2024-12-29 12:42:37 +08:00
6955128785
Switch to utf8mb4 / utf8mb4_general_ci. fixes #278
...
Fix incorrect py version and pip3 path on OpenBSD 7.6.
2024-12-24 15:31:10 +08:00
3c16c7eca9
Revert last commit.
2024-08-15 10:31:08 +08:00
2b2204ba25
Fixed: Add missing index for SQL column msgs.policy in Amavisd SQL database.
2024-08-15 10:22:10 +08:00
6b3d16cdca
Fix incorrect owner of newly created PgSQL table: fail2ban.jails.
2024-07-25 10:24:55 +08:00
a08e8297a0
Fixed: Amavisd cannot save mail subject longer than 255 characters in MariaDB.
2024-07-22 15:08:25 +08:00
3c400ee07f
New files: update/1.7.0/fail2ban.{mysql,pgsql}.
2024-05-24 15:20:35 +08:00
f8665519d3
Rename dir: update/1.7.0/ -> 1.6.3.
2023-05-23 11:43:45 +08:00
28dd5eb429
Fix an incorrect regular expression while updating mlmmjadmin config file.
2022-09-07 20:25:51 +08:00
f9df65b71f
Fixed: [CentOS] Not install cyrus-sasl packages which causes Postfix doesn't support PLAIN auth.
2022-09-01 22:57:36 +08:00
7d8debfda0
Fixed: not set correct owner for sql table 'maillist_owners'.
2022-07-19 09:25:31 +08:00
c003b2d763
Fix incorrect pgsql ALTER COLUMN statements.
2022-03-18 13:36:58 +08:00
fda3ef4687
Add a comment line.
2022-03-17 12:22:09 +08:00
215ce24963
[SOGo] Create SQL VIEW in vmail database, so that end users can change their own passwords.
2022-03-17 12:12:22 +08:00
3d8f7d5f9a
Fixed: [MySQL] Can not remove record which contains non-ascii character from table domain_admins with unexpected collate.
2022-01-14 13:04:14 +08:00
8ac085979c
Fix incorrect sql column types in vmail.mailbox and sogo.users tables.
...
Remove unused sql columns: mailbox.lastlogin{date,ipv4,protocol}.
Remove unused LDAP attribute: lastLogin{Date,IP,Protocol}.
2021-09-13 11:02:44 +08:00
c49dd2de19
Fix incorrect pgsql column type.
2021-09-13 10:28:46 +08:00
bec2d22fe5
Remove 'IF NOT EXISTS' in sql commands.
2021-09-13 09:27:34 +08:00
b515c31b51
Fix incorrect ldap attribute values.
2021-09-09 01:48:26 +08:00
61c593f9e5
Fix incorrect pgsql syntax error.
...
Add sql snippet file used to re-create SOGo SQL VIEW.
2021-09-01 14:28:47 +08:00
ad02f81a9a
Replace varchar(1) by char(1).
2021-09-01 13:41:44 +08:00
fd24c5b2d4
Fix incorrect column types.
2021-09-01 13:38:04 +08:00
f99d976121
Update sogo.conf to enable service control. fixes #124
2021-09-01 11:20:19 +08:00
ad820325c5
+ Introduce new LDAP attribute/value pairs and SQL columns used to
...
enable or disable per-user SOGo webmail, calendar and activesync
services.
+ Update iRedAPD to 5.0.3.
2021-09-01 11:05:48 +08:00
3b22086cc3
Bypass Amazon EC2 HELO hostnames.
...
Detect old service before adding missing ones while updating LDAP data for Dovecot 2.3. fixes #121
2021-06-04 12:32:51 +08:00
8130bf5ed9
Correct quote marks in update/1.4.0/iredmail.pgsql ( #119 )
2021-04-19 13:52:12 +08:00
eeb27ac74e
Bump version number: 1.4.0. We're ready.
...
Add missing SQL index in MariaDB, remove duplicate index in PostgreSQL.
2021-04-02 16:46:17 +08:00
4960c376cf
Typo in ChangeLog file and rename directory (update/1.4/ -> update/1.4.0/).
2021-02-28 14:09:28 +08:00
d6313a44b3
SQL backends: Drop 4 unused SQL columns in vmail.mailbox table:
...
- allowedsenders
- rejectedsenders
- allowedrecipients
- rejectedrecipients
pkgs/get_all.sh: Install all missed packages in one command instead of installing one each time.
2021-02-25 18:33:54 +08:00
7eae4a496a
Upgrade netdata to 1.29.3.
...
Add update/1.4/iredmail.{my,pg}sql.
2021-02-24 10:42:34 +08:00
9a3ced9518
- Fixed: tools/backup_pgsql.sh: Not dump databases with --clean argument.
...
- Fixed: Not install nftables package on Ubuntu 20.04.
- Fixed: `update/ldap/update-ldap-dovecot-2.3.py`: ldap attribute name is str. fixes #109
- Upgrade netdata to 1.29.0.
2021-02-08 14:26:27 +08:00
4adc118dbe
Fix update/ldap/update-ldap-dovecot-2.3.py.
2020-10-23 07:58:59 +08:00
594a134d3b
Fix a py 2to3 issue in update/ldap/update-ldap-dovecot-2.3.py.
2020-10-21 20:01:25 +08:00
9a7cc61349
Update shasum of repacked iRedAdmin OSE.
...
Remove unused update/ldap/updateLDAPValues_*.py. Our upgrade tutorials stick to files in iRedMail-1.0 release, so removing them now won't impact upgrading old iRedMail releases.
2020-10-10 12:47:21 +08:00
c070716c99
Track last login of both POP3/IMAP logins, also when new (last one) email was delivered via LMTP/LDA.
2020-02-28 17:27:02 +08:00
2fd976c867
Update Roundcube to 1.4.2.
2020-01-02 09:45:41 +08:00
226f634e57
Update iRedAdmin (open source edition) to 1.0.
...
Add sample MySQL commands to extend SQL table 'amavisd.msgs' for easier queries.
2019-12-28 09:26:01 +08:00
e410063727
Re-organize directory structure.
2019-12-09 08:30:27 +08:00
a3410ab28c
Re-organize directory structure.
2019-12-09 08:25:52 +08:00
Zhang Huangbin