Hi, I compiled and installed the 2.0-pre version of DBmail but it doesn't
seem to be working properly ;( Sendmail just bounces the messages back to
the sender. Here is a snippet of the logfile:
Jul 1 15:43:30 daimonion postfix/postfix-script: warning:
/var/spool/postfix/etc/localtime and /etc/localtime differ
Jul 1 15:43:31 daimonion postfix/postfix-script: warning:
/var/spool/postfix/etc/host.conf and /etc/host.conf differ
Jul 1 15:43:31 daimonion postfix/postfix-script: warning:
/var/spool/postfix/etc/nsswitch.conf and /etc/nsswitch.conf differ
Jul 1 15:43:31 daimonion postfix/postfix-script: warning:
/var/spool/postfix/etc/hosts and /etc/hosts differ
Jul 1 15:43:31 daimonion postfix/postfix-script: starting the Postfix mail
system
Jul 1 15:43:31 daimonion postfix: succeeded
Jul 1 15:43:31 daimonion postfix/master[19607]: daemon started -- version
2.1.0-pre-20040209
Jul 1 15:44:01 daimonion postfix/smtpd[19616]: connect from unknown[10.1.0.50]
Jul 1 15:44:19 daimonion postfix/smtpd[19616]: DA03F250821:
client=unknown[10.1.0.50]
Jul 1 15:44:22 daimonion postfix/cleanup[19618]: DA03F250821:
message-id=<[EMAIL PROTECTED]>
Jul 1 15:44:22 daimonion postfix/qmgr[19612]: DA03F250821: from=<[EMAIL
PROTECTED]>, size=327, nrcpt=1 (queue active)
Jul 1 15:44:22 daimonion postfix/local[19619]: DA03F250821: to=<[EMAIL
PROTECTED]>, relay=local, delay=12, status=bounced (unknown user: "test")
Jul 1 15:44:22 daimonion postfix/cleanup[19618]: 530BE250822:
message-id=<[EMAIL PROTECTED]>
Jul 1 15:44:22 daimonion postfix/qmgr[19612]: 530BE250822: from=<>, size=1917,
nrcpt=1 (queue active)
Jul 1 15:44:22 daimonion postfix/qmgr[19612]: DA03F250821: removed
Jul 1 15:44:24 daimonion postfix/smtp[19622]: 530BE250822: to=<[EMAIL
PROTECTED]>, relay=mail.kadu.net[80.51.58.140], delay=2, status=sent (250 ok
1088689526 qp 10317)
Jul 1 15:44:24 daimonion postfix/qmgr[19612]: 530BE250822: removed
Jul 1 15:44:53 daimonion postfix/smtpd[19616]: disconnect from
unknown[10.1.0.50]
I also enclose my transport, master.cf, main.cf and dbmail.conf that should
be relevant.
What am I doing wrong? Help, please, I am nearing a deadline ;(((
--
tomasz k. jarzynka / 601 706 601 / tomee(a-t)kadu(d-o-t)net
"As a computer, I find your faith in technology amusing."
# $Id: dbmail.conf,v 1.103 2004/04/26 08:27:55 ilja Exp $
# (c) 2000-2002 IC&S, The Netherlands
#
# Configuration file for DBMAIL
# This configuration file needs to be run through dbmail-config to be effective
# after that, changes are effective inmediatly
[DBMAIL]
# Database settings
host=localhost # host for database, set to localhost if
database is om
# the same host as dbmail and you want to use a local
socket
# for connecting.
sqlport= # if you want to use TCP/IP for connecting to the
database,
# and have the database running on a non-standard port.
sqlsocket= # when using a local socket connection to the database,
fill
# in the path to the socket here (e.g.
/var/run/mysql.sock)
user=dbmail # user to connect as to database
pass=dbmail123 # password for user to database
db=dbmail # name of database
# trace level for dbmail-maintenance
TRACE_LEVEL=2
[SMTP]
SENDMAIL=/usr/sbin/sendmail # your sendmail executable, this is needed for
bouncing
# and forwarding mail.
DBMAIL_FROM_ADDRESS= # the email address where bounces come from
POSTMASTER= # postmaster's email address (which is used in the
bounce messages)
AUTO_NOTIFY=no
AUTO_REPLY=no
TRACE_LEVEL=5
[LMTP]
EFFECTIVE_USER=nobody # the user that dbmail-lmtpd will run as
(need to be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that dbmail-lmtpd will run as
BINDIP=* # the ipaddress the dbmail-lmtpd server has to bind
# to, * for all adresses. Use 127.0.0.1 to only
# bind to localhost.
PORT=24 # the port number the dbmail-lmtpd server has
to bind to.
NCHILDREN=2 # default number of LMTP handlers (each is a
process)
MAXCHILDREN=2 # mac. number of LMTP handlers
MAXCONNECTS=100 # the maximum number of connections a default
childs makes
TIMEOUT=300 # the time (s) before the dbmail-lmtpd should
shutdown a connection which is being idle.
RESOLVE_IP=yes # if yes, the lmtp daemon resolves IP numbers
to DNS names in the log
TRACE_LEVEL=5
MAX_ERRORS=500
[POP]
EFFECTIVE_USER=nobody # the user that dbmail-pop3d will run as
(need to be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that dbmail-pop3d will run as
BINDIP=* # the ipaddress the dbmail-pop3d server has
to bind to, * for all addresses
PORT=110 # the port number the dbmail-pop3d server has
to bind to.
NCHILDREN=50 # default number of POP3 handlers (each is a
process)
MAXCHILDREN=200 # mac. number of POP3 handlers
MAXCONNECTS=10000 # the maximum number of connections a default
childs makes
TIMEOUT=300 # the time (s) before the dbmail-pop3d should
shutdown a connection which is being idle.
RESOLVE_IP=yes # if yes, the pop daemon resolves IP numbers
to DNS names in the log
POP_BEFORE_SMTP=no
TRACE_LEVEL=5
[IMAP]
EFFECTIVE_USER=nobody
EFFECTIVE_GROUP=nogroup
BINDIP=*
PORT=143
NCHILDREN=50
MAXCONNECTS=10000 # the maximum number of connections a default
childs makes
TIMEOUT=4000 # the time (s) before the dbmail-imapd should
shutdown a connection which is being idle.
RESOLVE_IP=yes # if yes, the imap daemon resolves IP numbers
to DNS names in the log
IMAP_BEFORE_SMTP=no
TRACE_LEVEL=5
# end of configuration file
# TRANSPORT(5) TRANSPORT(5)
#
# NAME
# transport - format of Postfix transport table
#
# SYNOPSIS
# postmap /etc/postfix/transport
#
# postmap -q "string" /etc/postfix/transport
#
# postmap -q - /etc/postfix/transport <inputfile
#
# DESCRIPTION
# The optional transport table specifies a mapping from
# email addresses to message delivery transports and/or
# relay hosts. The mapping is used by the trivial-rewrite(8)
# daemon.
#
# This mapping overrides the default routing that is built
# into Postfix:
#
# mydestination
# A list of domains that is by default delivered via
# $local_transport.
#
# virtual_mailbox_domains
# A list of domains that is by default delivered via
# $virtual_transport.
#
# relay_domains
# A list of domains that is by default delivered via
# $relay_transport.
#
# any other destination
# Mail for any other destination is by default deliv-
# ered via $default_transport.
#
# Normally, the transport table is specified as a text file
# that serves as input to the postmap(1) command. The
# result, an indexed file in dbm or db format, is used for
# fast searching by the mail system. Execute the command
# postmap /etc/postfix/transport in order to rebuild the
# indexed file after changing the transport table.
#
# When the table is provided via other means such as NIS,
# LDAP or SQL, the same lookups are done as for ordinary
# indexed files.
#
# Alternatively, the table can be provided as a regular-
# expression map where patterns are given as regular expres-
# sions, or lookups can be directed to TCP-based server. In
# that case, the lookups are done in a slightly different
# way as described below under "REGULAR EXPRESSION TABLES"
# and "TCP-BASED TABLES".
#
# TABLE FORMAT
# The input format for the postmap(1) command is as follows:
#
# pattern result
# When pattern matches the recipient address or
# domain, use the corresponding result.
#
# blank lines and comments
# Empty lines and whitespace-only lines are ignored,
# as are lines whose first non-whitespace character
# is a `#'.
#
# multi-line text
# A logical line starts with non-whitespace text. A
# line that starts with whitespace continues a logi-
# cal line.
#
# The pattern specifies an email address, a domain name, or
# a domain name hierarchy, as described in section "TABLE
# LOOKUP".
#
# The result is of the form transport:nexthop. The trans-
# port field specifies a mail delivery transport such as
# smtp or local. The nexthop field specifies where and how
# to deliver mail. More details are given in section "RESULT
# FORMAT".
#
# TABLE LOOKUP
# With lookups from indexed files such as DB or DBM, or from
# networked tables such as NIS, LDAP or SQL, patterns are
# tried in the order as listed below:
#
# [EMAIL PROTECTED] transport:nexthop
# Mail for [EMAIL PROTECTED] is delivered through
# transport to nexthop.
#
# [EMAIL PROTECTED] transport:nexthop
# Mail for [EMAIL PROTECTED] is delivered through transport
# to nexthop.
#
# domain transport:nexthop
# Mail for domain is delivered through transport to
# nexthop.
#
# .domain transport:nexthop
# Mail for any subdomain of domain is delivered
# through transport to nexthop. This applies only
# when the string transport_maps is not listed in the
# parent_domain_matches_subdomains configuration set-
# ting. Otherwise, a domain name matches itself and
# its subdomains.
#
# Note 1: the special pattern * represents any address (i.e.
# it functions as the wild-card pattern).
#
# Note 2: the null recipient address is looked up as
# [EMAIL PROTECTED] (default: mailer-dae-
# [EMAIL PROTECTED]).
#
# RESULT FORMAT
# The transport field specifies the name of a mail delivery
# transport (the first name of a mail delivery service entry
# in the Postfix master.cf file).
#
# The interpretation of the nexthop field is transport
# dependent. In the case of SMTP, specify host:service for a
# non-default server port, and use [host] or [host]:port in
# order to disable MX (mail exchanger) DNS lookups. The []
# form is required when you specify an IP address instead of
# a hostname.
#
# A null transport and null nexthop result means "do not
# change": use the delivery transport and nexthop informa-
# tion that would be used when the entire transport table
# did not exist.
#
# A non-null transport field with a null nexthop field
# resets the nexthop information to the recipient domain.
#
# A null transport field with non-null nexthop field does
# not modify the transport information.
#
# EXAMPLES
# In order to deliver internal mail directly, while using a
# mail relay for all other mail, specify a null entry for
# internal destinations (do not change the delivery trans-
# port or the nexthop information) and specify a wildcard
# for all other destinations.
#
# my.domain :
# .my.domain :
# * smtp:outbound-relay.my.domain
#
# In order to send mail for foo.org and its subdomains via
# the uucp transport to the UUCP host named foo:
#
# foo.org uucp:foo
# .foo.org uucp:foo
#
# When no nexthop host name is specified, the destination
# domain name is used instead. For example, the following
# directs mail for [EMAIL PROTECTED] via the slow transport to a
# mail exchanger for foo.org. The slow transport could be
# something that runs at most one delivery process at a
# time:
#
# foo.org slow:
#
# When no transport is specified, Postfix uses the transport
# that matches the address domain class (see TRANSPORT FIELD
# discussion above). The following sends all mail for
# foo.org and its subdomains to host gateway.foo.org:
#
# foo.org :[gateway.foo.org]
# .foo.org :[gateway.foo.org]
#
# In the above example, the [] are used to suppress MX
# lookups. The result would likely point to your local
# machine.
#
# In the case of delivery via SMTP, one may specify host-
# name:service instead of just a host:
#
# foo.org smtp:bar.org:2025
#
# This directs mail for [EMAIL PROTECTED] to host bar.org port
# 2025. Instead of a numerical port a symbolic name may be
# used. Specify [] around the hostname in order to disable
# MX lookups.
#
# The error mailer can be used to bounce mail:
#
# .foo.org error:mail for *.foo.org is not deliv-
# erable
#
# This causes all mail for [EMAIL PROTECTED] to be
# bounced.
#
# REGULAR EXPRESSION TABLES
# This section describes how the table lookups change when
# the table is given in the form of regular expressions. For
# a description of regular expression lookup table syntax,
# see regexp_table(5) or pcre_table(5).
#
# Each pattern is a regular expression that is applied to
# the entire address being looked up. Thus,
# some.domain.hierarchy is not looked up up via its parent
# domains, nor is [EMAIL PROTECTED] looked up as [EMAIL PROTECTED]
#
# Patterns are applied in the order as specified in the
# table, until a pattern is found that matches the search
# string.
#
# Results are the same as with indexed file lookups, with
# the additional feature that parenthesized substrings from
# the pattern can be interpolated as $1, $2 and so on.
#
# TCP-BASED TABLES
# This section describes how the table lookups change when
# lookups are directed to a TCP-based server. For a descrip-
# tion of the TCP client/server lookup protocol, see
# tcp_table(5).
#
# Each lookup operation uses the entire recipient address
# once. Thus, some.domain.hierarchy is not looked up via
# its parent domains, nor is [EMAIL PROTECTED] looked up as
# [EMAIL PROTECTED]
#
# Results are the same as with indexed file lookups.
#
# CONFIGURATION PARAMETERS
# The following main.cf parameters are especially relevant
# to this topic. See the Postfix main.cf file for syntax
# details and for default values. Use the postfix reload
# command after a configuration change.
#
# empty_address_recipient
# The address that is looked up instead of the null
# sender address.
#
# parent_domain_matches_subdomains
# List of Postfix features that use domain.tld pat-
# terns to match sub.domain.tld (as opposed to
# requiring .domain.tld patterns).
#
# transport_maps
# List of transport lookup tables.
#
# SEE ALSO
# postmap(1) create mapping table
# trivial-rewrite(8) rewrite and resolve addresses
# pcre_table(5) format of PCRE tables
# regexp_table(5) format of POSIX regular expression tables
# tcp_table(5) TCP client/server table lookup protocol
#
# LICENSE
# The Secure Mailer license must be distributed with this
# software.
#
# AUTHOR(S)
# Wietse Venema
# IBM T.J. Watson Research
# P.O. Box 704
# Yorktown Heights, NY 10598, USA
#
# TRANSPORT(5)
mailbox_transport = dbmail-lmtp:localhost:24
#
# Postfix master process configuration file. Each logical line
# describes how a Postfix daemon program should be run.
#
# A logical line starts with non-whitespace, non-comment text.
# Empty lines and whitespace-only lines are ignored, as are comment
# lines whose first non-whitespace character is a `#'.
# A line that starts with whitespace continues a logical line.
#
# The fields that make up each line are described below. A "-" field
# value requests that a default value be used for that field.
#
# Service: any name that is valid for the specified transport type
# (the next field). With INET transports, a service is specified as
# host:port. The host part (and colon) may be omitted. Either host
# or port may be given in symbolic form or in numeric form. Examples
# for the SMTP server: localhost:smtp receives mail via the loopback
# interface only; 10025 receives mail on port 10025.
#
# Transport type: "inet" for Internet sockets, "unix" for UNIX-domain
# sockets, "fifo" for named pipes.
#
# Private: whether or not access is restricted to the mail system.
# Default is private service. Internet (inet) sockets can't be private.
#
# Unprivileged: whether the service runs with root privileges or as
# the owner of the Postfix system (the owner name is controlled by the
# mail_owner configuration variable in the main.cf file). Only the
# pipe, virtual and local delivery daemons require privileges.
#
# Chroot: whether or not the service runs chrooted to the mail queue
# directory (pathname is controlled by the queue_directory configuration
# variable in the main.cf file). Presently, all Postfix daemons can run
# chrooted, except for the pipe, virtual and local delivery daemons.
# The proxymap server can run chrooted, but doing so defeats most of
# the purpose of having that service in the first place.
# The script postfix-chroot.sh can be used to set up a Postfix chroot
# environment on your Mandrake Linux System
#
# Wakeup time: automatically wake up the named service after the
# specified number of seconds. A ? at the end of the wakeup time
# field requests that wake up events be sent only to services that
# are actually being used. Specify 0 for no wakeup. Presently, only
# the pickup, queue manager and flush daemons need a wakeup timer.
#
# Max procs: the maximum number of processes that may execute this
# service simultaneously. Default is to use a globally configurable
# limit (the default_process_limit configuration parameter in main.cf).
# Specify 0 for no process count limit.
#
# Command + args: the command to be executed. The command name is
# relative to the Postfix program directory (pathname is controlled by
# the daemon_directory configuration variable). Adding one or more
# -v options turns on verbose logging for that service; adding a -D
# option enables symbolic debugging (see the debugger_command variable
# in the main.cf configuration file). See individual command man pages
# for specific command-line options, if any.
#
# General main.cf options can be overridden for specific services.
# To override one or more main.cf options, specify them as arguments
# below, preceding each option by "-o". There must be no whitespace
# in the option itself (separate multiple values for an option by
# commas).
#
# In order to use the "uucp" message tranport below, set up entries
# in the transport table.
#
# In order to use the "cyrus" message transport below, configure it
# in main.cf as the mailbox_transport.
#
# SPECIFY ONLY PROGRAMS THAT ARE WRITTEN TO RUN AS POSTFIX DAEMONS.
# ALL DAEMONS SPECIFIED HERE MUST SPEAK A POSTFIX-INTERNAL PROTOCOL.
#
# DO NOT SHARE THE POSTFIX QUEUE BETWEEN MULTIPLE POSTFIX INSTANCES.
#
# ==========================================================================
# service type private unpriv chroot wakeup maxproc command + args
# (yes) (yes) (yes) (never) (100)
# ==========================================================================
smtp inet n - y - - smtpd
#smtps inet n - n - - smtpd
# -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
#submission inet n - n - - smtpd
# -o smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes
#628 inet n - n - - qmqpd
pickup fifo n - y 60 1 pickup
-o content_filter=
-o receive_override_options=
cleanup unix n - y - 0 cleanup
qmgr fifo n - y 300 1 qmgr
#qmgr fifo n - n 300 1 oqmgr
tlsmgr fifo - - y 300 1 tlsmgr
rewrite unix - - y - - trivial-rewrite
bounce unix - - y - 0 bounce
defer unix - - y - 0 bounce
trace unix - - y - 0 bounce
verify unix - - y - 1 verify
flush unix n - y 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - y - - smtp
relay unix - - y - - smtp
# -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq unix n - y - - showq
error unix - - y - - error
local unix - n n - - local
virtual unix - n n - - virtual
#lmtp unix - - y - - lmtp
#
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
#
# maildrop. See the Postfix MAILDROP_README file for details.
#
maildrop unix - n n - - pipe
flags=DRhu user=nobody argv=/usr/bin/maildrop -d ${recipient}
#
# Cyrus. Please See the Postfix CYRUS_README file for details
#
# deliver interface (deprecated), to use this also use
# postconf -e cyrus-deliver_destination_recipient_limit=1
cyrus-deliver unix - n n - - pipe
user=cyrus argv=/usr/lib/cyrus-imapd/deliver -e -r ${sender} -m ${extension}
${user}
#
# for default cyrus socket placement
cyrus unix - n n - - lmtp
-o lmtp_cache_connection=yes
#
# if you configure cyrus socket in the chroot jail
cyrus-chroot unix - - y - - lmtp
-o lmtp_cache_connection=yes
#
# for lmtp to cyrus via tcp
cyrus-inet unix - - y - - lmtp
-o lmtp_cache_connection=yes
-o lmtp_sasl_auth_enable=yes
-o lmtp_sasl_password_maps=hash:/etc/postfix/cyrus_lmtp_sasl_pass
-o lmtp_sasl_security_options=noanonymous
#
# UUCP. Unix to Unix CoPy
#
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=/usr/bin/uux -r -n -z -a$sender - $nexthop!rmail
($recipient)
#
# these are not distributed with Mandrake Linux
#
#ifmail unix - n n - - pipe
# flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
#bsmtp unix - n n - - pipe
# flags=Fq. user=foo argv=/usr/local/sbin/bsmtp -f $sender $nexthop $recipient
##### START OF CONTENT FILTER CUSTOMIZATIONS #####
# Please see the Postfix FILTER_README for details.
# These sample entries expect your content filter to
# listen on port 10025 and to inject mail back into
# postfix on port 10026.
#
# to enable such content filter run the command
# postconf -e content_filter=smtp-filter:127.0.0.1:10025
# postconf -e smtp-filter_destination_concurrency_limit=2
# or
# postconf -e content_filter=lmtp-filter:127.0.0.1:10025
# postconf -e lmtp-filter_destination_concurrency_limit=2
# and the command
# postconf -e receive_override_options=no_address_mappings
#
127.0.0.1:10026 inet n - y - - smtpd
-o content_filter=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8
-o mynetworks_style=host
-o strict_rfc821_envelopes=yes
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_client_connection_limit_exceptions=127.0.0.0/8
lmtp-filter unix - - y - - lmtp
-o lmtp_data_done_timeout=1200
-o disable_dns_lookups=yes
smtp-filter unix - - y - - smtp
-o smtp_data_done_timeout=1200
-o disable_dns_lookups=yes
dbmail-lmtp unix - - n - - lmtp -v
##### END OF CONTENT FILTER CUSTOMIZATIONS #####
# These are only the parameters changed from a default install
# see /etc/postfix/main.cf.dist for a commented, fuller version of this file.
# These are changed by postfix install script
readme_directory = /usr/share/doc/postfix-2.1.0/README_FILES
sample_directory = /usr/share/doc/postfix-2.1.0/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
command_directory = /usr/sbin
manpage_directory = /usr/share/man
daemon_directory = /usr/lib/postfix
newaliases_path = /usr/bin/newaliases.postfix
mailq_path = /usr/bin/mailq.postfix
queue_directory = /var/spool/postfix
mail_owner = postfix
# User configurable parameters
myhostname = arista.ath.cx
inet_interfaces = localhost daimonion
mynetworks_style = host
delay_warning_time = 4h
smtpd_banner = $myhostname ESMTP $mail_name ($mail_version)
unknown_local_recipient_reject_code = 450
local_recipient_maps =
smtp-filter_destination_concurrency_limit = 2
lmtp-filter_destination_concurrency_limit = 2
smtpd_sasl_path = /etc/postfix/sasl:/usr/lib/sasl2
recipient_delimiter = +
owner_request_special = no
alias_maps = hash:/etc/postfix/aliases, hash:/var/lib/mailman/data/aliases
