More SQL

[Chris Knipe]

Silly Tosser(tm) mistake.  Please ignore.


Regards,
Chris.

----- Original Message ----- 
From: "Chris Knipe" <savage at savage.za.org>
To: <freeradius-users at lists.freeradius.org>
Sent: Wednesday, August 23, 2006 2:06 PM
Subject: More SQL


> Ok,
>
> Either I'm very stupid, or something is not working :(
>
> Debug output:
> rlm_sql (sql): Released sql socket id: 8
> rlm_sql (sql): No matching entry in the database for request from user 
> [user at domain.com]
>  modcall[authorize]: module "sql" returns notfound for request 6
> modcall: leaving group authorize (returns ok) for request 6
> auth: No authenticate method (Auth-Type) configuration found for the 
> request: Rejecting the user
> auth: Failed to validate the user.
> Login incorrect: [user at domain.com/password] (from client ACS01 port 17 cli 
> 00:01:4A:5E:86:80)
>
>
> However,
>
> My authorize_check_query returns:
> +--------------------------------------+-------------------------------------------------+-----------+------------+----+
> | EntryID                              | CONCAT(`User`.Username, '@', 
> `Realm`.RealmName) | Attribute | Value      | op |
> +--------------------------------------+-------------------------------------------------+-----------+------------+----+
> | 6c9b56e2-833b-1029-8ba8-00005e000164 | user at domain.com | Password  | 
> password | == |
> +--------------------------------------+-------------------------------------------------+-----------+------------+----+
>
> My authorize_reply_query returns:
> blank.  Dont use return items on a per user level
>
> My authorize_group_check_query:
> +--------------------------------------+------------------+------------------+-------------+----+
> | EntryID                              | GroupName        | Attribute | 
> Value       | op |
> +--------------------------------------+------------------+------------------+-------------+----+
> | 7277e77a-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Auth-Type | 
> Local       | =  |
> | 7276ec35-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> Framed-Protocol | PPP         | == |
> | 7278f993-8331-1029-8ba8-00005e000164 | PPPoE Test Group | NAS-Port-Type 
> | Ethernet    | == |
> | 727b0157-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Pool-Name | 
> IP-WLAN     | := |
> | 727a0eba-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Service-Type | 
> Framed-User | == |
> | 7275f803-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> Simultaneous-Use | 1           | := |
> +--------------------------------------+------------------+------------------+-------------+----+
>
> And, the authorize_reply_query
> +--------------------------------------+------------------+-------------------------+-----------------------------------+----+
> | EntryID                              | GroupName        | Attribute | 
> Value                             | op |
> +--------------------------------------+------------------+-------------------------+-----------------------------------+----+
> | e5a85344-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> Acct-Interim-Interval   | 3600                              | := |
> | e5a26d7c-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Class | WLAN 
> | := |
> | e5a37a9b-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Framed-Netmask 
> | 255.255.255.255                   | := |
> | e5a4d134-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> Framed-Protocol | PPP                               | := |
> | e5a60591-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Framed-Routing 
> | Broadcast-Listen                  | := |
> | e5a74936-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> Mikrotik-Rate-Limit     | 64k/1024k 64k/1024k 64k/1024k 15s | := |
> | e5a97448-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> MS-Primary-DNS-Server   | 198.18.0.36                       | := |
> | e5aa9732-8331-1029-8ba8-00005e000164 | PPPoE Test Group | 
> MS-Secondary-DNS-Server | 198.18.0.4                        | := |
> | e5ab9178-8331-1029-8ba8-00005e000164 | PPPoE Test Group | Service-Type | 
> Framed-User                       | := |
> +--------------------------------------+------------------+-------------------------+-----------------------------------+----+
>
>
> What exactly is it not finding??? :(
>
>
>
> Regards,
> Chris.
> - List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>