[linux] Postfix + mysql+dovecot a autoreply

Martin Plch martin.plch na svslm.sk
Pátek Listopad 8 15:17:19 CET 2013


Dakujem Marek uz to funguje.

Tak pre uplnost chyba 1 bola ze nebolo vyplnene na co si ma upozronil 

 

                rewrite_recipient => ['my_sql_map:address2'
                               # 'map_name:result', 'map_name2:result'
                ],

 

chyba 2 ze cely cas som mal v databaze martin na autoreplay.yyy.eu namiesto
martin na autoreply.yyy.eu  :D Musim sa smiat inac by som sa asi obesil. J

 

a funguje mi to aj ked taha veci z databazy. V tabulke autoresponder mam
toto

 

active                  message                             subject
charset                 forward               address
address2                             local_domains  tstart     tfinish

1                            Message Body                  Message Subject
martin na autoreply.YYY.eu          martin na YYY.eu                YYY.eu
0             0

 

HURA IDE MI TO J.

 

Prajem prijemny vikend a VELKA VDAKA tebe Marek (raz ti to dufam urcite
oplatim)

 

Martin

 

 

	
Vies problem je ze neviem YAA donutit logovat obsirnejsie aj ked pouzijem
(Dost by mi to pomohlo keby som ho vedel logovat viac)Lebo mam dojem ako
keby on sa do tej casti ku odoslaniu nedostal pripadne to odosle nejak zle a
nejaky loop back ho zastavi aby sa to neposielalo dookola.
 
export YAA_DEBUG=1;
$daemon_tcpserver_loglevel = 4;
$duration_interval="-1";
 
Neviem preco? Tipujem asi preto ze nie je YAA spusteny ako daemon. Lebo ked
ho spustim yaa.pl s konzoly  tak ma hlasok vela v konzole a ked poslem mail
a yaa sa spusti cez pipe tak zaloguje len to co som poslal.
 
Este zopar otazok:
 
Neviem na co su tieto veci:
##toto mam prazdne v databze
                charset => ['my_sql_map:charset'
                               # 'map_name:result', 'map_name2:result'
                ],
##toto mam prazdne v databze
                forward => ['my_sql_map:forward'
                               # 'map_name:result', 'map_name2:result'
                ],
##toto nema tam byt nieco ??? alebo zobere original adresu
                rewrite_sender => [
                               # 'map_name:result', 'map_name2:result'
                ],
## to uz si mi objasnil tam bude mat
                rewrite_recipient => ['my_sql_map:address2'
                               # 'map_name:result', 'map_name2:result'
                ],
                'local_domains' => ['my_sql_map:local_domains'
                               # 'map_name:result', 'map_name2:result'...
                ],

Martin
P.S. asi ta nakoniec popytam o zaslanie toho tvojho konfigu (kde zmazes mena
a hesla) aby som si to porovnal kde som to zle prepisal. Lebo verzii mojich
konfigou uz mam hadam aj 30 J.
 
 
 
From: Marek Podmaka [mailto:marki na marki-online.net] 
Sent: Friday, November 08, 2013 2:10 PM
To: Martin Plch
Subject: Re: [linux] Postfix + mysql+dovecot a autoreply
 
Cau,

V tom SQL mas "where address = %m". Namiesto toho on doplni adresu
recipienta, t.j. adresu na ktoru on dany email dostal
(martin na autoreply.yyy.eu). Kedze taku si tam nemal, tak databaza mu
nevratila ziadny riadok (co by sa dalo lahko zistit keby si si zapol
obsirnejsie logovanie).

Takze ked das do toho SQL address2 (kde budu @autoreply adresy) tak by to
malo fungovat. (Alebo ako si navrhol, v address mat @autoreply.yyy.eu a do
address2 si davat tie normalne @yyy.eu adresy).

Ano, YAA posiela odpoved naspat odosielatelovi (pozor pri debugovani, by
default posle len 1 odpoved kazdemu odosielatelovi denne). Ale podla
prijimatela musi z db zistit detaily tej odpovede. A prijimatel mailu pre
YAA je iny ako prijimatel toho povodneho mailu...

Friday, November 8, 2013, 13:44:21, Martin Plch wrote:

	
Myslis ze tu polozku z databazy adress niekde pouziva?
Pozrel som konfig a nemam ju nikde definovanu.
Nema sa pouzit takto?:
               
rewrite_recipient => ['my_sql_map:address'
                               # 'map_name:result', 'map_name2:result'
                ],

alebo si v db doplnim tam este address2 a potom by bolo
address =  <mailto:martin na autoreply.yyy.eu> martin na autoreply.yyy.eu
 <mailto:address2=martin na yyy.eu> address2=martin na yyy.eu
 
a potom by som pouzil
rewrite_recipient => ['my_sql_map:address2'
                               # 'map_name:result', 'map_name2:result'
                ],

 
chcem sa uberat takymto smerom pretoze na tom servry bezi viac domen.  A pri
vacation sa to bude pridavat cez nejake web rozhranie.
 
