Source

iredmail / iRedMail / samples / iredmail.pgsql

Author Commit Message Labels Comments Date
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
* 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
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
Sync.
Zhang Huangbin
Fix incorrect PGSQL syntax in postfix lookup files.
Zhang Huangbin
Enable PostgreSQL backend on RHEL/CentOS 6. Not completed yet.
Zhang Huangbin
Fix incorrect INDEX in PostgreSQL template file.
Zhang Huangbin
Start working on Gentoo support.
Zhang Huangbin
Fixed: Dovecot cannot store realtime quota usage in PostgreSQL.
Zhang Huangbin
PostgreSQL SQL structure: sample/iredmail.pgsql.