From: Georg Gretz (no email)
Date: Sat Nov 02 2002 - 06:30:48 EST
I'm really confused now.
I am trying to send a mail to my postfix machine. Receiver is ggretz at gretzmedia dot biz dot Postfix should lookup in the virtual
table in a mysql db the redirection to . Then, postfix should lookup in the users db vor the
maildir of , which ist /var/spool/mail/web1p1/. Then it should place the mail there.
- Why is unknown to postfix?
- Why is postfix sending so many queries to the db? Are these queries not enough to achieve the task:
1. select transport from transport where domain = 'gretzmedia.biz'
2. select goto from virtual where address = ''
3. select maildir from users where adress = '' (got from goto, query 2)
The db tables have the same structure as in the "Postfix+Courier-IMAP+MySQL for multiple domains HOWTO" written by
Kirby Menzel and Lucas Peet.
Here are the logs.
-- /var/log/mysql/mysql.log --------------------------------------------------
021102 11:59:30 353 Connect postfix at localhost on maildb3
353 Query select transport from transport where domain = '*'
353 Query select transport from transport where domain = ''
353 Query select transport from transport where domain = 'gretzmedia.biz'
354 Connect postfix at localhost on maildb3
354 Query select goto from virtual where address = 'gretzmedia.biz'
354 Query select goto from virtual where address = 'gretzmedia.biz'
355 Connect postfix at localhost on maildb3
355 Query select maildir from users where address = ''
355 Query select maildir from users where address = '@gretzmedia.biz'
354 Query select goto from virtual where address = ''
355 Query select maildir from users where address = 'gretzmedia.biz'
356 Connect postfix at localhost on maildb3
356 Query select goto from virtual where address = ''
356 Query select goto from virtual where address = ''
356 Query select goto from virtual where address = 'postmaster'
356 Query select goto from virtual where address = '@gretzmedia.biz'
353 Query select transport from transport where domain = ''
353 Query select transport from transport where domain = 'gretzmedia.biz'
336 Query select goto from virtual where address = 'gretzmedia.biz'
356 Query select goto from virtual where address = ''
356 Query select goto from virtual where address = '@internetic.de'
353 Query select transport from transport where domain = ''
353 Query select transport from transport where domain = 'internetic.de'
353 Query select transport from transport where domain = '.de'
336 Query select goto from virtual where address = 'internetic.de'
------------------------------------------------------------------------------
-- /var/log/mail -------------------------------------------------------------
Nov 2 11:59:30 p15107547 postfix/smtpd[30704]: connect from waldorf.one-2-one.net[217.115.142.71]
Nov 2 11:59:30 p15107547 postfix/smtpd[30704]: 22F94214188: client=waldorf.one-2-one.net[217.115.142.71]
Nov 2 11:59:30 p15107547 postfix/cleanup[30705]: 22F94214188: message-id=<>
Nov 2 11:59:30 p15107547 postfix/qmgr[30674]: 22F94214188: from=<enjaxx at internetic dot de>, size=856, nrcpt=1 (queue active)
Nov 2 11:59:30 p15107547 postfix/smtpd[30704]: disconnect from waldorf.one-2-one.net[217.115.142.71]
Nov 2 11:59:30 p15107547 postfix/qmgr[30674]: 22F94214188: to=<postmast>, orig_to=<>, relay=none, delay=0, status=bounced (unknown user: "")
Nov 2 11:59:30 p15107547 postfix/cleanup[30705]: 78E662141B0: message-id=<>
Nov 2 11:59:30 p15107547 postfix/qmgr[30674]: 78E662141B0: from=<>, size=2521, nrcpt=1 (queue active)
Nov 2 11:59:30 p15107547 postfix/smtp[30712]: 78E662141B0: to=<enjaxx at internetic dot de>, relay=mail.internetic.de[217.115.142.71], delay=0, status=sent (250 2.0.0 gA2B1hl17721 Message accepted for delivery)
------------------------------------------------------------------------------
-- postconf -n output --------------------------------------------------------
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/lib/postfix
debug_peer_level = 2
default_destination_concurrency_limit = 10
default_privs = nobody
local_destination_concurrency_limit = 2
mail_name = Postfix on SuSE Linux 7.2 (i386)
mail_owner = postfix
mailq_path = /usr/bin/mailq
manpage_directory = /usr/local/man
mydestination = localhost.$myhostname
myhostname = gretzmedia.biz
newaliases_path = /usr/bin/newaliases
program_directory = /usr/lib/postfix
queue_directory = /var/spool/postfix
readme_directory = no
sample_directory = /etc/postfix
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
smtpd_banner = $myhostname ESMTP $mail_name
transport_maps = mysql:/etc/postfix/mysql_transport_maps.cf
virtual_gid_maps = mysql:/etc/postfix/mysql_virtual_gid_maps.cf
virtual_mailbox_base = /
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_maps = mysql:/etc/postfix/mysql_virtual_maps.cf
virtual_uid_maps = mysql:/etc/postfix/mysql_virtual_uid_maps.cf
------------------------------------------------------------------------------
-- mysql_transport_maps.cf ---------------------------------------------------
hosts=localhost
dbname=maildb3
table=transport
user=postfix
password=***
select_field=transport
where_field=domain
------------------------------------------------------------------------------
-- mysql_virtual_maps.cf -----------------------------------------------------
hosts=localhost
dbname=maildb3
table=virtual
user=postfix
password=***
select_field=goto
where_field=address
------------------------------------------------------------------------------
-- mysql_virtual_mailbox_maps.cf ---------------------------------------------
hosts=localhost
dbname=maildb3
table=users
user=postfix
password=***
select_field=maildir
where_field=address
------------------------------------------------------------------------------
-- mysql_virtual_uid_maps.cf -------------------------------------------------
hosts=localhost
dbname=maildb3
table=users
user=postfix
password=***
select_field=uid
where_field=address
------------------------------------------------------------------------------
-- mysql_virtual_gid_maps.cf -------------------------------------------------
hosts=localhost
dbname=maildb3
table=users
user=postfix
password=***
select_field=gid
where_field=address
------------------------------------------------------------------------------
> Hi,
> I have recently had similar problems, there are so many ways of
> configuring postix for many different scenarios, and the docs available
> on the web seem to at times contradict....
> I found this very frustrating... what compounded my frustration was the
> way the usergroup replys are kind of abrupt and always say the same
> "RTFM".
> Anyway, attached is a permissions map of a default install of Postfix
> What are you trying to achieve?
> I have just set up a Postfix relay to accept mail from internet
> (pointed to by MX record for our domain)
> this lives in a DMZ along side our external DNS server.
> It is configured to accept mail and pass it thru the firewall to our
> internal mail server. (local delivery and spam checking occurs here -
> just b'cos it was already in place)
> It is also configured to accept outgoing mail only from our internal
> mailserver to bedelivered to destinations on the internet.
> I would reccomend running postfix chrooted, if you are farmilliar with
> chroots, Postfix may confuse you (it got me) as it works a little
> different.
> Postfix actually starts up as root, then (after reading master.cf)
> starts the other daemons as lower priiledged users (a bit like
> apache)....
> If you need help I will try, but I am fairly new myself, and I am still
> 'tuning' my own config....
> Simon Crowther
-
To unsubscribe, send mail to with content
(not subject): unsubscribe postfix-users
|
|
|