Hello List,
I recently installed freeradius 1.0 pre1 with Oracle8i, Ascend MAX. and I found it
very very good.
Thanks Alan Dekok and all freeradius ppl for such a nice work.
I did some changes please suggest,
I customize authorize_check_query to :-
authorize_check_query ="SELECT 1 as id,e.userid as UserName,'Password' as
Attribute,e.password as
Value,'==' as op from everyuser e where e.userid='%{SQL-User-Name}' and e.status=0
union SELECT
id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE Username
='{SQL-User-Name}' order by
id"
Reason=I only need check password/status most of the time thats why I did that.Status
will be
update from my billing module
and authorize_reply_query to :-
authorize_reply_query="Select 1 as
id,e.userid,'Session-Timeout',((e.balance-e.usedbalance)/p.onpeakrate)*3600,'==' from
everyuser e,
packages p where e.userid='%{SQL-User-Name}' and e.policyindex=p.indexptr union SELECT
id,UserName,Attribute,Value,op FROM ${authreply_table} WHERE Username =
'%{SQL-User-Name}' ORDER
BY id"
Reason=I don't want to use radacct table too big, so i m not able to use sqlcounter.
So I fetch
remaining seconds and get in Session-Timeout every time. Usedbalance is updated by my
billing
module.
select * from radgroupreply;
For Dialup
ID GROUPNAME ATTRIBUTE OP VALUE
--- -------------------- ---------------------------------------- --
--------------------
32 dynamic Service-Type := Framed-User
33 dynamic Framed-Protocol := PPP
34 dynamic Framed-Compression := Van-Jacobsen-TCP-IP
35 dynamic Framed-MTU := 1500
62 dynamic Port-Limit := 1
61 dynamic Nas-Port-Type := Async
for ISDN no 'Async'
63 isdn Service-Type := Framed-User
64 isdn Framed-Protocol := PPP
65 isdn Framed-Compression := Van-Jacobsen-TCP-IP
66 isdn Framed-MTU := 1500
67 isdn Port-Limit := 1
select * from radgroupcheck
ID GROUPNAME ATTRIBUTE OP VALUE
-- -------------------- -------------------------------------- -- -----
0 dynamic Auth-Type == Sql
1 isdn Auth-Type == Sql
I have to use Auth-Type=Local or Auth-Type=Sql ? please suggest.
select * from radcheck;
ID USERNAME ATTRIBUTE VALUE OP
-- ------------------- ------------------ --------------------- --
2 babar Calling-Station-Id 2315938 ==
NULLIF is not supported in Oracle 8i
SET FramedIPAddress = NULLIF('%{Framed-IP-Address}', ''), \
so I change it to
SET FramedIPAddress= CASE WHEN '%{Framed-IP-Address}'='' THEN '' ELSE
'%{Framed-IP-Address}' END,\
Actually Im trying to develop usage base,pre-paid, post-paid billing. So I write a
billing module
which is checking radacct table every 60 seconds and bill the user on basis of hourly
+ onpeek
time/offpeak time/Monthly/Unlimited/ISDN rates, billing module is also checking
timelimit
expiration of users every half an hour. I used OCI/C code for billing module.
Right now i m billing from NAS AcctSessionTime this is correct or I have to use
acctStopTime minus
acctStartTime ? please suggest.
I m deleting radacct entries when i got acctstoptime and when billing is done and
storing in
another table 'usagedetails'. and using snmp check for multilogin. Please suggest all
this is okey
?
Thanks once again,
Babar Shafiq.
=====
God is a great Programmer
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
