HP-Command-String in sql accounting
Hello, I've enabled command accounting of my HP procure switches. The information is sent to radius : rad_recv: Accounting-Request packet from host 10.10.0.138 port 1274, id=79, length=128 Acct-Session-Id = "002800000016" Acct-Status-Type = Interim-Update Service-Type = NAS-Prompt-User Acct-Authentic = RADIUS User-Name = "toto" NAS-IP-Address = 10.10.0.138 NAS-Identifier = "sw" NAS-Port-Type = Virtual Calling-Station-Id = "10.1.11.61" HP-Command-String = "show running-config" Acct-Delay-Time = 0 But the HP-Command-String is not present in the radacct table, is it possible to have it ? thanks
Just change the SQL schema of your table and adapt the SQL query in sql.conf! Best regards, E:S
-----Original Message----- From: freeradius-users- bounces+edvin.seferovic=kolp.at@lists.freeradius.org [mailto:freeradius-users- bounces+edvin.seferovic=kolp.at@lists.freeradius.org] On Behalf Of Marc Boisis-Delavaud Sent: Montag, 12. März 2012 15:56 To: FreeRadius users mailing list Subject: HP-Command-String in sql accounting
Hello, I've enabled command accounting of my HP procure switches. The information is sent to radius : rad_recv: Accounting-Request packet from host 10.10.0.138 port 1274, id=79, length=128 Acct-Session-Id = "002800000016" Acct-Status-Type = Interim-Update Service-Type = NAS-Prompt-User Acct-Authentic = RADIUS User-Name = "toto" NAS-IP-Address = 10.10.0.138 NAS-Identifier = "sw" NAS-Port-Type = Virtual Calling-Station-Id = "10.1.11.61" HP-Command-String = "show running-config" Acct-Delay-Time = 0
But the HP-Command-String is not present in the radacct table, is it possible to have it ? thanks
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 12 Mar 2012, at 15:55, Marc Boisis-Delavaud wrote:
Hello, I've enabled command accounting of my HP procure switches. The information is sent to radius : rad_recv: Accounting-Request packet from host 10.10.0.138 port 1274, id=79, length=128 Acct-Session-Id = "002800000016" Acct-Status-Type = Interim-Update Service-Type = NAS-Prompt-User Acct-Authentic = RADIUS User-Name = "toto" NAS-IP-Address = 10.10.0.138 NAS-Identifier = "sw" NAS-Port-Type = Virtual Calling-Station-Id = "10.1.11.61" HP-Command-String = "show running-config" Acct-Delay-Time = 0
But the HP-Command-String is not present in the radacct table, is it possible to have it ? thanks
Yes. Just edit the queries in raddb/sql/<your db>/dialup.conf for accounting updates and modify your SQL schema. Be sure to issue the following commands on your ProCurve switches: aaa accounting session-id common aaa accounting commands interim-update radius (from the output it looks like you already have) You'll probably want to use a text field type and the built in SQL function to concatenate the HP-Command-String field from multiple accounting update packets. -Arran Arran Cudbard-Bell a.cudbardb@freeradius.org Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !
participants (3)
-
Arran Cudbard-Bell -
Edvin Seferovic | Kolpinghaus Sankt Pölten -
Marc Boisis-Delavaud