<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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'>Myslis ze tu polozku z databazy adress niekde pouziva?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Pozrel som konfig a nemam ju nikde definovanu.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Nema sa pouzit takto?:<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 => ['my_sql_map:address'<br> # 'map_name:result', 'map_name2:result'<br> ],<br><br></span><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'>alebo si v db doplnim tam este address2 a potom by bolo<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>address = <a href="mailto:martin@autoreply.yyy.eu">martin@autoreply.yyy.eu</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a href="mailto:address2=martin@yyy.eu">address2=martin@yyy.eu</a><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'>a potom by som pouzil<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>rewrite_recipient => ['my_sql_map:address2'<br> # 'map_name:result', 'map_name2:result'<br> ],<br><br></span><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'>chcem sa uberat takymto smerom pretoze na tom servry bezi viac domen. A pri vacation sa to bude pridavat cez nejake web rozhranie.<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'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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 </span><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><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><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 1:06 PM<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"'>Ano, problem je v tom ze v db mas adresu v normalnom formate </span><a href="mailto:martin@YYY.eu"><span style='font-size:9.0pt;font-family:"Courier New"'>martin@YYY.eu</span></a><span style='font-size:9.0pt;font-family:"Courier New"'> ale YAA dostane request na </span><a href="mailto:martin@autoreply.yyy.eu"><span style='font-size:9.0pt;font-family:"Courier New"'>martin@autoreply.yyy.eu</span></a><span style='font-size:9.0pt;font-family:"Courier New"'> a nevie co s tym.<br>Ja som ten subor mal default v instalacii, je tam aj presne example pre tvoj pripad.<br>'recipient_pcre' treba vlozit medzi $lookup_maps a potom ho nastavit pre rewrite_recipient.<br><br>Obsahom suboru /usr/local/yaa/conf/recipient.pcre je (zmen si to na svoju domenu):<br><br># This is sample map file for PCRE lookup map driver<br># PCRE driver can use and parse any postfix pcre tables<br># AS LONG PATTERN, FLAGS and RESULT ARE IN THE SAME LINE.<br>#<br># if /pattern/flags, endif macros ARE NOT SUPPORTED<br><br># sample:<br># rewrite recipient <a href="mailto:*@autoreply.domain.tld">*@autoreply.domain.tld</a> to <a href="mailto:*@domain.tld">*@domain.tld</a><br># (handy for 'rewrite_recipient' autoresponse attribute)<br><br>#/^([\w\-\.]+)@autoreply\.domain\.tld/i <a href="mailto:$1@domain.tld">$1@domain.tld</a><br><br><br>Friday, November 8, 2013, 12:01:44, 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";color:#1F497D'>Ahoj,<br>V konfigu mam toto zmenene oproti original:<br> <br># run as daemon?<br># type: boolean<br># default: 0, do not run as daemon<br># this setting enables daemon mode operation.<br>$daemon = 0;<br> <br> <br>$lookup_maps = {<br>'my_sql_map' => {<br> 'driver' => 'SQL',<br> 'sql_dsn' => 'dbi:mysql:database=mailserver;host=127.0.0.1',<br> 'sql_username' => "user",<br> 'sql_password' => "passwd",<br> 'sql_select' => "select active,message,subject,charset,forward,address,local_domains from autoresponder where address = %m and active='1'",<br> },<br><u>};<br></u>$lookup_map_query_order = {<br>active => [ 'my_sql_map:active'<br> # 'map_name:result', 'map_name2:result'<br> ],<br> subject => ['my_sql_map:subject'<br> # 'map_name:result', 'map_name2:result'<br> ],<br> message => ['my_sql_map:message'<br> # 'map_name:result', 'map_name2:result'<br> ],<br> charset => ['my_sql_map:charset'<br> # 'map_name:result', 'map_name2:result'<br> ],<br> forward => ['my_sql_map:forward'<br> # 'map_name:result', 'map_name2:result'<br> ],<br> rewrite_sender => [<br> # 'map_name:result', 'map_name2:result'<br> ],<br> rewrite_recipient => [<br> # 'map_name:result', 'map_name2:result'<br> ],<br> 'local_domains' => ['my_sql_map:local_domains'<br> # 'map_name:result', 'map_name2:result'...<br> ],<br>};<br> <br></span><span style='font-size:9.0pt;font-family:"Courier New";color:black'>'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?<br> <br>Asi mi to preto nefunguje lebo to neprepise.<br> <br>V databaze mam<br>Tabulku autoresponder:<br>Polozky:<br>active message subject charset forward address local_domains tstart tfinish<br>obsah:<br>1 Message Body Message Subject <a href="mailto:martin@YYY.eu">martin@YYY.eu</a> YYY.eu 0 0<br> <br>Tabulku transport:<br>Polozky:<br>domain transport<br>obsah:<br>autoreply.YYY.eu yaa<br> <br> <br>Martin <br> <br></span><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'> linux [<a href="mailto:linux-bounces@lists.linux.sk">mailto:linux-bounces@lists.linux.sk</a>] <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<br></span><span style='color:black'> <br></span><span style='font-size:9.0pt;font-family:"Courier New";color:black'>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></span><a href="mailto:abc@autoreply.domena.sk"><span style='font-size:9.0pt;font-family:"Courier New"'>abc@autoreply.domena.sk</span></a><span style='font-size:9.0pt;font-family:"Courier New"'> to v YAA prepisat na </span><a href="mailto:abc@domena.sk"><span style='font-size:9.0pt;font-family:"Courier New"'>abc@domena.sk</span></a><span style='font-size:9.0pt;font-family:"Courier New"'>, aby to<br>vedel v db najst. Pokial mas v db priamo </span><a href="mailto:martin@autoreply.yyy.eu"><span style='font-size:9.0pt;font-family:"Courier New"'>martin@autoreply.yyy.eu</span></a><span style='font-size:9.0pt;font-family:"Courier New"'>, 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=<</span><a href="mailto:martin.plch@xxx.sk"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin.plch@xxx.sk</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, 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] <</span><a href="mailto:martin.plch@xxx.sk"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin.plch@xxx.sk</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>> -> <</span><a href="mailto:martin@yyy.eu"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin@yyy.eu</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, Message-ID: <</span><a href="mailto:01c301cedc50$719297d0$54b7c770$@xxx.sk"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>01c301cedc50$719297d0$54b7c770$@xxx.sk</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, 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=<</span><a href="mailto:martin@yyy.eu"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin@yyy.eu</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, 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=<</span><a href="mailto:martin@yyy.eu"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin@yyy.eu</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, 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: </span><a href="mailto:martin.plch@xxx.sk"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin.plch@xxx.sk</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>, recipients: </span><a href="mailto:martin@autoreply.yyy.eu"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin@autoreply.yyy.eu</span></a><br><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Nov 8 08:02:20 server yaa.pl[20166]: 2419904: Processing complete.<br>Nov 8 08:02:20 server postfix/pipe[20131]: E40904C098: to=<</span><a href="mailto:martin@autoreply.yyy.eu"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin@autoreply.yyy.eu</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, orig_to=<</span><a href="mailto:martin@yyy.eu"><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>martin@yyy.eu</span></a><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>>, 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><br><i><span style='font-family:"Arial","sans-serif";color:silver'>-- <br> bYE, Marki</span></i><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>