Hello all, Ive 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. This is working almost fine but for some reason I cant figure out its giving the same IP address to two different clients. So, my network layout is something like this: [ freeradius ] -- [ external* mysql ] -- [ external* postgresql ] * external I mean as the databases are running in separate hardware but in the same physical network My customers are authenticating over PPPoE interfaces on two parallel servers that work as a backup for each other but they are running simultaneously. This would be layout for my clients: (internet) [ auth01/auth02 ] (clients) Auth01 and Auth02 can both communicate with Freeradius in the same physical network and they are getting there with no more than 1 ms (its a gigabit network that fairly is using 50 mbit). 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). 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: Fri Jan 27 12:20:03 2012 : Auth: Login OK: [cjunior] (from client LJS.AUTH.02 port 69822 cli 74:EA:3A:D1:FD:17) Fri Jan 27 12:20:03 2012 : Info: Allocated IP: 186.251.148.216 from main_pool (did cnett_pppoe cli 74:EA:3A:D1:FD:17 port 69822 user cjunior) Fri Jan 27 14:41:38 2012 : Info: Released IP 186.251.148.216 (did cnett_pppoe cli 74:EA:3A:D1:FD:17 user cjunior) Fri Jan 27 14:45:47 2012 : Auth: Login OK: [taise] (from client LJS.AUTH.02 port 69530 cli 00:02:72:89:34:C5) Fri Jan 27 14:45:47 2012 : Info: Allocated IP: 186.251.150.130 from main_pool (did cnett_pppoe cli 00:02:72:89:34:C5 port 69530 user taise) Fri Jan 27 15:18:01 2012 : Auth: Login OK: [cjunior] (from client LJS.AUTH.02 port 69668 cli 74:EA:3A:D1:FD:17) Fri Jan 27 15:18:01 2012 : Info: Allocated IP: 186.251.150.226 from main_pool (did cnett_pppoe cli 74:EA:3A:D1:FD:17 port 69668 user cjunior) Fri Jan 27 12:19:14 2012 : Info: Allocated IP: 186.251.150.136 from main_pool (did cnett_pppoe cli 00:02:72:89:34:C5 port 69799 user taise) Fri Jan 27 23:22:04 2012 : Info: Released IP 186.251.150.130 (did cnett_pppoe cli 00:02:72:89:34:C5 user taise) Mon Jan 30 08:19:05 2012 : Info: Released IP 186.251.150.5 (did cnett_pppoe cli 00:02:72:89:34:C5 user taise) Mon Jan 30 08:20:23 2012 : Auth: Login OK: [taise] (from client LJS.AUTH.02 port 69525 cli 00:02:72:89:34:C5) Mon Jan 30 08:20:23 2012 : Info: Allocated IP: 186.251.151.65 from main_pool (did cnett_pppoe cli 00:02:72:89:34:C5 port 69525 user taise) Mon Jan 30 08:23:54 2012 : Info: Released IP 186.251.151.65 (did cnett_pppoe cli 00:02:72:89:34:C5 user taise) Mon Jan 30 08:24:05 2012 : Auth: Login OK: [taise] (from client LJS.AUTH.01 port 350112 cli 00:02:72:89:34:C5) Mon Jan 30 08:24:05 2012 : Info: Allocated IP: 186.251.150.118 from main_pool (did cnett_pppoe cli 00:02:72:89:34:C5 port 350112 user taise) This is really strange. Bellow I am showing my PostgreSQL radippool table and there is just the taise record (ok, I know, it could not have both). http://www.cnett.com.br/nata/imagens/Capturar1.JPG Looking for problems I also checked the usage of CPU and RAM on PostgreSQL box and MySQL box but there is nothing I could use. For those who ask I change the pool_key because I was having duplicated pool_key from my NAS (Auth01 and Auth02) so I just made a change where the name of the server is showing. The problem with the duplicate IPs is older than the change so the pool_key is discarded. http://www.cnett.com.br/nata/imagens/cpu_usage_postgres-mysql.JPG Is it possible to someone help me finding a solution? -- Descrição: Descrição: 111027-nata_at_cnett
