How to monitor azure paas db in nagios xi ?

[bsanjay]

Hi Pbroste,
Please find the requested details attached and do the needful,

Best Regards,
bsanjay

[pbroste]

Hello @bsanjay

Thanks for following up with the results; appears that PHP version 5 is missing options and want to upgrade to 7:

https://support.nagios.com/kb/article/nagios-xi-upgrading-to-php-7-860.html

Please let us know if you have further questions,
Perry

[bsanjay]

Hi Pbroste,
Upgrading the PHP to version 7 helped resolving mssql issue. But after upgrading the PHP, we are unable to access the nagiosxi dashboard. Please find below the error messages & logs for your refenrence,

[root@nagiosxiserv html]# php -v
PHP 7.3.31 (cli) (built: Oct 4 2021 11:51:19) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.31, Copyright (c) 1998-2018 Zend Technologies

[root@nagiosxiserv html]# tail -50 /var/log/httpd/error_log
[Tue Oct 05 13:54:55.801370 2021] [core:notice] [pid 7749] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:00:44.092579 2021] [mpm_prefork:notice] [pid 7749] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:00:56.158551 2021] [suexec:notice] [pid 11094] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:00:56.182304 2021] [auth_digest:notice] [pid 11094] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:00:56.182906 2021] [lbmethod_heartbeat:notice] [pid 11094] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:00:56.225298 2021] [mpm_prefork:notice] [pid 11094] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:00:56.225334 2021] [core:notice] [pid 11094] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:10:52.101371 2021] [mpm_prefork:notice] [pid 11094] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:10:53.169760 2021] [suexec:notice] [pid 17630] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:10:53.191146 2021] [auth_digest:notice] [pid 17630] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:10:53.191599 2021] [lbmethod_heartbeat:notice] [pid 17630] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:10:53.231371 2021] [mpm_prefork:notice] [pid 17630] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:10:53.231411 2021] [core:notice] [pid 17630] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:12:47.782953 2021] [mpm_prefork:notice] [pid 17630] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:12:56.848853 2021] [suexec:notice] [pid 18452] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:12:56.871493 2021] [auth_digest:notice] [pid 18452] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:12:56.872021 2021] [lbmethod_heartbeat:notice] [pid 18452] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:12:56.914918 2021] [mpm_prefork:notice] [pid 18452] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:12:56.914965 2021] [core:notice] [pid 18452] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:15:04.065126 2021] [mpm_prefork:notice] [pid 18452] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:15:16.140538 2021] [suexec:notice] [pid 19439] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:15:16.162841 2021] [auth_digest:notice] [pid 19439] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:15:16.163283 2021] [lbmethod_heartbeat:notice] [pid 19439] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:15:16.206110 2021] [mpm_prefork:notice] [pid 19439] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:15:16.206154 2021] [core:notice] [pid 19439] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:19:02.743544 2021] [mpm_prefork:notice] [pid 19439] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:19:03.812539 2021] [suexec:notice] [pid 21012] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:19:03.834021 2021] [auth_digest:notice] [pid 21012] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:19:03.834470 2021] [lbmethod_heartbeat:notice] [pid 21012] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:19:03.876718 2021] [mpm_prefork:notice] [pid 21012] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:19:03.876740 2021] [core:notice] [pid 21012] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:31:03.498036 2021] [mpm_prefork:notice] [pid 21012] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:31:04.565802 2021] [suexec:notice] [pid 26259] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:31:04.587854 2021] [auth_digest:notice] [pid 26259] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:31:04.588343 2021] [lbmethod_heartbeat:notice] [pid 26259] AH02282: No slotmem from mod_heartmonitor
PHP Warning: Module 'SourceGuardian' already loaded in Unknown on line 0
[Tue Oct 05 14:31:04.629517 2021] [mpm_prefork:notice] [pid 26259] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:31:04.629539 2021] [core:notice] [pid 26259] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:31:28.078279 2021] [mpm_prefork:notice] [pid 26259] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:31:29.148894 2021] [suexec:notice] [pid 26415] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:31:29.170926 2021] [auth_digest:notice] [pid 26415] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:31:29.171358 2021] [lbmethod_heartbeat:notice] [pid 26415] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:31:29.212439 2021] [mpm_prefork:notice] [pid 26415] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:31:29.212484 2021] [core:notice] [pid 26415] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Oct 05 14:58:04.811133 2021] [mpm_prefork:notice] [pid 26415] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Oct 05 14:58:05.883324 2021] [suexec:notice] [pid 4219] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Oct 05 14:58:05.907325 2021] [auth_digest:notice] [pid 4219] AH01757: generating secret for digest authentication ...
[Tue Oct 05 14:58:05.907781 2021] [lbmethod_heartbeat:notice] [pid 4219] AH02282: No slotmem from mod_heartmonitor
[Tue Oct 05 14:58:05.950367 2021] [mpm_prefork:notice] [pid 4219] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/7.4.24 configured -- resuming normal operations
[Tue Oct 05 14:58:05.950436 2021] [core:notice] [pid 4219] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

