Re : Re : Re : [etch] Postfix virtual domains avec Mysql

Bonjour & merci =E0 Mouss,=0AVoici ce que retourne les commandes postmap su=
r mysql-virtual_domains.cf et mysql-virtual_transports.cf=0A=0Amarina:/home=
/admins# postmap -q dpi-arobasetelecom.ci mysql:/etc/postfix/mysql-virtual_=
domains.cf=0Adpi-arobasetelecom.ci=0A=0Amarina:/home/admins# postmap -q dpi=
-arobasetelecom.ci mysql:/etc/postfix/mysql-virtual_transports.cf=0Asmtp:ma=
il.dpi-arobasetelecom.ci=0Amarina:/home/admins#=0A=0AQuand je fais un envoi=
d'email depuis la console vers admins@dpi-arobasetelecom.ci, kdclaver@gmai=
l.com et kdclaver@yahoo.fr=0Amarina:/home/admins# mail admins@dpi-arobasete=
lecom.ci=0ASubject: essai encore=0AEncore un essai=0A.=0ACc: kdclaver@yahoo=
.fr, kdclaver@gmail.com=0A=0Ac'est alors que j'ai dans mail.log ceci :=0A=
=0Amarina:/home/admins# tail -f /var/log/mail.log=0ASep 8 11:09:03 marina =
postfix/smtpd[11317]: B99556EDCF: client=3Dlocalhost.locald =
omain[127.0.0.1]=0ASep 8 11:09:03 marina postfix/cleanup[11288]: B=
99556EDCF: message-id=3D<200709081 00854.C35D06EDDE@ma=
rina.dpi-arobasetelecom.ci>=0ASep 8 11:09:03 marina postfix/smtpd[11317]: =
disconnect from localhost.localdomain[127.0.0.1]=0ASep 8 11:09:03 marina a=
mavis[2611]: (02611-02) Passed CLEAN, <root@marina.dpi-arobasetelecom.ci> -=
> <admins@dpi-arobasetelecom.ci>,<kdclaver@gmail.com>,<kdclav =
er@yahoo.fr>, Message-ID: <20070908100854.C3=
5D06EDDE@marina.dpi-arobasetelecom.c i>, mail_id: Ry0VznF8W=
pa5, Hits: -0.001, queued_as: B99556EDCF, 8652 ms=0ASep 8 11:09:03 marina =
postfix/qmgr[3069]: B99556EDCF: from=3D<root@marina.dpi-aro =
basetelecom.ci>, size=3D857, nrcpt=3D3 (queue active)=0ASep 8 11:09=
:03 marina postfix/smtp[11291]: C35D06EDDE: to=3D<admins@dpi-arobasete =
lecom.ci>, relay=3D127.0.0.1[127.0.0.1]:10024, delay=3D9.3, =
delays=3D0.31/0.03/0.4/8.5 , ds=
n=3D2.6.0, status=3Dsent (250 2.6.0 Ok, id=3D02611-02, from MTA([127.0.0.1]=
:10025) : 250 2.0.0 Ok: queued =
as B99556EDCF)=0ASep 8 11:09:04 marina postfix/smtp[11291]: C35D06EDDE: to=
=3D<kdclaver@gmail.com>, relay=
=3D127.0.0.1[127.0.0.1]:10024, delay=3D9.3, delays=3D0.31/0.03/0.4/8.5, dsn=
=3D2.6. 0, status=3Dsent (250 2=
.6.0 Ok, id=3D02611-02, from MTA([127.0.0.1]:10025): 250 2.0. =
0 Ok: queued as B99556EDCF)=0ASep 8 11:09:0=
4 marina postfix/smtp[11291]: C35D06EDDE: to=3D<kdclaver@yahoo.fr>, =
relay=3D127.0.0.1[127.0.0.1]:10024, d=
elay=3D9.3, delays=3D0.31/0.03/0.4/8.5, dsn=3D2.6.0 =
, status=3Dsent (250 2.6.0 Ok, id=3D02611-02, from MTA=
([127.0.0.1]:10025): 250 2.0.0 =
Ok: queued as B99556EDCF)=0ASep 8 11:09:04 marina postfix/smtp[11319]: B9=
9556EDCF: to=3D<admins@dpi-arobasete =
lecom.ci>, relay=3Dnone, delay=3D0.19, delays=3D0.1/0.09/0/0, dsn=3D5=
.4.6, status=3Dbounce d (mail f=
or mail.dpi-arobasetelecom.ci loops back to myself)=0ASep 8 11:09:04 marin=
a postfix/qmgr[3069]: C35D06EDDE: removed=0ASep 8 11:09:25 marina postfix/=
smtp[11318]: B99556EDCF: to=3D<kdclaver@gmail.com>, relay=3Dgmail-smtp-in.l=
.google.com[72.14.215.27]:25, delay=3D22, delays=3D0.1/0.06/16/5.6, dsn=3D2=
.0.0, status=3Dsent (250 2.0.0 OK 1189249763 30si1220978hue)=0ASep 8 11:09=
:26 marina postfix/smtp[11320]: B99556EDCF: to=3D<kdclaver@yahoo.fr>, relay=
=3Df.mx.mail.yahoo.com[209.191.88.247]:25, delay=3D23, delays=3D0.1/0.16/20=
/2.7, dsn=3D2.0.0, status=3Dsent (250 ok dirdel)=0ASep 8 11:09:26 marina p=
ostfix/cleanup[11288]: 66FB26EDDE: message-id=3D<20070908100926.66FB26EDDE@=
marina.dpi-arobasetelecom.ci>=0ASep 8 11:09:26 marina postfix/bounce[11321=
]: B99556EDCF: sender non-delivery notification: 66FB26EDDE=0ASep 8 11:09:=
26 marina postfix/qmgr[3069]: 66FB26EDDE: from=3D<>, size=3D2846, nrcpt=3D1=
(queue active)=0ASep 8 11:09:26 marina postfix/qmgr[3069]: B99556EDCF: re=
moved=0ASep 8 11:09:26 marina postfix/cleanup[11288]: 9223F6EDCF: message-=
id=3D<20070908100926.66FB26EDDE@marina.dpi-arobasetelecom.ci>=0ASep 8 11:0=
9:26 marina postfix/local[11324]: 66FB26EDDE: to=3D<root@marina.dpi-arobase=
telecom.ci>, relay=3Dlocal, delay=3D0.19, delays=3D0.02/0.15/0/0.02, dsn=3D=
2.0.0, status=3Dsent (forwarded as 9223F6EDCF)=0ASep 8 11:09:26 marina pos=
tfix/qmgr[3069]: 9223F6EDCF: from=3D<>, size=3D3003, nrcpt=3D1 (queue activ=
e)=0ASep 8 11:09:26 marina postfix/qmgr[3069]: 66FB26EDDE: removed=0ASep =
8 11:09:26 marina postfix/smtp[11319]: 9223F6EDCF: to=3D<postmaster@dpi-aro=
basetelecom.ci>, orig_to=3D<root@marina.dpi-arobasetelecom.ci>, relay=3Dnon=
e, delay=3D0.02, delays=3D0.01/0/0/0, dsn=3D5.4.6, status=3Dbounced (mail f=
or mail.dpi-arobasetelecom.ci loops back to myself)=0ASep 8 11:09:26 marin=
a postfix/qmgr[3069]: 9223F6EDCF: removed=0A=0A=0AC'est le mail destin=E9 e=
n local (root ---> admins) qui g=E9n=E8re une liste bounced dans mail.log.=
=0A=0AMerci =E0 tous pour votre patience et votre aide tr=E8s utile.=0A=0A =
=0A----- Message d'origine ----=0ADe : mouss <mlist.only@free.fr>=0A=C0 : F=
orum Debian <debian-user-french@lists.debian.org>=0AEnvoy=E9 le : Samedi, 8=
Septembre 2007, 9h23mn 15s=0AObjet : Re: Re : Re : [etch] Postfix virtual =
domains avec Mysql=0A=0A=0ADominique Claver KOUAME wrote:=0A> Merci Mouss =
pour ton retour, voici les r=E9ponses =0A> =0A> 1. t'as oubli=E9 de "dire" =
=E0 postfix de g=E9rer le domaine =0A> mail.dpi-arobasetelecom.ci. si tu ut=
ilises=0A> =0A> Ma r=E9ponse :=0A> Ce domaine est virtuel et d=E9clarer da=
ns la table domains de la base de donn=E9es mail.=0A> =0A> mysql> show tab=
les;=0A> +----------------+=0A> | Tables_in_mail |=0A> +----------------+=
=0A> | domains |=0A> | forwardings |=0A> | transport |=0A> |=
users |=0A> +----------------+=0A> 4 rows in set (0.00 sec)=0A> m=
ysql>=0A> mysql> select * from domains where domain is not null;=0A> +-----=
------------------+=0A> | domain |=0A> +--------------------=
---+=0A> | dpi-arobasetelecom.ci |=0A> +-----------------------+=0A> 1 row =
in set (0.00 sec)=0A> mysql>=0A> =0A=0Aessaye avec postmap:=0A# postmap -q =
dpi-arobasetelecom.ci \=0A mysql:/etc/postfix/mysql-virtual_domains.cf=
=0A=0ADans les logs, il y a:=0A=0ASep 7 13:42:48 marina postfix/smtp[13256=
]: E30AA6EDDC: =0Ato=3D<admins@dpi-arobasetelecom.ci>, relay=3Dnone, delay=
=3D1.7, =0Adelays=3D1.1/0.59/0/0, dsn=3D5.4.6, status=3Dbounced (mail for =
=0Amail.dpi-arobasetelecom.ci loops back to myself)=0A=0Ad'o=F9 vient ce "m=
ail." (dans mail.dpi-arobasetelecom.ci)?=0A=0A=0Aque donne=0A# postmap -q d=
pi-arobasetelecom.ci \=0A mysql:/etc/postfix/mysql-virtual_transports.cf=
=0A=0Asi =E7a retourne quelque chose, ton probl=E8me est dans "le coin".=0A=
sinon, qu'y a-t-il dans cette table?=0A=0A=0A-- =0ALisez la FAQ de la liste=
avant de poser une question :=0Ahttp://wiki.debian.net/?DebianFrench =0A=
Vous pouvez aussi ajouter le mot ``spam'' dans vos champs "From" et=0A"Repl=
y-To:"=0A=0ATo UNSUBSCRIBE, email to debian-user-french-REQUEST@lists.debia=
n.org=0Awith a subject of "unsubscribe". Trouble? Contact listmaster@lists.=
debian.org=0A=0A=0A __________________________________________________=
___________________________ =0ANe gardez plus qu'une seule adresse mail ! C=
opiez vos mails vers Yahoo! Mail