[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution

2009-02-10 Thread Daevid Vincent
SOLVED: THIS IS STUPID!! The Where clause requires that YOU put an additional "AND" in there. Auth_MySQL_Where " AND type = 'Admin' AND enabled = 1 " So the auth_mysql code must be making a "SELECT * FROM user WHERE username = 'foo' AND password = 'bar' WHERE 1" or some other c

[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution

2009-02-10 Thread Daevid Vincent
I've been struggling with this in a brand new 8.10 server myself that I just setup yesterday. Not sure how or why, but i got this magic incantation to work (do note however, I'm storing the passwords in plaintext in mySQL): AuthName "CRiMson -- use: test/test123