[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: 1.1.6: PAP and MySQL-stored NT-Password don't work
From:       Stefan Winter <stefan.winter () restena ! lu>
Date:       2007-04-30 5:39:40
Message-ID: 200704300739.44744.stefan.winter () restena ! lu
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


> > 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@restena.lu     Tel.:     +352 424409-1
http://www.restena.lu                Fax:      +352 422473

[Attachment #5 (application/pgp-signature)]

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

[prev in list] [next in list] [prev in thread] [next in thread]