mail@??? wrote:
> Trying to setup exim + dovecot, with filtering by clamav +
> spamassassin for virtual domains, for users without local system logins
> In addition, i would like to add features for Disk Quota + Max
> Attachment Size + Monthly Transfer quota for each account
> Could someone point me to some documentation of setting up all these
> features with the use of a SQLite or MySQL database for backend storage?
>
I've been looking into the various parts of a proper MTA setup, and from
what I understand it should look something like this >>>
http://snapclear.com/exim/MTA_Layout.png
In addition, I found an excellent config example over at
http://developer.gauner.org/ispmail-exim/
This setup seems to be exactly what I'm looking for, but unfortunately
it does not explain how to set per mailbox quotas.
Could someone perhaps tell me how i can add a "quota" field to the sql
schema below ?
Feld Typ
Beschreibung
id int(9) Primärschlüssel,
auto_increment
local_part varchar(255) Der Benutzerteil der
Adresse
domain int(16) Der Domainteil der Adresse, verweist
auf die Tabelle Domains
forward varchar(255) Das Ziel der
Weiterleitung
cc varchar(255) Alle Nachrichten an diese Adresse
werden hierhin kopiert
name varchar(255) Ein Benutzerdefinierter
Name
pwclear varchar(255) Das Passwort im
Klartext
pwcrypt varchar(255) Das Passwort im UNIX Crypt
Format
is_away enum('yes','no') Auto-Responder
aktiv?
away_text enum('yes','no') Text für den
Auto-Responder
spam_check enum('yes','no') SpamAssassin
ausführen?
spam_purge enum('yes','no') Spam Mails direkt
löschen?
virus_check enum('yes','no') Virus-Scan
ausführen?
is_enabled enum('yes','no') Account
aktiv?
created_at int(16) Zeitstempel der
Erstellung
updated_at int(16) Zeitstempel der letzten
Modifikation
