Changes between Version 6 and Version 7 of QuotasParBoite

Timestamp:

12/14/06 13:54:52 (6 years ago)

Author:

pierre-gilles

Comment:

--

QuotasParBoite

@@ -41 +41 @@
 {{{
  mysql -usysusr -pmot_de_passe system -e "ALTER TABLE `mail_users` ADD `quota`  INT DEFAULT '104857600' NOT NULL ;"
+}}}
+
+Il faut en plus compiler une extension pour mysql afin que de disposer d'une fonction mailfilter. AlternC utilisant le transport local pour faire la délvrance nous devons sortir de ce shema afin de passer par un transport virtuel.
+
+{{{
+tar zxvf mailfilter.tgz
+cd mailfilter
+make 
+cp mailfiter.so /usr/lib/mysql-fct-mailfilter.so
+ldconfig 
+mysql restart
+mysql -usysusr -pmot_de_passe -e "create function mailfilter returns string soname 'mysql-fct-mailfilter.so' ;"
 }}}
 
@@ -108 +120 @@
 smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_invalid_hostname, reject_non_fqdn_hostname, reject_non_fqdn_sender, reject_non_fqdn_recipient, reject_unknown_sender_domain, reject_unknown_recipient_domain, reject_unauth_pipelining, reject_unauth_destination
 
-alias_maps = mysql:/etc/postfix/myalias.cf hash:/etc/aliases
+alias_maps = mysql:/etc/postfix/mymailinglists.cf mysql:/etc/postfix/myalias-only.cf hash:/etc/aliases
 
 default_privs = www-data
@@ -115 +127 @@
 #Quota Postfix VDA
 virtual_minimum_uid = 32
-virtual_gid_maps = proxy:mysql:/etc/postfix/mygid.cf
+virtual_gid_maps = proxy:mysql:/etc/postfix/mygid.cf proxy:mysql:/etc/postfix/mygidunderscore.cf
 virtual_uid_maps = static:33
 virtual_transport = virtual
 virtual_mailbox_base = /
-virtual_mailbox_domains = proxy:mysql:/etc/postfix/mydomain.cf
-virtual_mailbox_maps = proxy:mysql:/etc/postfix/myvirtual.cf
-virtual_alias_maps = proxy:mysql:/etc/postfix/myforward.cf
+virtual_alias_maps =  proxy:mysql:/etc/postfix/myredirections.cf proxy:mysql:/etc/postfix/mymixed.cf 
+virtual_mailbox_maps = proxy:mysql:/etc/postfix/myvirtualmaildirunderscore.cf proxy:mysql:/etc/postfix/myvirtualmaildir.cf 
+virtual_mailbox_domains = proxy:mysql:/etc/postfix/mydomains.cf proxy:mysql:/etc/postfix/myunderscore.cf
 virtual_alias_domains =
+append_at_myorigin = no
+append_dot_mydomain = no
 virtual_mailbox_extended = yes
 virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/myquota.cf
@@ -131 +145 @@
 virtual_create_maildirsize = yes
 virtual_overquota_bounce = yes
-proxy_read_maps= $virtual_mailbox_limit_maps $virtual_gid_maps proxy:unix:passwd.byname $virtual_mailbox_domains $virtual_mailbox_maps $virtual_alias_maps
+proxy_read_maps= $virtual_gid_maps $virtual_alias_maps $virtual_mailbox_domains $virtual_mailbox_maps $virtual_mailbox_limit_maps  proxy:unix:passwd.byname 
 local_transport = local
-mydestination =  %%fqdn%%
+mydestination = 
 }}}
 
-il faut éditer le fichier : /etc/alternc/templates/postfix/myvirtual.cf
-{{{
-#
-# %%warning_message%%
-#
-
-user = %%dbuser%%
-password = %%dbpwd%%
-hosts =%%dbhost%%
-dbname = %%dbname%%
-table = mail_users
-select_field = CONCAT(path,"/Maildir/")
-where_field = alias
-}}}
 
 il faut éditer le fichier : /etc/alternc/templates/courier/authmysqlrc 
@@ -157 +157 @@
 }}}
 
-il faut créer et éditer le fichier : /etc/postfix/myquota.cf
+
+Ensuite il faut reprendre les fichiers de maps mysql pour postfix :
 {{{
-user = sysusr
-password = ---MODIFIER-POUR-LE-MDP-SQL---
-hosts =localhost
-dbname = system
-table = mail_users
-select_field = quota
-where_field = alias
-}}}
-
-il faut créer et éditer le fichier : /etc/postfix/myforward.cf
-{{{
-user = sysusr
-password = ---MODIFIER-POUR-LE-MDP-SQL---
-hosts =localhost
-dbname = system
-table = mail_domain
-select_field = alias
-where_field = mail 
-additional_conditions =  AND pop='0' 
+tar zxvf conf.tgz 
+cd conf
+for i in * 
+sed -i s/MDP_SQL/A_REMPLACER_PAR_LE_VOTRE/ $i
+cp * /etc/postfix
 }}}
 
 changer les droits :
 {{{
-chmod 640 /etc/postfix/myforward.cf /etc/postfix/myquota.cf
-chgrp postfix /etc/postfix/myforward.cf /etc/postfix/myquota.cf
+chmod 640 /etc/postfix/*.cf 
+chgrp postfix /etc/postfix/*.cf
 }}}