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
