Page 1 of 2

NAGIOSQL LOGIN FAILED

Posted: Wed Jan 08, 2014 10:51 am
by eloisalunar
Hi Nagios Support,

During the installation of Nagios XI, I received the following error

- PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/ixed.5.1.lin' - /usr/lib64/php/modules/ixed.5.1.lin: cannot open shared object file: No such file or directory in Unknown on line 0
- 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-01-08 15:36:56-- http://localhost/nagiosql/index.php
Resolving localhost... ::1
Connecting to localhost|::1|:80... failed: Connection refused.
NAGIOSQL LOGIN FAILED!

Can you please help me to troubleshot this issue. I have attached here the install.log file.

Re: NAGIOSQL LOGIN FAILED

Posted: Wed Jan 08, 2014 12:07 pm
by abrist
What version of php are you running?

Code: Select all

yum list installed | grep php

Re: NAGIOSQL LOGIN FAILED

Posted: Wed Jan 08, 2014 12:39 pm
by eloisalunar
Hi -

Here is the result of the command.

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
php.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-cli.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-common.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-gd.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-ldap.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-mbstring.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-optional-6
php-mcrypt.x86_64 5.3.3-3.el6 @epel
php-mssql.x86_64 5.3.3-3.el6 @epel
php-mysql.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-pdo.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-pear.noarch 1:1.9.4-4.el6 @rhel-x86_64-server-6
php-pear-HTML-Template-IT.noarch 1.3.0-2.el5 @/php-pear-HTML-Template-IT-1.3.0-2.el5.noarch
php-pgsql.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6
php-snmp.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-optional-6
php-xml.x86_64 5.3.3-27.el6_5 @rhel-x86_64-server-6

Re: NAGIOSQL LOGIN FAILED

Posted: Wed Jan 08, 2014 1:44 pm
by sreinhardt
Have you modified the XI installation script to get around redhat registration? Also how are you getting packages without being registered, we depend on quite a few additional packages that generally will not install without having a proper redhat license.

Re: NAGIOSQL LOGIN FAILED

Posted: Tue Jan 14, 2014 4:11 am
by eloisalunar
I did not modify the XI installation script. Is it required to have a proper redhat license to install Nagios XI?

Re: NAGIOSQL LOGIN FAILED

Posted: Tue Jan 14, 2014 11:33 am
by abrist
eloisalunar wrote:Is it required to have a proper redhat license to install Nagios XI?
Yes, if you are installing on a redhat system. Otherwise, you can install XI to centos without issue.

Re: NAGIOSQL LOGIN FAILED

Posted: Tue Jan 14, 2014 7:41 pm
by varnar
Please check if httpd is running
try to execute
telnet localhost 80

Re: NAGIOSQL LOGIN FAILED

Posted: Wed Jan 15, 2014 10:56 am
by abrist
eloisalunar wrote:I did not modify the XI installation script. Is it required to have a proper redhat license to install Nagios XI?
Have you made anymore progress on this? Was your copy of redhat not registered? If registering is not possible, you could always install to centos instead, as that is free and still supported. . .

Re: NAGIOSQL LOGIN FAILED

Posted: Fri Jan 31, 2014 1:52 pm
by SteveBeauchemin
I was having a similar error.

I downloaded and installed the vSphere OVF Template (64-bit) 2102-2R2.7 and have it running in my ESX infrastructure.

I noticed that an update was available. Downloaded the Source Installer 2012R2.8c from Jan 20, 2014.

The installer would not run and appeared to be unable to connect to the NagiosXI page.
This is the error portion of the ./upgrade output:

Installing new XI templates...
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=[user]&tfPassword=[password]' -O nagiosql.login--2014-01-31 11:20:32-- http:/ /localhost/nagiosql/index.php
Resolving proxy.[Domain].com...
Connecting to proxy.[Domain].com|:[Port]... connected.
Proxy request sent, awaiting response... 502 cannotconnect
2014-01-31 11:20:32 ERROR 502: cannotconnect.

NAGIOSQL LOGIN FAILED!

I thought - Shouldn't the upgrade work on an unmodified, newly installed VMware image with no changes made?

Then I read the error more closely and realized that the proxy was not allowing localhost access.
I had to modify the linux environment variables that allow HTTP traffic to use a proxy.

in /etc/profile.d I always create the following 2 files to allow access via proxy for my host.
Note: 'proxy FQDN', 'Domain', and 'Port' should reflect your own installation

(yes, these files have both upper case and lower case of the same thing - it is overkill but works)
cat /etc/profile.d/proxy.csh
#proxy.csh
setenv http_proxy http://[proxy FQDN]:[Port]/
setenv https_proxy http://[proxy FQDN]:[Port]/
setenv ftp_proxy http://[proxy FQDN]:[Port]/
setenv no_proxy .[Domain].com,localhost,127.0.0.1
setenv HTTP_PROXY http://[proxy FQDN]:[Port]/
setenv HTTPS_PROXY http://[proxy FQDN]:[Port]/
setenv FTP_PROXY http://[proxy FQDN]:[Port]/

and
cat /etc/profile.d/proxy.sh
#proxy.sh
export http_proxy=http://[proxy FQDN]:[Port]/
export https_proxy=http://[proxy FQDN]:[Port]/
export ftp_proxy=http://[proxy FQDN]:[Port]/
export no_proxy=.[Domain].com,localhost,127.0.0.1
export HTTP_PROXY=http://[proxy FQDN]:[Port]/
export HTTPS_PROXY=http://[proxy FQDN]:[Port]/
export FTP_PROXY=http://[proxy FQDN]:[Port]/

Now Note the no_proxy lines. I used to have a single item there reflecting my Domain.
Now I have added ,localhost,127.0.0.1 to the line (comma separated)
no_proxy=.[Domain].com
changed to
no_proxy=.[Domain].com,localhost,127.0.0.1

Prior to doing this, I could not upgrade my fresh install with the latest version of Source Installer.
I hope this posting saves other folks from having the same problem.

Thanks.
Steve B

Re: NAGIOSQL LOGIN FAILED

Posted: Fri Jan 31, 2014 3:06 pm
by sreinhardt
Steve, it looks like you have not configured wget for your internal proxy settings as we suggest. Take a look at the documentation link below and if you continue to have issues please open a thread specific to your issue.
http://support.nagios.com/wiki/index.ph ... th_Proxies