[courier-users] Trouble with Courier IMAP+MySQL Auth

[Jonathan Hilgeman]

Hi,   HISTORY LEADING UP TO THE PROBLEM: I'm new to IMAP administration - I've been using QMail and its POP3 server for a while now (Maildir storage), and decided to try out IMAP. I already have a recent version of MySQL installed and running fine. I just finished installing Courier-IMAP 1.5.3 (just a plain ./configure, make, make check, su, make install - no special options). It detected MySQL and installed the authdaemond.mysql binary, which is good.   I edited the config files (both courier's and the authmysql.rc file - or whatever its called) to make sure the program would have a valid MySQL connection. I created a database called "mail" and added the suggested table query straight from the bottom of the README.authmysql.html document, so everything is set up - tables and all. I ran authdaemond and it automatically selected the mysql binary and began running that normally.    PROBLEM: However, I've been reading and reading but I can't find any docs that say anything about how to add a user to that table. I've tried adding a record manually by taking a logical guess at what goes where, but it won't authenticate. (A side note - I commented out the MD5/crypt authentication line in the config file, and enabled the CLEAR field so I can input cleartext passwords for now - until I get it all working). I want to add a user: Username: jonathan Password: somepass Maildir: /qmailboxes/jonathan/Maildir   WHAT I'VE TRIED: so this is what I put into the database: id: jonathan crypt: <nothing> clear: somepass name: jonathan uid: 0 gid: 0 home: /qmailboxes/jonathan maildir: Maildir quota: <blank>   What am I doing wrong here? Is it the UID/GID being 0 (root)?   - Jonathan