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 = "0000B005" > 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
