Sorry, I reinstalled all again and still the same problem. What i should do? Unlink sql? Thanks. -------- Mensaje original -------- De: A.L.M.Buxey@lboro.ac.uk Fecha: 22/11/2015 21:23 (GMT+01:00) Para: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Asunto: Re: FreeRadius 3.0.4 Hi,
including configuration file /etc/raddb/sites-enabled/inner-tunnel /etc/raddb/mods-config/sql/main/mysql/queries.conf[145]: Reference "${group_attribute}" not found Errors reading or parsing /etc/raddb/radiusd.conf
file read at wrong time
First time I modified some parameters on radiusd.conf, and run ln -s ../mods-available/sql ./, and configure sql parametres.
yes, dont do that. SQL is , like LDAP, now a module that understands if it can be run. if you are doing any linking at all it would be to link mods-available/sql to mods-enabled/sql ${group_attribute} is actually defined in the sql config file alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
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
On Nov 23, 2015, at 4:36 PM, Oscar Jofre <oscar@jofre.com> wrote:
I've been setting up mariadb database and radius: radiusd.conf max_requests = 250000 max_servers = 256
That is way too high, unless you're running 10M users.
database: max_connextions = 500 (because before 141 reach tha max value)
Fix your database so it isn't slow.
I keep testing 12.000 PPoE connection with 5 minutes timeout and 1 minute interim.
That's ridiculous. 1 minute interim updates are *way* too short. Set it for 5-10 minutes at least. And what "timeout" did you set? Session-Timeout? If that's at 5 minutes, it's also ridiculous. Set it to at least an hour.
To reach 144.000 new rows per hour.
Which is ridiculous. No wonder your database falls over. You have configured your server so that it will break. Don't do that. Use *reasonable* defaults.
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
You misconfigured something locally. That message doesn't appear in the default configuration.
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.
The default configuration writes accounting packets to the detail file.
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
Fix your configuration so it's not using ridiculously short timeouts.
During this test the radacct whas performing between 1.900 and 2.100 inserts per second
Because you set ridiculously short timeouts. Dont' do that.
Thanks for all the help I really appreciate it !
You've been told repeatedly to not set such short timeouts. You're still doing it. You've already been told *why* it's a problem. Instead of fixing the timeouts, you keep using the same short timeouts. And then ask (again) why there's a problem. We've told you why it's a problem. Stop asking questions, and follow instructions. Alan DeKok.
participants (4)
-
Alan DeKok -
Fajar A. Nugraha -
oscar -
Oscar Jofre