Freeradius realm using multiple sql and virtual server

[Philemon Jaomalaza]

for the moment, for each virtual server, I created a virtual server, its realm and its module sql but actually I do not know how to link them.

where should I add:
if realm1
sql1
elsif realm2
sql2
elsif realm3
sql3
else
sql

in the /freeradius/3.0/proxy.conf or in the /freeradius/3.0/mods-available/sql module?

maybe that's the issues

Philemon Jaomalaza
Tél. : +261 (0) 32 05 113 26
Email : philemon.jaomalaza at gmail.com


-----Message d'origine-----
De : Freeradius-Users [mailto:freeradius-users-bounces+philemon.jaomalaza=gmail.com at lists.freeradius.org] De la part de Alan DeKok
Envoyé : samedi 23 juin 2018 14:23
À : FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Objet : Re: Freeradius realm using multiple sql and virtual server


> On Jun 23, 2018, at 1:34 AM, Philemon Jaomalaza <philemon.jaomalaza at gmail.com> wrote:
> 
> This the output receiving packet when I try to authentificate for usertest1 at mydomaintest.com with password: usertest1password 

  And you've configured the server to use the "sql" module for all users.

  You've said previously that you want different domains to use different SQL modules.  How did you  configure that?

  i.e. how do you expect it to happen?

  It looks like you've configured multiple realms and SQL modules.  But, (and the important thing here) haven't tied them together in any way.

  You should do something like:

	if realm1
		sql1
	elsif realm2
		sql2
	elsif realm3
		sql3
	else
		sql

  Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html