Hello,
I think this question got missed the first time around.
Reading back through the notes I noticed that Mysql 4.1 is not on the
req. list, only previous versions... I installed Mysql 4.1 without
noticing this.
So I have an error with the poller process that states the SQL syntax is
wrong, and I am wondering if I have to reinstall Mysql, or if I can
change the syntax by hand in the scripts somewhat easily. Is there
known incompatability issues with Mysql 4.1? If so, how soon till JFFNMS
becomes 4.1 complient. Let me know if I can help with this in any way.
I wonder if this is related to the apache.php error I posted ealier.
Here is the error: fro mthe poller process as I see it:
12:14:02 db_ping(mysql) Connection to DB Restored...
12:14:02 Query Failed - table_insert(events) - insert into events
(date,type,host,interface,state,username,info) VALUES ('2005-05-18
12:13:57','39','15','Port
80','valid','tcp_content_analisis','adecn.freqLimit('j 328', 0, 12);
adecn.f') - 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 'j 328', 0, 12);
adecn.f')' at line 112:14:02 : H 15 : I 87 : P 30 :
tcp_content_analisis(tcp_..ent): valid|adecn.freqLimit('j 328', 0, 12);
adecn.f -> alarm(39): Event Added: (time P:884.43 | 5221.48)
It looks off hand like a quote is missing around the
'adecn.freqLimit('j 328', 0, 12);
part...which I can fix with no problem if that is all...
Any help is much appreciated - Ove
--- Begin Message ---
Hello,
I have another question. Reading back through the notes I
noticed that Mysql 4.1 is not on the req. list, only previous
versions... I installed Mysql 4.1 without noticing this.
So I have an error with the poller process that states the SQL syntax is
wrong, and I am wondering if I have to reinstall Mysql, or if I can
change the syntax by hand in the scripts somewhat easily. Is there
known incompatability issues with Mysql 4.1? If so, how soon till JFFNMS
becomes 4.1 complient. Let me know if I can help with this in any way.
I wonder if this is related to the apache.php error I posted ealier.
Here is the error: fro mthe poller process as I see it:
12:14:02 db_ping(mysql) Connection to DB Restored...
12:14:02 Query Failed - table_insert(events) - insert into events
(date,type,host,interface,state,username,info) VALUES ('2005-05-18
12:13:57','39','15','Port
80','valid','tcp_content_analisis','adecn.freqLimit('j 328', 0, 12);
adecn.f') - 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 'j 328', 0, 12);
adecn.f')' at line 112:14:02 : H 15 : I 87 : P 30 :
tcp_content_analisis(tcp_..ent): valid|adecn.freqLimit('j 328', 0, 12);
adecn.f -> alarm(39): Event Added: (time P:884.43 | 5221.48)
It looks off hand like a quote is missing around the
'adecn.freqLimit('j 328', 0, 12);
part...which I can fix with no problem if that is all...
Any help is much appreciated - Ove
-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users
--- End Message ---
