Page 2 of 2

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

Posted: Tue Feb 22, 2022 10:47 am
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;'

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

Posted: Wed Feb 23, 2022 1:39 am
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.

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

Posted: Wed Feb 23, 2022 2:44 pm
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/

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

Posted: Thu Feb 24, 2022 2:01 am
by QPUSER
Hi SSAX,

As suggested, I have raised case 353059

Thanks
QP

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

Posted: Thu Feb 24, 2022 5:46 pm
by ssax
Locking thread, ticket received, we will continue support through the ticket. I have sent a response in the ticket.

Thank you!