custom sql query

[Sandra H.]

Hello,
We have a database that contains usernames and password that we want to auth
from using a web app we have.
I have tried all kinds of config's in the sql.conf file and still get fails

I have turned on sqltrace and here is the error we currently get, its not
much...

rlm_sql (sql): Reserving sql socket id: 2
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 2

Right now to retrieve username and password...(sql script) we use this from
sql query   select Username, Password from Contact where length(Username) >
0;

How do I slap that into sql.conf to make it work for simply just
username/password auth?


Any help would be appreciated.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090325/f1087c3c/attachment.html>