[Os-sim-devel] Problems at Alarm_Console from last update

[sebastian s. <seb...@gm...>]

Hi
 I'm running ossim on a debian box. From the last update at the
alarm_console i get an error:

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 '+0 AS timestamp, inet_ntoa(src_ip), inet_nto

I get ride of it changing a line at classes/Alarm.inc (at least dont
get the error and see some output), this is a diff output:

--- Alarm.inc.orig      2005-09-21 04:18:07.000000000 +0000
+++ Alarm.inc   2005-09-21 04:18:20.000000000 +0000
@@ -228,7 +228,7 @@
         /* number of alerts per page */
         $nalerts =3D $sup - $inf;

-        $query =3D "SELECT *, timestamp+0 AS timestamp,
+        $query =3D "SELECT *, timestamp + 0 AS timestamp,
                   inet_ntoa(src_ip), inet_ntoa(dst_ip)
             FROM alarm $where $order LIMIT $nalerts OFFSET $inf";


Sorry my poor english. Thanks in advance and continue with your great work.

Sebastian Serrano