Insert or Update Username and NAS-Port-Id

[heldt]

Hi!

I have a freeradius(2.0.4+dfsg-6) using postgresql and running on Debian
Lenny. 
Everything works great. 

Now I'm in the position to where I need to insert or update the User-name,
NAS-Port-id, NAS-Port-type and NAS-Identiifier to a table in the database
each time freeradius receives a request.
This would help me keep track on mac/ip -> nas-port-id. 

Could someone tell me how I can solve this or point me to some documents.

When I run radsniff I get the following data: (replaced real IP with 'x')

Packet number 22 has just been sniffed
	From:    x.x.x.x:49960
	To:      x.x.x.x:1812
	Type:    Access-Request
	User-Name = "00:73:07:37:5a:e2"
	User-Password = ""
	NAS-IP-Address = 172.16.87.2
	NAS-Port-Type = Ethernet
	NAS-Port-Id = "1/1/6:124"
	NAS-Identifier = "on-kkna-ess-01"
Packet number 23 has just been sniffed
	From:    x.x.x.x:49960
	To:      x.x.x.x:1812
	Type:    Access-Request
	User-Name = "192.168.0.12"
	User-Password = ""
	NAS-IP-Address =  x.x.x.x
	NAS-Port-Type = Ethernet
	NAS-Port-Id = "1/1/16:101"
	NAS-Identifier = "on-kkna-ess-01"
	Alc-Client-Hardware-Addr = "00:73:06:06:15:59"


// Daniel Heldt
-- 
View this message in context: http://freeradius.1045715.n5.nabble.com/Insert-or-Update-Username-and-NAS-Port-Id-tp2849496p2849496.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.