Virtual Servers & nas_table Server Column Problem

[Alan DeKok]

On Jul 29, 2020, at 6:49 AM, Ali Arslan via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> 
> I use freeradius 3.0.20 on ubuntu server 20.04 virtual machines with mssql backend accessed by freetds.
> I had 3 virtual machines just for freeradius, so i wanted to run them all on a single machine to make better use of resources and decided to make use of Virtual Server capability of freeradius.
> 
> i kept the defualt site as the server of main ISP and added  2 more virtual servers, namely WISPServer and HotspotServer (for hotels and cafes)  whose listen sections are as follows:

  http://wiki.freeradius.org/list-help

  There is no need to post the configuration files.  Please don't.  It doesn't help 99% of the time.

> The attached debug file shows that the client added to WISPServer  clients list:
> 
> rlm_sql (WISPSQL): Adding client 192.168.1.1 (ofis) to WISPServer clients list
> rlm_sql (192.168.1.1): Client "ofis" (WISPSQL) added
> 
> But when the client ( 92.168.1.1 ) sends an accountig request i get error:
> 
> Ignoring request to acct address * port 2813 bound to server WISPServer from unknown client 192.168.1.1 port 41272 proto udp
> 
> To make it work i needed to do one two things, remove Server column from nas query or make it NULL (actually empty string, NULL does not work either), in this case it adds clients to global client list saying
> 
> rlm_sql ( WISPSQL): Adding client 192.168.1.1 (ofis) to global clients list
> 
> For security reasons i wan to define client for a Virtual Server, how can i make it work?

  I've pushed a fix.  You can download the latest version of v3.0.x from gthub:  https://github.com/FreeRADIUS/freeradius-server/

  Alan DeKok.