Re: Re: Customization of authorize_reply_query
Phil Mayers:
Just set a null query e.g.
select null where 1=0
Thanks a lot! This was the hint I need.. I used: select null from table where 1=0 because it required FROM. One more question. I set the number of sql connections to make to server to 5 (default value). I noticed that if all connections are currently in use, the authentication fails: Tue Oct 2 16:07:10 2012 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Is there some parameter that would cause to wait until next next connection will be available instead of failing authentication? Thanks Vaclav
Václav Pernica wrote:
One more question. I set the number of sql connections to make to server to 5 (default value). I noticed that if all connections are currently in use, the authentication fails:
Tue Oct 2 16:07:10 2012 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Is there some parameter that would cause to wait until next next connection will be available instead of failing authentication?
No. Either configure the server to open more connections, or configure the database to return in a timely manner. The whole *point* of limiting resources is so that FreeRADIUS doesn't go down when your database goes down. That won't be changed. Alan DeKok.
On 2 Oct 2012, at 09:31, Alan DeKok <aland@DEPLOYINGRADIUS.COM> wrote:
Václav Pernica wrote:
One more question. I set the number of sql connections to make to server to 5 (default value). I noticed that if all connections are currently in use, the authentication fails:
Tue Oct 2 16:07:10 2012 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Is there some parameter that would cause to wait until next next connection will be available instead of failing authentication?
Uh, why would you want to do that? Just reduce the number of threads in the thread pool to match the number of connections you have. -Arran
participants (3)
-
Alan DeKok -
Arran Cudbard-Bell -
Václav Pernica