most redundant Radius system

[Raymond Chen]

Dear all,

Any idea on the redundant Radius system scheme with MySQL?

Thanks

Raymond



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

also, how to call a external program from Accounting section in radiusd.conf

[Raymond Chen]

Raymond

how to use external program in both authorize and accounting secction

[Raymond Chen]

Thanks

Raymond



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

multiple AV-pairs return

[Raymond Chen]

Dear all,



Do any of you know how make freeradius return multiple AV
pairs back to NAS? Please provide detail.



Thanks



Raymond

call external authorization program from radius.conf

[Raymond Chen]

Dear all,



Can we call the authorize script directory from
radiusd.conf? 



Raymond

Prepaid calling card script

[Raymond Chen]

Dear All,

Does anyone have the Prepaid calling card script run as
exec-program-wait?  Please one copy to us.  

Your help is greatly appreciated.

Raymond



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

time format

[Raymond Chen]

Dear list,



I want to receive the setup, connection and disconnection
time in timestamp format instead of the UTC format. Do I use the rlm_rewrite
module or by means of other configuration method. Please show me the details.



Best regards



Raymond

time format

[Raymond Chen]

Dear list,



Trying to setup the radius to write CDR straight to MySQL
database. But the time from NAS as h323-setup-time=02:05:44.512 CN Thu Aug 15 2002
and in the MySQL database script, the time is define as -00-00 00:00:00. So
when radius trys to insert to database, it returns an error say the format is
incompatible. Any solution to this.



Best Regards



Raymond

Pair do not match

[Raymond Chen]

Dear all,

I've setup a radius to perform authenticate caller's ANI with oracle
table, the password is set to NULL.  The problem is radius
SOMETIMES(about 50% of the time) returned Pair do not match in radius
-X debug.  What is the problem here?   Can it be the radius is too slow
performing query and the AS5300 box timeout?  Or there is a problem with
code matching NULL password?

Please help

Raymond



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

AS5300 log to two Radius server simultaneously

[Raymond Chen]

Dear all,

A bit off topic.  Does anyone know how to configure the AS5300 so it
passes accounting records to 2 FreeRadius sever simultaneously.

Thanks

Raymond



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

accurate accounting when username missing

[Raymond Chen]

Dear list,



I am encountering a problem with accounting writing to
Oracle when username field is missing.
I understand there are other posts in this list with the same question
and solution, but it didnt work for me when I used sql_user_name = %{Stripped-User-Name:-%{User-Name:-none}}
in the sql.conf . when radius_xlat: ' ' which means no username, then the sql module
returns fail. Please help.



Thanks



Raymond

RE: accurate accounting when username missing

[Raymond Chen]

Here is the output of the debug,

modcall: entering group accounting
rlm_acct_unique: Hashing ',Client-IP-Address =
202.123.211.86,NAS-IP-Address = 202.123.211.86,Acct-Session-Id =
0D88,User-Name = '
rlm_acct_unique: Acct-Unique-Session-ID = cd7dc9202e9e5117.
  modcall[accounting]: module acct_unique returns ok
radius_xlat:  '/radius/radacct/202.123.211.86/detail'
rlm_detail: /radius/radacct/%{Client-IP-Address}/detail expands to
/radius/radacct/202.123.211.86/detail
  modcall[accounting]: module detail returns ok
radius_xlat:  ''
  modcall[accounting]: module sql returns fail
modcall: group accounting returns fail
Finished request 4

I found no clues here.  Does Anyone?

Raymond


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Alan DeKok
Sent: Thursday, March 28, 2002 8:49 PM
To: [EMAIL PROTECTED]
Subject: Re: accurate accounting when username missing 

Raymond Chen [EMAIL PROTECTED] wrote:
 I am encountering a problem with accounting writing to Oracle when
 username field is missing.  I understand there are other posts in this
 list with the same question and solution, but it didn't work for me
when
 I used sql_user_name = %{Stripped-User-Name:-%{User-Name:-none}} in
 the sql.conf .  when radius_xlat:  ' '  which means no username, then
 the sql module returns fail.  Please help.

  Find out why the translation/substition isn't working.  Run the
server in debugging mode.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

attr_rewrite to select output character

[Raymond Chen]

Dear list,

I am using attr_rewrite module to take a character from the VSA,  namely
Cisco-NAS-Port = ISDN 0:D:30,  I want to get the 0 from the attribute
which indicate which isdn port the VoIP call terminated to.  What do I
put in the searchfor variable to get the 0 and omit the rest.

And also, the attr_rewrite module is meant to call for multiple times if
need to do more then one rewrite.  How can I do that in the radius.conf

Raymond



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Cisco VSA h323 Attribute show again in string

[Raymond Chen]

Dear list,



I still cant get this to work even I enable the with_cisco_vsa_hack=yes in radiusd.conf. Did I missing something in the configuration?



Thanks



Raymond