Re: Customization of authorize_reply_query

2012-10-02 Thread Phil Mayers
On 02/10/12 13:35, Václav Pernica wrote: Hello I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query? The reason is that that DB contains millions of records and each query take some some time. Depending on DB

Re: Customization of authorize_reply_query

2012-10-02 Thread Alan DeKok
Václav Pernica wrote: I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query? The reason is that that DB contains millions of records and each query take some some time. Depending on DB load is 0.5 seconds

Re: Customization of authorize_reply_query

2012-10-02 Thread Fajar A. Nugraha
On Tue, Oct 2, 2012 at 7:35 PM, Václav Pernica v...@email.cz wrote: Hello I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query? The reason is that that DB contains millions of records and each query take

Re: Re: Customization of authorize_reply_query

2012-10-02 Thread Václav Pernica
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

Re: Customization of authorize_reply_query

2012-10-02 Thread Alan DeKok
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

Re: Customization of authorize_reply_query

2012-10-02 Thread Arran Cudbard-Bell
On 2 Oct 2012, at 09:31, Alan DeKok al...@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