Re: plpgsql freeradius authentication function

2010-10-25 Thread Alan DeKok
Kafui Akyea wrote: > I am sending an aaa authorize request to from a cisco tcl ivr script > to freeradius. That doesn't matter. > 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. You've already

Re: plpgsql freeradius authentication function

2010-10-23 Thread 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 i

Re: plpgsql freeradius authentication function

2010-10-19 Thread Kafui Akyea
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 wrote: > Kafui Akyea wrote: > > This

Re: plpgsql freeradius authentication function

2010-10-18 Thread Alan DeKok
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

Re: plpgsql freeradius authentication function

2010-10-18 Thread Kafui Akyea
This is what the freeradius debug looks like when i try to authenticate a user who is not valid. I dont get an Access-Reject. But for valid users the function works fine. radius_xlat: 'SELECT id,username,attribute,value,op FROM tryagain('7140949870','') as (id integer,username varchar,at

Re: plpgsql freeradius authentication function

2010-10-18 Thread Alan Buxey
Hi, >If i try to authenticate a user who is not valid i do not get an >Access-Reject but rather >i get >RADIUS: Retransmit to ([1]192.168.1.12:1812,1813) for id 1645/201 >RADIUS: Retransmit to ([2]192.168.1.12:1812,1813) for id 1645/201 >RADIUS: Retransmit to ([3]192.168.1.

Re: plpgsql freeradius authentication function

2010-10-18 Thread Kafui Akyea
Hi There is one more problem i am encountering although the function works. If i try to authenticate a user who is not valid i do not get an Access-Reject but rather i get RADIUS: Retransmit to (192.168.1.12:1812,1813) for id 1645/201 RADIUS: Retransmit to (192.168.1.12:1812,1813) for id 1645/201

Re: plpgsql freeradius authentication function

2010-10-18 Thread Kafui Akyea
Alan, Thanks a lot that worked Kafui On Mon, Oct 18, 2010 at 11:52 AM, Alan DeKok wrote: > Kafui Akyea wrote: > > Hi > > > > I implemented this in the freeradius postgresql.conf file > > SELECT id,username,attribute,op,value > > That's the wrong order. See the default SELECT in > raddb/sql/p

Re: plpgsql freeradius authentication function

2010-10-18 Thread Alan DeKok
Kafui Akyea wrote: > Hi > > I implemented this in the freeradius postgresql.conf file > SELECT id,username,attribute,op,value That's the wrong order. See the default SELECT in raddb/sql/postgresql/dialup.conf. > I am generally trying to authenticate with a postgres function Make sure it ret

Re: plpgsql freeradius authentication function

2010-10-18 Thread Kafui Akyea
Hi I implemented this in the freeradius postgresql.conf file SELECT id,username,attribute,op,value FROM try('714094','') as(id integer,username varchar,attribute varchar,op character,value varchar); and implemented this function on the Postgres database server CREATE OR REPLACE FUNCTION t

RE: plpgsql freeradius authentication function

2010-10-17 Thread Santiago Balaguer GarcĂ­a
In which statement do you implement this query? Date: Sat, 16 Oct 2010 11:49:36 -0400 Subject: plpgsql freeradius authentication function From: kak...@gmail.com To: freeradius-users@lists.freeradius.org Hi I have a plpgsql function being called from freeradius to do authentication but i kee