Changeset 3189

Timestamp:

08/06/12 11:22:13 (10 months ago)

Author:

squidly

Message:

Ajout d'une vue SQL alias_view pour gérer les alias de mail plus simplement

Location:

alternc/trunk

Files:

• etc/alternc/templates/postfix/myalias.cf (modified) (1 diff)
• install/alternc.install (modified) (1 diff)
• install/mysql.sql (modified) (2 diffs)

alternc/trunk/etc/alternc/templates/postfix/myalias.cf

@@ -7 +7 @@
 hosts =%%dbhost%%
 dbname = %%dbname%%
-query = select concat( if(isnull(mailbox.id), '', concat(concat(address.address,'@',domaines.domaine), '\n')), recipient.recipients ) from recipient join address on address.id = recipient.address_id left outer join mailbox on mailbox.address_id = address.id join domaines on domaines.id = address.domain_id where concat(address.address,'@',domaines.domaine)='%s';
+query = select alias from alias_view where mail='%s';
  
 

alternc/trunk/install/alternc.install

@@ -332 +332 @@
 
 #######################################################################
+#populate alternc database with the mailname used by postfix to send mail for each vhost
+#
+mailname=`cat /etc/mailname`
+mysql_query "update table variable SET value="$mailname" where name='mailname_bounce';" 
+
+#######################################################################
 # Save installed files to check them during next install
 #

alternc/trunk/install/mysql.sql

@@ -647 +647 @@
 
 --
--- Structure de la vue `dovecot-view`
+-- Structure de la vue `dovecot_view`
 --
 
@@ -663 +663 @@
 join `domaines` on((`domaines`.`id` = `address`.`domain_id`)));
 
+--
+-- Structure de la vue `alias_view`
+--
+
+CREATE OR REPLACE VIEW `alias_view` AS 
+select concat(`address`.`address`,'@',`domaines`.`domaine`) AS `mail`,
+concat(if(isnull(`mailbox`.`id`),'',concat(concat(`address`.`address`,'@',`domaines`.`domaine`),'\n')),`recipient`.`recipients`) AS `alias` 
+from (((`recipient` join `address` on((`address`.`id` = `recipient`.`address_id`)))
+left join `mailbox` on((`mailbox`.`address_id` = `address`.`id`)))
+join `domaines` on((`domaines`.`id` = `address`.`domain_id`)))
+union
+select distinct concat(`m`.`login`,'@',`v`.`value`) AS `mail`,
+`m`.`mail` AS `alias`
+from ((`membres` `m` join `variable` `v`) join `domaines` `d`)
+where (`v`.`name` = 'mailname_bounce');