Konfigurowałem autorespondera Yaa według tego poradnika:
http://www.linuxdicas.com.br/section-vi ... e-271.html
Mam na mySQL bazę z tabelami
[INDENT]# Przeglądaj autoresponder
# Przeglądaj transport
# Przeglądaj view_aliases
# Przeglądaj view_users
# Przeglądaj virtual_aliases
# Przeglądaj virtual_domains
# Przeglądaj virtual_users[/INDENT]
Tabela autoresponder ma takie dane:
Kod: Zaznacz cały
active message subject charset forward address local_domains tstart tfinish [url=https://helium.tagroup.pl/phpmyadmin/tbl_change.php?db=mail&table=autoresponder&token=64a465dafcb380f9ae4b4a9b7b1f5d09&primary_key=+CONVERT%28%60autoresponder%60.%60address%60+USING+utf8%29+%3D+%27admin%40tagroup.pl%27&sql_query=SELECT+%2A+FROM+%60autoresponder%60+WHERE+1&goto=sql.php]
[/URL] [url=https://helium.tagroup.pl/phpmyadmin/sql.php?db=mail&table=autoresponder&token=64a465dafcb380f9ae4b4a9b7b1f5d09&sql_query=DELETE+FROM+%60autoresponder%60+WHERE+CONVERT%28%60autoresponder%60.%60address%60+USING+utf8%29+%3D+%27admin%40tagroup.pl%27+LIMIT+1&zero_rows=Rekord+zosta%C5%82+skasowany&goto=sql.php%3Fdb%3Dmail%26table%3Dautoresponder%26token%3D64a465dafcb380f9ae4b4a9b7b1f5d09%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560autoresponder%2560%2BWHERE%2B1%26zero_rows%3DRekord%2Bzosta%25C5%2582%2Bskasowany%26goto%3Dtbl_sql.php]
[/URL] 1 Message Body Message Subject [EMAIL="[email protected]"][email protected][/EMAIL] domena.pl 1276779491 1276793891
Kod: Zaznacz cały
domain transport [url=https://helium.tagroup.pl/phpmyadmin/tbl_change.php?db=mail&table=transport&token=64a465dafcb380f9ae4b4a9b7b1f5d09&primary_key=+CONVERT%28%60transport%60.%60domain%60+USING+utf8%29+%3D+%27autoreply.tagroup.pl%27&sql_query=SELECT+%2A+FROM+%60transport%60+WHERE+1&goto=sql.php]
[/URL] [url=https://helium.tagroup.pl/phpmyadmin/sql.php?db=mail&table=transport&token=64a465dafcb380f9ae4b4a9b7b1f5d09&sql_query=DELETE+FROM+%60transport%60+WHERE+CONVERT%28%60transport%60.%60domain%60+USING+utf8%29+%3D+%27autoreply.tagroup.pl%27+LIMIT+1&zero_rows=Rekord+zosta%C5%82+skasowany&goto=sql.php%3Fdb%3Dmail%26table%3Dtransport%26token%3D64a465dafcb380f9ae4b4a9b7b1f5d09%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560transport%2560%2BWHERE%2B1%26zero_rows%3DRekord%2Bzosta%25C5%2582%2Bskasowany%26goto%3Dtbl_sql.php]
[/URL] domena.pl yaa:
Kod: Zaznacz cały
$lookup_maps = {
'my_sql_map' => {
'driver' => 'SQL',
'sql_dsn' => 'dbi:mysql:database=mail;host=localhost',
'sql_username' => "user",
'sql_password' => "haslo",
'sql_select' => "select active,message,subject,charset,forward,local_domains from autoresponder where address = %m and active='1' and tstart <= UNIX_TIMESTAMP() and tfinish >= UNIX_TIMESTAMP()",
},
$lookup_map_query_order = {
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_recipient => [
forward => ['my_sql_map:forward'
# 'map_name:result', 'map_name2:result'
], # 'map_name:result', 'map_name2:result'
],
'local_domains' => ['my_sql_map:local_domains'
# 'map_name:result', 'map_name2:result'...
],
},
Kod: Zaznacz cały
Jun 18 11:00:16 server postfix/cleanup[25788]: C046CDE083: message-id=<[email protected]>
Jun 18 11:00:16 server postfix/qmgr[3420]: C046CDE083: from=<[email protected]>, size=1213, nrcpt=1 (queue active)
Jun 18 11:00:16 server yaa.pl[27809]: Warning: setting empty lookup query order for attribute 'rewrite_recipient'.
Jun 18 11:00:16 server yaa.pl[27809]: Warning: setting empty lookup query order for attribute 'rewrite_sender'.
Jun 18 11:00:16 server yaa.pl[27809]: 5224366: Processing new request, id 5224366
Jun 18 11:00:16 server yaa.pl[27809]: 5224366: Warning: Your MTA does not provide Delivered-To header. Yaa will have to rely on message headers which are very easy to fake. You've been warned.
Jun 18 11:00:16 server yaa.pl[27809]: 5224366: Warning: Your MTA violates RFC 822 by not adding Return-Path header in message. Yaa will have to rely on message headers which are very easy to fake. You've be$
Jun 18 11:00:16 server yaa.pl[27809]: 5224366: Message sender: [EMAIL="[email protected]"][email protected][/EMAIL], recipients: [EMAIL="[email protected]"][email protected][/EMAIL]
Jun 18 11:00:17 server yaa.pl[27809]: 5224366: Processing complete.
Jun 18 11:00:17 server postfix/qmgr[3420]: C046CDE083: removed
Jun 18 11:00:17 server postfix/pipe[27808]: C046CDE083: to=<[email protected]>, relay=yaa, delay=0.25, delays=0.07/0.02/0/0.16, dsn=2.0.0, status=sent (delivered via yaa service)
Jun 18 11:00:18 server postfix/qmgr[3420]: 46504DE079: from=<>, size=706, nrcpt=1 (queue active)
Jun 18 11:00:18 server postfix/qmgr[3420]: 48DCCDE07A: from=<>, size=3116, nrcpt=1 (queue active)
Jun 18 11:00:18 server postfix/smtp[27811]: 48DCCDE07A: to=<[email protected]>, relay=mx6.go2.pl[193.17.41.46]:25, delay=549, delays=549/0.01/0.03/0.07, dsn=2.0.0, status=sent (250 OK queued as WMrrrY)
Jun 18 11:00:18 server postfix/qmgr[3420]: 48DCCDE07A: removed
Dodatkowo w postfixie mam ustawione:
Kod: Zaznacz cały
yaa unix - n n - - pipe
user=vmail
argv=/usr/local/postfix-tools/yaa-0.3.1/bin/yaa.pl
Kod: Zaznacz cały
transport_maps = proxy:mysql:/etc/postfix/transport
Kod: Zaznacz cały
user = użytkownik
password = hasło
hosts = 127.0.0.1
dbname = mail
#table = transport
#select_field = transport
#where_field = domain
#hosts = 127.0.0.1
query = SELECT transport FROM transport WHERE domain='%s'
No i co, nie wiecie co może być nie tak?
