Re: Cacti + PostgreSQL Graphing

Found it ... spine (the new poller for cacti) doesnt' seem to report
errors very well ... switched to cmd.php and it turns out that, low and
behold, it can't find psql since /usr/local/bin isn't part of the path ...
fixed that in check_postgres.pl and all works well now ...



On Wed, 3 Mar 2010, Marc G. Fournier wrote:

>
> Greg (or anyone out there) ... have you had any experience with using
> check_postgres.pl --action=dbstats with Cacti?  I'm getting, in my cacti.log,
> a result of:
>
> SPINE: Poller[0] Host[124] DS[2619] SCRIPT: /usr/local/bin/check_postgres.pl
> --action=dbstats --host=192.0.2.23 --dbuser=monitor --dbpass=monitor
> --dbname=test, output: U
>
> The specific problem bing the 'output: U', which should look something like:
>
> output: backends:1 commits:97645 rollbacks:5 read:177034 hit:6872718
> idxscan:0 idxtupread:0 idxtupfetch:0 idxblksread:2199 idxblkshit:3 seqscan:3
> seqtupread:1000110 ret:24845129 fetch:2956289 ins:2201738 upd:3999 del:312
> dbname:test
>
> Google seems to have a bunch of stuff talking about 'output: U', but dating
> back to '06 and older ... the command runs fine (and fast) from the command
> line, so not a timeout ...
>
> So, anyone using dbstats with the newest version of Cacti, and have it
> working?
>
> On Mon, 1 Mar 2010, Marc G. Fournier wrote:
>
>>
>> Greg, before I start hacking away at it, do you have any examples of using
>> check_postgres_dbstats with cacti?  rather not recreate teh wheel is
>> someone has already done it ...
>>
>> thx ...
>>
>> On Sat, 27 Feb 2010, Greg Smith wrote:
>>
>>> Marc G. Fournier wrote:
>>>> We are mainly a nagios / cacti environment, and I came across...
>>>
>>> Why start with Cacti then?  There's way more Nagios integration available;
>>> the little check_pgsql that comes with it (I think it's still there), and
>>> the whole list at
>>> http://exchange.nagios.org/directory/Plugins/Databases/PostgresQL
>>>
>>> I'd think that starting with http://bucardo.org/wiki/Check_postgres for
>>> example would put you way ahead of anything that's available for Cacti.
>>>
>>> --
>>> Greg Smith  2ndQuadrant US  Baltimore, MD
>>> PostgreSQL Training, Services and Support
>>> greg@2ndQuadrant.com   www.2ndQuadrant.us
>>>
>>>
>>
>> ----
>> Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
>> scrappy@hub.org                                     http://www.hub.org
>>
>> Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy@hub.org
>>
>
> ----
> Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
> scrappy@hub.org                                     http://www.hub.org
>
> Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy@hub.org
>

----
Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
scrappy@hub.org                                     http://www.hub.org

Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy@hub.org