>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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
