Hi Jesús, Worked perfectly! Many thanks :)
Regards, Dave -----Original Message----- From: Díaz Pérez, Jesús [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 17:11 To: 'Dave Walters'; '[EMAIL PROTECTED]' 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:[EMAIL PROTECTED] Enviado el: lunes, 03 de marzo de 2003 17:28 Para: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]: 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 [EMAIL PROTECTED]: 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 [EMAIL PROTECTED]: 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 [EMAIL PROTECTED] www.luna.co.uk === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.