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.