From owner-freebsd-isp Sat Feb 9 10:40:31 2002 Delivered-To: freebsd-isp@freebsd.org Received: from misery.sdf.com (misery.sdf.com [207.200.153.226]) by hub.freebsd.org (Postfix) with ESMTP id E446037B419 for ; Sat, 9 Feb 2002 10:40:12 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 16ZbnF-0001s4-00; Sat, 9 Feb 2002 10:00:09 -0800 Date: Sat, 9 Feb 2002 10:00:07 -0800 (PST) From: Tom Samplonius To: Paulo Fragoso Cc: freebsd-isp@freebsd.org Subject: Re: Radius (Acct-Session-Id) In-Reply-To: <20020208090322.E12341-100000@mirage.nlink.com.br> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org Some NASes incorrectly start re-using the Session-IDs. If you should examine the two records, you should be able to determine whether it is an actual duplicate, or a just a re-used Session-ID. If you want a unique key for RADIUS data, just the Session-ID is not enough. I use a aggregate key, consisting of the Session-ID, NAS IP (Session-IDs are only unique per NAS), and length of session. Now you mention that you want to store Start and Stop records, so two records per session. I only store one record per session. So you will not be able to use the length of the session as part of the key. Tom On Fri, 8 Feb 2002, Paulo Fragoso wrote: > Hi, > > I've ever found in the details files (generated by cistron radiusd) some > logs with same Acct-Session-Id, which are related with only one real > connection, using same NAS-Port-Id. > > Is possible another conection to other port estabilished by a diferent > user but with same Acct-Session-Id? > > I'm planning to put all information in the database (PostgresQL) using > Acct-Session-Id and Acct-Status-Type (Start or Stop) for primary keys, > this way all repeated information will be discard. Is this corrected? > > We are using a Lucent MAX 6000 RAS and Radius Cistro 1.6.4 runnig at > FreeBSD. > > Paulo. > > -- > __O > _-\<,_ Why drive when you can bike? > (_)/ (_) > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-isp" in the body of the message > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message