[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-gnu-radius] (no subject)
From: |
David Friedman |
Subject: |
Re: [Help-gnu-radius] (no subject) |
Date: |
Thu, 21 Feb 2002 10:38:40 -0500 |
User-agent: |
Mutt/1.2.5i |
* David Friedman (address@hidden) wrote:
> * Sergey Poznyakoff (address@hidden) wrote:
> > Hi, David
> >
> > There is a syntax error in your query, it is marked by carret below:
> >
> > > Feb 20 22:04:34: Acct.error: MYSQL Error (-1): Cannot Query:UPDATE
> > > calls SET status=,acct_session_time=18,acct_input_octets=6721,...
> > ------------------^
> >
> > Probably, the accounting packet came without the Acct-Status-Type
> > attribute? You can verify this by looking the corresponding record
> > in your detail file. How often does it happen?
> >
>
> Yes, I figured I'd just surround that attribute with single quotes
> in the sqlserver file. Is that a good idea?
>
> It happens a lot with Qwest.
>
> The Acct-Status-Type = Start is fine, but I don't see a Stop. Instead,
> I see the following:
>
> 77766 = Stop
>
> I uncommented the vendor specific dictionary file a few days ago, FYI,
> as I thought that might have something to do with it (I don't think it did).
>
Here's a start and stop entry in the detail file for one of the
problematic sessions:
Tue Feb 19 21:08:07 2002
Proxy-State = VPRR00063.152.0.97:3573/1//424D4506/address@hidden/
User-Name = snip
NAS-IP-Address = 63.152.0.97
NAS-Port-Id = 3573
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 63.159.221.136
Login-IP-Host = 0.0.0.0
Login-Service = PortMaster
Login-TCP-Port = 0
Vendor-Specific = V2637\003\0060000
Vendor-Specific = V2637\012\006V.90
Vendor-Specific = V2637\014\006V.42
Vendor-Specific = V2637\015\006V.42
Called-Station-Id = <snip>
Calling-Station-Id = <snip>
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = C000B7D1:00032FA9
Acct-Authentic = RADIUS
Acct-Link-Count = 1
NAS-Port-Type = Async
Connect-Info = 26400
Service-Type = Framed-User
Framed-Protocol = PPP
Proxy-State = 93
Hint = national
Orig-User-Name = <snip>@fiam.net
Timestamp = 1014170887
Request-Authenticator = Verified
Wed Feb 20 01:16:54 2002
Proxy-State = VPRR00063.152.0.97:3573/1//424D4506/<snip>@fiam.net/
User-Name = snip
NAS-IP-Address = 63.152.0.97
NAS-Port-Id = 3573
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 63.159.221.136
Login-IP-Host = 0.0.0.0
Login-Service = PortMaster
Login-TCP-Port = 0
Vendor-Specific = V2637\003\0060000
Vendor-Specific = V2637\013\006V.90
Vendor-Specific = V2637\016\006\000\000\106\377
Vendor-Specific = V2637\017\006\000\000\000K
Vendor-Specific = V2637\020\006\000\000\000%
Vendor-Specific = V2637\021\006\000\000\000\002
Vendor-Specific = V2637\022\006\000\000\000\000
Vendor-Specific = V2637\023\006\000\000\000\000
Vendor-Specific = V2637\024\006\000\000\000\000
Vendor-Specific = V2637\027\006\000\000\000\007
Vendor-Specific = V2637\030\006\000\000\003\377
Called-Station-Id = <snip>
Calling-Station-Id = <snip>
77766 = Stop
Acct-Delay-Time = 0
Acct-Input-Octets = 489730
Acct-Output-Octets = 1995654
Acct-Session-Id = C000B7D1:00032FA9
Acct-Authentic = RADIUS
Acct-Session-Time = 14927
Acct-Input-Packets = 7436
Acct-Output-Packets = 6104
Acct-Link-Count = 1
NAS-Port-Type = Async
Acct-Terminate-Cause = 45
Connect-Info = 26400
Service-Type = Framed-User
Framed-Protocol = PPP
Proxy-State = 25
Hint = national
Orig-User-Name = <snip>@fiam.net
Timestamp = 1014185814
Request-Authenticator = Verified
One thing that I think is odd is that they're using Acct-Terminate-Cause
instead of Ascend-Disconnect-Cause, but are using the Ascend error codes.
Perhaps that's normal practice, but it seems to be going against an RFC
for no reason, IMHO.
ciao
--
David Friedman (address@hidden)
www.irctoo.net - IRCtoo... because it's not just irc.