mysql errors when running freeradius

A.L.M.Buxey at lboro.ac.uk A.L.M.Buxey at lboro.ac.uk
Thu Jun 11 17:14:39 CEST 2009


Hi,

> I have used the schema that was located in side raddb/sql/mysql/schema.sql.
> So the database looks like this:

the NAS table is here

raddb/sql/mysql/nas.sql

if you load that up you'll have a lovely new table to play with.

> Only one of those tables looks like it is to do with NAS's, which is
> radacct:

thats accounting. NAS devices can send info about each connection

> I noticed theres a line that states 'readclients' in the sql.conf. the
> comments talk about looking at a table called 'nas' like you suggested. If i
> was set this to 'no' would this then allow me to still use sql but read from
> the clients.conf instead?

correct.

> I have been playing around with it all day today and now i can get radius to

is 'sql' in the authenticate section of your virtual server? if not, the
system wont know to use SQL. 

alan



More information about the Freeradius-Users mailing list