[linux] Postfix + mysql+dovecot a autoreply
Martin Plch
martin.plch na svslm.sk
Pátek Listopad 8 12:01:44 CET 2013
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
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] 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
abc na autoreply.domena.sk to v YAA prepisat na abc na domena.sk, aby to
vedel v db najst. Pokial mas v db priamo 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=<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] <martin.plch na xxx.sk> -> <martin na yyy.eu>,
Message-ID: <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=<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=<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:
martin.plch na xxx.sk, recipients: 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=<martin na autoreply.yyy.eu>, orig_to=<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
------------- další část ---------------
HTML příloha byla odstraněna...
URL: <http://lists.linux.sk/pipermail/linux/attachments/20131108/dcfb83ce/attachment-0001.html>
Další informace o konferenci linux