20-Jan-03 at 13:36, Shannon Johnson ([EMAIL PROTECTED]) wrote : > I have the MySQL database set up with a test account (username test, > password test). When I run "radiusd -xxp 1645" and try "radtest test > test localhost:1645 0 testing", it gives me a bunch of stuff, but the > part that stands out is the following: > > radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE > Username = '' ORDER BY id'
I'm taking a stab at this - I have MySQL working here with FreeRadius 0.7.1 (haven't upgraded: still in R&D) You certainly have a problem in that the username is not getting to the SQL module:- I get output like this radius_xlat: 'test' sql_set_user: escaped user --> 'test' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'test' ORDER BY id' then get an accept/reject based on the password, which I store as a Crypt-Password so it's not in plaintext. > >From what I can tell, it's not passing the username (or password, for > that matter) to the SQL database. Would that be a correct assumption? If > so, do you have any suggestions on what to do to fix? > I used the howto at:- http://www.frontios.com/freeradius.html I'm not sure how your config is, or why the username isn't getting passed to the SQL query, maybe check your sql.conf file I have (around line 70) sql_user_name = "%{User-Name}" and in queries below authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE STRCMP(Use rname, '%{SQL-User-Name}') = 0 ORDER BY id" So check that SQL-User-Name is OK, and verify the SQL queries too. Hope this helps, -- |-Simon White, Internet Services Manager, Certified Check Point CCSA. |-MTDS Internet, Security, Anti-Virus, Linux and Hosting Solutions. |-MTDS 14, rue du 16 novembre, Agdal, Rabat, Morocco. |-MTDS tel +212.3.767.4861 - fax +212.3.767.4863 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
