From: Rob Shepherd <[EMAIL PROTECTED]>
Subject: Re: NT-PASSWORD--Re: Freeradius-Users Digest, Vol 17, Issue
47
To: FreeRadius users mailing list
<[email protected]>
Message-ID: <[EMAIL PROTECTED]>
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
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
colin | NT_Password | := | abcdef1234567890abcdef1234567890 |
I use Pear Crypt...
<?php
$cr = new Crypt_CHAP_MSv1();
$cr->password = $password;
$NThash = bin2hex($cr->ntPasswordHash());
?>
Rob
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

