Thank Alan for your instant support. My system's working now. Gotta love open source software. Regards, Thai. ________________________________ From: Alan DeKok <aland@deployingradius.com> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Sent: Thu, December 3, 2009 2:02:39 PM Subject: Re: Failure to get freeradius work with mysql 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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com