JamesWhetherly wrote: > I created a table using the schema called nas.sql, and populated it with > local host. When i then run radius (please note that i am in fact running > it: radiusd -X) i can't get it to authenticate.
For us to be able to help you, you *must* post the output of "radiusd -X" here. Otherwise, you're not sharing the single most useful piece of information that can let us help you. And for testing, DON'T start off with nases in SQL. > I had a look to see if sql was in the authenticate section of the virtual > server and by this i guess you mean the file 'default' located inside > 'sites-enabled' that is used in radiusd.conf? Sql was enabled under: > authorize section and accounting. I haven't uncommented sql sections in > post-auth. I added a line just saying 'sql' to the authenticate section like > u suggested and still doesn't make a difference. Don't do that. The SQL module *cannot* be used in the authenticate section. > One thing i noticed as well is the dialup.conf seems to deal with the nas > database too. Yes. That's where it's configured. > Theres a line saying 'sql_user_name = "%{User-Name}"' not sure > if this is meant to be 'radpass' as the user? It's the name of the user. > I'm unsure on what i should look at now? Don't add NASes in SQL. Start off with the *default* configuration. Then, configure the sql module (sql.conf), and uncomment the line including sql.conf in radiusd.conf. Edit raddb/sites-available/default, and un-comment the references to SQL. It's that easy. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html