postfix/smtpd[5673]: sql_select option missing

Discussion in 'Server Operation' started by CarbonCopy, Apr 23, 2010.

  1. CarbonCopy

    CarbonCopy New Member

    I'm using Postfix and Courier Imap with MySQL authentication and I see that error popping up a lot in my logs. The thing is, every site I find that references this is people who DON'T use SQL authentication, but I AM using it, and it works fine. How might i get rid of these errors

    Code:
    Apr 22 23:18:28 cl-t112-271cl postfix/smtpd[5673]: sql_select option missing
    Apr 22 23:18:28 cl-t112-271cl postfix/smtpd[5673]: auxpropfunc error no mechanism available
    
     
  2. Mark_NL

    Mark_NL New Member

    Did you use any how-to from this site to install it?
     
  3. CarbonCopy

    CarbonCopy New Member

    Yes, I used the Postfix/Courier/Amavisd with virtual users for CentOS 5.3 tutorial (Which I couldn't find to link you to)
     
  4. falko

    falko Super Moderator ISPConfig Developer

  5. Mark_NL

    Mark_NL New Member

    centos' postfix comes withoud mysql support, so you need to recompile it with mysql support. there are threads on the forum about this.
     
  6. CarbonCopy

    CarbonCopy New Member

    Yes, I realize that, and since I specified my installation is working fine, I have recompiled it with MySQL authentication support
     
  7. CarbonCopy

    CarbonCopy New Member

    my configurations are fine as far as I can tell

    Code:
    # Some server info
    myhostname = smtp.northernlightstechnology.ca
    mydestination = smtp.northernlightstechnology.ca, localhost, localhost.localdomain
    mynetworks = 127.0.0.0/8
    message_size_limit = 30720000
    
    # This is to setup virtual domains and users
    virtual_alias_domains =
    virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
    #alias_maps = hash:/etc/aliases
    virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_mailbox_base = /home/vmail
    virtual_uid_maps = static:5000
    virtual_gid_maps = static:5000
    
    # This is authentication related
    smtpd_sasl_auth_enable = yes
    broken_sasl_auth_clients = yes
    smtpd_sasl_authenticated_header = yes
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
    
    # Use TLS
    smtpd_use_tls = yes
    smtpd_tls_cert_file = /etc/postfix/smtpd.pem
    smtpd_tls_key_file = /etc/postfix/smtpd.pem
    smtpd_tls_CAfile = /etc/postfix/smtpd.pem
    
    # Some more virtual user stuff
    transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
    virtual_transport = maildrop
    maildrop_destination_recipient_limit = 1
    
    # Other stuff??
    virtual_create_maildirsize = yes
    virtual_maildir_extended = yes
    virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
    virtual_mailbox_limit_override = yes
    virtual_maildir_limit_message = "The user you are trying to reach is over quota."
    virtual_overquota_bounce = yes
    #proxy_read_maps = $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_$
    proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
    
    inet_addresses = all
    
    ####### ANTI SPAM/VIRUS/WORM SETTINGS #######
    smtpd_delay_reject = yes
    
    smtpd_recipient_restrictions =
      reject_unauth_pipelining,
      reject_unknown_recipient_domain,
      permit_mynetworks,
      permit_sasl_authenticated,
      reject_unauth_destination,
      permit
    content_filter = amavis:[127.0.0.1]:10024
    readme_directory = /usr/share/doc/postfix-2.5.6-documentation/readme
    sample_directory = /usr/share/doc/postfix-2.3.3/samples
    sendmail_path = /usr/sbin/sendmail.postfix
    html_directory = /usr/share/doc/postfix-2.5.6-documentation/html
    setgid_group = postdrop
    command_directory = /usr/sbin
    manpage_directory = /usr/share/man
    daemon_directory = /usr/libexec/postfix
    newaliases_path = /usr/bin/newaliases.postfix
    mailq_path = /usr/bin/mailq.postfix
    queue_directory = /var/spool/postfix
    mail_owner = postfix
    unknown_local_recipient_reject_code = 450
    smtpd_sasl_path = smtpd
    smtpd_sasl_type = cyrus
    smtpd_sasl_security_options = noanonymous
    
    data_directory = /var/lib/postfix
    
    
     
    Last edited: Apr 23, 2010
  8. CarbonCopy

    CarbonCopy New Member

    I found this on another site and it worked fine

     

Share This Page