Thanks Mike, I chance it from "Auth_Type" To "Auth-Type", But now the problem is : auth: type "(null)" Here is the deatail.
Please help me out! Thanks a lot! ================================================================== Thu Jun 17 11:23:59 2004 : Debug: rlm_sql (sql): sql_set_user escaped user --> 'tom' Thu Jun 17 11:23:59 2004 : Debug: radius_xlat: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'tom' ORDER BY id' Thu Jun 17 11:23:59 2004 : Debug: rlm_sql (sql): Reserving sql socket id: 4 Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'tom' ORDER BY id Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: Status: PGRES_TUPLES_OK Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: affected rows = Thu Jun 17 11:23:59 2004 : Debug: radius_xlat: 'SELECT radgroupcheck.id, radgroupcheck.GroupName, radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op FROM radgroupcheck, usergroup WHERE usergroup.Username = 'tom' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: query: SELECT radgroupcheck.id, radgroupcheck.GroupName, radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op FROM radgroupcheck, usergroup WHERE usergroup.Username = 'tom' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: Status: PGRES_TUPLES_OK Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: affected rows = Thu Jun 17 11:23:59 2004 : Debug: radius_xlat: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'tom'ORDER BY id' Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'tom'ORDER BY id Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: Status: PGRES_TUPLES_OK Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: affected rows = Thu Jun 17 11:23:59 2004 : Debug: radius_xlat: 'SELECT radgroupreply.id, radgroupreply.GroupName, radgroupreply.Attribute, radgroupreply.Value, radgroupreply.Op FROM radgroupreply,usergroup WHERE usergroup.Username = 'tom' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: query: SELECT radgroupreply.id, radgroupreply.GroupName, radgroupreply.Attribute, radgroupreply.Value, radgroupreply.Op FROM radgroupreply,usergroup WHERE usergroup.Username = 'tom' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: Status: PGRES_TUPLES_OK Thu Jun 17 11:23:59 2004 : Debug: rlm_sql_postgresql: affected rows = Thu Jun 17 11:23:59 2004 : Debug: rlm_sql (sql): Released sql socket id: 4 Thu Jun 17 11:23:59 2004 : Debug: modsingle[authorize]: returned from sql (rlm_sql) for request 0 Thu Jun 17 11:23:59 2004 : Debug: modcall[authorize]: module "sql" returns ok for request 0 Thu Jun 17 11:23:59 2004 : Debug: modsingle[authorize]: calling files (rlm_files) for request Thu Jun 17 11:23:59 2004 : Debug: modsingle[authorize]: calling files (rlm_files) for request 0 Thu Jun 17 11:23:59 2004 : Debug: users: Matched DEFAULT at 154 Thu Jun 17 11:23:59 2004 : Debug: modsingle[authorize]: returned from files (rlm_files) for request 0 Thu Jun 17 11:23:59 2004 : Debug: modcall[authorize]: module "files" returns ok for request 0 Thu Jun 17 11:23:59 2004 : Debug: modsingle[authorize]: calling mschap (rlm_mschap) for request 0 Thu Jun 17 11:23:59 2004 : Debug: modsingle[authorize]: returned from mschap (rlm_mschap) for request 0 Thu Jun 17 11:23:59 2004 : Debug: modcall[authorize]: module "mschap" returns noop for request 0 Thu Jun 17 11:23:59 2004 : Debug: modcall: group authorize returns ok for request 0 Thu Jun 17 11:23:59 2004 : Debug: rad_check_password: Found Auth-Type 654321 Thu Jun 17 11:23:59 2004 : Debug: auth: type "(null)" Thu Jun 17 11:23:59 2004 : Debug: auth: Failed to validate the user. Thu Jun 17 11:23:59 2004 : Auth: Login incorrect: [tom/654321] (from client ed_radius port 0) RE Please help me out! Thanks a lot! 引用 Michael Griego <[EMAIL PROTECTED]>: > On Wed, 2004-06-16 at 06:04, [EMAIL PROTECTED] wrote: > > rlm_sql: unknown attribute Auth_Type > > Here's your problem. Auth_Type is not a valid attribute. Change that > to Auth-Type (dash, not underscore). > > -- > > --Mike > > ----------------------------------- > Michael Griego > Wireless LAN Project Manager > The University of Texas at Dallas > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > ------------------------------------------------- This mail sent through NZOL Webmail: http://webmail.nzol.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