[root@nagiosxiserv html]# /usr/local/nagiosxi/scripts/reconfigure_nagios.sh
--- reset_config_perms.sh ------------
> Setting script permissions
> Setting CCM script permissions
> Setting special script permissions
> Setting special component script permissions
> Setting migrate permissions
> Setting configuration file/directory permissions
> Setting perfdata directory and RRD permissions
> Setting libexec directory permissions
> Setting Nagios XI config permissions
> Setting NOM checkpoint user:group permissions
> + Setting Recurring Downtime file user:group permissions
> + Setting BPI configuration file user:group permissions
--------------------------------------
PHP Fatal error: Cannot redeclare init_session() (previously declared in /usr/local/nagiosxi/html/includes/utils.inc.php:71) in /usr/local/nagiosxi/html/includes/utilsx.inc.php on line 71

Importing into the CCM failed!


Looks like some functions are deprecated in new php version which is causing this issue. Please let me know what needs to be done to resolve this issue as nagios xi dashboard is unavailable now.

Best Regards,
bsanjay

[pbroste]

Hello @bsanjay

Thanks for following up with the details that definitely helps going forward. We want to get the System Profile and copy of the '/usr/local/nagiosxi/html/includes/utils.inc.php' and '/usr/local/nagiosxi/html/includes/utilsx.inc.php'

Code: Select all

tar -czvf /tmp/phputils.tar.gz /usr/local/nagiosxi/html/includes/utils.inc.php /usr/local/nagiosxi/html/includes/utilsx.inc.php

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
• Save the profile.zip file and send via Private Message

Thanks,
Perry

[pbroste]

To follow up, you can get the System Profile via the following script:

Code: Select all

rm -rf /usr/local/nagiosxi/var/components/profile.zip
/usr/local/nagiosxi/scripts/components/getprofile.sh SUPPORT

Also, please check this as well:

Code: Select all

grep ixed /etc/php.d/sourceguardian.ini
grep ixed /etc/php.ini

Thanks,
Perry

[bsanjay]

Hi proste,
As per your request i did PM you the nagios system profile & php utils. Please find the output of the commads as per your request below,

[root@nagiosxiserv root]# grep ixed /etc/php.d/sourceguardian.ini
extension=ixed.7.3.lin

[root@nagiosxiserv root]# grep ixed /etc/php.ini
;extension = "ixed.7.3.lin"

Best Regards,
bsanjay

[pbroste]

Hello @bsanjay;

To followup from [PM] messages:

Are you installing RPM online or offline?

We Will need to get a list of packages so we can check versioning:

Code: Select all

yum repolist >/tmp/yum.txt
yum list >>/tmp/yum.txt

Please follow up and send the results of the /tmp/yum.txt.

Please go ahead and remove the line found in: '/etc/php.ini'
;extension = "ixed.7.3.lin"

Bounce the Apache service and send the; '/var/log/httpd/ssl_error_log file and the /var/log/httpd/error_log'

Code: Select all

tar -czvf apachelog.tar.gz /var/log/httpd/ssl_error_log file and the /var/log/httpd/error_log

Also looking back through want to get an update on this:

Code: Select all

 nmap -sV -Pn -p 1433 10.53.0.70

Thanks,
Perry

[bsanjay]

Hi Pbroste,
Please find below the required details. I did PM you the attachment for yum & apache2 logs,

[root@nagiosxiserv tmp]# nmap -sV -Pn -p 1433 10.53.0.70
Starting Nmap 6.47 ( http://nmap.org ) at 2021-10-08 07:02 UTC
Nmap scan report for 10.53.0.70
Host is up (0.16s latency).
PORT STATE SERVICE VERSION
1433/tcp open tcpwrapped

Service detection performed. Please report any incorrect results at http://nmap.org/submit/ .
Nmap done: 1 IP address (1 host up) scanned in 6.77 seconds

Best Regards,
bsanjay

[pbroste]

Hello @bsanjay

Hello @bsanjay

Thanks for sending over the requested logs, I left out the php.ini config and httpd configs.

Code: Select all

tar -czvf apacheconfig.tar.gz /etc/httpd/conf/ /etc/php.ini

Thanks,
Perry

Please send that over when you get a chance.

[bsanjay]

Hi pbroste,
Please find the files attached in PM,

Best Regards,
bsanjay