I found my Freeradius problem: It is : "Found Auth-Type 654321" Thu Jun 17 11:23:59 2004 : Debug: auth: type "(null)" I check my postgresql Table and found that the radcheck table has a wrong attribute, I set it "Auth-Type" by mistak it should be "Password". Thanks Mike! Thanks!
> > 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 > ------------------------------------------------- This mail sent through NZOL Webmail: http://webmail.nzol.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
