(RADIATOR) <Log SQL> only likes Unix Time

[Dave Walters]

Hi,

I'm trying to get Radiator to log the current time in long format rather
than Unix Time by doing the following:

<Log SQL>
        Identifier LogDB1
        DBSource dbi:mysqlPP:radius
        DBUsername username
        DBAuth password
        Table RADLOG
        Trace 3
        LogQuery insert into %3 (TIME_STAMP, PRIORITY, MESSAGE) /
        values (%l, %0, %2)
</Log>

But when I restart Radiator I get the following error message:

server:# Mon Mar  3 16:13:07 2003: INFO: Access rejected for
user at realm.com: MaxSessions exceeded
DBD::mysqlPP::db do failed: You have an error in your SQL syntax near
'Mar  3 16:13:07 2003, 3, 'Access rejected for user at realm.com:
MaxSessions ex' at line 1 at
/usr/local/ActivePerl-5.6/lib/site_perl/5.6.1/Radius/SqlDb.pm line 219.
DBD::mysqlPP::db do failed: You have an error in your SQL syntax near
'Mar  3 16:13:07 2003, 3, 'Access rejected for user at realm.com:
MaxSessions ex' at line 1 at
/usr/local/ActivePerl-5.6/lib/site_perl/5.6.1/Radius/SqlDb.pm line 219.

If I substitute %l with %t it works fine, although it obviously logs
Unix Time and not long format.

The column TIME_STAMP in RADLOG is set as "Type" Varchar with length 50
so it shouldn't be a problem with the field being to small/incorrect
type.

Any help you can give me would be gratefully recived,

Thanks,

Dave Walters
Technical Manager
Luna Internet
Tel. 0845 345 0175
Fax. 01782 544 029
Mob. 07968 729 489
dave at lunainternet.net
www.luna.co.uk 

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