Many thank you's for the fix ! It is working properly now.
Tom
________________________________
From: Clayton Dukes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 29, 2008 12:48 PM
To: Stewart, Tom L.
Cc: [email protected];
[EMAIL PROTECTED]
Subject: Re: [Php-syslog-ng-support] (no subject)
Hey Tom,
Sorry it took me a while - had some meetings.
Here's how to fix it:
Edit html/includes/common_funcs.php
go to line 180, it should look like this:
$add = "('".$table."', 'HOST', '".$value."', '".$updateTime."'),";
Change it to this:
$add = "('".$table."', 'HOST', '".addslashes($value)."',
'".$updateTime."'),";
(you're adding the "addslashes" command so that it quotes that weird sql
injection)
I'll add this fix to the latest code for the next release also.
Thanks!
On Tue, Apr 29, 2008 at 9:35 AM, Stewart, Tom L.
<[EMAIL PROTECTED]> wrote:
I upgraded to 2.9.7 and reset everything. Logging is fine but at 6:00 am
this morning (same time as the last time) the Cache reload stopped
working. My guess is there is a bad message that is being sent. Here is
part of the message from the log file.
Do I need to go into the sql and find the offending message?
Starting to reload cache
2008-04-29 06:05:01
Loading the cache with data from: all_logs
Error in "function perform_query()" <br>Mysql_error: You have an error
in your S
QL syntax; check the manual that corresponds to your MySQL server
version for th
e right syntax to use near 'YYYYMMDD')', '2008-04-29
06:05:02'),('all_logs', 'HO
ST', 'TO_CHAR(new_prdt_end_d' at line 1<br>Query was: INSERT INTO
search_cache (
tablename, type, value, updatetime) VALUES ('all_logs', 'HOST',
'008-04-29 06:05:02'),('all_logs', 'HOST', 'll_logs', 'HOST', 'rom',
'2008-04-29 06:05:02'),('al 'HOST', 'nm', '2008-04-29
06:05:02'),('all_logs', 'HOST', '5:02'),('all_logs', 'HOST', '1Error',
'2008-04-29 06:05:02'),('all_logs', 'HOST', ':02'),('all_logs', 'HOST',
'T', '-04-29 06:05:02'),('all_logs', 'HOST', 'gs', 'HOST', ''2008-04-29
06:05:02'),('all_logs', 'HOST', 'cc01-1000.landsend.com', '2008-04-2
Thank you,
Tom
________________________________
From: Clayton Dukes [mailto:[EMAIL PROTECTED]
Sent: Monday, April 28, 2008 2:16 PM
To: Stewart, Tom L.
Cc: [email protected]
Subject: Re: [Php-syslog-ng-support] (no subject)
Looks like the actual message contains a "("
can you try quoting that string or removing the (?
On Mon, Apr 28, 2008 at 11:34 AM, Stewart, Tom L.
<[EMAIL PROTECTED]> wrote:
ALL,
I am getting the following error on the cache reload:
Query failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'YYYYMMDD')', '2008-04-28 10:30:23'),('all_logs', 'HOST',
'TO_CHAR(new_prdt_end_d' at line 1
The above looks like it is missing a ")" ?
I am using 2.9.5d on Redhat ES 5.1.
Any information would be appreciated.
Thank you,
Tom
------------------------------------------------------------------------
-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/j
avaone
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
--
______________________________________________________________
Clayton Dukes
______________________________________________________________
--
______________________________________________________________
Clayton Dukes
______________________________________________________________
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
