(RADIATOR) RADAUTHLOG SQL Error

[Jason Godsey]

---------- Original Message ----------------------------------
From: "Erich Zigler" <erich at superheronetworks.com>
Date:  Thu, 11 Mar 2004 15:58:04 -0600

><AuthLog SQL>
>        Identifier AuthLoggerSQL
>        DBSource        dbi:mysql:radiator
>        DBUsername      radiator
>        DBAuth          xxxxxxxxxxxxxx
>        Table           RADAUTHLOG
>
>        SuccessQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE,
>REASON,
> BADPASSWORD) values (%t, '%n', 1, %1, 1)

If I understand correctly, there isn't generally a reason on Success queries, maybe you could use (%t, '%n', 1, '', 1) if not null is enforced on REASON.

Beyond that, you have TYPE and BADPASSWORD simply 1?  How do you differentiate between them (GOOD/BAD Logins)?

>
>        FailureQuery insert into RADAUTHLOG (TIME_STAMP, USERNAME, TYPE,
>REASON,


> BADPASSWORD) values (%t, '%n', 0, %1, %3)
>
></AuthLog>
>
>FailureQuery works, however SuccessQuery doesn't.
>
>Any ideas?
>
>--
>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.
>

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