Re: MySQL accounting strangeness

2004-07-05 Thread Ernesto Freyre 
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| -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

RE: MySQL accounting strangeness

2004-07-05 Thread Andre Fortin 
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| -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