Re: Question about multiple sql databases!
On Mar 2, 2015, at 4:39 AM, Haviaras Kostas <[hidden email] <http://freeradius.1045715.n5.nabble.com/user/SendEmail.jtp?type=node&node=5732078&i=0>> wrote:
Each database is for different company! I will change to have different username and passwords.
Then you will need different SQL queries. If you use the same SQL queries for each company, > > you will get the same response.
This isn’t really a RADIUS problem.
Alan DeKok.
I just tested, you are right, I am getting the same result! You know how to solve this ??? Thanks
On Mar 4, 2015, at 2:50 AM, Haviaras Kostas <koshalirod@gmail.com> wrote
I just tested, you are right, I am getting the same result! You know how to solve this ???
Configure multiple SQL modules. One for each virtual server. Or, update the queries to include a “database table” field. Take that field from a RADIUS attribute. Probably one you create yourself (see raddb/dictionary). Then, in each virtual server, set the value of that attribute to the correct database table. And then use the same SQL module in all 3 virtual servers. Alan DeKok.
participants (2)
-
Alan DeKok -
Haviaras Kostas