(RADIATOR) Date Format in <AuthBy SQL>

[Hugh Irvine]

Hello Jason -

On Wednesday 25 July 2001 18:20, Separovic, Jason wrote:
> I've tried many different combinations but I can't get the date into the
> database in the following
>
> <AuthBy SQL>
> ......
>    FailureQuery insert into auth(date,user) values('%Y-%m-%d %H:%M:%S',
> '%U')
> </....
>
>
> I need the date to be in the format YYYY-MM-DD HH:MM:SS
>
> I tried entering the date into a char() field and nothing was entered.

I suspect you mean 

<AuthLog SQL>

?

If so, please send me a copy of the configuration file (no secrets), together 
with a trace 4 debug from Radiator showing what is happening.

thanks

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.