Different accounting based on avpair
Hi, I've been searching the ML for something related to this without any success. I don't know if freeradius does what i need and correct me if i'm wrong. I want to freeradius insert/update different sql tables using a avpair from my custom dictionary. What i would like is somthing like this: "if avpair Wireless = yes use accounting module sql1 else use accounting module sql2" accounting { acct_unique sql1 if (Wireless = yes) sql2 if (Wireless != yes) } Could it be done with users file? Thanks, -- Nuno Miguel Pais Fernandes <npf@eurotux.com> Cisco Certified Network Associate Oracle Certified Professional Eurotux Informática, S.A. [http://eurotux.com] Rua Rosalvo de Almeida, 5. 4710-429 BRAGA PORTUGAL Tel: (+351) 253 257395 - Fax: (+351) 253 257396
Hi, Does someone have any info on this? Is it possible with freeradius? Does anyone have this setup working? Thanks Nuno Fernandes On Wednesday 15 November 2006 18:17, Nuno Pais Fernandes wrote:
Hi,
I've been searching the ML for something related to this without any success. I don't know if freeradius does what i need and correct me if i'm wrong.
I want to freeradius insert/update different sql tables using a avpair from my custom dictionary. What i would like is somthing like this:
"if avpair Wireless = yes use accounting module sql1 else use accounting module sql2"
accounting { acct_unique sql1 if (Wireless = yes) sql2 if (Wireless != yes) }
Could it be done with users file?
Thanks,
-- Nuno Miguel Pais Fernandes <npf@eurotux.com> Cisco Certified Network Associate Oracle Certified Professional Eurotux Informática, S.A. [http://eurotux.com] Rua Rosalvo de Almeida, 5. 4710-429 BRAGA PORTUGAL Tel: (+351) 253 257395 - Fax: (+351) 253 257396
Nuno Pais Fernandes wrote:
Hi,
Does someone have any info on this? Is it possible with freeradius? Does anyone have this setup working?
Yes. See doc/Acct-Type and doc/configurable_failover. You can configure two SQL modules, and select which one to use via Acct-Type. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
Hi, Thanks, it worked :) Just for the record, redhat's RPMS doesn't bring doc/Acct-Type :) Nuno Fernandes On Friday 24 November 2006 16:50, Alan DeKok wrote:
Nuno Pais Fernandes wrote:
Hi,
Does someone have any info on this? Is it possible with freeradius? Does anyone have this setup working?
Yes. See doc/Acct-Type and doc/configurable_failover.
You can configure two SQL modules, and select which one to use via Acct-Type.
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Nuno Miguel Pais Fernandes <npf@eurotux.com> Cisco Certified Network Associate Oracle Certified Professional Eurotux Informática, S.A. [http://eurotux.com] Rua Rosalvo de Almeida, 5. 4710-429 BRAGA PORTUGAL Tel: (+351) 253 257395 - Fax: (+351) 253 257396
participants (2)
-
Alan DeKok -
Nuno Pais Fernandes