(RADIATOR) PLSQL procedure parsing problem

[Pavel A Crasotin]

Hello Jan, Hugh and all.

I've just looked at the code of AuthSQL.pm and AuthPLSQL.pm.
So the answer to the Jan's question is No, IMHO.
There is no way to bind variables at this time, statement should be
parsed every time before it's called.

Hugh, as far as I understood Jan the suggestion is to prepare a
statement not every time it's called but once right after reconnect to
DB. Then Radiator can use prepared statement binding necessary
variables.

This feature will cause rewriting of large piece of Radiator code. So
Jan dont wait it too early. Am I right, Hugh? :)

I'll try to implement this feature in the next version of AuthPLSQL
module for the access request first.




HI> Hello Jan -

HI> Thanks for the clarification.

HI> BTW - you do not need to use the AuthBy PLSQL clause for what you are
HI> doing - all that is happening is the normal processing of AuthBy SQL is
HI> being used to process the AcctSQLStatement.

HI> I have copied this mail to Pavel who is the author of the AuthBy PLSQL
HI> clause to see if he has any suggestions.

HI> regards

HI> Hugh


HI> On 15 Nov 2004, at 20:38, Jan Stanik wrote:

>> Hugh Irvine wrote:
>>> Hello Jan -
>>> I'm sorry but I don't understand your question - could you please 
>>> give me a bit more detail?
>>> regards
>>
>> Of course. I use sessiondb.acct stored procedure to write radiator 
>> account logs into the oracle
>> database. When I look into the oracle statistics I see that this 
>> procedure is parsed every time it is called.
>> This slows the database response down.
>> Oracle hint is to use bind variables when the procedure is called but
>> I don't know how to do it
>> in Radiator.
>>
>>
>>> Hugh
>>> On 15 Nov 2004, at 01:20, Jan Stanik wrote:
>>>>
>>>> Hi,
>>>>
>>>>     I have problem with high parsing when radiator calls acct stored
>>>> procedure from Oracle db. Can anyone help me to adapt the calling of
>>>> this procedure not be parsed every time?
>>>>
>>>> here is a part of config file:
>>>>
>>>> <AuthBy PLSQL>
>>>>         Identifier SessionDB
>>>>         NoDefault
>>>>         NoDefault
>>>>         DBSource        dbi:Oracle:%{GlobalVar:OraName1}
>>>>         DBUsername      %{GlobalVar:OraUser1}
>>>>         DBAuth          %{GlobalVar:OraPass1}
>>>>         FailureBackoffTime 180
>>>>
>>>>         AcctSQLStatement begin \
>>>>                          sessiondb.acct('%u', '%N',
>>>> 0%{NAS-Port},\                     '%{Acct-Session-Id}', 
>>>> '%{Framed-IP-Address}',\                
>>>> '%{NAS-Port-Type}','%{Service-Type}',\
>>>>                     
>>>> 0%{Acct-Session-Time},'%{Acct-Status-Type}',\
>>>>             '%{Class}', 0%{Acct-Input-Octets},\
>>>>         0%{Acct-Output-Octets},0%{Acct-Input-Gigawords},\  
>>>> 0%{Acct-Output-Gigawords}); \
>>>>                          end;
>>>> </AuthBy>
>>>>
>>>> -- 
>>>> 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.
>>>>
>>>>
>>> NB:
>>> Have you read the reference manual ("doc/ref.html")?
>>> Have you searched the mailing list archive 
>>> (www.open.com.au/archives/radiator)?
>>> Have you had a quick look on Google (www.google.com)?
>>> Have you included a copy of your configuration file (no secrets),
>>> together with a trace 4 debug showing what is happening?
>>
>> --
>> 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.
>>
>>

HI> NB:

HI> Have you read the reference manual ("doc/ref.html")?
HI> Have you searched the mailing list archive 
HI> (www.open.com.au/archives/radiator)?
HI> Have you had a quick look on Google (www.google.com)?
HI> Have you included a copy of your configuration file (no secrets),
HI> together with a trace 4 debug showing what is happening?



--
With respect,
Pavel A Crasotin
OJSC SeverTransCom
Tel: +7 (0852) 58-41-03, 58-01-01
Fax: +7 (0852) 58-01-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.