[Reconnoiter-users] help using postgres plug-in
Michal Taborsky - Netretail Holding
michal.taborsky at nrholding.com
Thu Nov 4 13:01:19 EDT 2010
could be an authentication/connection type related problem. Let us see
your pg_hba.conf file, should be in /var/lib/pgsql/data/pg_hba.conf.
Also, is your Postgres running on the default port? Maybe send your
postgresql.conf too, if it is not too secret.
Dne 4.11.2010 17:41, Mark Wong napsal(a):
> Hello everyone,
> I was having trouble figuring out how to get the postgres plug-in to
> work based off the web page example. I believe it has something to do
> with noitd or noit.conf. I'm working with postgres 8.4.4 (on ubuntu
> 10.04) and the urskek release.
> I started with a noit config for postgres similar to what is on the web
> After some suggestions from Robert Treat I got to:
> <postgres period="10000" module="postgres">
> <dsn>host=127.0.0.1 dbname=reconnoiter user=noit password=noit</dsn>
> <check uuid="1b2c1290-f001-46b3-a184-0cc553bcff1d"
> name="reconnoiter" target="127.0.0.1">
> <sql>select datname, pg_database_size(datname) as size,
> xact_commit, xact_rollback from pg_stat_database</sql>
> Basically I'm trying to set up noit to check the database that
> reconnoiter is set up in, everything running on the same system (a vm).
> When I start noit:
> # sbin/noitd -c /home/mwong/local/etc/noit.conf -D -d
> Found 15 /noit/logs//log stanzas
> Found 1 outlets for log 'error'
> Module selfcheck successfully loaded.
> ping_icmp: send buffer set to 1998848
> Module ping_icmp successfully loaded.
> Module snmp successfully loaded.
> Module ssh2 successfully loaded.
> Loading lua module: varnish
> Module varnish successfully loaded.
> Loading lua module: http
> Module http successfully loaded.
> Loading lua module: resmon
> Module resmon successfully loaded.
> Loading lua module: smtp
> Module smtp successfully loaded.
> Module postgres successfully loaded.
> Compiling filterset 'default'
> Prepending deny into default
> check uuid: '1b2c1290-f001-46b3-a184-0cc553bcff1d' has no timeout
> C 1288749940.479 1b2c1290-f001-46b3-a184-0cc553bcff1d
> 127.0.0.1 postgres reconnoiter
> loaded uuid: 1b2c1290-f001-46b3-a184-0cc553bcff1d
> Found 4 /noit/listeners//listener stanzas
> noit_listener(/tmp/noit, 0, 1, 5, noit_console, (nil))
> noit_listener(*, 32322, 1, 5, noit_console, (nil))
> noit_listener(*, 32323, 1, 5, noit_console, (nil))
> noit_listener(*, 43191, 1, 5, control_dispatch, (nil))
> 127.0.0.1`reconnoiter<- [timeout]
> 127.0.0.1`reconnoiter -> [unavailable:bad]
> My database log says:
> 2010-11-02 19:05:41 PDT : [1-1] user=[unknown],db=[unknown],host=
> LOG: connection received: host=127.0.0.1 port=39725
> My observation suggests the username and dbname is mishandled between
> the noit.conf and making the database connection from noit, assuming
> that my noit.conf is correct.
> I verified I can connect with psql from the same system:
> $ psql -h 127.0.0.1 -U noit -W -d reconnoiter
> Password for user noit:
> psql (8.4.4)
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> Type "help" for help.
> Anything else I can provide that will help?
> Reconnoiter-users mailing list
> Reconnoiter-users at lists.omniti.com
chief systems architect
Netretail Holding, B.V.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Reconnoiter-users