Polskie Forum Użytkowników Debiana

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

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'