OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Postfix user cannot get authenticated.

From: Burak Yżlmaz (netsoniccyahoo.com)
Date: Thu Apr 19 2007 - 04:45:08 CDT

I have built postfix with mysql support...i try to get authenticated on the pop3 and imap and smtpd but the logs say;

Apr 19 05:41:58 albumx authdaemond: received auth request, service=pop3, authtype=login
Apr 19 05:41:58 albumx authdaemond: authmysql: trying this module
Apr 19 05:41:58 albumx authdaemond: SQL query: SELECT email, crypt, "", uid, gid, homedir, "", "", name, "" FROM postfix_users WHERE email = "burakalbumx.com" AND (access='y')
Apr 19 05:41:58 albumx authdaemond: no password available to compare
Apr 19 05:41:58 albumx authdaemond: authmysql: REJECT - try next module
Apr 19 05:41:58 albumx authdaemond: FAIL, all modules rejected
The problem i can see i have used plain password in all my configuration...This query above tries to get "crypt" field from mysql database...But it must get "plain" field"....I couldnt find where do this query stored....

How am i going to fix this query?

thank you
Burak YILMAZ

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com