NT-PASSWORD--Re: Freeradius-Users Digest, Vol 17, Issue 47

["ego seek" <egoseek@gmail.com>]

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">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