At 09:17 AM 11/1/2002 +0000, Ingvar Bjarnason wrote:
Let me guess, it's a cisco NAS?Hi everyone,We noticed that when using MySQL for radius accounting the Framed-IP-Address was only being inserted into the radacct table for update packets, not for stop packets. So depending on the configuration of the NAS you might not get any record of the IP addresses of the users unless of course you were also logging to a detail file (which is always a good idea btw.). Anyway, below is a patch for the sql update query.
Read the 'doc/cisco' notes, where it suggests that you enable the command:
'aaa accounting delay-start'
Otherwise the cisco sends the start packet before it has fully allocated
the IP for the session. Adding the above command delays the start packet
until after the IP has been assigned.
If you get the IP address in the 'start' then there is no need to record
it from the 'stop' packet.
-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
