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