(RADIATOR) SessionDatabase SQL date problems and solution
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
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:
> 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