Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Problem exporting to Nagios (Cosme Corr?a)
----------------------------------------------------------------------
Message: 1
Date: Mon, 06 Oct 2014 12:37:10 -0300
From: Cosme Corr?a <[email protected]>
Subject: [Netdot-users] Problem exporting to Nagios
To: Netdot-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi,
I am testing Export -> Configurations -> Nagios
With this error message:
config_tasks.html produced the following error:
DBD::Pg::db selectall_arrayref failed: ERROR: syntax error at or near ","
LINE 11: LEFT OUTER JOIN (bgppeering, entity peer) ON d.id=...
^ [for Statement "
SELECT d.id, d.snmp_managed, d.community, d.snmp_target,
d.host_device,
d.monitoring_template, d.down_from, d.down_until,
entity.name, entity.aliases,
site.name, site.number, site.aliases, contactlist.id,
i.id, i.number, i.name, i.description,
i.admin_status, i.monitored, i.contactlist,
ip.id, ip.address, ip.version, ip.parent,
ip.monitored, rr.name, zone.name,
service.id, service.name, ipservice.monitored,
ipservice.contactlist,
bgppeering.bgppeeraddr, bgppeering.contactlist,
peer.asnumber, peer.asname
FROM rr, zone, device d
LEFT OUTER JOIN (bgppeering, entity peer) ON
d.id=bgppeering.device
AND bgppeering.entity=peer.id
AND bgppeering.monitored=1
LEFT OUTER JOIN devicecontacts ON d.id=devicecontacts.device
LEFT OUTER JOIN contactlist ON
contactlist.id=devicecontacts.contactlist
LEFT OUTER JOIN entity ON d.used_by=entity.id
LEFT OUTER JOIN site ON d.site=site.id,
interface i
LEFT OUTER JOIN ipblock ip ON ip.interface=i.id
LEFT OUTER JOIN ipservice ON ipservice.ip=ip.id
LEFT OUTER JOIN service ON ipservice.service=service.id
WHERE d.monitored='1'
AND i.device=d.id
AND d.name=rr.id
AND rr.zone=zone.id
"] at /usr/local/netdot/lib/Netdot/Exporter.pm line 85.
Stack:
[/usr/local/netdot/lib/Netdot/Exporter.pm:85]
[/usr/local/netdot/lib/Netdot/Exporter/Nagios.pm:167]
[/usr/local/netdot/htdocs/export/config_tasks.html:144]
[/usr/local/netdot/htdocs/export/autohandler:64]
[/usr/share/perl5/HTML/Mason/Request.pm:936]
[/usr/local/netdot/htdocs/masondata/obj/991023240/export/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
Does it make any sense?
TIA,
--
Cosme Faria Corr?a
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 71, Issue 1
*******************************************
