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