Some help in Freeradius - debug

[Enrique Acosta]

this is the debug for user jvidal and the user didn`t found ....

rad_recv: Access-Request packet from host 192.168.0.2:1035, id=100,
length=154
        User-Name = "jvidal"
        NAS-IP-Address = 192.168.0.2
        NAS-Port = 3
        Called-Station-Id = "00-1E-2A-3C-D2-90:NETGEAR2"
        Calling-Station-Id = "00-18-4D-66-60-24"
        Framed-MTU = 1400
        NAS-Port-Type = Wireless-802.11
        Connect-Info = "CONNECT 54Mbps 802.11g"
        EAP-Message = 0x0200000b016a766964616c
        Message-Authenticator = 0xd245baabd1d9b6ece4c2122fe0b744df
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
  modcall[authorize]: module "preprocess" returns ok for request 0
  modcall[authorize]: module "chap" returns noop for request 0
  modcall[authorize]: module "mschap" returns noop for request 0
    rlm_realm: No '@' in User-Name = "jvidal", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 0
  rlm_eap: EAP packet type response id 0 length 11
  rlm_eap: No EAP Start, assuming it's an on-going EAP conversation
  modcall[authorize]: module "eap" returns updated for request 0
radius_xlat:  'jvidal'
rlm_sql (sql): sql_set_user escaped user --> 'jvidal'
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
radcheck           WHERE Username = 'jvidal'          ORDER BY id'
rlm_sql (sql): Reservingrlm_sql_mysql: query:  SELECT id, UserName,
Attribute, Value, op           FROM radcheck           WHERE Username =
'jvidal'          ORDER BY id
radius_xlat:  'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jvidal' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: query:  SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = 'jvidal' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
radreply           WHERE Username = 'jvidal'           ORDER BY id'
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, op
FROM radreply           WHERE Username = 'jvidal'           ORDER BY id
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = 'jvidal' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: query:  SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = 'jvidal' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql (sql): Released sql socket id: 4
rlm_sql (sql): No matching entry in the database for request from user
[jvidal]
  modcall[authorize]: module "sql" returns notfound for request 0
modcall: leaving group authorize (returns updated) for request 0
  rad_check_password:  Found Auth-Type EAP
auth: type "EAP"
  Processing the authenticate section of radiusd.conf
modcall: entering group authenticate for request 0
  rlm_eap: EAP Identity
  rlm_eap: processing type tls
  rlm_eap_tls: Initiate
  rlm_eap_tls: Start returned 1
  modcall[authenticate]: module "eap" returns handled for request 0
 sql socket id: 4
rlm_sql (sql): No matching entry in the database for request from user
[jvidal]
  modcall[authorize]: module "sql" returns notfound for request 0
modcall: leaving group authorize (returns updated) for request 0
  rad_check_password:  Found Auth-Type EAP
auth: type "EAP"
  Processing the authenticate section of radiusd.conf
modcall: entering group authenticate for request 0
  rlm_eap: EAP Identity
  rlm_eap: processing type tls
  rlm_eap_tls: Initiate
  rlm_eap_tls: Start returned 1
  modcall[authenticate]: module "eap" returns handled for request 0
modcall: leaving group authenticate (returns handled) for request 0
Sending Access-Challenge of id 100 to 192.168.0.2 port 1035
        EAP-Message = 0x010100061920
        Message-Authenticator = 0x00000000000000000000000000000000
        State = 0x314214bdd05f8421ec27027c7fade7d4
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...





El mar, 23-12-2008 a las 22:28 +0100, tnt at kalik.net escribió:
> >mysql> select * from radcheck where UserName = 'jvidal';
> >+-----+----------+--------------------+----+-------------------+
> >| id  | UserName | Attribute          | op | Value             |
> >+-----+----------+--------------------+----+-------------------+
> >| 116 | jvidal   | Cleartext-Password | := | 123               |
> >| 125 | jvidal   | Calling-Station-Id | == | 00-18-4d-66-60-24 |
> >
> >But radius.log is reporting this:
> >
> >Tue Dec 23 10:40:44 2008 : Info: rlm_eap_mschapv2: Issuing Challenge
> >Tue Dec 23 10:40:44 2008 : Info: rlm_sql (sql): No matching entry in the
> >database for request from user [jvidal]
> >Tue Dec 23 10:40:44 2008 : Info: rlm_sql (sql): No matching entry in the
> >database for request from user [jvidal]
> >Tue Dec 23 10:40:44 2008 : Auth: Login incorrect: [jvidal/<no
> >User-Password attribute>] (from client radius-server port 0)
> 
> Can you post the debug? It looks like you haven't copied the request
> attributes to the tunnel but are trying to check them.
> 
> >Tue Dec 23 10:40:44 2008 : Info: rlm_sql (sql): No matching entry in the
> >database for request from user [jvidal]
> >Tue Dec 23 10:40:44 2008 : Auth: Login incorrect: [jvidal/<no
> >User-Password attribute>] (from client red-Wifi-FCMC1 port 1 cli
> >00-18-4D-66-60-24)
> >
> 
> Ivan Kalik
> Kalik Informatika ISP
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- 
Enrique Acosta Figueredo
Adm. de Red en Nodo Infosur, Cfgos, Cuba(Network Administrator at
Infosur Node, Cfgos, Cuba)
Est modus in rebus
Linux User # 301079
http://counter.li.org


---------------------------------------
    Red Telematica de Salud - Cuba
    	  CNICM - Infomed