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@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@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