"Henry Su" <[EMAIL PROTECTED]> wrote:
>Hi, I am a newcomer on freeradius, could any one point me out some steps on
>setting up freeradius 0.3 using oracle 8i to authenticate? Thanks a lot.
I use freeradius0.2 with oracle8.1.7 and have to apply the modifications
suggested by [EMAIL PROTECTED] in the mailing list with the subject "can you explain me
this behavior?(freeradius+oracle)" to succeded in authentification.
For the accounting, i have to modify sql query in sql.conf :
=====================================================================
accounting_start_query = "INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId,
UserNam
e, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
AcctSessionTime, AcctAuth
entic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, Callin
gStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay, AcctStop
Delay) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '
%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}', to_date('%S','YY-MM-DD
HH24:MI:SS'), NULL, '
0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}',
'%{Calling-Station-I
d}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',
'%{Acct-Delay-Time}', '0')"
=========================================================================
The modification are date formatting with to_date and NULL value for column date
because 0 is not a valid value for date.
In the radiusd.conf file, you also have to do that modifications :
authenticate {
authtype SQL {
sql
}
}
accounting {
sql
...
}
Fred
If
>you do not have oracle experience, could u pls give me the steps for mysql?
>______________________________________________
>
>Henry Su
>
>NTT Multimedia Communications Laboratories, Inc.
>
>250 Cambridge Avenue Suite 300
>
>Palo Alto, CA 94306, USA (PDT:UTC -7H)
>
>Tel: +1 650 833 3652
>
>Fax: +1 650 326 1878
>
>_______________________________________________
>
>
>
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
