But you asked if there was: "some standard method that may be used to connect and fetch data from the MYSQL database?" The answer is: Look at rlm_sql, rlm_sqlippool or any of the other modules that use SQL.. -Peter On Fri 08 Jun 2007, Nitin Naveen wrote:
Hi Peter,
I did bother to look at rlm_sql. However my need is a bit different. I do not want to fetch values from a DB and added them as values to certain radisu attributes. I want to fetch, do some operation on the feteched value and then add the result of the operation to the radius attributes. Any ideas or suggested steps would be helpful.
Regards Nitin
Date: Thu, 7 Jun 2007 11:12:47 +0300 From: Peter Nixon <listuser@peternixon.net> Subject: Re: How to connect to backend DB To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <200706071112.48377.listuser@peternixon.net> Content-Type: text/plain; charset="iso-8859-9"
On Thu 07 Jun 2007, Nitin Naveen wrote:
Hi,
I am writing a new RLM called rlm_prop_protocol. It basically adds some attributes. The value for these attributes are pulled from a backend database (MYSQL). I wanted to know whether there is a provision in freeradius or some standard method that may be used to connect and fetch data from the MYSQL database. As of now I have added MYSQL specific code in my module.
Did you bother to look at the FreeRADIUS code before you started writing??
The modules rlm_sql and rlm_sql_mysql would seem to be pretty self explanatory :-)
It is quite likely that you can do what you need without writing a new module...
Cheers
-- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc