Nagios Support Forum

[root@localhost nagiosxi]# ./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--2011-11-15 20:09:43-- http://localhost/nagiosql/index.php
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2011-11-15 20:09:43 ERROR 500: Internal Server Error.

NAGIOSQL LOGIN FAILED!
ERROR: NagiosQL import appears to have failed - exiting. (Reason: Import files are still present in /usr/local/nagios/etc/import)

Can you post the contents of the install.log file that was generated by the installation scripts? If for some reason you have trouble attaching it, can you post the top 50 lines of it?

Hi ,Below are the details which was generted by install.log

hecking PostgresQL status...
PostgresQL running - continuing...
Creating role and database...
ERROR: role "nagiosxi" already exists
ERROR: database "nagiosxi" already exists
User 'nagiosxi' created successfully.
Database 'nagiosxi' created successfully.
Restarting Postgres...
Stopping postgresql service: ^[[60G[^[[0;32m OK ^[[0;39m]^M
Starting postgresql service: ^[[60G[^[[0;32m OK ^[[0;39m]^M
Sleeping for a few seconds (please wait)...
Database structure already created - skipping...
Database schema created successfully.
Database already contains values - skipping data load...
Data inserted into database successfully.
Nagios xi PostgresQL Database Initialized OK.
Nagios xi base files installed OK
Crontabs installed OK
Daemons configured to start OK
httpd: no process killed
Starting httpd: ^[[60G[^[[0;32m OK ^[[0;39m]^M
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--2011-11-16 12:50:12-- http://localhost/nagiosql/index.php
Resolving proxy4.wipro.com... 10.201.51.54
Connecting to proxy4.wipro.com|10.201.51.54|:8080... connected.
Proxy request sent, awaiting response... 401 Unauthorized
Authorization failed.
NAGIOSQL LOGIN FAILED!
ERROR: NagiosQL import appears to have failed - exiting. (Reason: Import files are still present in /usr/local/nagios/etc/import)

And Also ,While Commented my proxy server and connecting threw local host getting following..

[root@localhost nagiosxi]# service httpd status
httpd (pid 18795) is running...
[root@localhost nagiosxi]# ./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--2011-11-16 13:59:56-- http://localhost/nagiosql/index.php
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2011-11-16 13:59:56 ERROR 500: Internal Server Error.

NAGIOSQL LOGIN FAILED!
ERROR: NagiosQL import appears to have failed - exiting. (Reason: Import files are still present in /usr/local/nagios/etc/import)

Thanks in advance ...i need to know what is happening as we are going to buy licence for nagios ..so please explain.

Are you using a proxy on your installation? If so, read the following:
http://support.nagios.com/wiki/index.ph ... th_Proxies

hi i have already set all the proxy and its working in all other Installation...!

There have been repo changes for CentOS 6, so our FAQ solution may not work for proxy installations on CentOS 6. If I were to guess, I would bet that you're missing the following package, and you'll have to figure out how to get it installed through your proxy.

php-pear-HTML-Template-IT.noarch

You can check if it got installed by running:

Hi..The package already installed ...see below what i getting while running the same

[root@localhost ~]# yum list installed | grep pear
php-pear.noarch 1:1.9.0-2.el6 @base
[root@localhost ~]#

44

Pear is installed, the pear templating package is missing:
If you can figure out how to install php-pear-HTML-Template-IT.noarch from behind a proxy, go ahead and post the solution and we'll update our wiki. I'm betting that if you can get that installed, then run the installer again with a freshly unzipped tarball, I'm betting that you'll be able to get the installer to work.