FreeRadius 3.0.4

Oscar Jofre oscar at jofre.com
Mon Nov 23 22:36:06 CET 2015


Fajar,

Got it ! Thanks a lot.
I just remove /etc/raddb and reinstall.
Just link to sql config and working.

Having FreeRadius 3.0.10 runing...

Can I ask a little more ?

I've been setting up mariadb database and radius:
radiusd.conf
	max_requests = 250000
	max_servers = 256
	min_spare_servers = 30
     	 max_spare_servers = 400

database:
	max_connextions = 500 (because before 141 reach tha max value)
	at this moment: max_used_connextions = 262	
	(other parameters according to the hardware ram and cpu)

I keep testing 12.000 PPoE connection with 5 minutes timeout and 1 minute interim. To reach 144.000 new rows per hour. 

Now on radius log I got:

1)
Every minute I got

Mon Nov 23 22:07:01 2015 : ERROR: (3057208) detail: ERROR: Couldn't open file /var/log/radius/radacct/88.17.150.241/detail-20151123:
Failed to open file /var/log/radius/radacct/88.17.150.241/detail-20151123: No such file or directory
Mon Nov 23 22:07:01 2015 : ERROR: (3057209) detail: ERROR: Couldn't open file /var/log/radius/radacct/88.13.76.4/detail-20151123:
Failed to open file /var/log/radius/radacct/88.13.76.4/detail-20151123: No such file or directory

I've changed privileges

find /var/log/radius -type d -exec chmod 755 {} \;
find /var/log/radius -type f -exec chmod 644 {} \;

But still the same.
The funny thing is that the detail file is growing, I mena there is updating info every second.

2)

I don’t understand how I have to handle this spares Info .. I've changed min_spare_servers = 30 and max_spare_servers = 400 but always this info on log:

Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Need 4 more connections to reach 226 spares
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Need 3 more connections to reach 226 spares
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Opening additional connection (2893), 1 of 23 pending slots used
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Need 2 more connections to reach 226 spares
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Opening additional connection (2894), 2 of 23 pending slots used
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Need 1 more connections to reach 226 spares
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Opening additional connection (2895), 3 of 23 pending slots used
Mon Nov 23 22:23:02 2015 : Info: rlm_sql (sql): Opening additional connection (2896), 4 of 23 pending slots used
Mon Nov 23 22:23:18 2015 : Info: rlm_sql (sql): Need 19 more connections to reach 226 spares
Mon Nov 23 22:23:18 2015 : Info: rlm_sql (sql): Opening additional connection (2897), 1 of 19 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Need 18 more connections to reach 226 spares
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2898), 1 of 18 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Need 17 more connections to reach 226 spares
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2899), 2 of 18 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2900), 1 of 16 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2901), 1 of 15 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2902), 1 of 14 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2903), 2 of 14 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2904), 2 of 13 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2905), 2 of 12 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2906), 1 of 10 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2907), 1 of 9 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2908), 1 of 8 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2909), 1 of 7 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2910), 1 of 6 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2911), 2 of 6 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2912), 3 of 6 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2913), 1 of 3 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2914), 2 of 3 pending slots used
Mon Nov 23 22:23:19 2015 : Info: rlm_sql (sql): Opening additional connection (2915), 3 of 3 pending slots used
Mon Nov 23 22:23:49 2015 : Info: rlm_sql (sql): Closing connection (2844), from 29 unused connections
Mon Nov 23 22:23:51 2015 : Info: rlm_sql (sql): Need 1 more connections to reach 226 spares
Mon Nov 23 22:23:51 2015 : Info: rlm_sql (sql): Opening additional connection (2916), 1 of 1 pending slots used


3) About Monitoring database server

iostat -d -x 2

Linux 3.10.0-229.14.1.el7.x86_64 (rad.sss.com)  23/11/15        _x86_64_        (4 CPU)

Device:         rrqm/s   wrqm/s     r/s     w/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await r_await w_await  svctm  %util
sda               2,47     0,25   36,81  160,65   904,12  1305,10    22,38     0,46    2,31    1,75    2,44   1,64  32,30
dm-0              0,00     0,00    0,01    0,00     0,04     0,00     8,00     0,00    0,66    0,66    0,00   0,53   0,00
dm-1              0,00     0,00   37,59  160,82   898,94  1305,01    22,22     0,46    2,33    1,82    2,45   1,63  32,33

Device:         rrqm/s   wrqm/s     r/s     w/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await r_await w_await  svctm  %util
sda               0,00     0,00   40,00  274,00   164,00  2363,00    16,10     0,67    2,12    0,95    2,29   1,94  60,95
dm-0              0,00     0,00    0,00    0,00     0,00     0,00     0,00     0,00    0,00    0,00    0,00   0,00   0,00
dm-1              0,00     0,00   40,00  274,00   164,00  2363,00    16,10     0,67    2,13    0,95    2,30   1,95  61,15

Device:         rrqm/s   wrqm/s     r/s     w/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await r_await w_await  svctm  %util
sda               0,00     0,00   30,50  232,50   122,00  1934,75    15,64     0,59    2,25    1,36    2,37   2,12  55,75
dm-0              0,00     0,00    0,00    0,00     0,00     0,00     0,00     0,00    0,00    0,00    0,00   0,00   0,00
dm-1              0,00     0,00   30,50  233,00   122,00  1936,75    15,63     0,59    2,25    1,36    2,36   2,12  55,80

Device:         rrqm/s   wrqm/s     r/s     w/s    rkB/s    wkB/s avgrq-sz avgqu-sz   await r_await w_await  svctm  %util
sda               0,00     0,00   34,00  276,00   136,00  2261,00    15,46     0,74    2,39    1,00    2,56   2,02  62,55
dm-0              0,00     0,00    0,00    0,00     0,00     0,00     0,00     0,00    0,00    0,00    0,00   0,00   0,00
dm-1              0,00     0,00   34,00  275,50   136,00  2259,00    15,48     0,74    2,39    1,00    2,56   2,02  62,60

During this test the radacct whas performing between 1.900 and 2.100 inserts per segond

select date_format(acctstarttime,"%Y-%m-%d-%H-%i"),count(*) from 
	radacct group by date_format(acctstarttime,"%Y-%m-%d-%H-%i") order by date_format(acctstarttime,"%Y-%m-%d-%H-%i") desc limit 0,120;    
  
	2015-11-23-22-29	2096
	2015-11-23-22-28	2296
	2015-11-23-22-27	2104
	2015-11-23-22-26	2023
	2015-11-23-22-25	1967
	2015-11-23-22-24	2015


Thanks for all the help I really appreciate it !

Oscar.

-----Mensaje original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+oscar=jofre.com at lists.freeradius.org] En nombre de Fajar A. Nugraha
Enviado el: lunes, 23 de noviembre de 2015 3:48
Para: FreeRadius users mailing list
Asunto: Re: FreeRadius 3.0.4

On Mon, Nov 23, 2015 at 3:43 AM, oscar <oscar at jofre.com> wrote:

> Sorry,
> I reinstalled all again and still the same problem.
> What i should do? Unlink sql?
> Thanks.
>
>

The clean way would be to start clean. Backup your /etc/raddb, uninstall, remove /etc/raddb, install. Then configure your system again (which includes adding symlinks of relevant modules from raddb/mods-available to
raddb/mods-enabled)

Or if you're lazy, you can try first to undo your manual config (including the symlink you created manually), and then add the correct one.

--
Fajar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html




More information about the Freeradius-Users mailing list