Re: [exim] Configuring exim - dovecot - clamav - spamassassi…

Pàgina inicial
Delete this message
Reply to this message
Autor: mail@snapclear.com
Data:  
A: exim-users
Assumpte: Re: [exim] Configuring exim - dovecot - clamav - spamassassin, with usage restrictions using MySQL or SQLite for Virtual Users
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