Re: Problem with postfix and mysql

From: Andreas Winkelmann (no email)
Date: Sun May 15 2005 - 17:38:13 EDT

  • Next message: Magnus Bäck: "Re: Overrides in MASTER.CF not working ... ?"

    Am Sunday 15 May 2005 23:22 schrieb Mattia:

    > > saslauthd or authdaemond ?
    >
    > I wanna use "authdaemond".
    >
    > > "postconf -n" please.
    >
    > broken_sasl_auth_clients = yes
    > config_directory = /etc/postfix
    > inet_interfaces = all
    > mailbox_command =
    > mailbox_size_limit = 0
    > mydestination = localhost
    > mydomain = area.loc
    > myhostname = server.area.loc
    > mynetworks = 127.0.0.0/8 192.168.1.0/24
    > myorigin = /etc/mailname
    > recipient_delimiter = +
    > relay_transport = relay domains
    > relayhost =
    > smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
    > smtpd_recipient_restrictions = permit_mynetworks,
    > permit_sasl_authenticated, reject_non_fqdn_hostname,
    > reject_non_fqdn_sender, reject_non_fqdn_recipient,
    > reject_unauth_destination, reject_unauth_pipelining,
    > reject_invalid_hostname, reject_rbl_client opm.blitzed.org,
    > reject_rbl_client list.dsbl.org, reject_rbl_client bl.spamcop.net,
    > reject_rbl_client sbl-xbl.spamhaus.org
    > smtpd_sasl_auth_enable = yes
    > smtpd_sasl_local_domain = $myhostname
    > smtpd_sasl_security_options = noanonymous
    > unknown_local_recipient_reject_code = 450
    > virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
    > virtual_gid_maps = static:104
    > virtual_mailbox_base = /usr/local/virtual
    > virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
    > virtual_mailbox_limit = 51200000
    > virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
    > virtual_minimum_uid = 103
    > virtual_transport = virtual
    > virtual_uid_maps = static:103
    >
    > > > :# cat /etc/postfix/sasl/smtpd.conf
    > > > pwcheck_method: authdaemond
    > > > log_level: 10
    > > > mech_list: PLAIN LOGIN
    > > > authdaemond_path:/var/run/courier/authdaemon/socket
    >
    > this is the same as "howto" but the problem is this:
    >
    > :# telnet localhost 25
    > Trying 127.0.0.1...
    > Connected to localhost.localdomain.
    > Escape character is '^]'.
    > 220 server.area.loc ESMTP Postfix (Debian/GNU)
    > helo server
    > 250 server.area.loc
    > mail from:
    > 250 Ok
    > rcpt to:
    > 250 Ok
    > data
    > 354 End data with <CR><LF>.<CR><LF>
    > .
    > 250 Ok: queued as 87D2C1308D
    > quit
    > 221 Bye
    > Connection closed by foreign host.
    >
    > how you can see,autodemon doesn't start

    Where should it start? What do you expect? If you want to see AUTH-Lines, you
    should use EHLO, not HELO.

    > :# tail -f /var/log/mail.log
    > these are the logs:
    > May 15 20:54:00 server postfix/smtpd[1176]: connect from
    > localhost.localdomain[127.0.0.1]
    > May 15 20:54:21 server postfix/smtpd[1176]: 87D2C1308D:
    > client=localhost.localdomain[127.0.0.1]
    > May 15 20:54:25 server postfix/cleanup[1182]: 87D2C1308D:
    > message-id=<>
    > May 15 20:54:26 server postfix/qmgr[1053]: 87D2C1308D:
    > from=<>, size=332, nrcpt=1 (queue active)
    > May 15 20:54:26 server postfix/virtual[1199]: 87D2C1308D:
    > to=<>, relay=virtual, delay=15, status=sent (delivered to
    > maildir)
    > May 15 20:54:26 server postfix/qmgr[1053]: 87D2C1308D: removed
    > May 15 20:54:28 server postfix/smtpd[1176]: disconnect from
    > localhost.localdomain[127.0.0.1]

    Is ok.

    > :# tail -f /var/log/auth.log
    > May 15 20:53:26 server postfix/smtpd[1176]: sql_select option missing
    > May 15 20:53:26 server postfix/smtpd[1176]: auxpropfunc error no mechanism
    > available
    > May 15 20:53:26 server postfix/smtpd[1176]: _sasl_plugin_load failed on
    > sasl_auxprop_plug_init for plugin: sql

    'Cause you want to use authdaemond, remove the sql-plugin from Cyrus-SASL
    Plugin-Directory. Then the Error regarding the missing sql_select will go
    away.

    > :# less /etc/postfix/master.cf
    > smtp inet n - n - - smtpd

    > in your opinion, why doesn't it find the authenticity?
    > why sasl doesn't start?

    -- 
    	Andreas
    

  • Next message: Magnus Bäck: "Re: Overrides in MASTER.CF not working ... ?"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD