Recurrent errors in Apache http log

[vmesquita]

There are some errors being showing up in the nagios error log almost with every entry, making the log huge:

Code: Select all

[Sun Apr 24 03:28:29 2016] [error] [client 172.27.15.48] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432?\ncould not connect to server: Connection refused\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682, referer: http://nagios.selic.bc/nagiosxi/includes/components/nocscreen/noc.php
[Sun Apr 24 03:28:29 2016] [error] [client 172.27.15.48] PHP Notice:  Undefined variable: result in /usr/local/nagiosxi/html/includes/db.inc.php on line 249, referer: http://nagios.selic.bc/nagiosxi/includes/components/nocscreen/noc.php
[Sun Apr 24 03:28:29 2016] [error] [client 172.27.15.178] PHP Warning:  pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432?\ncould not connect to server: Connection refused\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432? in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-postgres64.inc.php on line 682, referer: http://nagios.selic.bc/nagiosxi/includes/components/xicore/status.php?show=servicedetail&host=libracont.selic.bc&service=mainframe_metering_15&dest=auto

Any idea of what is causing this and how it can be fixed?

[Box293]

Is the service running?

Code: Select all

service postgresql status

[vmesquita]

Yes:

Code: Select all

$ service postgresql status
postmaster (pid  2203) is running...

[rkennedy]

Can you PM over a profile so that we can take a look at your environment? Additionally, what is the full output of netstat -an?

[vmesquita]

I attached the output of the command to this message. But I didn't understand the PM over profile, can you clarify?

[ssax]

You can download your profile by going to Admin > System Config > System Profile and click the Download Profile button in the top right corner. Then just PM it to one of use by clicking on one of our names and then click the "Send a private message" link, make sure to click "Add the file" after you select your profile.

[vmesquita]

Ok, I sent to you both!

[ssax]

I'm not seeing anything from your profile that stands out.

Please PM this file as well:

Code: Select all

/var/lib/pgsql/data/pg_hba.conf

[rkennedy]

Additionally, did you previously upgrade from an earlier version? Which version?

[vmesquita]

We upgraded from 5.2.5 to 5.2.7 recently, but this issue has been happening for a while.