Hi,Tunde,
>Hi Rubby, > >Well I hope you have solved your problem so that you can help with mine. >Hi Steve, > >Seems I am the only newbie at freeradius. >I am new to freeradius and I guess you have a lot of experience with it. >My problem is: >Please I am about to set up free radius to authenticate against >an Oracle database. In fact. I am abot to install free radius for >the first time. First,what platform do you run freeradius on? Mine is Linux. If you run freeradius as root,please add two environment variant: ORACLE_HOME=.... LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib And then ./configure , make , make install >Please, help on things like setting up groups and the SQL statement >to use would be appreciated. freeradius does it very well.Look at the freeradius_directory/src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql You only need to add some items to table usergroup,radgroupcheck,radgroupreply, then it will support group. >I need to be able to apply different profiles/groups policies depending >on whether the person belongs to a time-limited group/email only - This is the Login-Time attribute which freeradius supports through the module rlm_counter,and I donnot implement it , if you success ,please email to me,:) >I guess these would be stored in the Oracle DB along with other user >data and the SQL statement must then match them with exact group >names defined in a free radius config. file? No,no config file, directly the db table. > >Hope to hear from you soon. > >NB: someone sent me a sql.conf file and it was very cryptic - I know the >answer is in there somewhere but ouch! :-) >Are there specifics of the installation that relates directly to Oracle? - things >i need to know or do before the actuall install? No,when you run radiusd,it connects to Oracle. See the attachment, that is my sql.conf > >Regards, >Tunde Itayemi. > >Okay, for example,let's say I have two profile/groups: >emailonly and rushour >emailonly (ip addresses in 10.0.0 range), rushour (ip addresses in 63.x.x) (time 8am- >to-8pm) >assuming I put an extra field in the Oracle table for these group names, No,just the table usergroup,radgroupcheck,radgroupreply >how does my sql config file look? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
