Acct-Session-Id too long
Dear all, FreeRADIUS 1.0.4 I'm using mysql to store accounting...especially to check simultaneous-use.. but one case as below, i received a long "Acct-Session-Id" ... and cannot fit into mysql... and problem to update Stop record... should I change column size from char32 to reasonable value ? pls advise.. thanks.. Acct-Session-Id = "erx atm 2/3.10601218:60.1218:0165889995" +--------------+----------------------------------+------------------+---------------------+-------------+ | nasipaddress | AcctSessionId | AcctUniqueId | acctstoptime | nasporttype | +--------------+----------------------------------+------------------+---------------------+-------------+ | 61.6.191.247 | erx atm 2/3.10601218:60.1218:016 | ebe88dbb3457c826 | 2005-08-22 10:32:52 | xDSL |
Hi,
but one case as below, i received a long "Acct-Session-Id" ... and cannot fit into mysql... and problem to update Stop record...
should I change column size from char32 to reasonable value ?
I had the same problem some time ago and solved it by extending the allowed length for that column. So, yes, go ahead. Stefan Winter -- Stefan WINTER Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche Ingénieur de recherche 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg email: stefan.winter@restena.lu tél.: +352 424409-1 http://www.restena.lu fax: +352 422473
Rohaizam Abu Bakar wrote:
but one case as below, i received a long "Acct-Session-Id" ... and cannot fit into mysql... and problem to update Stop record...
According to the RFCs, Acct-Session-Id can be up to 253 characters, but probably you won't need that many.
should I change column size from char32 to reasonable value ?
Yes. Check the maximum characters that your NAS will ever send. -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0)475 67 22 65 E: thor.spruyt@telenet.be W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be
On Mon, Aug 22, 2005 at 05:15:53PM +0800, Rohaizam Abu Bakar wrote:
Dear all,
but one case as below, i received a long "Acct-Session-Id" ... and cannot fit into mysql... and problem to update Stop record...
should I change column size from char32 to reasonable value ?
Acct-Session-Id = "erx atm 2/3.10601218:60.1218:0165889995"
+--------------+----------------------------------+------------------+---------------------+-------------+ | nasipaddress | AcctSessionId | AcctUniqueId | acctstoptime | nasporttype | +--------------+----------------------------------+------------------+---------------------+-------------+ | 61.6.191.247 | erx atm 2/3.10601218:60.1218:016 | ebe88dbb3457c826 | 2005-08-22 10:32:52 | xDSL | - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
The ERX I'm hooked up to recently crossed the 64-byte mark, so I suggest 128 bytes for the field length, if you don't want to go all the way to 253. -- ----------------------------------------------------------- Paul "TBBle" Hampson, MCSE 8th year CompSci/Asian Studies student, ANU The Boss, Bubblesworth Pty Ltd (ABN: 51 095 284 361) Paul.Hampson@Pobox.Com Of course Pacman didn't influence us as kids. If it did, we'd be running around in darkened rooms, popping pills and listening to repetitive music. -- Kristian Wilson, Nintendo, Inc, 1989 License: http://creativecommons.org/licenses/by/2.1/au/ -----------------------------------------------------------
participants (4)
-
Paul TBBle Hampson -
Rohaizam Abu Bakar -
Stefan Winter -
Thor Spruyt