Page 1 of 2

Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 6:57 am
by rave
Hi to everyone,

Trying to install NagiosXi on CentOS 6, i got this problem:

Code: Select all

Running './E-importnagiosql'...
httpd: no process killed
Starting httpd:                                            [  OK  ]
Sleeping...
NOTE: If prompted, enter the MySQL root password
NagiosQL database appears OK - continuing...
NDOUtils database appears OK - continuing...
Found config files to import - continuing...
URL: http://localhost/nagiosql/index.php
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosql/index.php --no-check-certificate --post-data 'Submit=Login&tfUsername=nagiosxi&tfPassword=n@gweb' -O nagiosql.login--2014-04-18 11:53:01--  http://localhost/nagiosql/index.php
Resolviendo localhost... 127.0.0.1, ::1
Connecting to localhost|127.0.0.1|:80... conectado.
Petición HTTP enviada, esperando respuesta... 500 Internal Server Error
2014-04-18 11:53:01 ERROR 500: Internal Server Error.

NAGIOSQL LOGIN FAILED!
RESULT=1

===================
INSTALLATION ERROR!
===================
Installation step failed - exiting.
Check for error messages in the install log (install.log).

If you require assistance in resolving the issue, please include install.log
in your communications with Nagios XI technical support.
Lookin at nagios_loging.php i see that the file nagios.login is empty, is this normal? I config too no_proxy=localhost on wgetrc but doesn't works. Actually i can login on Nagiosxi webapp.

I don't know what to do now, thanks for the help.

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 9:28 am
by slansing
Please do not double post, your first few posts are going to have to be moderated by us.

Is this a fresh centos 6 minimal install? If not, what type of install did you do? Did you change anything no matter how minor, besides time settings, on the system prior to installing XI? Did you install mysql, php-mysql, anything of that sort?

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 10:17 am
by rave
Sorry for the double post, it was a mistake :roll:

The installation was did on a install minimal CentOS like our provider let us. It has Plesk, Apache, MySql, Php-Mysql and PHP pre-installed. If you need more information just let me know :)

Nagios Core works fine, thanks for tour quickly answer and help. :D

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 10:46 am
by slansing
Well, that is not exactly a minimal install then :). Having those packaged pre installed will cause issues when installing XI since we install very specific versions of said packages. You will need to use our pre-configured VM's, or a completely fresh fully minimal centos image.

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 10:59 am
by rave
Our provider doesn't allow us to have a more minimal install of CentOS. There are another idea of what we can do? Some idea approximate of what which be the concrete problem?

Thank you very much for your supporting.

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 11:29 am
by slansing
I'm not sure why they would be adverse to the idea, nagios will be installing those packages anyways. You could use the VM's as I mentioned above.

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 12:06 pm
by rave
Ok, now NagiozXI installation reports me this. Any idea?

Code: Select all

NOTE: If prompted, enter the MySQL root password
NagiosQL database appears OK - continuing...
NDOUtils database appears OK - continuing...
Found config files to import - continuing...
URL: http://localhost/nagiosql/index.php
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosql/index.php --no-check-certificate --post-data 'Submit=Login&tfUsername=nagiosxi&tfPassword=n@gweb' -O nagiosql.login--2014-04-18 17:05:34--  http://localhost/nagiosql/index.php
Resolviendo localhost... 127.0.0.1, ::1
Connecting to localhost|127.0.0.1|:80... conectado.
Petición HTTP enviada, esperando respuesta... 200 OK
Longitud: 0 [text/html]
Saving to: `nagiosql.login'

     0K                                                        0,00 =0s

2014-04-18 17:05:34 (0,00 B/s) - `nagiosql.login' saved [0/0]

NAGIOSQL LOGIN FAILED!
RESULT=1
Thanks!

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 12:54 pm
by lmiltchev
Are you behind a proxy? If you are, please, review our wiki post on the use of proxies in Nagios XI:

http://support.nagios.com/wiki/index.ph ... th_Proxies

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 1:27 pm
by rave
Thanks for the information, but we don't use a proxy, i checked right now. I'm really missing because i can go to http://ip.address/nagiosql/install/index.php and in this point, NagiosQL ask me to run the wizard installation, must i do this steps?

I can enter to the install throught lynx and with a external machine.

EDIT:

In NagiosQL install page i see this: ENABLE_INSTALLER does not exist!
Please create an empty file called ENABLE_INSTALLER in the install directory to continue!

Re: Nagios XI 2012 Installation error NagiosQL ERROR 500

Posted: Fri Apr 18, 2014 1:43 pm
by lmiltchev
Important: Nagios Enterprises highly recommends and will only support installing Nagios XI on a newly installed, "clean" system. Attempting to install Nagios XI on a pre-existing system with other applications already installed can cause the Nagios XI installation process to fail, critical system components and settings (e.g. database servers) to be modified in a way that negatively affects other applications, and previously installed applications to be automatically upgraded or removed. While installing XI on a system with other applications is possible, it is not recommended due to the possible interactions and complexity of multiple components that are required for Nagios XI to function. If you choose to ignore these warnings, you do so at your own risk.

Internet access is required for installation and upgrades!
http://assets.nagios.com/downloads/nagi ... stallation

You are clearly not following our guidelines and we cannot support this type if installation.