[Bug 798272] New: server:monitoring/munin: Bug: "FATAL: role "nobody" does not exist at /usr/lib/perl5/vendor_perl/5.16.0/Munin/Plugin/Pgsql.pm"
https://bugzilla.novell.com/show_bug.cgi?id=798272 https://bugzilla.novell.com/show_bug.cgi?id=798272#c0 Summary: server:monitoring/munin: Bug: "FATAL: role "nobody" does not exist at /usr/lib/perl5/vendor_perl/5.16.0/Munin/Plugin/Pgsql.p m" Classification: openSUSE Product: openSUSE.org Version: unspecified Platform: 64bit OS/Version: openSUSE 12.2 Status: NEW Severity: Normal Priority: P5 - None Component: 3rd party software AssignedTo: wolfgang@rosenauer.org ReportedBy: sault.don@gmail.com QAContact: opensuse-communityscreening@forge.provo.novell.com CC: nix@opensuse.org Found By: Community User Blocker: --- I can't get any of the postgresql plugins to work. I have created the symlinks into /etc/munin/plugins for the respective databases. They are not configured to use "_ALL". I have appended specific database names to the plugins that end in "_". The munin-node log is filled with these messages and no graphs are drawn (showing postgres db example/snippet): 2013/01/12-14:35:13 [29149] Error output from postgres_size_postgres: 2013/01/12-14:35:13 [29149] 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 377. 2013/01/12-14:35:13 [29149] Service 'postgres_size_postgres' exited with status 1/0. The log shows this for the system configured plugins (ones that don't end in "_"): 2013/01/12-14:35:16 [29149] Error output from postgres_xlog: 2013/01/12-14:35:16 [29149] 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 377. 2013/01/12-14:35:16 [29149] Service 'postgres_xlog' exited with status 1/0. The log is flooded with similar messages for each database. I checked those plugins and none say anything about setting up configurations in /etc/munin/plugin-conf.d/munin-node so I don't know if I need entries in there... The CONFIGURATION portions mention: Configuration is done through libpq environment variables, for example PGUSER, PGDATABASE, etc. For more information, see L<Munin::Plugin::Pgsql>. But I don't know where to set those env. variables... My Perl understanding is next to nil, but it looks kind of easy b/c I know python and bash. -- 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.
https://bugzilla.novell.com/show_bug.cgi?id=798272 https://bugzilla.novell.com/show_bug.cgi?id=798272#c Donovan Cameron <sault.don@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|3rd party software |Other Version|unspecified |Final AssignedTo|wolfgang@rosenauer.org |bnc-team-screening@forge.pr | |ovo.novell.com Product|openSUSE.org |openSUSE 12.2 Target Milestone|--- |Final QAContact|opensuse-communityscreening |qa-bugs@suse.de |@forge.provo.novell.com | -- 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.
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.
https://bugzilla.novell.com/show_bug.cgi?id=798272 https://bugzilla.novell.com/show_bug.cgi?id=798272#c2 Donovan Cameron <sault.don@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |CLOSED Resolution| |INVALID --- Comment #2 from Donovan Cameron <sault.don@gmail.com> 2013-01-13 01:42:59 UTC --- Looks like it was some formatting mistakes from me: Changed from... [postgres_*_postgres] user postgres env.PGUSER postgres env.PGHOST /tmp/.s.PGSQL.5432 env.PGPORT 5432 to... (eg, removed spaces) [postgres_*_postgres] env.PGUSER postgres env.PGHOST /tmp/.s.PGSQL.5432 And added a separate entry for "user postgres" [postgres_*] user postgres So, not a bug, just a me. Closing. -- 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.
participants (1)
-
bugzilla_noreply＠novell.com