(RADIATOR) PLSQL procedure parsing problem

[Hugh Irvine]

Hello Jan -

Thanks for the clarification.

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

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

regards

Hugh


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.
>
>

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?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
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.