(RADIATOR) SessionDatabase SQL date problems and solution

Hugh Irvine hugh at open.com.au
Wed Jan 23 16:06:08 CST 2008

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


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



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


Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
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:

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.

More information about the radiator mailing list