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