 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
12 messages in net.sourceforge.lists.courier-usersRe: [courier-users] mysql auth not wo...| From | Sent On | Attachments |
|---|---|---|
| Pedro Venda | Feb 1, 2003 6:25 am | |
| Onno | Feb 1, 2003 11:28 am | |
| Pedro Venda | Feb 1, 2003 4:30 pm | |
| Pedro Venda | Feb 1, 2003 6:05 pm | |
| Sam Varshavchik | Feb 1, 2003 7:31 pm | |
| Onno | Feb 2, 2003 4:25 am | |
| Pedro Venda | Feb 2, 2003 10:12 am | |
| Onno | Feb 3, 2003 3:18 am | |
| Pedro Venda | Feb 3, 2003 6:22 am | |
| Nat Sakimura | Feb 3, 2003 7:04 am | |
| Daniel Higgins | Feb 3, 2003 7:59 am | |
| Pedro Venda | Feb 3, 2003 1:17 pm |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | Re: [courier-users] mysql auth not working - updated | Actions... |
|---|---|---|
| From: | Onno (onno...@yahoo.com) | |
| Date: | Feb 2, 2003 4:25:39 am | |
| List: | net.sourceforge.lists.courier-users | |
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 <pj...@mega.ist.utl.pt> 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 cour...@lists.sourceforge.net Unsubscribe:
https://lists.sourceforge.net/lists/listinfo/courier-users
__________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com