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
Yes, I used the Postfix/Courier/Amavisd with virtual users for CentOS 5.3 tutorial (Which I couldn't find to link you to)
You mean this guide? http://www.howtoforge.com/virtual-users-domains-postfix-courier-mysql-squirrelmail-centos-5.3-x86_64 Please compare your configuration files with those from chapters 8 and 9.
centos' postfix comes withoud mysql support, so you need to recompile it with mysql support. there are threads on the forum about this.
Yes, I realize that, and since I specified my installation is working fine, I have recompiled it with MySQL authentication support
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
