search

OPMDG / opm-doc

Global documentation of the project
http://opm.readthedocs.io/
Other
13 stars 10 forks source link

More troubleshooting documentation #8

Open rjuju opened 8 years ago

rjuju commented 8 years ago

Add the tips provided by @tabdoelhafiezkhan in https://github.com/OPMDG/opm-core/issues/36

wenJanus commented 6 years ago

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

wenJanus commented 6 years ago

db_user=YOUR_USER db_password=YOUR_PASS which user？

rjuju commented 6 years ago

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 commented 6 years ago

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

wenJanus commented 6 years ago

@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 commented 6 years ago

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 commented 6 years ago

@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 commented 6 years ago

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).