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 <santiagoawa@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: kakyea@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