RE: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-23 Thread freeradius
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? A:

Re: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-23 Thread Padam J Singh
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 for your reply! :-) So my basic question is: Does authorize_check_query complete fully before starting

Re: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-23 Thread Alan DeKok
freerad...@duxtel.com wrote: That is true for a select statement, but my authorize_check_query is /not/ a simple select. sigh Do you understand how databases work? the 'auth()' function is a plpgsql function that does a variety of lookups and other checks, and then depending on the

RE: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-23 Thread freeradius
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

RE: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-23 Thread freeradius
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

Re: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-23 Thread Alan DeKok
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

authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-22 Thread freeradius
Hi Folks! I have a working freeRadius with Postgresql database behind it, and looking at developing some additional functionality for a public access wireless service requested by one of our customers. The deal is that they want to allow limited access (by time/download etc) to first-time

Re: authorize_check_query - authorize_reply_query - synchronous or asynchronous?

2009-11-22 Thread Alan DeKok
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 at