Hi,
In addition of using TCL IVR script... you will see all the information you need for
++
AcctUniqueId = h323-conf-id
ConnectInfo_start = (not quite sure... see Cisco doc)
ConnectInfo_stop = (not quite sure... see Cisco doc)
AcctTerminateCause = h323-disconnect-cause
NASPortId = 0 (for all records)= Cisco-NAS-Port
++
-Original Message-
From: Thomas Jalsovsky [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 1:25 PM
To: [EMAIL PROTECTED]
Subject: Re: freeradius and mysql accounting and use of
called-station-id
Hello,
if you make debugging in radius server and in Cisco ('debug
radius' :), you should find, that Cisco doesn't send this attribute in the
auth. requests, therefore you cannot make auth. decision by this
attribute. I don't know that it is possible to configure Cisco to send
this attribute, I cannot make that.
Another solution: you should write/rewrite TCL IVR script and you
can send the info (e.g. called-station-id) via Cisco VSA attribute and
your FreeRADIUS server will see this through VSAs. Take a look for
h323-ivr-in and h323-ivr-out in the TCL IVR 2 documentation.
Regards,
Thomas
On Thu, 11 Apr 2002, Dirk Tanneberger wrote:
sql.conf is o.k. and with sql tracing I see, that these values are blank.
I think the Cisco AS5300 send not these values.
But how can I configure AS5300 to send the parameters?
In details-file are the following entries:
Thu Apr 11 15:54:34 2002
NAS-IP-Address = 192.168.0.254
NAS-Port = 106
Cisco-NAS-Port = Serial3:10
NAS-Port-Type = ISDN
User-Name = test
Called-Station-Id = 3552000
Calling-Station-Id = 3551720
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = B005
Framed-Protocol = PPP
Acct-Link-Count = 2
X-Ascend-Num-In-Multilink = 1
Acct-Multi-Session-Id = 14165
Framed-IP-Address = 193.98.116.99
X-Ascend-Disconnect-Cause = 45
X-Ascend-Pre-Input-Octets = 154
X-Ascend-Pre-Output-Octets = 139
X-Ascend-Pre-Input-Packets = 4
X-Ascend-Pre-Output-Packets = 5
Acct-Input-Octets = 666
Acct-Output-Octets = 394
Acct-Input-Packets = 26
Acct-Output-Packets = 19
X-Ascend-PreSession-Time = 1
Acct-Session-Time = 13
X-Ascend-Data-Rate = 64000
X-Ascend-Xmit-Rate = 64000
X-Ascend-Multilink-ID = 14165
Acct-Delay-Time = 0
Client-IP-Address = 192.168.1.41
Timestamp = 1018533274
Thanks Dirk
- Original Message -
From: Chris Parker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 5:27 PM
Subject: Re: freeradius and mysql accounting and use of called-station-id
At 05:09 PM 4/11/2002 +0200, Dirk Tanneberger wrote:
Hello all,
I use freeradius 0.5 and my NAS is a Cisco AS5300.
I test with freeradius and mysql since 2 weeks and I have 2 problems:
The radius server writes the accounting records in the mysql-table, but
the following entries leave blank for all records:
++
AcctUniqueId
ConnectInfo_start
ConnectInfo_stop
AcctTerminateCause
NASPortId = 0 (for all records)
++
How can I fill these parameters?
What do you have in 'sql.conf' for the queries? Simply adding the columns
to the table definition will not fill them in. You must also alter your
sql.conf to add them if they do not exist.
Also, make sure you are correctly calling the 'acct_unique' module in your
config.
If this has been done, run the server in debugging mode, with sql tracing
enabled, so you can see what sql queries are being run.
-Chris
--
\\\|||/// \ StarNet Inc. \Chris Parker
\ ~ ~ / \ WX *is* Wireless!\ Director, Engineering
| @ @ |\ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\--
\ Wholesale Internet Services - http://www.megapop.net
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
