FreeRADIUS+unixODBC+BerkeleyDB
Hi, We want to use FreeRadius alongwith Oracle Berkeley DB as the backend DB.We have installed FreeRADIUS 1.1.3 and BerkeleyDB.We also have installed unixODBC-2.2.12.Please let us know how to configure FreeRADIUS with unixODBC and connect FreeRADIUS <-->unixODBC<-->BerkeleyDB. Thanks in advance for your help Regards Sourav
Hi, We want to use FreeRadius alongwith Oracle Berkeley DB as the backend DB.We have installed FreeRADIUS 2.1.3 and BerkeleyDB.We also have installed unixODBC-2.2.12.Please let us know how to configure FreeRADIUS with unixODBC and connect FreeRADIUS <-->unixODBC<-->BerkeleyDB. Thanks in advance for your help Regards Sourav ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius developers mailing list" <freeradius-devel@lists.freeradius.org> Sent: Thursday, February 19, 2009 1:00 PM Subject: Re: FreeRADIUS+unixODBC+BerkeleyDB
Sourav Chakraborty wrote:
Hi, We want to use FreeRadius alongwith Oracle Berkeley DB as the backend DB.We have installed FreeRADIUS 1.1.3
Why?
Use a recent version.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
Previously Sourav Chakraborty wrote:
We want to use FreeRadius alongwith Oracle Berkeley DB as the backend DB.We have installed FreeRADIUS 2.1.3 and BerkeleyDB.We also have installed unixODBC-2.2.12.Please let us know how to configure FreeRADIUS with unixODBC and connect FreeRADIUS <-->unixODBC<-->BerkeleyDB.
Unless I am very mistaken ODBC is used as a bridge for SQL databases, and BerkeleyDB is a simple key/value store, not a SQL database. So what you are asking for is not possible. Wichert. -- Wichert Akkerman <wichert@wiggy.net> It is simple to make things. http://www.wiggy.net/ It is hard to make things simple.
Thanks for the info....in that case please let me know how to configure FreeRadius to use BerkeleyDB.I can see a module rlm_dbm in freeradius-server-2.1.3/src/modules.Is that the module which helps connect FreeRADIUS to BerkeleyDB? Regards Sourav ----- Original Message ----- From: "Wichert Akkerman" <wichert@wiggy.net> To: "Sourav Chakraborty" <sourav.chakraborty@rebaca.com> Cc: "FreeRadius developers mailing list" <freeradius-devel@lists.freeradius.org> Sent: Thursday, February 19, 2009 1:26 PM Subject: Re: FreeRADIUS+unixODBC+BerkeleyDB
Previously Sourav Chakraborty wrote:
We want to use FreeRadius alongwith Oracle Berkeley DB as the backend DB.We have installed FreeRADIUS 2.1.3 and BerkeleyDB.We also have installed unixODBC-2.2.12.Please let us know how to configure FreeRADIUS with unixODBC and connect FreeRADIUS <-->unixODBC<-->BerkeleyDB.
Unless I am very mistaken ODBC is used as a bridge for SQL databases, and BerkeleyDB is a simple key/value store, not a SQL database. So what you are asking for is not possible.
Wichert.
-- Wichert Akkerman <wichert@wiggy.net> It is simple to make things. http://www.wiggy.net/ It is hard to make things simple.
Sourav Chakraborty wrote:
Thanks for the info....in that case please let me know how to configure FreeRadius to use BerkeleyDB.I can see a module rlm_dbm in freeradius-server-2.1.3/src/modules.Is that the module which helps connect FreeRADIUS to BerkeleyDB?
I think you have it backwards. You are asking how to implement a solution, but you haven't said what the problem is. What do you want the server to *do* with a BDB? What do you want to store in the DB? Why have you decided that a BDB is a solution to some un-stated problem? And there's no need to use rlm_dbm. It will likely be deprecated, or removed, in a future release. Alan DeKok.
Sorry,let me explain the purpose first -- We are trying to have a server solution(FreeRADIUS) that would store radius accounting messages coming from NAS.Our data server(separate node) will query this FreeRADIUS server to get info of particular subscribers for generating CDRs. Since the incoming radius msg rate will be very high,hence we want to evaluate the number of transactions per second(writes basically) on Berkeley DB. ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius developers mailing list" <freeradius-devel@lists.freeradius.org> Sent: Thursday, February 19, 2009 1:48 PM Subject: Re: FreeRADIUS+unixODBC+BerkeleyDB
Sourav Chakraborty wrote:
Thanks for the info....in that case please let me know how to configure FreeRadius to use BerkeleyDB.I can see a module rlm_dbm in freeradius-server-2.1.3/src/modules.Is that the module which helps connect FreeRADIUS to BerkeleyDB?
I think you have it backwards.
You are asking how to implement a solution, but you haven't said what the problem is.
What do you want the server to *do* with a BDB? What do you want to store in the DB? Why have you decided that a BDB is a solution to some un-stated problem?
And there's no need to use rlm_dbm. It will likely be deprecated, or removed, in a future release.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
Sourav Chakraborty wrote:
Sorry,let me explain the purpose first -- We are trying to have a server solution(FreeRADIUS) that would store radius accounting messages coming from NAS.Our data server(separate node) will query this FreeRADIUS server to get info of particular subscribers for generating CDRs.
There is no module that writes accounting records to a BDB. You will have to write your own module.
Since the incoming radius msg rate will be very high,hence we want to evaluate the number of transactions per second(writes basically) on Berkeley DB.
Why? Just write to a "detail" file. Then, import that into an SQL database. A BDB is just about useless for queries or long-term storage of information. Alan DeKok.
participants (3)
-
Alan DeKok -
Sourav Chakraborty -
Wichert Akkerman