if SASL using for SMTP auth, it must got (plaintext!) passwords from
dbmail_USERS table,
or duplicate passwords in original SASL database for each mail user (if want
make different passwd for POP/IMAP and SMTP).
Then, mail addresses (aliases) must be known for Postfix or mail will bounce.
For SASL can get user passwords from DBMail, it must have MySQL plugin
installed.
Then set please sasl_passdb and smtpd.conf files like this examples
/etc/postfix/sasl_passdb.cf
user = dbmail password = dbmail_passhosts = 127.0.0.1port=3306dbname =
dbmailtable = dbmail_usersselect_field = passwdwhere_field = userid
cat ./smtpd.conf# SASL library configuration file for postfix# all parameters
are documented into:# /usr/share/doc/cyrus-sasl-2.*/options.html
# The mech_list parameters list the sasl mechanisms to use,# default being all
mechs found.# To authenticate using the separate saslauthd daemon, (e.g. for#
system or ldap users). Also see /etc/sysconfig/saslauthd.# To authenticate
against users stored in sasldb.pwcheck_method: auxpropauxprop_plugin:
sqlsql_engine: mysqlmech_list: LOGIN PLAIN CRAM-MD5 # MY options - You may use
othersql_hostnames: 127.0.0.1:3306sql_user: dbmailsql_passwd:
dbmail_passsql_database: dbmailsql_verbose: yessql_select: SELECT passwd FROM
dbmail_users WHERE userid = '%u'For Postfix will know aliases from DBMail,
Postfix must have MySQL base read ability and
a file (I use /etc/postfix/sql-recipients.cf), added into local_recipient_maps
in main.cf like
local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf $alias_maps
cat ./sql-recipients.cfuser = dbmailpassword = dbmail_passwdhosts =
127.0.0.1port=3306dbname = dbmailtable = dbmail_aliasesselect_field =
aliaswhere_field = alias
This works for me now...
Best regards!
> Date: Sat, 20 Oct 2007 11:26:57 -0400> From: [EMAIL PROTECTED]> To:
> [email protected]> Subject: [Dbmail] Problematic with Postfix setup> > Hi
> all,> > I've heard wonderful things about DBMail and I'm looking to switch
> my> existing setup. One of the reasons I'm looking to switch is because of>
> the ability to filter virtual user mail with sieve. Currently I'm> having the
> following issues:> > When testing on my local box:> > Oct 20 11:19:47
> catalyst postfix/bounce[8450]: 47FC44443BC: sender> non-delivery
> notification: A61964443FE> Oct 20 11:19:47 catalyst postfix/qmgr[8441]:
> A61964443FE: from=<>,> size=2109, nrcpt=1 (queue active)> Oct 20 11:19:47
> catalyst postfix/qmgr[8441]: 47FC44443BC: removed> Oct 20 11:19:47 catalyst
> postfix/smtp[8449]: A61964443FE:> to=<[EMAIL PROTECTED]>, relay=none,
> delay=0.17, delays=0.07/0/0.1/0,> dsn=5.4.6, status=bounced (mail for
> phpgeek.org loops back to myself)> Oct 20 11:19:47 catalyst
> postfix/qmgr[8441]: A61964443FE: removed> > >From an external box:> > Oct 20
> 11:20:19 catalyst postfix/smtpd[8445]: NOQUEUE: reject: RCPT> from
> nz-out-0506.google.com[64.233.162.224]: 554 5.7.1> <[EMAIL PROTECTED]>: Relay
> access denied; from=<[EMAIL PROTECTED]>> to=<[EMAIL PROTECTED]> proto=ESMTP
> helo=<nz-out-0506.google.com>> > Here is my current postfix main.cf and
> master.cf, if anyone could be> as kind enough to help me.> > [EMAIL
> PROTECTED]:~/dbmail-2.2.7-rc4# postconf -n> alias_database =
> hash:/etc/postfix/aliases> alias_maps = hash:/etc/postfix/aliases>
> append_dot_mydomain = no> biff = no> broken_sasl_auth_clients = yes>
> config_directory = /etc/postfix> delay_warning_time = 4h>
> disable_vrfy_command = yes> inet_interfaces = all> local_recipient_maps =>
> mailbox_transport = dbmail-lmtp:localhost:24> maximal_backoff_time = 8000s>
> maximal_queue_lifetime = 7d> minimal_backoff_time = 1000s> mydestination =>
> myhostname = mail.phpgeek.org> mynetworks = 127.0.0.0/8> mynetworks_style =
> host> relayhost => smtp_helo_timeout = 60s> smtpd_banner = $myhostname ESMTP
> $mail_name (Microsoft Vista)> smtpd_client_restrictions = reject_rbl_client
> sbl.spamhaus.org,> reject_rbl_client relays.ordb.org, reject_rbl_client>
> blackholes.easynet.nl, reject_rbl_client dnsbl.njabl.org, permit>
> smtpd_data_restrictions = reject_unauth_pipelining> smtpd_delay_reject = yes>
> smtpd_hard_error_limit = 12> smtpd_helo_required = yes>
> smtpd_helo_restrictions = permit_mynetworks, warn_if_reject>
> reject_non_fqdn_hostname, reject_invalid_hostname, permit>
> smtpd_recipient_limit = 64> smtpd_recipient_restrictions =
> permit_mynetworks,> permit_sasl_authenticated, reject_unauth_pipelining,>
> reject_non_fqdn_recipient, reject_unknown_recipient_domain,>
> reject_unauth_destination, check_policy_service inet:127.0.0.1:60000,>
> permit> smtpd_sasl_auth_enable = yes> smtpd_sasl_local_domain =>
> smtpd_sasl_path = /etc/postfix/sasl:/usr/lib/sasl2>
> smtpd_sasl_security_options = noanonymous> smtpd_sender_restrictions =
> permit_sasl_authenticated,> permit_mynetworks, reject_non_fqdn_sender,>
> reject_unknown_sender_domain, reject_unauth_pipelining, permit>
> smtpd_soft_error_limit = 3> smtpd_tls_cert_file = /etc/postfix/postfix.cert>
> smtpd_tls_key_file = /etc/postfix/postfix.key> smtpd_use_tls = yes>
> unknown_local_recipient_reject_code = 450> > [EMAIL
> PROTECTED]:~/dbmail-2.2.7-rc4# cat /etc/postfix/master.cf> #> # Postfix
> master process configuration file. For details on the format> # of the file,
> see the master(5) manual page (command: "man 5 master").> #> #
> ==========================================================================> #
> service type private unpriv chroot wakeup maxproc command + args> # (yes)
> (yes) (yes) (never) (100)> #
> ==========================================================================>
> #smtp inet n - - - - smtpd> smtp inet n - - - - smtpd> -o
> cleanup_service_name=pre-cleanup> submission inet n - - - - smtpd> -o
> smtpd_enforce_tls=yes> -o smtpd_sasl_auth_enable=yes> -o
> smtpd_client_restrictions=permit_sasl_authenticated,reject> #smtps inet n - -
> - - smtpd> smtps inet n - n - - smtpd -o> smtpd_tls_wrappermode=yes -o
> smtpd_sasl_auth_enable=yes> -o smtpd_tls_wrappermode=yes> -o
> smtpd_sasl_auth_enable=yes> -o
> smtpd_client_restrictions=permit_sasl_authenticated,reject> #628 inet n - - -
> - qmqpd> pickup fifo n - - 60 1 pickup> #cleanup unix n - - - 0 cleanup>
> cleanup unix n - - - 0 cleanup> -o mime_header_checks=> -o
> nested_header_checks=> -o body_checks=> -o header_checks=> amavis unix - - -
> - 2 smtp> -o smtp_data_done_timeout=1200> -o smtp_send_xforward_command=yes>
> 127.0.0.1:10025 inet n - - - - smtpd> -o content_filter=> -o
> local_recipient_maps=> -o relay_recipient_maps=> -o
> smtpd_restriction_classes=> -o smtpd_client_restrictions=> -o
> smtpd_helo_restrictions=> -o smtpd_sender_restrictions=> -o
> smtpd_recipient_restrictions=permit_mynetworks,reject> -o
> strict_rfc821_envelopes=yes> -o mynetworks=127.0.0.0/8> -o
> smtpd_error_sleep_time=0> -o smtpd_soft_error_limit=1001> -o
> smtpd_hard_error_limit=1001> pre-cleanup unix n - - - 0 cleanup> -o
> virtual_alias_maps=> -o canonical_maps=> -o sender_canonical_maps=> -o
> recipient_canonical_maps=> -o masquerade_domains=> dbmail-lmtp unix - - n - -
> lmtp -v> qmgr fifo n - n 300 1 qmgr> #qmgr fifo n - - 300 1 oqmgr> #tlsmgr
> unix - - - 1000? 1 tlsmgr> tlsmgr unix - - n 300 1 tlsmgr> rewrite unix - - -
> - - trivial-rewrite> bounce unix - - - - 0 bounce> defer unix - - - - 0
> bounce> trace unix - - - - 0 bounce> verify unix - - - - 1 verify> flush unix
> n - - 1000? 0 flush> proxymap unix - - n - - proxymap> smtp unix - - - - -
> smtp> # When relaying mail as backup MX, disable fallback_relay to avoid MX
> loops> relay unix - - - - - smtp> -o fallback_relay=> # -o
> smtp_helo_timeout=5 -o smtp_connect_timeout=5> showq unix n - - - - showq>
> error unix - - - - - error> discard unix - - - - - discard> local unix - n n
> - - local> virtual unix - n n - - virtual> lmtp unix - - - - - lmtp> anvil
> unix - - - - 1 anvil> scache unix - - - - 1 scache> #> #
> ====================================================================> #
> Interfaces to non-Postfix software. Be sure to examine the manual> # pages of
> the non-Postfix software to find out what options it wants.> #> # Many of the
> following services use the Postfix pipe(8) delivery> # agent. See the pipe(8)
> man page for information about ${recipient}> # and other message envelope
> options.> #
> ====================================================================> #> #
> maildrop. See the Postfix MAILDROP_README file for details.> # Also specify
> in main.cf: maildrop_destination_recipient_limit=1> #> maildrop unix - n n -
> - pipe> flags=DRhu user=virtual argv=/usr/bin/maildrop -d ${recipient}> #> #
> See the Postfix UUCP_README file for configuration details.> #> uucp unix - n
> n - - pipe> flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail
> ($recipient)> #> # Other external delivery methods.> #> 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=bsmtp argv=/usr/lib/bsmtp/bsmtp
> -t$nexthop -f$sender $recipient> scalemail-backend unix - n n - 2 pipe>
> flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store>
> ${nexthop} ${user} ${extension}> mailman unix - n n - - pipe> flags=FR
> user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py> ${nexthop}
> ${user}> > 587 inet n - n - - smtpd -o> smtpd_enforce_tls=yes -o
> smtpd_sasl_auth_enable=yes> > Thank you.> > - sf>
> _______________________________________________> DBmail mailing list>
> [email protected]> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
