(RADIATOR) Using SQL statemens inside a PostAuthHook

[Hugh Irvine]

Hello Bogdan -

Yes you can use all of the Radiator internal routines on an existing 
connection to the database established in an AuthBy SQL clause. You 
just need to get a handle to the AuthBy clause (using find()) and use 
that handle for your calls.

You will find an example of how to get a handle to an AuthBy clause in 
the hook AllocateIPAddressFromProxy in the file goodies/hooks.txt. You 
will also find lots of examples of how to use the SQL calls in the code 
in the Radius directory.

regards

Hugh


On Tuesday, Feb 11, 2003, at 21:56 Australia/Melbourne, Bogdan TARU 
wrote:

>
> 	Hi everyone,
>
>  I have noticed the following phrase in the Radiator documentation:
>
>  6.16.14 PostAuthHook:
>   -skip- PostAuthHook can be an arbitrarily complicated Perl function,
> that might run external processes, consult databases, change the 
> contents
> of the current request or many other things. -skip-
>
>  My question is how can I consult a database from inside a 
> PostAuthHook? I
> am tring to use the same SQL database as the one configured in <AuthBy
> SQL>. So, do I have to connect once again using perl functions, or can 
> I
> somehow 're-use' the existing SQL connection to make some queries?
>
>  Could I get some examples of how to do this? I have already checked 
> the
> 'hooks.txt' file, but no database examples are there.
>
>  Thank you,
>  bogdan
>
>
> ----------------------------
> iCom Media AG
> Kirchweg 36
> Koln, 50858
> Germany
>
> Phone: +49-(0)221-485-689-16
> Fax  : +49-(0)221-485-689-20
> Mobile:+49-(0)173-906-46-01
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.