https://bugzilla.novell.com/show_bug.cgi?id=798272 https://bugzilla.novell.com/show_bug.cgi?id=798272#c1 --- Comment #1 from Donovan Cameron <sault.don@gmail.com> 2013-01-13 01:30:23 UTC --- PGSQL Settings Info: pg_hba.conf entry for unix socket: TYPE DATABASE USER ADDRESS METHOD local all all trust Output of terminal commands to verify unix socket location: 1.) ps auxw | grep postgres 2.) lsof -p 28893 | grep unix postgres 28893 postgres 5u unix 0xffff8801eb05f4c0 0t0 6587797 /tmp/.s.PGSQL.5432 So I created entries for the pgsql users (5 of them) in plugin-conf.d/munin-node: [postgres_*_postgres] user postgres env.PGUSER postgres env.PGHOST /tmp/.s.PGSQL.5432 env.PGPORT 5432 For every other user I replaced env.PGUSER with their username and the [postgres_*_username] entry as well. Since the local unix socket on pgsql is set to trust, I don't think I need to specify a password. Not sure what else I'm missing. munin-node log output: 2013/01/12-18:25:16 [12997] Error output from postgres_connections_postgres: 2013/01/12-18:25:16 [12997] DBI connect('dbname=template1','',...) failed: FATAL: role "nobody" does not exist at /usr/lib/perl5/vendor_perl/5.16.0/Munin/Plugin/Pgsql.pm line 430. 2013/01/12-18:25:16 [12997] Service 'postgres_connections_postgres' exited with status 1/0. 2013/01/12-18:25:17 [12997] Error output from postgres_connections_postgres: 2013/01/12-18:25:17 [12997] DBI connect('dbname=template1','',...) failed: FATAL: role "nobody" does not exist at /usr/lib/perl5/vendor_perl/5.16.0/Munin/Plugin/Pgsql.pm line 430. 2013/01/12-18:25:17 [12997] Service 'postgres_connections_postgres' exited with status 1/0. 2013/01/12-18:25:17 [12997] Error output from postgres_querylength_postgres: 2013/01/12-18:25:17 [12997] DBI connect('dbname=template1','',...) failed: FATAL: role "nobody" does not exist at /usr/lib/perl5/vendor_perl/5.16.0/Munin/Plugin/Pgsql.pm line 430. 2013/01/12-18:25:17 [12997] Service 'postgres_querylength_postgres' exited with status 1/0. 2013/01/12-18:25:17 [12997] Error output from postgres_querylength_postgres: 2013/01/12-18:25:17 [12997] DBI connect('dbname=template1','',...) failed: FATAL: role "nobody" does not exist at /usr/lib/perl5/vendor_perl/5.16.0/Munin/Plugin/Pgsql.pm line 430. 2013/01/12-18:25:17 [12997] Service 'postgres_querylength_postgres' exited with status 1/0. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.