Re: Problem with postfix and mysql

From: Mattia (no email)
Date: Sun May 15 2005 - 17:22:36 EDT

  • Next message: Mattia: "Re: Problem with postfix and mysql"

    Alle 20:39, sabato 14 maggio 2005, Andreas Winkelmann ha scritto:

    Hi,
    thank you very much for help me.

    I'm sorry but I was following "howto" www.high5.net/howto/ ,but it didn't
    work so I followed another one....
    I think I made confusion.... :-)

    > 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

    :# 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]

    :# 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

    :# less /etc/postfix/master.cf
    smtp inet n - n - - smtpd
    #127.0.0.1:25 inet n - n - - smtpd
            -o smtpd_etrn_restrictions=reject
    #628 inet n - - - - qmqpd
    pickup fifo n - - 60 1 pickup
    cleanup unix n - n - 0 cleanup
    qmgr fifo n - - 300 1 qmgr
    #qmgr fifo n - - 300 1 oqmgr
    rewrite unix - - n - - trivial-rewrite
    bounce unix - - - - 0 bounce
    defer unix - - - - 0 bounce
    trace unix - - - - 0 bounce
    verify unix - - - - 1 verify
    flush unix n - n 1000? 0 flush
    proxymap unix - - - - - proxymap
    smtp unix - - n - - smtp
    relay unix - - - - - smtp
    # -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
    showq unix n - - - - showq
    error unix - - - - - error
    local unix - - - - - local
    virtual unix - n n - - virtual
    lmtp unix - - - - - lmtp
    anvil unix - - - - 1 anvil

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

    thank you so much,for every suggestion

    Mattia


  • Next message: Mattia: "Re: Problem with postfix and mysql"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD