Hi Guys This is my first time on the list so please go easy on me if this is a FAQ. (I did look though the webpage and do a google search first..)
I have inherited a couple of RH 7.2 (intel) boxes running FreeRadius 0.5
I will be replacing them when I get a chance as they are in a bit of a
state, but right now I dont have the luxury.
I have them configured to use the mysql backend.
Now the problem is I have enabled the following:
with_cisco_vsa_hack = yes
and the restarted the radiusd however the detail files (and the sql) still
show the following (Note: I have changed the IP addresses and usernames etc
but all the rest is correct. I am also aware that NTP seems to be broken on
that router. Looking into it now :-)
Wed Jul 31 10:50:34 2002
NAS-IP-Address = y.y.y.y
Cisco-NAS-Port = "ISDN 2:D:31"
NAS-Port-Type = Async
User-Name = "1000"
Called-Station-Id = "00723689762342"
Calling-Station-Id = "1000"
Acct-Status-Type = Stop
Service-Type = Login-User
h323-gw-id = "h323-gw-id=site1-gw1-5300."
Cisco-AVPair = "302D6CE7 A39111D6 9248906D CBD699C4"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=Telephony"
h323-setup-time = "h323-setup-time=.09:21:13.460 BST Sun Mar 7
1993"
h323-connect-time = "h323-connect-time=.09:21:20.687 BST Sun Mar 7
1993"
h323-disconnect-time = "h323-disconnect-time=.09:24:53.847 BST Sun
Mar 7 1993"
h323-disconnect-cause = "h323-disconnect-cause=10"
h323-voice-quality = "h323-voice-quality=0"
h323-conf-id = "h323-conf-id=302D6CE7 A39111D6 9248906D CBD699C4"
Acct-Session-Id = "000026EB"
Acct-Input-Octets = 215873
Acct-Output-Octets = 122392
Acct-Input-Packets = 10798
Acct-Output-Packets = 3116
Acct-Session-Time = 213
Cisco-AVPair = "Unknown"
Cisco-AVPair = "Unknown"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Acct-Delay-Time = 0
Client-IP-Address = 212.50.53.200
SQL-User-Name = "fffffff"
Timestamp = 1028101834
Wed Jul 31 10:50:34 2002
NAS-IP-Address = 212.50.53.200
NAS-Port-Type = Async
User-Name = "1000"
Called-Station-Id = "001234234532465"
Calling-Station-Id = "1000"
Acct-Status-Type = Stop
Service-Type = Login-User
h323-gw-id = "h323-gw-id=girne-gw1-5300."
Cisco-AVPair = "302D6CE7 A39111D6 9248906D CBD699C4"
h323-call-origin = "h323-call-origin=answer"
h323-call-type = "h323-call-type=VoIP"
h323-setup-time = "h323-setup-time=.09:21:13.132 BST Sun Mar 7
1993"
h323-connect-time = "h323-connect-time=.09:21:20.689 BST Sun Mar 7
1993"
h323-disconnect-time = "h323-disconnect-time=.09:24:53.919 BST Sun
Mar 7 1993"
h323-disconnect-cause = "h323-disconnect-cause=10"
h323-remote-address = "h323-remote-address=z.z.z.z"
h323-voice-quality = "h323-voice-quality=37"
h323-conf-id = "h323-conf-id=302D6CE7 A39111D6 9248906D CBD699C4"
Acct-Session-Id = "000026EA"
Acct-Input-Octets = 122392
Acct-Output-Octets = 215873
Acct-Input-Packets = 3116
Acct-Output-Packets = 10798
Acct-Session-Time = 213
Cisco-AVPair = "Unknown"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Cisco-AVPair = "0"
Acct-Delay-Time = 0
Client-IP-Address = x.x.x.x
SQL-User-Name = "ffffffff"
Timestamp = 1028101834
Does anyone have a clue as to why the vsa_hack mode is not stripping the
attributes like it should be?
Note: I have created a fairly comprehensive SQL table layout to cover doing
VOIP accounting with Ciscos and freeradius. Would there be any interest in
me publishing it somewhere? I can also possibly be convinced to maintain
some SuSE 8.0 rpms for FreeRadius if no one else is. (SuSE ship FR 0.5 rpms
on the CDs, but obviously people would like 0.7 :-)
Regards
--
Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
"They that can give up essential liberty to obtain a little
temporary safety, deserve neither liberty nor safety."
-Benjamin Franklin
msg07467/pgp00000.pgp
Description: PGP signature
