I followed Virtual Users And Domains With Postfix, Courier And MySQL (Fedora Core 5) exactly with the exception of Clamv/Amavis/Spamassasin. I also am using Fedora Core 6. I used the following 3rd party software in place of the onces noted in the How-to:
I added a user and am able to receive email for that user. When I attempt to retreive the messages for that user this is what I get:
Jan 24 20:12:35 gabriel authdaemond: received auth request, service=pop3, authtype=login
Jan 24 20:12:35 gabriel authdaemond: authmysql: trying this module
Jan 24 20:12:35 gabriel authdaemond: SQL query: SELECT email, password, "", 5000., 5000, "/home/vmail", "", "", "", "" FROM users WHERE email = "firstname.lastname@example.org"
Jan 24 20:12:35 gabriel authdaemond: supplied password does not match encrypted password
Jan 24 20:12:35 gabriel authdaemond: authmysql: REJECT - try next module
Jan 24 20:12:35 gabriel authdaemond: FAIL, all modules rejected
Jan 24 20:12:35 gabriel pop3d: LOGIN FAILED, email@example.com, ip=[::ffff:127.0.0.1]
I have googled all day for this error and have not found a resolution.
I have old_password=1 in my my.cnf