Multiple Customer Databases

[Oliver Kutscher]

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 at addix.net
www.addix.net

Am 25.07.2016 um 17:23 schrieb A.L.M.Buxey at 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
>