Freeradius 3.0.22 - mssql - Schema

[Clive Allen]

   Please ignore this. I apologiese for taking up your time with this
   question.

   I have found the missing component (which I was sure I had enabled) in
   the /etc/raddb/mods-available/sql file .... I thought I had enabled the
   following:

   read_clients = yes

   Again, my apologies

   All is now working. Thanks.

   Sent: Sunday, November 28, 2021 at 10:31 AM
   From: "Clive Allen" <cliveallen0907 at gmx.com>
   To: freeradius-users at lists.freeradius.org
   Subject: Freeradius 3.0.22 - mssql - Schema
   Hi,
   I noticed that the mssql schema does not include a "nas" section that
   the "mysql" contains as follows:
   CREATE TABLE IF NOT EXISTS nas (
   id int(10) NOT NULL auto_increment,
   nasname varchar(128) NOT NULL,
   shortname varchar(32),
   type varchar(30) DEFAULT 'other',
   ports int(5),
   secret varchar(60) DEFAULT 'secret' NOT NULL,
   server varchar(64),
   community varchar(50),
   description varchar(200) DEFAULT 'RADIUS Client',
   PRIMARY KEY (id),
   KEY nasname (nasname)
   );
   I have converted this to "mssql" staments and created the nas table.
   However, the radtest that has proved successful does not seem to take
   any of the nas table entries but does take the username. For example,
   if I use the following inputs into the "nas" table:
   Server = <freeradius box>
   Shortname = <ServerName>
   Secret = secret
   User details:
   clive
   test123
   :=
   Cleartext-Password
   And then I utilise radtest as follows:
   radtest clive test123 localhost 1812 secret ---- I can try any
   combination here of localhost, IP address or name and get the same
   result.
   It does not even pass to mssql (no response at all). However, if I use
   the following:
   radtest clive test123 localhost 1 testing123
   I get an access-accept.
   So, my question is - Does mssql with freeradius accept a "nas" table
   please?
   -
   List info/subscribe/unsubscribe? See
   [1]http://www.freeradius.org/list/users.html

References

   1. http://www.freeradius.org/list/users.html