EAP-PEAP with NT-Password stored in mysql database

Phil Mayers p.mayers at imperial.ac.uk
Thu Oct 11 18:04:58 CEST 2012


On 11/10/12 16:23, Hocine M wrote:
> Hi,
>
> First apologize my english, j'm french.

No problem.

> i don't use the default virtual server, i only use one
> file....l3_wifi_peap (where i use sql_auth for auth and sql_acct for
> accounting)

Your config is broken:

> +- entering group authorize {...}
> ++[preprocess] returns ok
> [eap] No EAP-Message, not doing EA
> ++[eap] returns noop
> [sql_auth]     expand: %{User-Name} -> alan.cox at test.fr
> [sql_auth] sql_set_user escaped user --> 'alan.cox at test.fr'
> rlm_sql (sql_auth): Reserving sql socket id: 4
> [sql_auth]     expand: SELECT uid, mail, 'NT-Password' AS attribute,
> NTPassword, '==' AS op       FROM dsi_radius       WHERE mail =
> '%{SQL-User-Name}'       ORDER BY uid -> SELECT uid, mail, 'NT-Password'
> AS attribute, NTPassword, '==' AS op       FROM dsi_radius       WHERE
> mail = 'alan.cox at test.fr'       ORDER BY uid
> rlm_sql (sql_auth): Released sql socket id: 4
> [sql_auth] User alan.cox at test.fr not found
> ++[sql_auth] returns notfound
> ERROR: No authenticate method (Auth-Type) found for the request:
> Rejecting the user
> Failed to authenticate the user.

You have edited the default config and broken it.

Go back to the default config and start again. Make small changes, 
testing at each step. Use version control to save each working config.

Also - this request is not EAP. You are not testing EAP.

Google "eapol_test"


More information about the Freeradius-Users mailing list