FreeTDS affected_rows_count Problem, Virtual Servers - nas_table Server Column Problem

[Alan DeKok]

On Aug 6, 2020, at 8:16 AM, Alan DeKok <aland at deployingradius.com> wrote:
>>    1 - Multiple clients cannot be added to the same virtual server, if tried get error like:
>>        rlm_sql (sql): Processing generate_sql_clients
>>        rlm_sql (sql): Executing select query: SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1
>>        rlm_sql (sql): Adding client 10.5.50.1 (home) to default clients list
>>        rlm_sql (10.5.50.1): Client "home" (sql) added
>>        rlm_sql (sql): Adding client 192.168.1.210 (citylight) to default clients list
>>        Failed to associate clients with virtual server default
>>        Failed to add client, possible duplicate?
>> 
>>        Although there is no other client with same Name (IPAddress) it cannot add second client.
> 
>  Hmm... that should work.  I'll see if I can do some tests.

  I've checked, and it works with the latest version from v3.0.x.

>>    2- If it gets an Access-Request it errors with "from unknown client" even if the client is added and same client works if it is made global, some lines from debug:
>>        rlm_sql (WISPSQL): Adding client 192.168.1.200 (orbitalanya) to WISPServer clients list
>>        rlm_sql (192.168.1.200): Client "orbitalanya" (WISPSQL) added
>> 
>>        Error with Access-Request:
>>        Ignoring request to auth address * port 2812 bound to server WISPServer from unknown client 192.168.1.200 port 49390 proto udp
> 
>  That should work, too.

  It works with the latest code from v3.0.x.

  Alan DeKok.