plpgsql freeradius authentication function

[Kafui Akyea]

Hi

I am sending an aaa authorize request to from a cisco tcl ivr script
to freeradius.

After the authentication is done i want to retrieve the Username and
Password values
that are sent back to the cisco gateway to the IVR script.

I am able to retrieve the other H323 attribute value pairs with infotag get
aaa_avpair command
but i am unable to retrieve the Username and Password from the returned
values.

Help will be very much appreciated.

kafui

On Tue, Oct 19, 2010 at 11:04 AM, Kafui Akyea <kakyea at gmail.com> wrote:

> I have not changed the order of the default queries. Because for
> users in radcheck table it authenticates perfectly but for users who are
> not
> thats when i need to get an Access-Reject but i dont get anything at all.
>
>
>
> On Tue, Oct 19, 2010 at 1:18 AM, Alan DeKok <aland at deployingradius.com>wrote:
>
>> Kafui Akyea wrote:
>> > This is what the freeradius debug looks like when i try to authenticate
>> > a user who is not valid.
>> ...
>> > rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire
>> row.
>> > rlm_sql (sql): Error getting data from database
>> > rlm_sql (sql): SQL query error; rejecting user
>> > rlm_sql (sql): Released sql socket id: 1
>> >   modcall[authorize]: module "sql" returns fail for request 3
>>
>>   The answer is the same as last time: ensure that your function returns
>> the same values as the default queries.
>>
>>  If you're going to modify the default queries, it helps to understand
>> what they do and how they work.
>>
>>  Alan DeKok.
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20101024/a3d7d363/attachment.html>