Logging to Oracle - Quoting issue
Hi! I have already written a mail to info@balabit.hu today, but I am impatient. Forgive me please! We have an issue when logging to Oracle. Obviously, Oracle requires a single quote to be quoted by a single quote. I have found this [1] article about it. Since it's 2005 now, I'd like to know whether this one is fixed in the latest version or not. I have 1.6.2 running in production now on a few machines. I didn't find anything in the Changelog about this, unfortunately. Could someone give me a hint? Thanks IA André [1] https://lists.balabit.hu/pipermail/syslog-ng/2003-November/ 005510.html ___ ___ ___ ___ \C/ \O/ \L/ \T/ Andre Bonhote t: +41 (0)44 5 600 600 V V V V Platform Infrastructure f: +41 (0)44 5 630 501 we make business Senior IP Engineer straight.forward COLT Telecom e: andre@colt.net
Just found another one: &'s don't get quoted at all. It looks like sqlplus will wait for a user entry (variable substitution). Example: 'mc2.fra.qmail-send: [ID 748625 mail.info] 1115721654.581305 starting delivery 6475704: msg 932402 to remote M&E@xxxxx.com' ... Enter value for e: In the meantime, I have found macros.c where all that gets defined. Unfortunately I don't know much C. Any hints? TIA André On May 10, 2005, at 12:29, André Bonhôte wrote:
Hi!
I have already written a mail to info@balabit.hu today, but I am impatient. Forgive me please!
We have an issue when logging to Oracle. Obviously, Oracle requires a single quote to be quoted by a single quote. I have found this [1] article about it. Since it's 2005 now, I'd like to know whether this one is fixed in the latest version or not. I have 1.6.2 running in production now on a few machines. I didn't find anything in the Changelog about this, unfortunately.
Could someone give me a hint?
Thanks IA
André
[1] https://lists.balabit.hu/pipermail/syslog-ng/2003-November/ 005510.html ___ ___ ___ ___ \C/ \O/ \L/ \T/ Andre Bonhote t: +41 (0)44 5 600 600 V V V V Platform Infrastructure f: +41 (0)44 5 630 501 we make business Senior IP Engineer straight.forward COLT Telecom e: andre@colt.net
_______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
___ ___ ___ ___ \C/ \O/ \L/ \T/ Andre Bonhote t: +41 (0)44 5 600 600 V V V V Platform Infrastructure f: +41 (0)44 5 630 501 we make business Senior IP Engineer straight.forward COLT Telecom e: andre@colt.net
On Tue, 2005-05-10 at 12:55 +0200, André Bonhôte wrote:
Just found another one: &'s don't get quoted at all. It looks like sqlplus will wait for a user entry (variable substitution).
Example:
'mc2.fra.qmail-send: [ID 748625 mail.info] 1115721654.581305 starting delivery 6475704: msg 932402 to remote M&E@xxxxx.com'
... Enter value for e:
In the meantime, I have found macros.c where all that gets defined. Unfortunately I don't know much C.
No, this has not yet been solved. You have to modify macros.c:append_string() function, add support for Oracle style escaping. I'm sorry but I currently have no time to do that myself. -- Bazsi
On May 10, 2005, at 13:05, Balazs Scheidler wrote:
In the meantime, I have found macros.c where all that gets defined. Unfortunately I don't know much C.
No, this has not yet been solved. You have to modify macros.c:append_string() function, add support for Oracle style escaping. I'm sorry but I currently have no time to do that myself.
Ok, I will try. The one with & can be solved using SET DEFINE OFF in sqlplus Cheers André ___ ___ ___ ___ \C/ \O/ \L/ \T/ Andre Bonhote t: +41 (0)44 5 600 600 V V V V Platform Infrastructure f: +41 (0)44 5 630 501 we make business Senior IP Engineer straight.forward COLT Telecom e: andre@colt.net
participants (2)
-
André Bonhôte
-
Balazs Scheidler