Martin
P.S. uz sa v tom zacinam zamotavat kde ma ist aka adresa. To YAA dostane
hlavicku kde ma odosilatela a prijmatela a on by mal potom poslat spat len
odosilatelovi mail nie? Pretoze pri prijmany sa to presmerovava aj na
normalnu aj na fiktivnu adresu.
Ale som rad ze to niekomu funguje lebo po tyzdny trapenia sa som uz stracal
nadej ze sa to da rozbehat. (Teraz mam aspon nadej ze sa mi to mozno podari
J)
 
From: linux [ <mailto:linux-bounces na lists.linux.sk>
mailto:linux-bounces na lists.linux.sk] On Behalf Of Marek Podmaka
Sent: Friday, November 08, 2013 1:06 PM
To: Vseobecna diskusia o Linuxe
Subject: Re: [linux] Postfix + mysql+dovecot a autoreply
 
Ano, problem je v tom ze v db mas adresu v normalnom formate
<mailto:martin na YYY.eu> martin na YYY.eu ale YAA dostane request na
<mailto:martin na autoreply.yyy.eu> martin na autoreply.yyy.eu a nevie co s tym.
Ja som ten subor mal default v instalacii, je tam aj presne example pre tvoj
pripad.
'recipient_pcre' treba vlozit medzi $lookup_maps a potom ho nastavit pre
rewrite_recipient.

Obsahom suboru /usr/local/yaa/conf/recipient.pcre je (zmen si to na svoju
domenu):

# This is sample map file for PCRE lookup map driver
# PCRE driver can use and parse any postfix pcre tables
# AS LONG PATTERN, FLAGS and RESULT ARE IN THE SAME LINE.
#
# if /pattern/flags, endif macros ARE NOT SUPPORTED

# sample:
# rewrite recipient  <mailto:*@autoreply.domain.tld> *@autoreply.domain.tld
to  <mailto:*@domain.tld> *@domain.tld
# (handy for 'rewrite_recipient' autoresponse attribute)

#/^([\w\-\.]+)@autoreply\.domain\.tld/i
<mailto:$1 na domain.tld> $1 na domain.tld


Friday, November 8, 2013, 12:01:44, Martin Plch wrote:

	
Ahoj,
V konfigu mam toto zmenene oproti original:
 
# run as daemon?
# type: boolean
# default: 0, do not run as daemon
# this setting enables daemon mode operation.
$daemon = 0;
 
 
$lookup_maps = {
'my_sql_map' => {
                'driver' => 'SQL',
                'sql_dsn' => 'dbi:mysql:database=mailserver;host=127.0.0.1',
                'sql_username' => "user",
                'sql_password' => "passwd",
                'sql_select' => "select
active,message,subject,charset,forward,address,local_domains from
autoresponder where address = %m and active='1'",
                },
};
$lookup_map_query_order = {
active => [ 'my_sql_map:active'
                               # 'map_name:result', 'map_name2:result'
                ],
                subject => ['my_sql_map:subject'
                               # 'map_name:result', 'map_name2:result'
                ],
                message => ['my_sql_map:message'
                               # 'map_name:result', 'map_name2:result'
                ],
                charset => ['my_sql_map:charset'
                               # 'map_name:result', 'map_name2:result'
                ],
                forward => ['my_sql_map:forward'
                               # 'map_name:result', 'map_name2:result'
                ],
                rewrite_sender => [
                               # 'map_name:result', 'map_name2:result'
                ],
                rewrite_recipient => [
                               # 'map_name:result', 'map_name2:result'
                ],
                'local_domains' => ['my_sql_map:local_domains'
                               # 'map_name:result', 'map_name2:result'...
                ],
};
 
'file'   => '/usr/local/yaa/conf/recipient.pcre' ,takyto subor nemam co je
vo vnutri?
 
Asi mi to preto nefunguje lebo to neprepise.
 
V databaze mam
Tabulku autoresponder:
Polozky:
active    message                             subject charset forward
address                               local_domains                  tstart
tfinish
obsah:
1             Message Body                  Message Subject
<mailto:martin na YYY.eu> martin na YYY.eu                YYY.eu
0                                0
 
Tabulku transport:
Polozky:
domain                transport
obsah:
autoreply.YYY.eu            yaa
 
 
Martin 
 
From: linux [ <mailto:linux-bounces na lists.linux.sk>
mailto:linux-bounces na lists.linux.sk] On Behalf Of Marek Podmaka
Sent: Friday, November 08, 2013 11:22 AM
To: Vseobecna diskusia o Linuxe
Subject: Re: [linux] Postfix + mysql+dovecot a autoreply
 
Cau,

Ja pouzivam YAA uz niekolko rokov. Podla tych logov to vyzera ze
postfix je nastaveny OK. Len zrejme v YAA musis nastavit
rewrite_recipient, aby vedel pre koho ma autoodpovedac hladat.

Odkial tahas info o tom ze autoodpovedac je zapnuty a aky ma byt obsah
odpovede? Ja to mam v MySQL podla prijemcu, cize musim z
 <mailto:abc na autoreply.domena.sk> abc na autoreply.domena.sk to v YAA prepisat
