Hello,
thanks for all answer. The accounting attribute, I will check
with debuging on cisco router, in order to locate the problem.
My authentication problem with called -station-id is another.
Authentication with one entry per user for called-station-id in radcheck-table
works fine. But the probleme is, that the user comes with different called-staton-id.
How can I check two or more called-station-id's per user? Or can I us wildcards?
regards
Dirk Tanneberger
----- Original Message -----
From: "Thomas Jalsovsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 8:25 AM
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
