1.1.6: PAP and MySQL-stored NT-Password don't work

Stefan Winter stefan.winter at restena.lu
Mon Apr 30 07:39:40 CEST 2007


> > radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
> > radcheck           WHERE Username = 'swinter'           ORDER BY id'
> >
> > radius_xlat:  'SELECT
> > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroup
> >check.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
> > usergroup.Username = 'swinter' AND usergroup.GroupName =
> > radgroupcheck.GroupName ORDER BY radgroupcheck.id'
>
> What do these two SQL queries return if you run them in the CLI SQL client?

First:

+----+----------+-------------+----------------------------------+----+
| id | UserName | Attribute   | Value                            | op |
+----+----------+-------------+----------------------------------+----+
|  1 | swinter  | NT-Password | 0CB6948805F797BF2A82807973B89537 | := |
+----+----------+-------------+----------------------------------+----+

Second: Empty set.

Stefan

-- 
Stefan WINTER

Stiftung RESTENA - Réseau Téléinformatique de l'Education Nationale et de 
la Recherche
Ingenieur Forschung & Entwicklung

6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg
E-Mail: stefan.winter at restena.lu     Tel.:     +352 424409-1
http://www.restena.lu                Fax:      +352 422473
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070430/39d6925a/attachment.pgp>


More information about the Freeradius-Users mailing list