na  <mailto:abc na domena.sk> abc na domena.sk, aby to
vedel v db najst. Pokial mas v db priamo  <mailto:martin na autoreply.yyy.eu>
martin na autoreply.yyy.eu, tak
by to mal vediet najst priamo.
A nastav si $daemon_tcpserver_loglevel aspon na notice (2), vtedy by mal
pisat
aj info tom ci nasiel v db zaznam pre daneho cloveka a ci mu posiela
odpoved.

To prepisovanie prijemcu sa robi cez:
rewrite_recipient => [ 'recipient_pcre:result' ],

'recipient_pcre' => {
    'driver' => 'PCRE',
    'file'   => '/usr/local/yaa/conf/recipient.pcre',
    'replacement_num' => 2
},


Friday, November 8, 2013, 8:16:41, Martin Plch wrote:

	
Ahojte,
Mam Debian a na nom rozbehany postfix + mysql +dovecot +amavis+ spamassasin
v style vmail teraz sa tam snazim rozchodit automaticku odpoved pouzil som
na to YAA-0.3.1. podla navodu
 
 <http://www.howtoforge.com/autoresponders_for_virtual_postfix_users>
http://www.howtoforge.com/autoresponders_for_virtual_postfix_users
 
aj po "odladeny" configu na moj server a odstraneny vsetkych chyb podla
logov  sa mi to nepodarilo rozchodit do zdarneho konca aj ked v logoch uz
nie je ziadny error a vsetko sa tvari ze prebehne. 
YAA script prebehne ale neodosle spat spravu.
 
Nov  8 08:02:20 server postfix/smtpd[20128]: disconnect from
localhost[127.0.0.1]
Nov  8 08:02:20 server postfix/qmgr[11057]: E40904C098: from=<
<mailto:martin.plch na xxx.sk> martin.plch na xxx.sk>, size=3879, nrcpt=2 (queue
active)
Nov  8 08:02:20 server amavis[17317]: (17317-19) Passed CLEAN,
[123.456.137.194] [123.456.137.194] < <mailto:martin.plch na xxx.sk>
martin.plch na xxx.sk> -> < <mailto:martin na YYY.eu> martin na yyy.eu>, Message-ID:
< <mailto:01c301cedc50$719297d0$54b7c770$@xxx.sk>
01c301cedc50$719297d0$54b7c770$@xxx.sk>, mail_id: Nr1eYgtcrVlm, Hits:
-1.471, size: 3239, queued_as: E40904C098, 4942 ms
Nov  8 08:02:20 server postfix/smtp[20077]: 071CE4C097: to=<
<mailto:martin na YYY.eu> martin na yyy.eu>, relay=127.0.0.1[127.0.0.1]:10024,
delay=5, delays=0.05/0/0/4.9, dsn=2.0.0, status=sent (250 2.0.0 Ok,
id=17317-19, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as
E40904C098)
Nov  8 08:02:20 server postfix/qmgr[11057]: 071CE4C097: removed
Nov  8 08:02:20 server postfix/pipe[20130]: E40904C098: to=<
<mailto:martin na YYY.eu> martin na yyy.eu>, relay=dovecot, delay=0.15,
delays=0.08/0/0/0.07, dsn=2.0.0, status=sent (delivered via dovecot service)
Nov  8 08:02:20 server yaa.pl[20166]: Warning: setting empty lookup query
order for attribute 'rewrite_recipient'.
Nov  8 08:02:20 server yaa.pl[20166]: Warning: setting empty lookup query
order for attribute 'rewrite_sender'.
Nov  8 08:02:20 server yaa.pl[20166]: 2419904: Processing new request, id
2419904
Nov  8 08:02:20 server yaa.pl[20166]: 2419904: Message sender:
<mailto:martin.plch na xxx.sk> martin.plch na xxx.sk, recipients:
<mailto:martin na autoreply.yyy.eu> martin na autoreply.yyy.eu
Nov  8 08:02:20 server yaa.pl[20166]: 2419904: Processing complete.
Nov  8 08:02:20 server postfix/pipe[20131]: E40904C098: to=<
<mailto:martin na autoreply.yyy.eu> martin na autoreply.yyy.eu>, orig_to=<
<mailto:martin na YYY.eu> martin na yyy.eu>, relay=yaa, delay=0.21,
delays=0.08/0/0/0.13, dsn=2.0.0, status=sent (delivered via yaa service)
Nov  8 08:02:20 server postfix/qmgr[11057]: E40904C098: removed
 
 
 
Prosim vas pouziva niekto YAA script ako autoreply? 
 
Pripadne ma prosim nasmerujte k nejakemu skriptu ktory mate vyskusany.
 
Schema podla ktorej sa to snazim rozbehat: 
 <http://unwin.org/postfix/vda-autoresponder.html>
http://unwin.org/postfix/vda-autoresponder.html
 
S pozdravom
 
Martin Plch








-- 
  bYE, Marki







-- 
  bYE, Marki






-- 
  bYE, Marki





-- 
  bYE, Marki

------------- další část ---------------
HTML příloha byla odstraněna...
URL: <http://lists.linux.sk/pipermail/linux/attachments/20131108/70cb4828/attachment-0001.html>


Další informace o konferenci linux