You don't have the postgresql client libs installed. <br><br><div class="gmail_quote">On Tue, Oct 5, 2010 at 12:53 AM, Rachid Alami <span dir="ltr"><<a href="mailto:r_alami23@hotmail.com">r_alami23@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<font style="font-size: 8pt;" size="1">Hello Stewart,</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">Thanks for your help but I am getting the following error:</font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">Here is what I did:</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">I copied "check_pgsql" plug-in in the following path and gave the appropriate rights:</font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1">[ralamim@server1 libexec]$ pwd</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">/usr/local/nagios/libexec</font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1">[ralamim@server1 libexec]$ ls -l check_pgsql</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">-rwxr-xr-x 1 nagios nagios 62774 Aug 17 05:15 check_pgsql</font> <font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">I also enabled the following in command.cfg</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1">[ralamim@server1 etc]$ grep check_pgsql command.cfg</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">command[check_pgsql]=/usr/local/groundwork/nagios/libexec/check_pgsql -H $HOSTADDRESS$ </font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">and defined the following command in check_commands.cfg</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1">define command {</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1"> command_name check_pgsql</font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1"> command_line $USER1$/check_pgsql -H $HOSTADDRESS$</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">}</font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">but when I run the check I get the following error:</font><font style="font-size: 8pt;" size="1"><br>
</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">[ralamim@server1 libexec]$ ./check_pgsql -H server23</font><font style="font-size: 8pt;" size="1"><br></font><font style="font-size: 8pt;" size="1">./check_pgsql: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory</font><font style="font-size: 8pt;" size="1"><br>
<br>Please advise,<br><br>Thanks.<br></font><div class="im"><br><br><br>> To: <a href="mailto:nagiosplug-help@lists.sourceforge.net" target="_blank">nagiosplug-help@lists.sourceforge.net</a><br></div>> From: <a href="mailto:sstdennis@zaxia.com" target="_blank">sstdennis@zaxia.com</a><br>
> Date: Fri, 1 Oct 2010 16:29:08 +0000<br>> Subject: Re: [Nagiosplug-help] [SPAM]??Re: check_pgsql installation<div><div></div><div class="h5"><br>> <br>> The process for any plug-in is to:<br>> - locate the plug-in on the Nagios server (copying it there if necessary)<br>
> - run it with -h parameter and review its specific parameters and their use <br>> - if it accepts a host parameter then it can likely run from the Nagios server, so run it by hand until you have the service to be monitored tweeked to respond + the parameters set up right. <br>
> - if there is no host parameter, install the Nagios Plugin software on the server to be monitored, potentially copy the plug-in there too, and do the plug-in run/test from the command line until it works <br>> - ensure that the command to run the plug-in is configured on the Nagios server<br>
> - define the service check, on the Nagios server, for the server to be monitored. <br>> - if the check could not run on the Nagios server, then it must be run via a remote service call. Therefore, select and configure either NRPE or SSH (or some other method) to invoked the command from the Nagios server. Test it from the command of the Nagios server. Then use the check_nrpe or check_ssh plugin to define the service check<br>
> - reload the Nagios config or restart the Nagios deamon<br>> - review the check results<br>> - tweek/test the check under various circumstances, stopping the cycle when it works "right"<br>> <br>
> HTH,<br>> Stewart<br>> -----Original Message-----<br>> From: Rachid Alami Marrouni <<a href="mailto:r_alami23@hotmail.com" target="_blank">r_alami23@hotmail.com</a>><br>> Date: Fri, 1 Oct 2010 11:15:19 <br>
> To: <<a href="mailto:nagiosplug-help@lists.sourceforge.net" target="_blank">nagiosplug-help@lists.sourceforge.net</a>><br>> Reply-To: Nagios Plugin Help List <<a href="mailto:nagiosplug-help@lists.sourceforge.net" target="_blank">nagiosplug-help@lists.sourceforge.net</a>><br>
> Subject: [SPAM]??Re: [Nagiosplug-help] check_pgsql installation<br>> <br>> ------------------------------------------------------------------------------<br>> Start uncovering the many advantages of virtual appliances<br>
> and start using them to simplify application deployment and<br>> accelerate your shift to cloud computing.<br>> <a href="http://p.sf.net/sfu/novell-sfdev2dev" target="_blank">http://p.sf.net/sfu/novell-sfdev2dev</a><br>
> ------------------------------------------------------------------------------<br>> Start uncovering the many advantages of virtual appliances<br>> and start using them to simplify application deployment and<br>
> accelerate your shift to cloud computing.<br>> <a href="http://p.sf.net/sfu/novell-sfdev2dev" target="_blank">http://p.sf.net/sfu/novell-sfdev2dev</a><br>> _______________________________________________<br>> Nagiosplug-help mailing list<br>
> <a href="mailto:Nagiosplug-help@lists.sourceforge.net" target="_blank">Nagiosplug-help@lists.sourceforge.net</a><br>> <a href="https://lists.sourceforge.net/lists/listinfo/nagiosplug-help" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagiosplug-help</a><br>
> ::: Please include plugins version (-v) and OS when reporting any issue. <br>> ::: Messages without supporting info will risk being sent to /dev/null<br> </div></div></div>
<br>------------------------------------------------------------------------------<br>
Virtualization is moving to the mainstream and overtaking non-virtualized<br>
environment for deploying applications. Does it make network security<br>
easier or more difficult to achieve? Read this whitepaper to separate the<br>
two and get a better understanding.<br>
<a href="http://p.sf.net/sfu/hp-phase2-d2d" target="_blank">http://p.sf.net/sfu/hp-phase2-d2d</a><br>_______________________________________________<br>
Nagiosplug-help mailing list<br>
<a href="mailto:Nagiosplug-help@lists.sourceforge.net">Nagiosplug-help@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagiosplug-help" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagiosplug-help</a><br>
::: Please include plugins version (-v) and OS when reporting any issue.<br>
::: Messages without supporting info will risk being sent to /dev/null<br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Best Regards,<br>Stephen<br>