Unable to get FreeRADIUS working with MySQL
Hi, I am running FreeRADIUS Version 1.1.3, for host x86_64-redhat-linux-gnu (from the CentOS repositories) and am having problem getting it working with MySQL. The specific error message that I am seeing is: ... rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: leaving group authorize (returns ok) for request 0 rad_check_password: Found Auth-Type System auth: type "System" ERROR: Unknown value specified for Auth-Type. Cannot perform requested action. auth: Failed to validate the user. Delaying request 0 for 1 seconds Finished request 0 Going to the next request ... After testing with the following command: /usr/bin/radtest test_user password 127.0.0.1 1812 sharedsecret It seems like the sql module is set up correctly, because the authorize section returns ok. However, the authentication section does not check the database, but rather uses the DEFAULT user, which has 'Auth-Type' set to 'System'. This returns an error and the request is rejected. How do I get 'rad_check_password' to check the database instead of the looking at the system users? Is there an 'Auth-Type' of 'SQL' which I could use? Thank you Stephen
On 01/11/2011 02:54 AM, Stephen Tyers wrote:
Hi,
I am running FreeRADIUS Version 1.1.3,
Upgrade to an newer, supported version of the server. Start with the default configs and a test user in /etc/raddb/users: username Cleartext-Password := "password" See that this works, move the info into SQL, continue from there making one change at a time and keeping a history of your configs so you can go back when something breaks.
participants (3)
-
Fajar A. Nugraha -
Phil Mayers -
Stephen Tyers