[RADIATOR] Qos-Metering-Profile-Name and SessionDatabase

Ian Mordey Ian.Mordey at allurian.com
Wed Jul 11 06:31:46 CDT 2012


Hi there
I'm trying to get my SessionDatabase to push a specific attribute into the SQL database. I currently have as my AddQuery:
        AddQuery        INSERT INTO tblradiussessions(radSessionID, radUsername, radTimeStamp, radIPAddress, radServiceType, radNASIdentifier, radNASPort, radNASType,  date, `Tunnel-Client-En
dpoint`, `Tunnel-Client-Auth-ID`, metering) values ('%{Acct-Session-Id}', '%u', '%{Timestamp}', '%{Framed-IP-Address}', '%{Service-Type}', '%N', '%{NAS-Port}', '%{NAS-Port-Type}', NOW(),'%{Tu
nnel-Client-Auth-ID}','%{Tunnel-Server-Auth-ID}','%{Qos-Metering-Profile-Name}')

But this isn't actually picking up the attribute:
Wed Jul 11 12:29:26 2012: DEBUG: do query to 'dbi:mysql:mops:localhost': 'INSERT INTO tblradiussessions(radSessionID, radUsername, radTimeStamp, radIPAddress, radServiceType, radNASIdentifier, radNASPort, radNASType,  date, `Tunnel-Client-Endpoint`, `Tunnel-Client-Auth-ID`, metering) values ('FF10FFFF5804A752-4FFD6395', 'user6490 at domain3.com', '1342006166', '172.17.25.90', 'Framed-User', '192.168.100.5', '2433001298', 'Virtual', NOW(),'wbc50','Eeyore','')':

>From a tcpdump I can see the attribute as
AVP: l=24  t=Vendor-Specific(26) v=Redback(2352)
VSA: l=18 t=Qos-Metering-Profile-Name(88): 8MB-RATE-LIMIT-M
Qos-Metering-Profile-Name: 8MB-RATE-LIMIT-M

Anyone know how I can get this  information into my session Db?

Thanks
Ian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20120711/2baa4f0e/attachment.html 


More information about the radiator mailing list