Cleartext-password problem

hadi golestani hadi.golestani at gmail.com
Mon Oct 22 22:21:13 CEST 2007


Hi,
I've installed freeradius and it was working fine with users file
authentication but when I add sql module ( freeradius's wiki->SQL_HOWTO )
when I try radtest with a username that is in db, authentication failed, and
it's the out put of debug mode:

rad_recv: Access-Request packet from host 127.0.0.1:1026, id=168, length=147
        Service-Type = Framed-User
        Framed-Protocol = PPP
        User-Name = "n2test"
        MS-CHAP-Challenge = 0x409da00bcdf49bf9ac057995c300f40b
        MS-CHAP2-Response =
0x24003e5162483aabe749b5dd4550f8e68be60000000000000000980209d9d70a472836d24769c794daa603e726bc8f27c73e
        Calling-Station-Id = "192.168.1.4"
        NAS-IP-Address = 127.0.0.1
        NAS-Port = 0
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 12
  modcall[authorize]: module "preprocess" returns ok for request 12
  modcall[authorize]: module "chap" returns noop for request 12
  rlm_mschap: Found MS-CHAP attributes.  Setting 'Auth-Type  = mschap'
  modcall[authorize]: module "mschap" returns ok for request 12
    rlm_realm: No '@' in User-Name = "n2test", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 12
  rlm_eap: No EAP-Message, not doing EAP
  modcall[authorize]: module "eap" returns noop for request 12
    users: Matched entry DEFAULT at line 153
    users: Matched entry DEFAULT at line 172
    users: Matched entry DEFAULT at line 184
  modcall[authorize]: module "files" returns ok for request 12
radius_xlat:  'n2test'
rlm_sql (sql): sql_set_user escaped user --> 'n2test'
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
radcheck           WHERE Username = 'n2test'           ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql: Failed to create the pair: Unknown attribute "Cleartext-Password"
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 2
  modcall[authorize]: module "sql" returns fail for request 12
modcall: leaving group authorize (returns fail) for request 12
Finished request 12
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 12 ID 168 with timestamp 471cb73a
Nothing to do.  Sleeping until we see a request.

Why this happens? can this was for some missing information in my db?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20071022/21f76bec/attachment.html>


More information about the Freeradius-Users mailing list