I am working on setting up a wireless hotspot using Chillispot on
DD-WRT. I have installed Freeradius on a W2K server that runs an Oracle
database.
After reading the documentation and various howtos, I wanted to see if
someone could offer some pointers on authenticating to Oracle using a
pre-existing database and not the db/tables built from the sql file in
the example docs. For example: I have a list of users listed in the
database as 'barcode' (20 Char) and the password is stored in plain text
as 'pin' (4 Char).
I don't care about updating or creating users through Freeradius nor do
I care about accounting (simultaneous connections).
The defaults in the oraclesql.conf are:
authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM \
${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER \
BY id"
authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM \
${authreply_table} WHERE Username = '%{SQL-User-Name}' ORDER \
BY id"
Which I assumed might be able to be trimmed down to:
authorize_check_query = "SELECT barcode,pin FROM ${authcheck_table} \
WHERE barcode = '%{SQL-User-Name}'"
Am I incorrect in this assumption?
Thanks,
Brian
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
