Date: Wed, 13 Sep 2006 16:35:49 +0100 From: Rob Shepherd <rob@techniumcast.com> Subject: Re: NT-PASSWORD--Re: Freeradius-Users Digest, Vol 17, Issue 47 To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <45082555.6030105@techniumcast.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Thank you, but, after done that radiusd display this to me: radius_xlat: 'davide' rlm_sql (sql): sql_set_user escaped user --> 'davide' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'davide' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql: Failed to create the pair: Unknown attribute "NT_Password" rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module "sql" returns fail for request 0 modcall: leaving group authorize (returns fail) for request 0 There was no response configured: rejecting request 0 Server rejecting request 0. Finished request 0 What I have to do now? (username=davide, password=verde, my radcheck table row is: ------------|------------------------------|--------|--------------------------------------------------------------| |davide | NT_Password | := | 781b0395cf9f8c1e5873eee5d28c38eb | ------------|------------------------------|---------|--------------------------------------------------------------| where i have to configure radius? BEst regards. ego seek wrote:

I'm working with mschapv2, I use a PHP web site to register a user, can i insert into the db a NT-hased password?

Yes, radcheck should contain UserName | Attribute | op | Value | ----------|---------------|------|------------------------------------| colin | NT_Password | := | abcdef1234567890abcdef1234567890 | I use Pear Crypt... <?php $cr = new Crypt_CHAP_MSv1(); $cr->password = $password; $NThash = bin2hex($cr->ntPasswordHash()); ?> Rob