Hi Guys,

I am configuring imap to authenticate against mysql.

Instead of using a new database I am using my own . I have set up the authmysqlrc file as follows

MYSQL_SERVER <IP address> MYSQL_USERNAME <db username> MYSQL_PASSWORD <db password> MYSQL_SOCKET /tmp/mysql.sock MYSQL_DATABASE subscriber MYSQL_USER_TABLE subscriber MYSQL_CLEAR_PWFIELD mailboxPassword MYSQL_UID_FIELD 700 MYSQL_GID_FIELD 700 MYSQL_LOGIN_FIELD mailboxUsername MYSQL_HOME_FIELD home MYSQL_MAILDIR_FIELD maildir

When I send a mail to a particular account it gets authenticated successfully, however the select statement does not pick up the value in the database for MYSQL_MAILDIR_FIELD

SQL query: SELECT mailboxUsername, "", mailboxPassword, 700, 700, home, "", "", "", "" FROM subscriber WHERE mailboxUsername = "353866090981"

There is no reference to maildir in the select statement so no value gets extracted

I have actually seen it in the debug - in the select statement below maildir is used

SQL query: SELECT mailboxUsername, "", mailboxPassword, 700, 700, home, maildir, "", "", "" FROM subscriber WHERE mailboxUsername = "353866090981"

Can you tell me what I need to do to make sure that maildir gets successfully included in the select statement ?

Thanks

Much appreciated

Steve