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
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
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
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
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
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
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
Hi Alan,
Thanks heaps for your reply! :-)
So my basic question is: Does authorize_check_query complete fully
before
starting the call to authorize_reply_query?
To re-phrase your question:
Q: What work does the database perform after it's returned an answer
from a SELECT
the call to authorize_reply_query?
To re-phrase your question:
Q: What work does the database perform after it's returned an answer
from a SELECT?
A: Nothing.
That is true for a select statement, but my authorize_check_query is /not/ a
simple select
of a
database.
Yes, very true - so it is conveivably possible that authorize_reply_query is
completed before my authorize_check_query has updated or inserted records.
I have *no idea* how you concluded that when I said the exact opposite.
I'm sure that there is a definitive answer
G'day!
sigh Do you understand how databases work?
Heheh - uh, yes: I understand how a database works!
Does the pgsql function do things AFTER it returns?
duh Of course not!
I have *no idea* how you concluded that when I said the exact opposite.
H, I read your last reply again
To: FreeRadius users mailing list
Subject: Re: authorize_check_query - authorize_reply_query - synchronous or
asynchronous?
Hi Mike,
I use a similar setup (PG Functions for auth/acct) and I never had an issue
with the query ordering.
Padam
freerad...@duxtel.com wrote:
Hi Alan,
Thanks heaps
freerad...@duxtel.com wrote:
sigh Do you understand how databases work?
Heheh - uh, yes: I understand how a database works!
Then there is no issue.
Perhaps I am missing some significant detail that is obvious to you...(?) I
am coming to this discussion with the assumption that the
Points all support
MAC-Auth when the wireless client connects to the network).
I'm expecting that if I can create a new user in the authorize_check_query
and have it return auth-success, then the authorize_reply_query will return
the relevant data from what is created by the former I hope
freerad...@duxtel.com wrote:
So my basic question is: Does authorize_check_query complete fully before
starting the call to authorize_reply_query?
To re-phrase your question:
Q: What work does the database perform after it's returned an answer
from a SELECT?
A: Nothing.
If they happen
Hello list, I'm using freeradius and have some doubts abot these steps.
authorize_check_query = store_check_query
'%{Stripped-User-Name:-%{User-Name}},
authorize_reply_query = store_check_query
'%{Stripped-User-Name:-%{User-Name}},
At this moment I'm using both authorize (check
Hi
The query 'authorize_reply_query' doesn't execute
when authoriztion failed, but i need to send reply
with error code to nas.
What should i do to make it working ?
regards,
Nik
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
, and NOT think about
configure_failover.
The query 'authorize_reply_query' doesn't execute
when authoriztion failed, but i need to send reply
with error code to nas.
What should i do to make it working ?
=nsinit=
-
List info/subscribe/unsubscribe? See http://www.freeradius.org
18 matches
Mail list logo