Dani Crisan wrote: >> > Hello, >> > Jul 18 16:02:35 mail authdaemond: authmysql: trying this module >> > Jul 18 16:02:35 mail authdaemond: SQL query: SELECT id, crypt, "", uid, >> > gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id = >> > "[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>" AND (enabled=1) >> >> Does that query work correctly from, say, `mysql --batch >> --user=the-value-configured-in-authmysqlrc --database=ditto >> --execute='SELECT id, crypt, "", [...] AND (enabled=1)'`? >> >> > Jul 18 16:02:35 mail authdaemond: supplied password 'THIS PASSWORD IS >> > CLEAR TEXT AND IT IS CORRECT' does not match encrypted password >> > 'sdtrusfX0Jj66' >> >> Eh? I don't think that text is stored as your cleartext password. >> Where is it from? > > The text 'THIS PASSWORD IS CLEAR TEXT AND IT IS CORRECT' I modified when > writing the email...It was actually the password I was trying to > authenticate as user [EMAIL PROTECTED] in clear text and it was correct.
Ooops, sorry. I got the qui pro quo after I posted. Sometimes I'm pretty thick :-( (BTW, mind that posting the crypted form may enable brute force attempts -a.k.a. dictionary attacks- of breaking that password.) Anyway, your query doesn't select a cleartext password field. Where does it come from? > Regarding the second issue: > - first i did: > # mysql --batch [EMAIL PROTECTED] --database=maildb --execute='SELECT > id, crypt, "", uid,gid, home, concat(home,'/',maildir), "", name, "" > FROM users WHERE id ="[EMAIL PROTECTED]"' > ERROR 1044 (42000): Access denied for user ''@'localhost' to database > 'maildb' That's correct, MySQL server should not be accessed by the end user. > - and then: > # mysql --batch --user=mail --database=maildb --execute='SELECT id, > crypt, "", uid,gid, home, concat(home,'/',maildir), "", name, "" FROM > users WHERE id ="[EMAIL PROTECTED]"' -p > ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near '/,maildir), "", name, "" FROM users WHERE id > ="[EMAIL PROTECTED]"' at line 1 That is a quote mismatch. Try replacing the concat part with concat(home,"/",maildir) -the single quote was used by the shell. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
