I had a look at a mysql log of my courier-imap
installation. And to authenticate 1 user it uses only
1 query (as it should)
Query: SELECT id, crypt, clear, uid, gid, home,
"", "", name FROM users WHERE id = "JohnDoe"
In regard to debugging info.... you can turn on a
debugging option in etc/imapd .... set DEBUG_LOGIN=2
and the username and password will show up in you
maillog (Remember to turn this off after your done)...
if this doen't help solving the problem post the
relevant config and log files, maybe somebody can spot
your problem that way....
grz,
Onno
--- Pedro Venda <[EMAIL PROTECTED]> wrote:
> > hi everyone!
> >
> > i am using courier imap 1.7.0 with authmysql.
> although it compiled fine
> > (unlike courier imap 1.6.2 which hanged in the
> configure script... for
> > which i found a solution but nobody cared, until
> courier imap 1.7.0 came
> > fixed) i cannot access my mailboxes via authmysql.
> >
> > checking the maillog entries, i found out that the
> users are not being
> > authenticated. i use encrypted passwords for
> everyone, but i can't seem
> > to
> > find any more debug info about this...
>
> after further investigation, i found out... well...
> nothing! i can see the
> queries via the mysql query-log feature, but i
> cannot see the results of
> those queries. I notice that the queries are made
> like:
> select field1,id,crypt,clear,field2,field3,... from
> users where id='username' and
> (imapok=1 and mailok=1)
> (imapok and mailok are booleans i created).
> Shouldn't the query use a
> "where id='username' and crypt=password('password')"
> instead of "where
> id='username'"?
>
> How many queries are made to a database in a sane
> (working) installation of
> courier with authmysql?
>
> note: i configured authmysqlrc, authdaemonrc and
> imapd. Are there any more
> configurations necessary? I think i am not
> forgetting anything...
>
> > can anyone give me a hand on this?
> >
> > thank you!
>
>
>
>
>
>
-------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld =
> Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> courier-users mailing list
> [EMAIL PROTECTED]
> Unsubscribe:
https://lists.sourceforge.net/lists/listinfo/courier-users
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
