Failure to get freeradius work with mysql

[Alan DeKok]

Thai Pham Vinh wrote:
> I'm doing some investigation to set up a system to authenticate wireless
> clients using 802.1X. freeradius is my choice because it's free and
> robust. I followed the instructions in "Deploying FreeRadius with MySQL
> Cluster Database" to set it up. I used radtest to verify the account in
> both "users" file and "mysql" database successfully. However, when it
> came to working with the wireless client, only the account in "users"
> file worked. The users stored in "mysql" database didn't. I configured
> the laptop to use EAP-PEAP.
> 
> I examined the debug and found that FR rejected the client request at
> the last steps (when using mysql database):

  The issue is that it's *not* looking in SQL.

  Edit raddb/sites-available/inner-tunnel, and look for "sql".
Uncomment the relevant lines.

  Alan DeKok.