Postfix + sasl SQL query error message (appears harmless)

[Jerry-124]

I have just started using SQL with SASL2. Previously, I was using the
sasldb file.

Although everything appears to be working correctly, I am finding this
error message in the /var/log/messages log file.

Nov  5 14:55:01 scorpio postfix/smtpd[9719]: sql query failed: Unknown column 'cmusaslsecretCRAM' in 'field list'

cat smtpd.conf

# SASL SQL Config file
# Global parameters

# Log lever: 0 to 7
log_level: 7

pwcheck_method: auxprop
mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5

# Auxiliary Plugin parameters
auxprop_plugin: sql
sql_engine: mysql
sql_host: localhost
sql_database: SASL
sql_user: SASL_USER
sql_passwd: secret
sql_select: SELECT %p FROM sasl_users WHERE username= '%u' AND userrealm = '%r' AND auth = '1'

postfix -n

alias_database = hash:/usr/local/etc/postfix/aliases
alias_maps = hash:/usr/local/etc/postfix/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/local/sbin
config_directory = /usr/local/etc/postfix
daemon_directory = /usr/local/libexec/postfix
data_directory = /var/db/postfix
debug_peer_level = 2
delay_warning_time = 2h
disable_vrfy_command = yes
html_directory = no
inet_interfaces = all
mail_owner = postfix
mail_spool_directory = /var/mail
mailq_path = /usr/local/bin/mailq
manpage_directory = /usr/local/man
milter_default_action = accept
mydestination =
mydomain = seibercom.net
mynetworks = 127.0.0.0/8, 192.168.1.0/24
mynetworks_style = subnet
myorigin = $mydomain
newaliases_path = /usr/local/bin/newaliases
queue_directory = /var/spool/postfix
readme_directory = no
recipient_delimiter = +
sample_directory = /usr/local/etc/postfix
sender_dependent_relayhost_maps = mysql:/usr/local/etc/postfix/mysql-sender_relay
sendmail_path = /usr/local/sbin/sendmail
setgid_group = maildrop
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = mysql:/usr/local/etc/postfix/mysql-sasl_passwd
smtp_sasl_security_options = noanonymous
smtp_sasl_type = cyrus
smtp_sender_dependent_authentication = yes
smtp_tls_CAfile = /usr/local/etc/postfix/certs/cacert.pem
smtp_tls_CApath = /usr/local/etc/postfix/certs
smtp_tls_note_starttls_offer = yes
smtp_tls_security_level = may
smtp_tls_session_cache_database = btree:/var/db/postfix/smtp_tls_session_cache
smtpd_authorized_verp_clients = $mynetworks
smtpd_banner = $myhostname ESMTP $mail_name ($mail_version)
smtpd_client_restrictions = permit_mynetworks reject_plaintext_session reject
smtpd_milters = unix:/var/run/clamav/clmilter.sock
smtpd_recipient_restrictions = permit_sasl_authenticated permit_mynetworks reject_unauth_destination reject
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_path = smtpd
smtpd_sasl_security_options = noanonymous
smtpd_sasl_tls_security_options = noanonymous
smtpd_tls_CAfile = /usr/local/etc/postfix/certs/cacert.pem
smtpd_tls_cert_file = /usr/local/etc/postfix/certs/postfix-cert.pem
smtpd_tls_key_file = /usr/local/etc/postfix/certs/postfix-key.pem
smtpd_tls_received_header = yes
smtpd_tls_security_level = may
smtpd_tls_session_cache_database = btree:/var/db/postfix/smtpd_tls_session_cache
tls_random_source = dev:/dev/urandom
transport_maps = mysql:/usr/local/etc/postfix/mysql-transport
unknown_local_recipient_reject_code = 550
virtual_gid_maps = static:1002
virtual_mailbox_base = /var/mail/vhost
virtual_mailbox_domains = mysql:/usr/local/etc/postfix/mysql-domains
virtual_mailbox_maps = mysql:/usr/local/etc/postfix/mysql-vmailbox
virtual_minimum_uid = 100
virtual_transport = dovecot
virtual_uid_maps = static:1002

--  
Jerry
postfix.user@...

TO REPORT A PROBLEM see http://www.postfix.org/DEBUG_README.html#mail
TO (UN)SUBSCRIBE see http://www.postfix.org/lists.html

Conflicting research paradigms
Have legitimized various crimes.
        The worst we can see
        Is in psychology,
Measuring reaction times.

[Patrick Ben Koetter]

* Jerry <postfix-users@...>:
> I have just started using SQL with SASL2. Previously, I was using the
> sasldb file.
>
> Although everything appears to be working correctly, I am finding this
> error message in the /var/log/messages log file.
>
> Nov  5 14:55:01 scorpio postfix/smtpd[9719]: sql query failed: Unknown column 'cmusaslsecretCRAM' in 'field list'

cmusaslsecretCRAM is a default field SASL queries for. It will be dropped in
an upcoming release of Cyrus SASL. For the moment, add the column and ingore
it or just ignore it.

p@rick

--
All technical questions asked privately will be automatically answered on the
list and archived for public access unless privacy is explicitely required and
justified.

saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>

[Jerry-124]

On Thu, 5 Nov 2009 21:32:50 +0100
Patrick Ben Koetter <p@...> replied:

>cmusaslsecretCRAM is a default field SASL queries for. It will be
>dropped in an upcoming release of Cyrus SASL. For the moment, add the
>column and ingore it or just ignore it.

Just to see what would happen, I added to column. I was then greeted
with this pseudo error message:

sql query failed: Unknown column 'MD5' in 'field list'

I just dropped the newly added column. It is a useless message, and as
you stated, it will be removed from future releases (hopefully).



--  
Jerry
postfix.user@...

TO REPORT A PROBLEM see http://www.postfix.org/DEBUG_README.html#mail
TO (UN)SUBSCRIBE see http://www.postfix.org/lists.html

The Law of the Perversity of Nature:
        You cannot determine beforehand which side of the bread to
butter.