DB Connect Error [nagiosxi]: Database connection failed

[TSCAdmin]

Our Nagios XI installation is running on a regular server, not VM and I have sufficient disk space available. Thanks

[TSCAdmin]

I retried to restore Nagios XI from production host to the DR but I am still facing the same issue.

While the psql scripts were running, I noticed something like

ERROR: must be owner of schema public
ERROR: schema "public" already exists
ALTER SCHEMA
ERROR: must be owner of schema public

WARNING: no privileges could be revoked
REVOKE
WARNING: no privileges could be revoked
REVOKE
WARNING: no privileges were granted
GRANT
WARNING: no privileges were granted
GRANT

Does that provide any help? I tried e-mailing [email protected] as well but never received any response, how do I get support for Nagios XI issues?

[rdedon]

I came across this which looks similar:
http://archives.postgresql.org/pgsql-bu ... g00143.php

[TSCAdmin]

Indeed, but it still does not solve my problem. I posted it so Nagios support people might get a hint what could be wrong.

[rdedon]

From the

I tried e-mailing [email protected] as well but never received any response, how do I get support for Nagios XI issues?

By posting here is one way, I am not sure why your emails are not getting us at all (I even checked spam). If you would, please Private message me with the email address and company name so I can confirm it is in records correctly.

I will ask one of the developers to take a look into this in detail as this is beyond my skill level.

[mguthrie]

Just to verify, have you done anything to change the passwords for any postgresql users on your system?

Can you refresh the javascript cache in your browser by holding shift and reloading the page?

Do you have any other systems using the XI license key besides your test machine and your production machine?

Does the "date" command return the correct date/time on your XI server?

[TSCAdmin]

Just to verify, have you done anything to change the passwords for any postgresql users on your system?

I haven't touched the password for postgresql, infact it was same as it comes hardcoded in Nagios XI installation scripts.

Can you refresh the javascript cache in your browser by holding shift and reloading the page?

I tried doing that numerous times after restarting postgresql.

Do you have any other systems using the XI license key besides your test machine and your production machine?

The license keys for production and development environment are totally different. I never got insert the license keys since NagiosQL never opened up.

Does the "date" command return the correct date/time on your XI server?

Yes the time was same before I disappointedly killed the server. I will try installing it again with the hope of better support

[mguthrie]

We're doing some hunting as to what could be causing this issue, could you post the following information for us?

# Linux Distribution and version?
# 32 or 64bit?
# VMware Image or Manual Install of XI?
# Are there specials configurations on your system, ie; is Gnome installed? Are you using a proxy? Are you using SSL?

[debrite]

Dear admin.

I think I also have the same problem. My first install on 64 bit OS and did not work. I finally change to 32 bits. I am using OS Redhat Enterprise 5.1.
and all always failed at the point ./ E-importnagiosql, where the error

ERROR: No files to import - exiting. Were Nagios Core and NagiosQL installed?
ERROR: NagiosQL import appears to have failed - exiting. (Reason: Nagios Core configuration is invalid)

and then I try to check the error log where when running. / E-importnagiosql there are errors

DB Connect Error [nagiosxi]: Database connection failed
Connecting ERROR TO DATABASES!

and I also have tried to do:
1.restart mysql
2.restart postgres
3.mysql Nagios-u -> checking for mysql login ability
4.psql nagiosxi nagiosxi -> checking abilities for postgres login

mysql-u Nagios
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 4 to server version: 5.0.22

Type 'help;' or '\ h' for help. Type '\ c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| Test |
+--------------------+
2 rows in set (0.00 sec)

mysql> exit
Bye

psql nagiosxi nagiosxi
Welcome to psql 8.1.9, the PostgreSQL interactive terminal.

Type: \ copyright for distribution terms
\ H for help with SQL commands
\? for help with psql commands
\ G or terminate with semicolon to execute query
\ Q to quit

