Forgive me, I am a lowly Network Engineer. We have QL running on an old Centos server and are migrating to Ubuntu due to EOL on Centos. I have the Module installed and see the same issue. Sorry if I am misreading your solution.
Thanks for the reply Martin! I have the module installed. root@nagios-new:/home/linux-admin# apt-get install php-mysqli Reading package lists... Done Building dependency tree... Done Reading state information... Done Note, selecting 'php8.3-mysql' instead of 'php-mysqli' php8.3-mysql is already the newest version (8.3.6-0ubuntu0.24.04.1). 0 upgraded, 0 newly installed, 0 to remove and 5 not upgraded. root@nagios-new:/home/linux-admin# php -m | grep mysqli mysqli Not sure what the issue is.
Thanks for the reply Martin! I have the module installed. root@nagios-new:/home/linux-admin# apt-get install php-mysqli Reading package lists... Done Building dependency tree... Done Reading state information... Done Note, selecting 'php8.3-mysql' instead of 'php-mysqli' php8.3-mysql is already the newest version (8.3.6-0ubuntu0.24.04.1). 0 upgraded, 0 newly installed, 0 to remove and 5 not upgraded. root@nagios-new:/home/linux-admin# php -m | grep mysqli mysqli Not sure what the issue is.
Hello The root cause of this message is the lack of the PHP mysqli module. If this module is missing, the installer is looking for the module manual URL inside an array called "$arrSourceURLs" - the result should be: https://php.net/manual/de/book.mysqli.php but the key definition is wrong inside the array of the 3.5.0 code because of a typo (MySQL insteed of MySQLi). Just install the MySQLi Module on your machine and the error should no longer appear. Martin
Hey all, I am attempting to install NagiosQL version 3.5.0 on Ubuntu 24.04. I can get to the installation web page, fulfill all the requirements, enter the requested information, and when I click "Next" I am given an Apache 500 Error. This is the error in the Apache2 error log: PHP Warning: Undefined array key "MySQLi" in /opt/nagiosql/install/step1.php on line 207, referer: http://10.64.25.91/nagiosql/install/install.php I have not altered the /opt/nagiosql/install/step1.php file in any way. Any...
Hey all, I am attempting to install NagiosQL version 3.5.0 on Ubuntu 24.04. I can get to the installation web page, fulfill all the requirements, enter the requested information, and when I click "Next" I am given an Apache 500 Error. This is the log error in the Apache2 error log: PHP Warning: Undefined array key "MySQLi" in /opt/nagiosql/install/step1.php on line 207, referer: http://10.64.25.91/nagiosql/install/install.php I have not altered the /opt/nagiosql/install/step1.php file in any way....
Three possible causes: the Nagios configuration file (nagios.cfg) still contains the paths to both configuration files - i.e. /etc/nagiosql/templates.cfg and /etc/nagios/templates.cfg (paths may differ). Only the path to the NagiosQL configuration files may still be there. the object is actually contained in two different configuration files. To check this, change to /etc/nagiosql on the command line and use this command: grep -r generic-contact * If this string is contained in two configuration...
Wonderful, I managed to identify that the problem was actually the server's Anti-Virus that was blocking the import. So I managed to import lol, but now I'm stuck with another error, which seems to be apparently simple, when I edit the nagios.cfg file so that it looks for the files within /etc/nagiosql/, nagios generates a generic- duplication error. contact in templates.cfg but I can't find the duplicate line. can you help me ?
Remember to check the correct php.ini - not CLI but web server and restart Apache after every change to the php.ini
It may be an incorrect setting in php.ini: https://stackoverflow.com/questions/7574260/php-connection-reset-on-large-file-upload-regardless-correct-setting Or it is due to an Apache module: https://serverfault.com/questions/1022288/uploads-failing-with-no-reason It is definitely not a problem of NagiosQL but is due to the web server or the system settings that do not allow file upload (at best SELinux or other security settings). I recommend the web search with the known error parameters and the...
chown apache:nagios chmod 777
Have you looked at your directory permissions and owner ship of files and directories. if that all looks ok, try the command line import command and use the strace command to get an internal view of what error is being returned. strace -f <nagiosql command>
Even inserting only one file at a time doesn't matter (example: commands.cfg).
Even inserting only one file at a time doesn't matter (example: commands.cfg).
what order are you loading the configs? hosts and services should be last. php has a maximum file size, which would need to be changed in php.ini. for large files like host and services, split them into smaller chunks.
Maybe the problem are in nagios.cgi file? idk
thanks for the support martin, After following the steps I managed to progress to a certain point, I basically managed to solve 75% of the problems, but I still can't import the files from Nagios Core to Nagios QL, the Crash screen appears and the files don't import. I'm also attaching it so you can see the support screen to see if I can find a light at the end of the tunnel lol.
thanks for the support martin, After following the steps I managed to progress to a certain point, I basically managed to solve 75% of the problems, but I still can't import the files from Nagios Core to Nagios QL, the Crash screen appears and the files don't import. I'm also attaching it so you can see the support screen to see if I can find a light at the end of the tunnel lol.
It can be standalone when using the ssh access to the Nagios server
It appears that the configuration has not been fully implemented. In particular, chapters 1.2, 1.3 and 1.4 in the instructions should be checked: https://sourceforge.net/projects/nagiosql/files/nagiosql/Documentation/
Good morning guys. I'm having some problems with NAGIOSQL for monitoring printers and computers. I have installed and configured NAGIOS CORE but it is very complicated to manage, especially changing printers that change IP, serial number, etc., so I decided to install NAGIOSQL to help me with this task, after learning a little I managed to get the interface working However, now I'm having some problems that I'll report below: When trying to import any configuration from NAGIOS CORE the screen crashes...
Good morning guys. I'm having some problems with NAGIOSQL for monitoring printers and computers. I have installed and configured NAGIOS CORE but it is very complicated to manage, especially changing printers that change IP, serial number, etc., so I decided to install NAGIOSQL to help me with this task, after learning a little I managed to get the interface working However, now I'm having some problems that I'll report below: When trying to import any configuration from NAGIOS CORE the screen crashes...
How can i import all database of Nagios Core to Nagios QL:
How can i import all database of Nagios Core to Nagios QL
Hi everyone. I have nagios Core installed and unfortunately I forgot the Administrative Database User password and now I can't install nagiosql Can anyone help me with how to reset or find the root user password? I use the CentOS system
I take it that NagiosQL has to be installed local to the Nagios server? and can't be standalone?
Suggesting adding database connections secured with user configurable TLS/SSL certificates.
Suggesting adding database connections secured with user configurable SSL/TLS certificates.
Suggesting database encryption with user-configurable SSL/TLS certificates.
i think your problem is database authentication. The nagiosql scripts and docs don't cater for all evetuallities. i would suggest creating a blank database and setting the password and rerunning the script.
I'm having a problem installing NagiosQL. I start the installation script (after ensuring all requirements are met) and proceed to the second step, where I enter all necessary passwords. But when I move to the final step to finalize the installation, instead of getting a page with information about success or failure, I see a blank page. The Apache log shows an Error 500. I'm using Debian 12 and NagiosQL 3.5.
Are their any instructions/guides on how to install the latest version of NagiosQL on a server without a local Nagios installation? I want to have a NagiosQL server that just has the web app for NagiosQL and database, and pushes config out to several other Nagios servers via SFTP. What changes do I need to make from the install guide to get a successfull installation of NagiosQL stand-alone? Thanks
I don't know what else is needed in the permissions, and to add the pnp4nagios, I added it but it is not generating performance data https://gitlab.com/wizonet/nagiosql/-/issues/44
NagiosQL supports the import of existing NagiosQL configuration files. NagiosQL supports an additional configuration name for all services to group them together by this name - e.g. all services of a host. Since this parameter is not present in standard configuration files, it can be written manually before the first import into NagiosQL. For this purpose this line can be added to any single service configuration: #NAGIOSQL_CONFIG_NAME myhost.mydomain.com or #NAGIOSQL_CONFIG_NAME My_webserver_services...
Hi, is there a way to import an existing config files? I have a Nagios Core Instance and this is configured with NConf. I have a lot of hosts (268) and services ( 639) with parent child configuraion. Regards, Ronny
Hi, is there a way to import an existing config files? I have a Nagios Core Instance and this is configured with NConf. I have a lot of hosts (268) and services ( 639) with parent child configuraion. Regards, Cookie
I see this in a host file. define host { host_name knew alias knew address knew.int.example.org parents bast ... Where is the 'parents' value set in NagioSQL?
Can't access pickers
Can't access pickers
While debugging, I noticed that the web server variable PHP_SELF contained the path of the calling file twice. A search on Google showed that this problem probably already occurred in other environments. The main thing is that it works now :)
Try it out! There is a NagiosQL preview installation on: https://www.wizonet.ch/nagiosql/ English users: User: guest_en Password: nagiosql2023 German users: User: guest_de Password: nagiosql2023 The installation is not connected to a real Nagios installation - but you can "test" and "restart" nagios using the existing menu entries because the Nagios binary is available. The installation and database is reset every hour.
Try it out! There is a NagiosQL preview installation on: https://www.wizonet.ch/nagiosql/ English users: User: guest_en Password: nagiosql2023 German users: User: guest_de Password: nagiosql2023 The installation is not connected to a real Nagios installation - but you can "test" and "restart" nagios using the existing menu entries because the Nagios binary is available.
Guess that's what I get for copy and pasting a seemingly working config. I got to looking at the developer console a little more, and now see what it's doing with the relative links, and your fix fixed it. Sorry for the hassle. Thanks for the help.
Ok, after a few tries I managed to get the VM running. Additionally I found the error after that :) Please change in the ngnix.conf the following lines in the "location ~ .php$ {" section: from (old): fastcgi_param PATH_INFO $fastcgi_script_name; to (new): fastcgi_param PATH_INFO $fastcgi_path_info; fastcgi_param PATH_TRANSLATED $document_root$fastcgi_script_name; And NagiosQL 3.5.0 will work as expected.
Thank you, but VMware ist not able to import the VM because it was not exported in OVF format 1.0. Can you export it again with 1.0? It was also not possible to open the ova with virtualbox because the WAS audio driver cannot be used - best to remove audio altogether as well.
Just sent you a message with a download link from Google Drive. Well, 2 messages since I forgot to include the link in the first.
Ok, then I'll wait for it - I think the problem is certainly solvable. I have installed a publicly available preview version of 3.5.0 here: https://www.wizonet.ch/nagiosql (User: admin Pw: admin) The data there is reset every hour and the installation has no connection to a real Nagios installation
Ok, then I'll wait for it - I think the problem is certainly solvable. I have installed a publicly available preview version of 3.5.0 here: https://www.wizonet.ch/nagiosql The data there is reset every hour and the installation has no connection to a real Nagios installation
Yeah, I think I can do that. Will also rule out me being a bonehead.
If it is possible for you to install a small virtual machine (VMware Player) with this environment on which you can reproduce the problem. So I could download this and test with me.
Did the previous NagiosQL 3.4.1 ever work in such an environment? Can you check NagiosQL 3.5.0 in an installation on which it has worked before? It would be helpful if you could rule out some of the parts, like alma or nginx or php-fpm. Does NagiosQL generally work with nginx or with php-fpm - just not in this combination on alma? The first step in debugging would be to change the URL of the main window from service.php to mutdialog.php. Then the content of the picker should be visible there - the...
here's the request for info.php
Alma Linux 9 nginx 1.20 php-fpm 8.0.2 firefox 109 chrome 108 Normally use Firefox, but tested on Chrome as well. Looking in the console, I see the request for the mut and info content. Server is definitely returning the wrong content.
I am not able to reproduce the problem at the moment. For me, the pickers work as expected on two installations and two different browsers. Can you give me more information about your environment (browser, web server, versions)?
Can't access pickers
Getting a 503 from SF. Grabbing it from Gitlab instead.
Dusting off long unused PHP skills. Turning display_errors led me to permissions issue on the sessions directory. One thing I absolutely hate about using packages, is that they all think apache rules the world, even though they are neck and neck overall and nginx dominates in the top 10k by more than 2:1. Now, on to testing!
3.5.0 Beta is now online: https://sourceforge.net/projects/nagiosql/files/nagiosql/NagiosQL%203.5.0%20%28BETA%20release%29/
Any messages in the webserver logs? Probably a PHP module that is missing - like session or mysqli?
I look forward to trying it out. I just fired up PHP 7.4 and still having an issue getting past the welcome screen. The start installation button just brings me right back and will not progress to the next step. Gotta be something simple I'm missing. Is there a debug flag or anything I can set to see what's going on?
NagiosQL 3.4.1 is not compatible with PHP8 and above. There are some issues with magic quotes and filters. If it's possible - you should wait for NagiosQL 3.5.0 or stay with PHP7. I will release a first beta version of 3.5.0 later today on sourceforge. You are welcome to download and test this beta version. If you update to a higher NagiosQL version, you should run the installer after a restore from a previous dump of the database, because new versions also bring additional database adjustments....
First and foremost, thanks for this incredible project. I stumbled on it over 10 years ago and have used it for a number of clients. I love that it exposes (nearly?) everything one can possibly do with Nagios. This week, I've been working on migrating an installation from CentOS7 (apache, php7.3, maria 5.5) to Alma 9 with Nginx, php 8.0, and maria 10.5. I have everything installed, but can't seem to get NagiosQL to run the installer. Seems that i need to wait for 3.5? While I'm here, is there anything...
NagiosQL 3.5 is almost finished. Probably we need some beta testers to check the application. It was developped based on PHP8.2 - so we recommend to use at least PHP8.0 but it work with PHP7.2 too.
NagiosQL uses the PID file to determine if the Nagios daemon is running or not. If the Nagios demon does not write a PID file this leads to this problem. You can work around this by specifying an existing file, e.g. nagios.cmd, for the PID file in the configuration domain. NagiosQL only checks if the file exists - it does not read its content.
Hey there, some time ago I updated a existing nagiosql 3.2.X instance to 3.4.1 - since this update from webgui it's not possible anymore to restart Nagios Daemon. OS: Debian 10 NagiosQL: 3.4.1 Nagios: 4.3.4-3 I will attach a screenshot of the message - the nagios.cmd file is located here "/var/lib/nagios4/rw/nagios.cmd" and the path is also configured in NagiosQL. Has anyone a hint or an idea how this can be fixed by myself? Thanks in advance
I have managed to refactor 3.4.1 to work with php 8.0, all seems to work fine.
I have managed refactored 3.4.1 to work with php 8.0, all seems to work fine.