Zabbix + pg_monz shows service not runningIs Zabbix the right tool for me?Zabbix does not send emailsMonitor RESTful API Web Service with ZabbixZabbix aggregate checks shows wrong statisticsZabbix - service restartExecute custom monit script upon failure to restart the processZabbix cannot connect to a PostgreSQL databaseAdding items from the monitored node?zabbix 3.0 + pg_monz 2.0 + PostgreSQL streaming replicationZabbix vfs.fs.size gives wrong result when filesystem is not mounted
Fluently Validation of Objects
Could Sauron have read Tom Bombadil's mind if Tom had held the Palantir?
Why won't the ground take my seed?
Does a centaur PC also count as being mounted?
Do sudoku answers always have a single minimal clue set?
Does “comme on était à New York” mean “since” or “as though”?
I'm reinstalling my Linux desktop, how do I keep SSH logins working?
Reverse of diffraction
Who gets an Apparition licence?
Why transcripts instead of degree certificates?
What is the olden name for sideburns?
Why isn’t the tax system continuous rather than bracketed?
Java Optional working of orElse is not as if else
Who is Johanna in this Joan Baez song - The Winds of the Old Days
Why are 120V general receptacle circuits limited to 20A?
Why did this meteor appear cyan?
For people who believe in Jesus and not the devil, what happened in the desert?
Can the passive "être + verbe" sometimes mean the past?
Zombie diet, why humans?
Golf the smallest circle!
What is the line crossing the Pacific Ocean that is shown on maps?
How was film developed in the late 1920s?
What does Mildred mean by this line in Three Billboards Outside Ebbing, Missouri?
Does the UK have a written constitution?
Zabbix + pg_monz shows service not running
Is Zabbix the right tool for me?Zabbix does not send emailsMonitor RESTful API Web Service with ZabbixZabbix aggregate checks shows wrong statisticsZabbix - service restartExecute custom monit script upon failure to restart the processZabbix cannot connect to a PostgreSQL databaseAdding items from the monitored node?zabbix 3.0 + pg_monz 2.0 + PostgreSQL streaming replicationZabbix vfs.fs.size gives wrong result when filesystem is not mounted
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am trying to setup monitoring for my PostgreSQL installation with zabbix ang pg_monz.
I've followed this standard installation guide(http://pg-monz.github.io/pg_monz/index-en.html#install). Everything seems working ok, besides PostgreSQL service running item, script that comes with pg_monz returns 0, however DB is running and other parameters are monitored.
What could be the issue here?
pgsql_simple.sh script
#!/bin/bash
PGSHELL_CONFDIR="$1"
# Load the psql connection option parameters.
source $PGSHELL_CONFDIR/pgsql_funcs.conf
psql -t -A -h $PGHOST -p $PGPORT -U $PGROLE $DBNAME -c "select 1;" 2>/dev/null
if [ $? -ne 0 ]; then
echo 0
fi
zabbix userparameter:
UserParameter=psql.running[*],"$1"/pgsql_simple.sh "$2"
monitoring postgresql zabbix
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
add a comment |
I am trying to setup monitoring for my PostgreSQL installation with zabbix ang pg_monz.
I've followed this standard installation guide(http://pg-monz.github.io/pg_monz/index-en.html#install). Everything seems working ok, besides PostgreSQL service running item, script that comes with pg_monz returns 0, however DB is running and other parameters are monitored.
What could be the issue here?
pgsql_simple.sh script
#!/bin/bash
PGSHELL_CONFDIR="$1"
# Load the psql connection option parameters.
source $PGSHELL_CONFDIR/pgsql_funcs.conf
psql -t -A -h $PGHOST -p $PGPORT -U $PGROLE $DBNAME -c "select 1;" 2>/dev/null
if [ $? -ne 0 ]; then
echo 0
fi
zabbix userparameter:
UserParameter=psql.running[*],"$1"/pgsql_simple.sh "$2"
monitoring postgresql zabbix
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
Remove "2>/dev/null" temporary and execute script as zabbix user. You should to see in the output what is your problem (credentials,permissions,...)
– Jan Garaj
Sep 24 '15 at 7:43
Permissions are ok, all scripts belong to zabbix user. Also there is .pgpass in zabbix home directory. psql works well from terminal, but from script it doesn't.
– erizo
Sep 24 '15 at 7:46
add a comment |
I am trying to setup monitoring for my PostgreSQL installation with zabbix ang pg_monz.
I've followed this standard installation guide(http://pg-monz.github.io/pg_monz/index-en.html#install). Everything seems working ok, besides PostgreSQL service running item, script that comes with pg_monz returns 0, however DB is running and other parameters are monitored.
What could be the issue here?
pgsql_simple.sh script
#!/bin/bash
PGSHELL_CONFDIR="$1"
# Load the psql connection option parameters.
source $PGSHELL_CONFDIR/pgsql_funcs.conf
psql -t -A -h $PGHOST -p $PGPORT -U $PGROLE $DBNAME -c "select 1;" 2>/dev/null
if [ $? -ne 0 ]; then
echo 0
fi
zabbix userparameter:
UserParameter=psql.running[*],"$1"/pgsql_simple.sh "$2"
monitoring postgresql zabbix
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
I am trying to setup monitoring for my PostgreSQL installation with zabbix ang pg_monz.
I've followed this standard installation guide(http://pg-monz.github.io/pg_monz/index-en.html#install). Everything seems working ok, besides PostgreSQL service running item, script that comes with pg_monz returns 0, however DB is running and other parameters are monitored.
What could be the issue here?
pgsql_simple.sh script
#!/bin/bash
PGSHELL_CONFDIR="$1"
# Load the psql connection option parameters.
source $PGSHELL_CONFDIR/pgsql_funcs.conf
psql -t -A -h $PGHOST -p $PGPORT -U $PGROLE $DBNAME -c "select 1;" 2>/dev/null
if [ $? -ne 0 ]; then
echo 0
fi
zabbix userparameter:
UserParameter=psql.running[*],"$1"/pgsql_simple.sh "$2"
monitoring postgresql zabbix
monitoring postgresql zabbix
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
asked Sep 24 '15 at 7:21
erizoerizo
321 silver badge6 bronze badges
321 silver badge6 bronze badges
Remove "2>/dev/null" temporary and execute script as zabbix user. You should to see in the output what is your problem (credentials,permissions,...)
– Jan Garaj
Sep 24 '15 at 7:43
Permissions are ok, all scripts belong to zabbix user. Also there is .pgpass in zabbix home directory. psql works well from terminal, but from script it doesn't.
– erizo
Sep 24 '15 at 7:46
add a comment |
Remove "2>/dev/null" temporary and execute script as zabbix user. You should to see in the output what is your problem (credentials,permissions,...)
– Jan Garaj
Sep 24 '15 at 7:43
Permissions are ok, all scripts belong to zabbix user. Also there is .pgpass in zabbix home directory. psql works well from terminal, but from script it doesn't.
– erizo
Sep 24 '15 at 7:46
Remove "2>/dev/null" temporary and execute script as zabbix user. You should to see in the output what is your problem (credentials,permissions,...)
– Jan Garaj
Sep 24 '15 at 7:43
Remove "2>/dev/null" temporary and execute script as zabbix user. You should to see in the output what is your problem (credentials,permissions,...)
– Jan Garaj
Sep 24 '15 at 7:43
Permissions are ok, all scripts belong to zabbix user. Also there is .pgpass in zabbix home directory. psql works well from terminal, but from script it doesn't.
– erizo
Sep 24 '15 at 7:46
Permissions are ok, all scripts belong to zabbix user. Also there is .pgpass in zabbix home directory. psql works well from terminal, but from script it doesn't.
– erizo
Sep 24 '15 at 7:46
add a comment |
1 Answer
1
active
oldest
votes
Wasn't expecting that, but problem was in the pg_monz script.
Database name in configuration was declared as PGDATABASE but in the script that executes query $DBNAME was used to retrieve that name. Fixed that and monitoring started working.
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f724478%2fzabbix-pg-monz-shows-service-not-running%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Wasn't expecting that, but problem was in the pg_monz script.
Database name in configuration was declared as PGDATABASE but in the script that executes query $DBNAME was used to retrieve that name. Fixed that and monitoring started working.
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
add a comment |
Wasn't expecting that, but problem was in the pg_monz script.
Database name in configuration was declared as PGDATABASE but in the script that executes query $DBNAME was used to retrieve that name. Fixed that and monitoring started working.
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
add a comment |
Wasn't expecting that, but problem was in the pg_monz script.
Database name in configuration was declared as PGDATABASE but in the script that executes query $DBNAME was used to retrieve that name. Fixed that and monitoring started working.
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
Wasn't expecting that, but problem was in the pg_monz script.
Database name in configuration was declared as PGDATABASE but in the script that executes query $DBNAME was used to retrieve that name. Fixed that and monitoring started working.
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
answered Sep 24 '15 at 9:05
erizoerizo
321 silver badge6 bronze badges
321 silver badge6 bronze badges
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f724478%2fzabbix-pg-monz-shows-service-not-running%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Remove "2>/dev/null" temporary and execute script as zabbix user. You should to see in the output what is your problem (credentials,permissions,...)
– Jan Garaj
Sep 24 '15 at 7:43
Permissions are ok, all scripts belong to zabbix user. Also there is .pgpass in zabbix home directory. psql works well from terminal, but from script it doesn't.
– erizo
Sep 24 '15 at 7:46