Hi all,
I think I found. In the line 92, consolidate/syslog.php:
$query_router='
SELECT hosts.id FROM hosts
WHERE hosts.ip = "'.$syslog_record['host'].'" OR
hosts.name="'.$syslog_record['host'].'"'.
(isset($host_ip)?' OR hosts.ip ="'.$host_ip.'"':'');
is the error.
Paste this select in SQL some postgresql (pgadmin3 or phpPgAdmin) and see
the error that is " instead of '
Added is an "echo" done to check and see the result and see below:
srv01:/opt/jffnms/engine# php -q consolidate.php
16:42:37 Consolidator Starting...
16:42:37 SYSLOG Events to Process: 149
16:42:37 S 12799:= 2010-05-26 15:47:31.885604 192.168.200.254 CRON[3617]:
pam_unix(cron:session): session closed for user jffnms
16:42:37 S 12799:= Matched ^([^[]+)(?:\[\d+\])?:\s+(.+)$
SELECT hosts.id FROM hosts
WHERE hosts.ip = "192.168.200.254" OR
hosts.name="192.168.200.254"pg_ping(): Unknown database type.srv01:
Thanks,
Marco Tulio
------------------------------------------------------------------------------
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users
