Freeradius log - Opening additional connection (rlm_sql)

user3105

10/8/22, 3:44 PM

forgive my lack of knowledge but I am new to this topic and there are a few concepts that elude me. When I view the radius logs in my server I get the following information:

root@pabx:~# tail -f /var/log/freeradius/radius.log
Tue Jun  8 17:21:27 2021 : Info: rlm_sql (sql): Opening additional connection (49), 1 of 32 pending slots used
Tue Jun  8 17:21:27 2021 : Info: Need 2 more connections to reach min connections (3)
Tue Jun  8 17:21:27 2021 : Info: rlm_sql (sql): Opening additional connection (50), 1 of 31 pending slots used
Tue Jun  8 17:25:49 2021 : Info: rlm_sql (sql): Closing connection (49): Hit idle_timeout, was idle for 262 seconds
Tue Jun  8 17:25:49 2021 : Info: rlm_sql (sql): Closing connection (50): Hit idle_timeout, was idle for 262 seconds
Tue Jun  8 17:25:49 2021 : Info: rlm_sql (sql): Opening additional connection (51), 1 of 32 pending slots used
Tue Jun  8 17:25:49 2021 : Info: Need 2 more connections to reach min connections (3)
Tue Jun  8 17:25:49 2021 : Info: rlm_sql (sql): Opening additional connection (52), 1 of 31 pending slots used
Tue Jun  8 17:25:50 2021 : Info: Need 1 more connections to reach min connections (3)
Tue Jun  8 17:25:50 2021 : Info: rlm_sql (sql): Opening additional connection (53), 1 of 30 pending slots used

I don't know in which part of the configuration this is modified and what it is necessary for. In my case I only need a maximum of 4 connections to the database. If someone could advise me about the best way to configure the rlm_sql module I would appreciate it.

I would also like to know if this poses any risk to the correct functioning of radius, hence my insistence on configuring it in the most efficient way.

Thanks

0 + 0

mysql

radius

freeradius

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Freeradius log - Opening additional connection (rlm_sql)

TH: บันทึก Freeradius - กำลังเปิดการเชื่อมต่อเพิ่มเติม (rlm_sql)

RO: Jurnal Freeradius - Deschiderea conexiunii suplimentare (rlm_sql)

RU: Журнал Freeradius — Открытие дополнительного соединения (rlm_sql)

VI: Nhật ký Freeradius - Mở kết nối bổ sung (rlm_sql)

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.