(RADIATOR) <Log SQL> only likes Unix Time

["Díaz Pérez, Jesús"]

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.