Hi all,
I'd like to ask for some help in making postfix work on my ubuntu box.
Please note: I'm not so expert in Linux, but learning with hands on!

I tried installing a mail system following step by step the valuable Abrahamsen guide (http://flurdy.com/docs/postfix/). But... when I began testing at half way (only basic services installed, mysql tables filled with my domain's data, but without content filtering or antivirus), I can't understand Postfix behaviour in querying on MySQL.

Let's say that the system has domain frog.com.

When I test connecting to port 25 and submitting a mail like this:
HELO anydomain.com
MAIL FROM: anyperson@anydomain.com
RCPT TO: frank@frog.com

from mysql log, I see that Postfix queries for (apart from the 'enabled' condition at the end):
1) SELECT domain FROM domains WHERE domain='anydomain.com'
2) SELECT destination FROM aliases WHERE mail='frog.com'
3) SELECT domain FROM domains WHERE domain='frog.com'

and session ends with NOQUEUE: reject: RCPT from localhost: 554 5.7.1 Service unavailable; Client host [127.0.0.1] blocked using sbl.spamhaus.org; from=<frank@anydomain.com> to=<frank@frog.com> proto=SMTP helo=<anydomain.com>

My questions are:
1) why does it check from sender domain being present in domains table?
2) why does it lookup only the domain frog.com in the destination field, while the whole address frank@frog.com is present in the aliases table, according to the guide instructions?


Thank you very much, I'm getting lost with setting up the mail system!
francesco




To be complete, below I report my tables content:

1) I imagine your sender restrictions, and

2) to check that your server is the destination.

You really need to post "postconf -n" when you have postfix problems btw.