Customization of authorize_reply_query

2012-10-02 Thread Václav Pernica
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 load is 0.5 seconds but during the peak

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: Re: Customization of RADIUS reply

2012-09-18 Thread Václav Pernica
Hello Alan Thanks for your hint. Read the file you edited: raddb/dictionary It works now, I just changed the number to lower value. And you are right, it is written there (even by capitals..) One more question. Is there some easy way, how to use different SQL queries

Re: Re: Customization of RADIUS reply

2012-09-18 Thread Václav Pernica
. I tried to use unlang in dialup.conf or radiusd.conf, but then it fails even with simple conditions. How to do it with Realm or where to use the condition for comparison? Thanks Václav Pernica - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Customization of RADIUS reply

2012-09-17 Thread Václav Pernica
Hello I’m configuring the FreeRADIUS together with the Oracle DB. I need to get the user authenticated and in the reply provide the parameter mailbox_fullname from the DB. The Oracle DB has for my purpose only one view which contains the following columns.