(RADIATOR) SessionDatabase SQL date problems and solution

[Hugh Irvine]

Hello Alexander -

You can use Identifiers in your hooks:

.....

# define one or more AuthBy clauses
# outside of any Realm or Handler

<AuthBy SQL>
	Identifier MyUsefulTag
	.....
</AuthBy>

.....

Then your hook code can find the AuthBy using the Identifier and use  
all of the normal functionality provided.

Have a look at "goodies/hooks.txt".

regards

Hugh


On 23 Jan 2008, at 23:09, Hartmaier Alexander wrote:

> Hi!
>
> I just discovered why I got ‘ORA-01861: literal does not match  
> format string’ errors for my Oracle session db.
> I use the ConnectionHook to alter the session NLS_DATE_FORMAT but  
> didn’t do this for the SessionDatabase because the docs don’t  
> mention it as a valid configuration option.
> While looking for a solution I found out that the SessSQL module is  
> a subclass of SqlDb so ConnectionHook works!
>
> Please add this info to the docs and maybe rethink the whole db  
> connection configuration.
> It would be great to be able to specify db connections and use them  
> by identifier.
>
> With best regards
> Alexander Hartmaier
>
> T-Systems Austria GesmbH
> Rennweg 97-99
> A-1030 Vienna
>
> phone: +43-(0)57057-4320
> mobile: +43-(0)676-8642-4320
>



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?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
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.