Ports down in Nagios whereas Up on network switch end

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Ports down in Nagios whereas Up on network switch end

Post by ssax »

Okay, so the backend Nagios Core is showing properly, it looks like it's probably the DB that isn't being updated (nagios_servicestatus):

Please try this:

Code: Select all

yum reinstall php-pgsql
yum install php-pdo-dblib php-process 
systemctl restart nagios httpd crond
Then make sure that this command:

Code: Select all

tail -Fn0 /usr/local/nagiosxi/var/cmdsubsys.log
Is not showing these errors anymore:

Code: Select all

PHP Warning:  PHP Startup: Unable to load dynamic library 'pgsql' (tried: /usr/lib64/php/modules/pgsql (/usr/lib64/php/modules/pgsql: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/pgsql.so (/usr/pgsql-9.6/lib/libpq.so.5: undefined symbol: simple_string_list_member)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_pgsql' (tried: /usr/lib64/php/modules/pdo_pgsql (/usr/lib64/php/modules/pdo_pgsql: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/pdo_pgsql.so (/usr/pgsql-9.6/lib/libpq.so.5: undefined symbol: simple_string_list_member)) in Unknown on line 0
Send the output of this command as well:

Code: Select all

mysql -uroot -pnagiosxi nagios -e 'show create table nagios_hoststatus; show create table nagios_servicestatus;show create table nagios_objects; select count(*) from nagios_objects;'
QPUSER
Posts: 19
Joined: Mon Dec 13, 2021 4:49 am

Re: Ports down in Nagios whereas Up on network switch end

Post by QPUSER »

Hi ,

As suggested, I did reinstallation of pgsql and check the output of "tail -Fn0 /usr/local/nagiosxi/var/cmdsubsys.log" still getting

Code: Select all

PHP Warning:  PHP Startup: Unable to load dynamic library 'pgsql' (tried: /usr/lib64/php/modules/pgsql (/usr/lib64/php/modules/pgsql: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/pgsql.so (/usr/pgsql-9.6/lib/libpq.so.5: undefined symbol: simple_string_list_member)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_pgsql' (tried: /usr/lib64/php/modules/pdo_pgsql (/usr/lib64/php/modules/pdo_pgsql: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/pdo_pgsql.so (/usr/pgsql-9.6/lib/libpq.so.5: undefined symbol: simple_string_list_member)) in Unknown on line 0
Refer the attached file for requested output.
You do not have the required permissions to view the files attached to this post.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Ports down in Nagios whereas Up on network switch end

Post by ssax »

Please create a ticket for this and include a link back to this forum thread so we can get a remote session setup to debug further:

https://support.nagios.com/tickets/
QPUSER
Posts: 19
Joined: Mon Dec 13, 2021 4:49 am

Re: Ports down in Nagios whereas Up on network switch end

Post by QPUSER »

Hi SSAX,

As suggested, I have raised case 353059

Thanks
QP
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Ports down in Nagios whereas Up on network switch end

Post by ssax »

Locking thread, ticket received, we will continue support through the ticket. I have sent a response in the ticket.

Thank you!
Locked