More troubleshooting documentation

[rjuju]

Add the tips provided by @tabdoelhafiezkhan in OPMDG/opm-core#36

[wenJanus]

postgres@opm=# SELECT grant_dispatcher('wh_nagios', 'user1'); this is which user？

[wenJanus]

db_user=YOUR_USER
db_password=YOUR_PASS which user？

[rjuju]

They're both referring to the same postgres role which import data in the warehouse. I'll add some comments to make it clearer, thanks for the report!

[rjuju]

@wenJanus done in 7b5ffa3, the doc is up to date. Thanks!

[wenJanus]

@rjuju Hi, when use morbo or hypnotoad but something wrong with it. should need other config or package? Thanks!

Arctic66:/usr/local/src/opm2.4/opm-core-REL_2_4/ui # /usr/local/perl/bin/morbo script/opm
do "script/opm" failed, '.' is no longer in @inc; did you mean do "./script/opm"? at (eval 148) line 2.
Couldn't load application from file "script/opm": No such file or directory at (eval 148) line 3.

Arctic66:/usr/local/src/opm2.4/opm-core-REL_2_4/ui # /usr/local/perl/bin/hypnotoad -f script/opm
Couldn't load application from file "/usr/local/src/opm2.4/opm-core-REL_2_4/ui/script/opm": Can't locate DBI.pm in @inc (you may need to install the DBI module) (@inc contains: /usr/local/src/opm2.4/opm-core-REL_2_4/ui/script/../lib /usr/local/perl/bin/../lib /usr/local/perl/lib/site_perl/5.26.0/x86_64-linux /usr/local/perl/lib/site_perl/5.26.0 /usr/local/perl/lib/5.26.0/x86_64-linux /usr/local/perl/lib/5.26.0) at /usr/local/src/opm2.4/opm-core-REL_2_4/ui/script/../lib/Helpers/Database.pm line 11.
BEGIN failed--compilation aborted at /usr/local/src/opm2.4/opm-core-REL_2_4/ui/script/../lib/Helpers/Database.pm line 11.

[rjuju]

Apparently, with morbo you need to specify a path (for instance ./script/opm are advised). According to logs from hypnotoad, you're missing DBI, and probably DBD::Pg perl modules. Please refer to http://opm.readthedocs.io/opm-core/Installation.html#user-interface for the UI requirements.

[wenJanus]

@rjuju Thank you very much! After install DBI and DBD::Pg, the problem was solved!

How the check_pgactivity work in the monitor project. Can you share some solution for me?

[rjuju]

Sorry for late replky @wenJanus.

I'm not sure I get your question. check_pgactivity is a probe for nagios dedicated for postgres. You must have a working nagios (or any fork available) to perform the needed checks on your servers. Once the checks are performed and perfdata are generated, you should see the UI getting updated automatically, provided you configured all the other steps documented (configuring nagios for perfdata output, setting up nagios_dispatcher and calling the wh_nagios.dispatch_record() function).