Re: Store Access-Request packet information in database

[Phil Mayers]

On 11/10/10 11:22, c.schw...@funknetz.at wrote:

Hi,

I would like to achieve some kind of a tracking system for 802.11
wireless clients, therefore every login attempt should be accepted and
the necessary information (e.g. nas-ip-address, calling-station-id)
should be stored in an extra database table.

Example output:
rad_recv: Access-Request packet from host 192.168.30.216 port 43128,
id=5, length=200
         NAS-Port-Type = Wireless-802.11
         Calling-Station-Id = "00:1A:73:59:25:4B"
         Called-Station-Id = "hotspot1"
         NAS-Port-Id = "wlan1"
         User-Name = "christoph"
         NAS-Port = 2152726535
         Acct-Session-Id = "80500007"
         Framed-IP-Address = 10.50.0.254
         Mikrotik-Host-IP = 10.50.0.254
         CHAP-Challenge = 0x12321805f00ad380736bd946aefe0389
         CHAP-Password = 0x1153fcb1c99609b962baa8042aca266905
         Service-Type = Login-User
         WISPr-Logoff-URL = "http://10.50.0.1/logout";
         NAS-Identifier = "test-loop21"
         NAS-IP-Address = 192.168.30.216

Does anybody have an idea how to store this kind of information when
freeradius receives an access-request packet?

Yes. Use the "sql" module.

This is well documented. Have you read any of the docs?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html