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