OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Subject: Problem with mysql and "additional_conditions"
From: Guenther Blatzheim (gblatzblatzheim.com)
Date: Sat Feb 19 2000 - 12:44:14 CST

I am using a mysql as an alias table with a "dir" column for /Maildir
delivery, but I ran in a problem with the "additional_conditions" field.

Think there are 3 columns in the table:

name = username,
dir = /Maildir directory
disabled = ENUM('0','1')

If I use a mysql conf file like this:

        # the user name and password to log into the mysql server
        user = test
        password = iknowit
        # the database name on the servers
        dbname = testdb
        # the table name
        table = mail
        #
        select_field = dir
        where_field = name

everything works as expected.

But after introduction of:

        additional_conditions = and !disabled

I find in the mail-log

Feb 19 19:22:39 moon postfix/smtpd[3543]: warning: Unknown column 'disabled'
in 'where clause'

which is definitly not true. The column exists! Any ideas?
(postfix-19991231-pl04)

Guenther