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

Reply via email to