The NAS is apparently sending all the information (according to the network guys here). It is getting the FramedIPAddress for sessions without a start time, so it's apparently sending it.. It just doesn't put it into mysql when theres a start time..
Andre > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ernesto > Freyre > Sent: Monday, July 05, 2004 5:27 PM > To: [EMAIL PROTECTED] > Subject: Re: MySQL accounting strangeness > > > Normally this could depend on your NAS configuration. Check this > is sending > the attributes you need. > > > Untitled DocumentErnesto Freyre Ramírez Área de Operaciones Red Privada > Virtual S.A. Av. Paseo de la República 4675 - Lima 34 Telf.: > (511) 241-4122 > Anexo 2245 Fax: (511) 446-8135 Visítenos en: www.qnet.com.pe > ----- Original Message ----- > From: "Andre Fortin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 05, 2004 12:26 PM > Subject: MySQL accounting strangeness > > > > Hello, > > > > Forgive me if this has been covered. I'm using FreeRADIUS 0.8.1 and am > > using MySQL for accounting (and LDAP for authorization, but that's > probably > > not important). This works well for getting totals of time > used for each > > user. However, I'm now trying to write a tool to search which username > was > > logged on at X time, and noticed some missing information in the radacct > > table; It seems that when a session is started, its not entering the > > FramedIPAddress. Strangely, if the user was logged in when accounting > > wasn't happening, and the session ends, it records a start time of all > > zeros, and the AcctStopTime, with the IP address. If the > system has both > > the AcctStartTime and StopTime, there is no IP address.. Here's > a snippet > of > > results from my database: > > > > > +--------------------------------+-----------------+-------------- > -------+-- > > -------------------+ > > | UserName | FramedIPAddress | > AcctStartTime | > > AcctStopTime | > > > +--------------------------------+-----------------+-------------- > -------+-- > > -------------------+ > > | Xuser | 66.206.230.5 | 0000-00-00 > 00:00:00 | > > 2004-04-29 11:57:27 | > > > > | Xuser | | 2004-05-03 > 23:33:25 | > > 2004-05-03 23:44:09 | > > > > > > > > All accounts are exhibiting this behavior; very few actually have a > recorded > > IP address, only the ones without a valid start time.. Any > ideas? If you > > need any more information, let me know.. I haven't yet tried upgrading, > as > > I'm not sure if it will fix it, and I don't want to accidently cause any > > other problems by changing the version. Thanks in advance, > > > > Andre > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
