Re: [Help-gnu-radius] (no subject)

[David Friedman]

* 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.