Problems using SQL IP Pool

Fajar A. Nugraha list at fajar.net
Mon Jan 30 13:16:10 CET 2012


On Mon, Jan 30, 2012 at 7:43 PM, Nataniel Klug <listas.nata at cnett.com.br> wrote:
>                 I’ve been using Freeradius for a long time and about 5 months ago I made a change in my default layout so I could use Freeradius SQL-IPPool running over PostgreSQL.

So you have ONLY one instance of sqlipool, backed by postgresql?

>                 I am using MySQL and PostgreSQL for a reason: somehow the software I use to bill my customers can only work with MySQL radacct table and it was not able to read the radacct from PostgreSQL. So I am running accounting over MySQL and Authentication/Authorization over PostgreSQL (I will post the configuration files in the end of this message).

If you don't use mysql for sqlpipool then it's not relevant for this
discussion. Focus on what you use for sqlippool

>
>
>
>                 So, returning to the problem, this is what is happening:
>
>
>
> http://www.cnett.com.br/nata/imagens/Capturar.JPG
>
>
>
>                 There is two clients using the SAME IP which is a problem. Looking into my Freeradius log file I could not find when “cjunior” got the IP I have JUST “taise” allocation:

And what does freeradius debug log say?

-- 
Fajar




More information about the Freeradius-Users mailing list