buffered-sql question

William azander at netonecom.net
Wed Dec 29 22:24:06 CET 2010


On Wednesday, December 29, 2010 03:59:35 pm Tim Sylvester wrote:
> > It claims that there is an accounting packet without an
> > acctsessiontime... I found the offending entries and now it works.  I
> 
> guess I'll have to
> 
> > edit those  out each time.  They are being created by a web-accelerator
> 
> program we
> 
> > use.
> > 
> > : Info: [sql] stop packet with zero session length. [user '', nas
> > 
> > '69.54.220.130']
> 
> This is just an informational message, not an error message, and can be
> ignored. However, the username for that packet is empty which is probably
> not what you want.
> 
> > Once I edit those records out, it works fine. :(
> > 
> >  offending record looks like:
> > Wed Dec 29 00:08:22 2010
> > 
> >         Event-Timestamp = "Dec 29 2010 00:08:22 EST"
> >         User-Name = "<username>"
> >         NAS-IP-Address = 69.54.220.130
> >         NAS-Identifier = "TN_GrandRapidsAPX.1dial.com"
> >         NAS-Port = 1838
> >         NAS-Port-Type = Async
> >         Service-Type = Framed-User
> >         Acct-Status-Type = Stop
> >         Acct-Delay-Time = 0
> >         Acct-Session-Id = "617355318"
> >         Acct-Authentic = RADIUS
> >         Acct-Session-Time = 1087
> >         Acct-Input-Octets = 45488
> >         Acct-Output-Octets = 68727
> >         Acct-Input-Packets = 169
> >         Acct-Output-Packets = 155
> >         Acct-Terminate-Cause = Session-Timeout
> >         Ascend-Disconnect-Cause = Session-Timeout
> >         Ascend-Connect-Progress = LAN-Session-Up
> >         Ascend-PreSession-Time = 32
> >         Ascend-Pre-Input-Octets = 347
> >         Ascend-Pre-Output-Octets = 251
> >         Ascend-Pre-Input-Packets = 12
> >         Ascend-Pre-Output-Packets = 12
> >         Ascend-First-Dest = 255.255.255.255
> >         Ascend-Data-Rate = 24000
> >         Ascend-Xmit-Rate = 26400
> >         Ascend-Modem-PortNo = 89
> >         Ascend-Modem-SlotNo = 10
> >         Ascend-Modem-ShelfNo = 1
> >         Calling-Station-Id = "<phone>"
> >         Called-Station-Id = "<dialup>"
> >         Ascend-Data-Svc = Switched-Voice-Bearer
> >         Framed-Protocol = PPP
> >         Framed-IP-Address = <ip address>
> >         Attr-103 = 0x4d1ac245
> >         Client-IP-Address = <ip address>
> >         Acct-Unique-Session-Id = "bcac314c121c56b5"
> >         Stripped-User-Name = "<username>"
> >         Realm = "<realm>"
> >         Timestamp = 1293599302
> 
> There's nothing wrong with this packet. It includes the User-Name attribute
> with a value of "<username>" and the Acct-Session-Time attribute with a
> value of 1087 seconds. The " Info: [sql] stop packet with zero session
> length." message would not be generated by this packet.
> 
> When you leave in the "offending" packets, what happens? Do you just get
> the "stop packet with zero session length" message? If that's the only
> "problem", just ignore it or fix the device that is sending that packet.
> 
> Tim
> 
> 
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

It doesn't import any additional records after that.  It just stops, and keeps 
generating the error.




More information about the Freeradius-Users mailing list