Nagvis Error - Nagios XI

[ABBsupervision]

Hello,

we encountered a problem while accessing nagvis. ( (see attached - Nagvis_ErrorPHP.PNG )

Error: PHP Error

Code: Select all

Error: (0) Undefined property: CorePDOHandler::$data
URL: /nagvis/server/core/ajax_handler.php?mod=Overview&act=getObjectStates&i[]=map-Portail&_ajaxid=1623332224
File: /usr/local/nagvis/share/server/core/classes/CorePDOHandler.php
Line: 306
#0 /usr/local/nagvis/share/server/core/classes/CorePDOHandler.php(306): nagvisExceptionErrorHandler(8, 'Undefined prope...', '/usr/local/nagv...', 306, Array)
#1 /usr/local/nagvis/share/server/core/classes/CorePDOHandler.php(332): CorePDOHandler->prep('SELECT\n ...')
#2 /usr/local/nagvis/share/server/core/classes/GlobalBackendPDO.php(615): CorePDOHandler->query('SELECT\n ...', Array)
#3 /usr/local/nagvis/share/server/core/classes/CoreBackendMgmt.php(474): GlobalBackendPDO->getServiceState(Array, 2, Array)
#4 /usr/local/nagvis/share/server/core/classes/CoreBackendMgmt.php(169): CoreBackendMgmt->fetchStateCounts('nagiosxidmz', 'serviceState', 2, Array)
#5 /usr/local/nagvis/share/server/core/classes/CoreModOverview.php(171): CoreBackendMgmt->execute()
#6 /usr/local/nagvis/share/server/core/classes/CoreModOverview.php(64): CoreModOverview->parseMapsJson(false, Array)
#7 /usr/local/nagvis/share/server/core/functions/index.php(120): CoreModOverview->handleAction()
#8 /usr/local/nagvis/share/server/core/ajax_handler.php(59): require('/usr/local/nagv...')
#9 {main}

I also inform you that when creating a new role on nagvis we receive another error message (see attached - Nagvis_Error Role.PNG )
Error : Syntax Error

Code: Select all

Invalid JSON response
Time: 1623332336
URL: /nagvis/server/core/ajax_handler.php?mod=RoleMgmt&act=view&_ajaxid=1623332336
Response:
Créer un Rôle
{"type":"error","message":"Error: (0) count(): Parameter must be an array or an object that implements Countable
URL: \/nagvis\/server\/core\/ajax_handler.php?mod=RoleMgmt&act=view&_ajaxid=1623332336
\nFile: \/usr\/local\/nagvis\/share\/server\/core\/classes\/ViewManageRoles.php
\nLine: 38
\n
#0 \/usr\/local\/nagvis\/share\/server\/core\/classes\/ViewManageRoles.php(38): nagvisExceptionErrorHandler(2, 'count(): Parame...', '\/usr\/local\/nagv...', 38, Array)
\n#1 \/usr\/local\/nagvis\/share\/server\/core\/classes\/ViewManageRoles.php(300): ViewManageRoles->addForm()
\n#2 \/usr\/local\/nagvis\/share\/server\/core\/classes\/CoreModRoleMgmt.php(44): ViewManageRoles->parse()
\n#3 \/usr\/local\/nagvis\/share\/server\/core\/functions\/index.php(120): CoreModRoleMgmt->handleAction()
\n#4 \/usr\/local\/nagvis\/share\/server\/core\/ajax_handler.php(59): require('\/usr\/local\/nagv...')
\n#5 {main}<\/code>Output:
<h2>Créer un Rôle<\/h2><\/pre>","title":"Error: PHP Error"}

Please find attached the error message.

Could you help us?

Best Regards,
SOUHAIB

[benjaminsmith]

HI Souhaib,

Thank you for posting the log output. Looking over that error message (Error: (0) Undefined property: CorePDOHandler::$data) this is related to a database connection issue. When did you start noticing the error, and have you made any system changes? Is the rest of the system working as expected?

Is the database local or offloaded?

Also, please send us the system profile and we'll review the logs. Thanks, Benjamin

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button

[ABBsupervision]

Hello,

Mysql database is local and repaired every night by running your script : /usr/local/nagiosxi/scripts/repair_databases.sh

We made the last change on system 45 days ago : optimzation of PHP, PHP-FPM.

This optimization resolved the monitoring engine problem

Nagvis was working fine, but sometimes we get slow loading, recently we got more problems : slow pages and errors ( as shown on previous screenshots).

Please find attached the requested profile.

Best Regards,
SOUHAIB

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

[benjaminsmith]

Hi ABBsupervision,

If you having a problem with the database tables crashing frequently, I would recommend converting the tables to innodb.

Database Storage Engine and High CPU usage in Nagios XI

Be sure to take a full backup or snapshot before making any changes. Also, be sure to enable regular scheduled backups to mitigate against any database failures that would require a restore.

Backing Up And Restoring Your Nagios XI System

Additionally, please increase the max connections on the database (if needed). I believe the slowness may be the result of a busy or slow responding database.0

Nagios XI - MySQL/MariaDB - Max Connection

Lastly, please post the output to the following command to check the table sizes. It may be necessary to adjust the command if you changed the default credentials.

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

Thank you,
Benjamin

[ABBsupervision]

Hello benjaminsmith,

We don't have any blockage with databases, and also we have set up a repair script for this database tables every night.

I inform you that we have increase the max connections on the database :

Code: Select all

[root@DCPNAGIOSXIN1 libexec]# mysql -uroot -pnagiosxi -e "show variables like 'max_connections';"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 1000  |
+-----------------+-------+

Please find below the output of command to check the table sizes :

Code: Select all

[root@DCPNAGIOSXIN1 libexec]# echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------------------------------+------------+
| Table                                      | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements                    |       0.00 |
| nagios_commands                            |       0.02 |
| nagios_commenthistory                      |       0.77 |
| nagios_comments                            |       0.00 |
| nagios_configfiles                         |       0.01 |
| nagios_configfilevariables                 |       0.01 |
| nagios_contact_addresses                   |       0.00 |
| nagios_contact_notificationcommands        |       0.01 |
| nagios_contactgroup_members                |       0.00 |
| nagios_contactgroups                       |       0.00 |
| nagios_contactnotificationmethods          |      45.24 |
| nagios_contactnotifications                |      31.61 |
| nagios_contacts                            |       0.00 |
| nagios_contactstatus                       |       0.00 |
| nagios_customvariables                     |       0.12 |
| nagios_customvariablestatus                |       0.10 |
| nagios_dbversion                           |       0.00 |
| nagios_downtimehistory                     |       0.00 |
| nagios_eventhandlers                       |       0.01 |
| nagios_externalcommands                    |       0.01 |
| nagios_flappinghistory                     |       0.14 |
| nagios_host_contactgroups                  |       0.00 |
| nagios_host_contacts                       |       0.01 |
| nagios_host_parenthosts                    |       0.00 |
| nagios_hostchecks                          |       0.15 |
| nagios_hostdependencies                    |       0.00 |
| nagios_hostescalation_contactgroups        |       0.00 |
| nagios_hostescalation_contacts             |       0.00 |
| nagios_hostescalations                     |       0.00 |
| nagios_hostgroup_members                   |       0.02 |
| nagios_hostgroups                          |       0.00 |
| nagios_hosts                               |       0.09 |
| nagios_hoststatus                          |       0.19 |
| nagios_instances                           |       0.00 |
| nagios_logentries                          |     227.51 |
| nagios_notifications                       |     154.31 |
| nagios_objects                             |       0.39 |
| nagios_processevents                       |       0.55 |
| nagios_programstatus                       |       0.00 |
| nagios_runtimevariables                    |       0.00 |
| nagios_scheduleddowntime                   |       0.00 |
| nagios_service_contactgroups               |       0.00 |
| nagios_service_contacts                    |       0.05 |
| nagios_service_parentservices              |       0.00 |
| nagios_servicechecks                       |       0.68 |
| nagios_servicedependencies                 |       0.00 |
| nagios_serviceescalation_contactgroups     |       0.00 |
| nagios_serviceescalation_contacts          |       0.00 |
| nagios_serviceescalations                  |       0.00 |
| nagios_servicegroup_members                |       0.00 |
| nagios_servicegroups                       |       0.00 |
| nagios_services                            |       0.48 |
| nagios_servicestatus                       |       1.04 |
| nagios_statehistory                        |      34.96 |
| nagios_systemcommands                      |       0.05 |
| nagios_timedeventqueue                     |       0.00 |
| nagios_timedevents                         |       0.00 |
| nagios_timeperiod_timeranges               |       0.00 |
| nagios_timeperiods                         |       0.00 |
| tbl_command                                |       0.06 |
| tbl_contact                                |       0.03 |
| tbl_contactgroup                           |       0.03 |
| tbl_contacttemplate                        |       0.03 |
| tbl_domain                                 |       0.03 |
| tbl_host                                   |       0.08 |
| tbl_hostdependency                         |       0.03 |
| tbl_hostescalation                         |       0.03 |
| tbl_hostextinfo                            |       0.03 |
| tbl_hostgroup                              |       0.03 |
| tbl_hosttemplate                           |       0.03 |
| tbl_info                                   |       0.17 |
| tbl_lnkContactToCommandHost                |       0.02 |
| tbl_lnkContactToCommandService             |       0.02 |
| tbl_lnkContactToContactgroup               |       0.02 |
| tbl_lnkContactToContacttemplate            |       0.02 |
| tbl_lnkContactToVariabledefinition         |       0.02 |
| tbl_lnkContactgroupToContact               |       0.02 |
| tbl_lnkContactgroupToContactgroup          |       0.02 |
| tbl_lnkContacttemplateToCommandHost        |       0.02 |
| tbl_lnkContacttemplateToCommandService     |       0.02 |
| tbl_lnkContacttemplateToContactgroup       |       0.02 |
| tbl_lnkContacttemplateToContacttemplate    |       0.02 |
| tbl_lnkContacttemplateToVariabledefinition |       0.02 |
| tbl_lnkHostToContact                       |       0.02 |
| tbl_lnkHostToContactgroup                  |       0.02 |
| tbl_lnkHostToHost                          |       0.02 |
| tbl_lnkHostToHostgroup                     |       0.02 |
| tbl_lnkHostToHosttemplate                  |       0.02 |
| tbl_lnkHostToVariabledefinition            |       0.02 |
| tbl_lnkHostdependencyToHost_DH             |       0.02 |
| tbl_lnkHostdependencyToHost_H              |       0.02 |
| tbl_lnkHostdependencyToHostgroup_DH        |       0.02 |
| tbl_lnkHostdependencyToHostgroup_H         |       0.02 |
| tbl_lnkHostescalationToContact             |       0.02 |
| tbl_lnkHostescalationToContactgroup        |       0.02 |
| tbl_lnkHostescalationToHost                |       0.02 |
| tbl_lnkHostescalationToHostgroup           |       0.02 |
| tbl_lnkHostgroupToHost                     |       0.02 |
| tbl_lnkHostgroupToHostgroup                |       0.02 |
| tbl_lnkHosttemplateToContact               |       0.02 |
| tbl_lnkHosttemplateToContactgroup          |       0.02 |
| tbl_lnkHosttemplateToHost                  |       0.02 |
| tbl_lnkHosttemplateToHostgroup             |       0.02 |
| tbl_lnkHosttemplateToHosttemplate          |       0.02 |
| tbl_lnkHosttemplateToVariabledefinition    |       0.02 |
| tbl_lnkServiceToContact                    |       0.02 |
| tbl_lnkServiceToContactgroup               |       0.02 |
| tbl_lnkServiceToHost                       |       0.05 |
| tbl_lnkServiceToHostgroup                  |       0.02 |
| tbl_lnkServiceToServicegroup               |       0.02 |
| tbl_lnkServiceToServicetemplate            |       0.02 |
| tbl_lnkServiceToVariabledefinition         |       0.02 |
| tbl_lnkServicedependencyToHost_DH          |       0.02 |
| tbl_lnkServicedependencyToHost_H           |       0.02 |
| tbl_lnkServicedependencyToHostgroup_DH     |       0.02 |
| tbl_lnkServicedependencyToHostgroup_H      |       0.02 |
| tbl_lnkServicedependencyToService_DS       |       0.02 |
| tbl_lnkServicedependencyToService_S        |       0.02 |
| tbl_lnkServicedependencyToServicegroup_DS  |       0.02 |
| tbl_lnkServicedependencyToServicegroup_S   |       0.02 |
| tbl_lnkServiceescalationToContact          |       0.02 |
| tbl_lnkServiceescalationToContactgroup     |       0.02 |
| tbl_lnkServiceescalationToHost             |       0.02 |
| tbl_lnkServiceescalationToHostgroup        |       0.02 |
| tbl_lnkServiceescalationToService          |       0.02 |
| tbl_lnkServiceescalationToServicegroup     |       0.02 |
| tbl_lnkServicegroupToService               |       0.02 |
| tbl_lnkServicegroupToServicegroup          |       0.02 |
| tbl_lnkServicetemplateToContact            |       0.02 |
| tbl_lnkServicetemplateToContactgroup       |       0.02 |
| tbl_lnkServicetemplateToHost               |       0.02 |
| tbl_lnkServicetemplateToHostgroup          |       0.02 |
| tbl_lnkServicetemplateToServicegroup       |       0.02 |
| tbl_lnkServicetemplateToServicetemplate    |       0.02 |
| tbl_lnkServicetemplateToVariabledefinition |       0.02 |
| tbl_lnkTimeperiodToTimeperiod              |       0.02 |
| tbl_logbook                                |       0.02 |
| tbl_mainmenu                               |       0.02 |
| tbl_permission                             |       0.02 |
| tbl_permission_inactive                    |       0.02 |
| tbl_service                                |       0.11 |
| tbl_servicedependency                      |       0.03 |
| tbl_serviceescalation                      |       0.03 |
| tbl_serviceextinfo                         |       0.03 |
| tbl_servicegroup                           |       0.03 |
| tbl_servicetemplate                        |       0.03 |
| tbl_session                                |       0.02 |
| tbl_session_locks                          |       0.02 |
| tbl_settings                               |       0.03 |
| tbl_submenu                                |       0.02 |
| tbl_timedefinition                         |       0.02 |
| tbl_timeperiod                             |       0.03 |
| tbl_user                                   |       0.03 |
| tbl_variabledefinition                     |       0.06 |
| xi_auditlog                                |     137.72 |
| xi_auth_tokens                             |       3.64 |
| xi_cmp_ccm_backups                         |       0.02 |
| xi_cmp_favorites                           |       0.03 |
| xi_cmp_nagiosbpi_backups                   |       0.17 |
| xi_cmp_trapdata                            |       0.03 |
| xi_cmp_trapdata_log                        |       0.03 |
| xi_commands                                |       0.52 |
| xi_deploy_agents                           |       0.02 |
| xi_deploy_jobs                             |       0.02 |
| xi_eventqueue                              |       0.03 |
| xi_events                                  |       0.23 |
| xi_meta                                    |       4.52 |
| xi_mibs                                    |       0.05 |
| xi_options                                 |       0.03 |
| xi_sessions                                |       0.03 |
| xi_sysstat                                 |       0.03 |
| xi_usermeta                                |       0.08 |
| xi_users                                   |       0.03 |
+--------------------------------------------+------------+

Best Regards,
SOUHAIB

[benjaminsmith]

Hi SOUHAIB,

Thanks for posting the table sizes, those look okay. A couple of questions to help us narrow this down.

1. How often is the is occurring?

2. Have you made any changes to the default Apache configurations in Nagios XI?

3. Please open up the developer tools in Chrome (right click and select inspect), then select Network (All) and load the page producing the error, then sort on the status, and let me know if you see any errors when loading the front-end scripts. Thanks, Benjamin

Untitled.png

[ABBsupervision]

Hello,

1 - We have encountered this issue since the beginning of this month but the first problem has been solved ( see attached - Nagvis_ErrorPHP.PNG ) , and the second problem is still relevant, we can't create a role ( see attached - Nagvis_Error Role.PNG ).

Code: Select all

Invalid JSON response
Time: 1623332336
URL: /nagvis/server/core/ajax_handler.php?mod=RoleMgmt&act=view&_ajaxid=1623332336
Response:
Créer un Rôle
{"type":"error","message":"Error: (0) count(): Parameter must be an array or an object that implements Countable
URL: \/nagvis\/server\/core\/ajax_handler.php?mod=RoleMgmt&act=view&_ajaxid=1623332336
\nFile: \/usr\/local\/nagvis\/share\/server\/core\/classes\/ViewManageRoles.php
\nLine: 38
\n
#0 \/usr\/local\/nagvis\/share\/server\/core\/classes\/ViewManageRoles.php(38): nagvisExceptionErrorHandler(2, 'count(): Parame...', '\/usr\/local\/nagv...', 38, Array)
\n#1 \/usr\/local\/nagvis\/share\/server\/core\/classes\/ViewManageRoles.php(300): ViewManageRoles->addForm()
\n#2 \/usr\/local\/nagvis\/share\/server\/core\/classes\/CoreModRoleMgmt.php(44): ViewManageRoles->parse()
\n#3 \/usr\/local\/nagvis\/share\/server\/core\/functions\/index.php(120): CoreModRoleMgmt->handleAction()
\n#4 \/usr\/local\/nagvis\/share\/server\/core\/ajax_handler.php(59): require('\/usr\/local\/nagv...')
\n#5 {main}<\/code>Output:
<h2>Créer un Rôle<\/h2><\/pre>","title":"Error: PHP Error"}

2 - We didn't made any changes.

3 - Please find attached the screenshots.


Best Regards,
SOUHAIB

[benjaminsmith]

Hi @ABBsupervision,

Thanks for helping us troubleshoot this so far, one of the team members here was able to come up with a solution. It's a Cent 8/ 7 PHP issue.

Please edit the following file:

Code: Select all

/usr/local/nagvis/share/server/core/classes/ViewManageRoles.php

Change this line from:

Code: Select all

if (count($name) > AUTH_MAX_ROLENAME_LENGTH)

To this:

Code: Select all

if (strlen($name) > AUTH_MAX_ROLENAME_LENGTH)

Then test this once more and let us know if the issue is resolved.

Regards,
Benjamin

[ABBsupervision]

Hi benjaminsmith,

We made the change on Nagvis scripts as you recommended.
It seems working fine, we didn't get any error on adding a new role or associating a user to this new role.

We're going to make other check just to be sure that everything is fine, and we'll let you know if you can close this post.

Thanks & regards

[benjaminsmith]

Hi,

We're going to make other check just to be sure that everything is fine, and we'll let you know if you can close this post.

Sounds good. We'll keep this open and wait for an update.