Freeradius 3.0.22 - mssql - Schema

Clive Allen cliveallen0907 at gmx.com
Sun Nov 28 11:31:11 CET 2021


   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?


More information about the Freeradius-Users mailing list