mysql> select * from usergroup; +----+----------+-----------+ | id | UserName | GroupName | +----+----------+-----------+ | 1 | 49 | 49 | | 2 | 1 | 1 | | 3 | wanghao | bvst | //look this +----+----------+-----------+ 3 rows in set (0.04 sec)
mysql> select * from radcheck; +----+----------+-----------+----+---------+ | id | UserName | Attribute | op | Value | +----+----------+-----------+----+---------+ | 1 | 49 | 80 | == | 49 | | 2 | 1 | Password | == | 1 | | 3 | wanghao | Password | == | wanghao | //look this +----+----------+-----------+----+---------+ 3 rows in set (0.01 sec) ----- Original Message ----- From: "Alexey Sheshka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 6:11 PM Subject: Re: FreeRadius+ mysql => No authenticate method (Auth-Type) configuration found for the request > On Tue, 21 Oct 2003 11:42:51 +0200 > [EMAIL PROTECTED] (Rens Houben) wrote: > > > In other news for Tue, Oct 21, 2003 at 12:29:05PM +0300, Alexey Sheshka has been seen typing: > > > On Tue, 21 Oct 2003 11:13:23 +0200 > > > [EMAIL PROTECTED] (Rens Houben) wrote: > > > > > > In other news for Tue, Oct 21, 2003 at 12:05:19PM +0300, Alexey Sheshka has been seen typing: > > > > > > Try this from a database prompt: > > > > > > SELECT * FROM radcheck WHERE username="pulsar"; > > > > > > and see if there's an Auth-Type entry in the result. I'm betting there > > ^^^^^^^^^ <-- This is a hint. > > > > > > isn't. > > > MySQL return : > > > > > mysql> SELECT * FROM radcheck WHERE username="pulsar"; > > > +----+----------+-----------+----+--------+ > > > | id | UserName | Attribute | op | Value | > > > +----+----------+-----------+----+--------+ > > > | 1 | pulsar | Password | == | 123456 | > > > +----+----------+-----------+----+--------+ > > > > Hmm, no Auth-Type attribute set. > > > > > I need something else ? > > > > Yup. > > > mysql> select * from radgroupcheck; > +----+-----------+-----------+----+-------+ > | id | GroupName | Attribute | op | Value | > +----+-----------+-----------+----+-------+ > | 1 | static | Auth-Type | := | Local | > +----+-----------+-----------+----+-------+ > > > Accordind documentation ... > > > -- > > > > PGP key : http://pgp.dtype.org:11371/pks/lookup?op=get&search=0x0BE90515 > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html