custom sql query

tnt at kalik.net tnt at kalik.net
Wed Mar 25 16:35:34 CET 2009


>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?
>

You can't just "slap" something into it. Read coments in dialup.conf.
They say what your query *must* return and in what order.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list