Hi, tahnk you very much! Using virtual servers solved my issue. Mit freundlichen Grüßen, i.A. Oliver Kutscher -- Postanschrift: ADDIX Internet Services GmbH Postfach 1225 D-24011 Kiel Tel: +49 431 7755 140 Fax: +49 431 7755 105 ok@addix.net www.addix.net Am 25.07.2016 um 17:23 schrieb A.L.M.Buxey@lboro.ac.uk:
Hi,
I have several customers with their own database. I do logging accounting data to sql. My problem is that any accounting data of any customers is logged to any radacct tables. E.g. accounting data of customer1 is logged to (sql) customer1.radacct, but also to customer2.radacct and vise versa.
because thats how you've configured it
accounting { customer1 customer2 }
so when your server goes through accounting section with a packet it does both of those.
you will need to write some policy/unlang to ensure that customer1 SQL only gets called when relevant etc eg
if (%{Called-Station-ID =~ /10\.90\.5/}) { customer1 } elsif (%{Called-Station-ID =~ /192\.168\.1/}) { customer2 }
or somesuch decision
alternatively (and much better!) use virtual-servers in the clients.conf and ensure that each customer gets their own V-S instance and then just call customer1 or cusotmer2 etc in the accounting section.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html