<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><title>Re: [linux] Postfix + mysql+dovecot a autoreply</title><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=SK link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Ahoj,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>V konfigu mam toto zmenene oproti original:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'># run as daemon?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'># type: boolean<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'># default: 0, do not run as daemon<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'># this setting enables daemon mode operation.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> $daemon = 0;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>$lookup_maps = {<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>'my_sql_map' => {<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 'driver' => 'SQL',<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 'sql_dsn' => 'dbi:mysql:database=mailserver;host=127.0.0.1',<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 'sql_username' => "user",<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 'sql_password' => "passwd",<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 'sql_select' => "select active,message,subject,charset,forward,address,local_domains from autoresponder where address = %m and active='1'",<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> },<o:p></o:p></span></p><p class=MsoNormal><a name="_MailEndCompose"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>};<o:p></o:p></span></a></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>$lookup_map_query_order = {<o:p></o:p></span></p><p class=MsoNormal style='text-indent:35.4pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>active => [ 'my_sql_map:active'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> subject => ['my_sql_map:subject'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> message => ['my_sql_map:message'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> charset => ['my_sql_map:charset'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> forward => ['my_sql_map:forward'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> rewrite_sender => [<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> rewrite_recipient => [<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> 'local_domains' => ['my_sql_map:local_domains'<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> # 'map_name:result', 'map_name2:result'...<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> ],<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>};<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Courier New"'>'file' => '/usr/local/yaa/conf/recipient.pcre' </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>,takyto subor nemam co je vo vnutri?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Asi mi to preto nefunguje lebo to neprepise.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>V databaze mam<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Tabulku autoresponder:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Polozky:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>active message subject charset forward address local_domains tstart tfinish<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>obsah:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>1 Message Body Message Subject martin@YYY.eu YYY.eu 0 0<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Tabulku transport:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Polozky:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>domain transport<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>obsah:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>autoreply.YYY.eu yaa<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Martin <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> linux [mailto:linux-bounces@lists.linux.sk] <b>On Behalf Of </b>Marek Podmaka<br><b>Sent:</b> Friday, November 08, 2013 11:22 AM<br><b>To:</b> Vseobecna diskusia o Linuxe<br><b>Subject:</b> Re: [linux] Postfix + mysql+dovecot a autoreply<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:9.0pt;font-family:"Courier New"'>Cau,<br><br>Ja pouzivam YAA uz niekolko rokov. Podla tych logov to vyzera ze<br>postfix je nastaveny OK. Len zrejme v YAA musis nastavit<br>rewrite_recipient, aby vedel pre koho ma autoodpovedac hladat.<br><br>Odkial tahas info o tom ze autoodpovedac je zapnuty a aky ma byt obsah<br>odpovede? Ja to mam v MySQL podla prijemcu, cize musim z<br><a href="mailto:abc@autoreply.domena.sk">abc@autoreply.domena.sk</a> to v YAA prepisat na <a href="mailto:abc@domena.sk">abc@domena.sk</a>, aby to<br>vedel v db najst. Pokial mas v db priamo <a href="mailto:martin@autoreply.yyy.eu">martin@autoreply.yyy.eu</a>, tak<br>by to mal vediet najst priamo.<br>A nastav si $daemon_tcpserver_loglevel aspon na notice (2), vtedy by mal pisat<br>aj info tom ci nasiel v db zaznam pre daneho cloveka a ci mu posiela odpoved.<br><br>To prepisovanie prijemcu sa robi cez:<br>rewrite_recipient => [ 'recipient_pcre:result' ],<br><br>'recipient_pcre' => {<br> 'driver' => 'PCRE',<br> 'file' => '/usr/local/yaa/conf/recipient.pcre',<br> 'replacement_num' => 2<br>},<br><br><br>Friday, November 8, 2013, 8:16:41, Martin Plch wrote:</span><o:p></o:p></p><table class=MsoNormalTable border=0 cellpadding=0><tr><td width=2 style='width:1.5pt;background:blue;padding:.75pt .75pt .75pt .75pt'></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Ahojte,<br>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<br> <br></span><a href="http://www.howtoforge.com/autoresponders_for_virtual_postfix_users"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>http://www.howtoforge.com/autoresponders_for_virtual_postfix_users</span></a><br><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br>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. <br>YAA script prebehne ale neodosle spat spravu.<br> <br>Nov 8 08:02:20 server postfix/smtpd[20128]: disconnect from localhost[127.0.0.1]<br>Nov 8 08:02:20 server postfix/qmgr[11057]: E40904C098: from=<<a href="mailto:martin.plch@xxx.sk">martin.plch@xxx.sk</a>>, size=3879, nrcpt=2 (queue active)<br>Nov 8 08:02:20 server amavis[17317]: (17317-19) Passed CLEAN, [123.456.137.194] [123.456.137.194] <<a href="mailto:martin.plch@xxx.sk">martin.plch@xxx.sk</a>> -> <<a href="mailto:martin@yyy.eu">martin@yyy.eu</a>>, Message-ID: <<a href="mailto:01c301cedc50$719297d0$54b7c770$@xxx.sk">01c301cedc50$719297d0$54b7c770$@xxx.sk</a>>, mail_id: Nr1eYgtcrVlm, Hits: -1.471, size: 3239, queued_as: E40904C098, 4942 ms<br>Nov 8 08:02:20 server postfix/smtp[20077]: 071CE4C097: to=<<a href="mailto:martin@yyy.eu">martin@yyy.eu</a>>, 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)<br>Nov 8 08:02:20 server postfix/qmgr[11057]: 071CE4C097: removed<br>Nov 8 08:02:20 server postfix/pipe[20130]: E40904C098: to=<<a href="mailto:martin@yyy.eu">martin@yyy.eu</a>>, relay=dovecot, delay=0.15, delays=0.08/0/0/0.07, dsn=2.0.0, status=sent (delivered via dovecot service)<br>Nov 8 08:02:20 server yaa.pl[20166]: Warning: setting empty lookup query order for attribute 'rewrite_recipient'.<br>Nov 8 08:02:20 server yaa.pl[20166]: Warning: setting empty lookup query order for attribute 'rewrite_sender'.<br>Nov 8 08:02:20 server yaa.pl[20166]: 2419904: Processing new request, id 2419904<br>Nov 8 08:02:20 server yaa.pl[20166]: 2419904: Message sender: <a href="mailto:martin.plch@xxx.sk">martin.plch@xxx.sk</a>, recipients: <a href="mailto:martin@autoreply.yyy.eu">martin@autoreply.yyy.eu</a><br>Nov 8 08:02:20 server yaa.pl[20166]: 2419904: Processing complete.<br>Nov 8 08:02:20 server postfix/pipe[20131]: E40904C098: to=<<a href="mailto:martin@autoreply.yyy.eu">martin@autoreply.yyy.eu</a>>, orig_to=<<a href="mailto:martin@yyy.eu">martin@yyy.eu</a>>, relay=yaa, delay=0.21, delays=0.08/0/0/0.13, dsn=2.0.0, status=sent (delivered via yaa service)<br>Nov 8 08:02:20 server postfix/qmgr[11057]: E40904C098: removed<br> <br> <br> <br>Prosim vas pouziva niekto YAA script ako autoreply? <br> <br>Pripadne ma prosim nasmerujte k nejakemu skriptu ktory mate vyskusany.<br> <br>Schema podla ktorej sa to snazim rozbehat: <br></span><a href="http://unwin.org/postfix/vda-autoresponder.html"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>http://unwin.org/postfix/vda-autoresponder.html</span></a><br><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br>S pozdravom<br> <br>Martin Plch</span><o:p></o:p></p></td></tr></table><p class=MsoNormal><br><br><br><br><i><span style='font-family:"Arial","sans-serif";color:silver'>-- <br> bYE, Marki</span></i><o:p></o:p></p></div></body></html>