Freeradius GGSN->Postgresql Based upon a SELECT it will trigger a specific IP Pool

[Pedro Costa]

Hi,

I'm new to Freeradius and i am trying to figure a way to use Freeradius to
Authenticate a user through a CISCO GGSN in where the GGSN will send the
IMSI to the Freeradius and the Freeradius will connect to a Postgresql DB
doing a SELECT on 2 tables and will receive a Language that the IMSI/User
has stored in the database, the Freeradius will then use the language (ex.:
French or German) and choose the specific IP Pool for that Language.

I'm currently trying to connect to Postgresql but i'm having doubt on how
can i acheive this purpose of selecting a ip pool based upon the output of
the SELECT command performed on the DB.

What is the best and/or simplest way to achieve this? Is it through Perl? Or
can the Freeradius connect straight to the Postgres DB and receive the
Select output and be able to use the respective IP Pool, if so how can i
achieve this?

Hope someone can help,

Best Regards,
P.M.R.C.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110524/1727c5dc/attachment.html>