I am currently looking into setting up freeRADIUS 1.0.1 in our corporate environment. Currently we are using Funk's Steel-Belted RADIUS server and utilize the ability to authenticate against a Oracle user database (a view). Is there anyway (a how-to maybe) to get freeRADIUS to be able to authenticate against an Oracle view? This is what our SQL query statement in our current Steel-Belted config file looks like.
Connect=DSN=cfadev;UID=dbuser;PWD=thepassword
SQL=SELECT password FROM was_radius_inet_access_auth_v WHERE username = %name/40
Steel-Belted RADIUS will get the password hash (base64 SHA1) from the Oracle table and do a compare. If there is a match then the user is authenticated.
Outside of installing the Oracle Client for Linux, what else would I have to do to make freeRADIUS authenticate against this Oracle view?
Thank you,
Brad Martin
Chick-fil-A, Inc.
Information Technology
(404) 765-7874
http://www.chick-fil-a.com
