Source

iredmail / iRedMail / samples / iredmail.mysql

Author Commit Message Labels Comments Date
Zhang Huangbin
Revert last commit.
Zhang Huangbin
Improved Dovecot SQL/LDAP query, so that we can disable IMAP service for certiain users, but still able to allow them to use webmail.
Zhang Huangbin
Enable Dovecot LMTP service by default.
Zhang Huangbin
New columns for MySQL/PostgreSQL backends: - admin.settings: used to store per-user settings, used in iRedAdmin. - alias.islit: used to mark a sql record is a mail list account.
Zhang Huangbin
Use 'TEXT' as type of column 'mailbox.settings'.
Zhang Huangbin
New column for SQL backends: mailbox.settings. Used to store per-user settings, used in iRedAdmin-Pro.
Zhang Huangbin
Remove unused SQL columns: mailbox.bytes, mailbox.messages.
Zhang Huangbin
* Disable 'smtp_tls_security_level=may', doesn't work very well with self-signed SSL certificate, especially sending email from Gmail. * New column for SQL backends (mailbox.enablelmtp) and new attribute/value pair for LDAP mail user: enabledService=lmtp. Used for LMTP service. * Bump version number: 0.9.0.
Zhang Huangbin
Add comments in SQL template file.
Zhang Huangbin
Remove duplicate records in samples/cluebringer_extra.sql.
Zhang Huangbin
Update iRedMail MySQL template: column type 'TEXT' (and BLOB) cannot have default value.
Zhang Huangbin
New SQL table: deleted_mailboxes. Used to store maildir path of deleted mail user, used in iRedAdmin-Pro. Package updates: + Roundcube webmail -> 0.9.2 + phpMyAdmin -> 4.0.4 + iRedAPD -> 1.4.1 + iRedAdmin -> 0.2.2
Zhang Huangbin
Use VARCHAR instead of TEXT type.
Zhang Huangbin
Update SQL triggers to insert value for column 'used_quota.domain' automatically.
Zhang Huangbin
New SQL column and LDAP attribute for mail domain, used to store preferred language for newly created mail users. - SQL: 'domain.defaultlang' - OpenLDAP: attribute 'preferredLanguage' for mailDomain object.
Zhang Huangbin
New SQL columns in table 'vmail.mailbox' for per-user restriction, used by iRedAPD: allowedsenders, rejectedsenders, allowedrecipients, rejectedrecipients.
Zhang Huangbin
Sync comments in samples/mysql.*sql.
Zhang Huangbin
Split Postfix MySQL/PGSQL lookup files as sample files: samples/postfix/{mysql,pgsql}/.
Zhang Huangbin
* Drop support for Ubuntu-11.10 (oneiric). * New columns for MySQL/PGSQL backend in table vmail.mailbox: isadmin, isglobaladmin, language.
Zhang Huangbin
Add new column 'mailbox.language' in MySQL & PGSQL backends, used by iRedAdmin.
Zhang Huangbin
Fixed: Add missing config and SQL table required for sharing IMAP folder to anyone. Thanks BigMichi1 <bigmichi1 _at_ bigmichi1.de>.
Zhang Huangbin
* Add missing auth service in Dovecot-2: auth-userdb. * Add new LDAP attribute and SQL column required by Dovecot-2 share folder: enabledService=lib-storage (ldap), enablelib-storage=1 (SQL). Thanks moreni <fmoreni _at_ simtrack.com.br> for the report.
Zhang Huangbin
Add new value of enabledService: doveadm. Required by command doveadm provided by Dovecot-2.
Zhang Huangbin
Typo.
Zhang Huangbin
Code cleanup.