(RADIATOR) <Log SQL> only likes Unix Time

[Dave Walters]

Hi Jesús,

Worked perfectly! Many thanks :)

Regards,

Dave

-----Original Message-----
From: Díaz Pérez, Jesús [mailto:jesus.diaz at ono.es] 
Sent: 03 March 2003 17:11
To: 'Dave Walters'; 'radiator at open.com.au'
Subject: RE: (RADIATOR) <Log SQL> only likes Unix Time


Hi Dave,

try to quote the time var: "%l"

regards

Jesús M Díaz


-----Mensaje original-----
De: Dave Walters [mailto:dave at LunaInternet.net] 
Enviado el: lunes, 03 de marzo de 2003 17:28
Para: radiator at open.com.au
Asunto: (RADIATOR) <Log SQL> only likes Unix Time


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.


Mail Disclaimer

La Informacion incluida en el presente correo electronico es SECRETO
PROFESIONAL Y CONFIDENCIAL, siendo para el uso exclusivo del
destinatario arriba mencionado. Si usted lee este mensaje y no es el
destinatario señalado, el empleado o el agente responsable de entregar
el mensaje al destinatario, o ha recibido esta comunicacion por error,
le informamos que esta totalmente prohibida cualquier divulgacion,
distribucion o reproduccion de esta comunicacion, y le rogamos que nos
lo notifique inmediatamente y nos devuelva el mensaje original a la
direccion arriba mencionada. Gracias.

The information contained in this e-mail is LEGALLY PRIVILEDGED AND
CONFIDENTIAL and is intended only for the use of the addressee named
above. If the reader of this message is not the intended recipient or
the employee or agent responsible for delivering the message to the
intended recipient, or you have received this communication in error,
please be aware that any dissemination, distribution or duplication of
this communication is strictly prohibited, and please notify us
immediately and return the original message to us at the address above.
Thank you.




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