mysql errors when running freeradius

[Alan DeKok]

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.