Hi I implemented this in the freeradius postgresql.conf file SELECT id,username,attribute,op,value FROM try('7140944444','0000') as(id integer,username varchar,attribute varchar,op character,value varchar);
and implemented this function on the Postgres database server CREATE OR REPLACE FUNCTION try (your_name TEXT, tiger TEXT) RETURNS RECORD AS $$ DECLARE users_rec RECORD; BEGIN if tiger = '0000' then SELECT INTO users_rec * FROM aniradcheck WHERE username = your_name; else SELECT INTO users_rec * FROM radcheck WHERE username = your_name; end if; RETURN users_rec.username; END; $$ LANGUAGE plpgsql; I am generally trying to authenticate with a postgres function Thanks and your help very much appreciated. On Mon, Oct 18, 2010 at 2:20 AM, Santiago Balaguer García < santiago...@hotmail.com> wrote: > 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 keep getting > Access-Reject from radius although when i run the function without > freeradius it works fine. > Please find below the function and how i call it > > CREATE OR REPLACE FUNCTION try (your_name TEXT, tiger TEXT) RETURNS RECORD > AS $$ > DECLARE > users_rec RECORD; > > BEGIN > if tiger = '0000' then > SELECT INTO users_rec * FROM aniradcheck WHERE username = your_name; > else > SELECT INTO users_rec * FROM radcheck WHERE username = your_name; > end if; > RETURN users_rec.username; > END; > > $$ LANGUAGE plpgsql; > > > SELECT id,username,attribute,op,value FROM try('7140944444','0000') as(id > integer,username varchar,attribute varchar,op character,value varchar); > > > Appreciate if you can help > Thanks > > - List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html