more than one freeradius user and database

I want to make free radius managing system.
there are many users who can use this system.
every user will have his own database.
for example, I have tow users the first one admin1 and the second admin2
the first user will have database1 and the second will have database2
there is one online free radius server which will be using for authenticating and accounting
in free radius, as you know there is one sql.conf file which contains the database information
I know I can make more than one instance of SQL for every user but when the system will have 100 users, for example, is this the right way to make 100 instances of database or there is another way to make this.
when the user open my online system he must have a new account when he click on register button he must insert his database information (host, username, password)
this information must go SQL.conf file in free radius to tell free radius to connect this database
are there any one have an Idea about my problem
I hope I explained my problem clearly

Answer

if i understood your question correctly, what you are looking for is to have a good performance radius database system. but on the face of it, what you have thought of doesn’t sound a good idea. for the following reasons:

  • over all maintenance becomes a huge issue for you.

  • later on if you have to change the database to add or delete a field you have to do it on all the databases which is cumbersome

  • taking reports on overall users and their status, consumption, service information will be difficult.

design the database well and you can use multiple modules to connect to it. you can write a python / perl programs for accounting module and sql module for authentication.

freeradius 3.0.x is shipped with rlm_rest module, where you can call a rest api for these purposes also. this gives you extreme power to manipulate with your data and would be even able to use BigData technologies also, which can easily handle the huge database overheads.

Attribution
Source : Link , Question Author : Abobaker EngIt , Answer Author : Lakshman Pilaka

Leave a Comment