nagiosxi => \ d
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+----------+ ----------
Public | if_command_id_seq | sequence | nagiosxi
Public | if_meta_id_seq | sequence | nagiosxi
Public | if_option_id_seq | sequence | nagiosxi
Public | if_sysstat_id_seq | sequence | nagiosxi
Public | if_user_id_seq | sequence | nagiosxi
Public | if_usermeta_id_seq | sequence | nagiosxi
Public | xi_commands | table | nagiosxi
Public | xi_commands_command_id_seq | sequence | nagiosxi
Public | xi_events | table | nagiosxi
Public | xi_events_event_id_seq | sequence | nagiosxi
Public | xi_meta | table | nagiosxi
Public | xi_meta_meta_id_seq | sequence | nagiosxi
Public | xi_options | table | nagiosxi
Public | xi_options_option_id_seq | sequence | nagiosxi
Public | xi_sysstat | table | nagiosxi
Public | xi_sysstat_sysstat_id_seq | sequence | nagiosxi
Public | xi_usermeta | table | nagiosxi
Public | xi_usermeta_usermeta_id_seq | sequence | nagiosxi
Public | xi_users | table | nagiosxi
Public | xi_users_user_id_seq | sequence | nagiosxi
(20 rows)

nagiosxi => \ q

uname-a
Linux localhost 2.6.18-53.el5PAE # 1 SMP Mon Oct 10 16:48:18 EDT 2007 i686 i686 i386 GNU / Linux

file / usr / bin / file
/ Usr / bin / file: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU / Linux 2.6.9, dynamically linked (uses shared libs), for GNU / Linux 2.6.9, stripped

Base on Manual Installation which the installation should be clean install, I had 2 times to re-install RedHat Enterprise OS , but still having the same problem.

I using " file-2011r1.1.tar.gz xi "
I already have an account on Nagios with username: BKN

Please your kind help.

Rgds
Fonda

[debrite]

Dear Admin,

I also experienced the same problem, which I've done 2 times reinstall its operating system for a clean install. I use the operating system, redhat enterprise 5.1 32bit.

where I've done:

1. restart mysql
2. restrat postgres
3.mysql Nagios-u -> checking for mysql login ability
4.psql nagiosxi nagiosxi -> checking abilities for postgres login

mysql-u Nagios
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 4 to server version: 5.0.22

Type 'help;' or '\ h' for help. Type '\ c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| Test |
+--------------------+
2 rows in set (0.00 sec)

mysql> exit
Bye

psql nagiosxi nagiosxi
Welcome to psql 8.1.9, the PostgreSQL interactive terminal.

Type: \ copyright for distribution terms
\ H for help with SQL commands
\? for help with psql commands
\ G or terminate with semicolon to execute query
\ Q to quit

nagiosxi => \ d
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+----------+ ----------
Public | if_command_id_seq | sequence | nagiosxi
Public | if_meta_id_seq | sequence | nagiosxi
Public | if_option_id_seq | sequence | nagiosxi
Public | if_sysstat_id_seq | sequence | nagiosxi
Public | if_user_id_seq | sequence | nagiosxi
Public | if_usermeta_id_seq | sequence | nagiosxi
Public | xi_commands | table | nagiosxi
Public | xi_commands_command_id_seq | sequence | nagiosxi
Public | xi_events | table | nagiosxi
Public | xi_events_event_id_seq | sequence | nagiosxi
Public | xi_meta | table | nagiosxi
Public | xi_meta_meta_id_seq | sequence | nagiosxi
Public | xi_options | table | nagiosxi
Public | xi_options_option_id_seq | sequence | nagiosxi
Public | xi_sysstat | table | nagiosxi
Public | xi_sysstat_sysstat_id_seq | sequence | nagiosxi
Public | xi_usermeta | table | nagiosxi
Public | xi_usermeta_usermeta_id_seq | sequence | nagiosxi
Public | xi_users | table | nagiosxi
Public | xi_users_user_id_seq | sequence | nagiosxi
(20 rows)

nagiosxi => \ q


uname-a
Ncsis.bkn.go.id Linux 2.6.18-53.el5PAE # 1 SMP Mon Oct 10 16:48:18 EDT 2007 i686 i686 i386 GNU / Linux

file / usr / bin / file
/ Usr / bin / file: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU / Linux 2.6.9, dynamically linked (uses shared libs), for GNU / Linux 2.6.9, stripped

We already have an account in Nagios with username: BKN
and use file-2011r1.1.tar.gz xi

thanks for your support.

Rgds
Fonda