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