Nagios XI database was not setup properly error

[lmiltchev]

Creating role and database...
Sorry, user root is not allowed to execute...

Have you modified the sudoers file in any way? Can you show us the output of the command below?

Code: Select all

grep root /etc/sudoers | grep -v '^#'

[Berto]

Here is the requested output.

[root@lnsvr0615 nagiosxi]# grep root /etc/sudoers | grep -v '^#'
root ALL=(ALL) ALL

[ssax]

Please attach a full sanitized copy of your /etc/sudoers file.

[Berto]

Here is the requested file. Also, our environment uses LDAP for sudo so if your needing any of those files please let me know.

I had to add a .txt to the end of the file as uploading errors about the extension.

--Berto

[lmiltchev]

Also, our environment uses LDAP for sudo so if your needing any of those files please let me know.

This may be the reason why the installer script fails. It seems like the script chokes on "/tmp/nagiosxi/nagiosxi/create_postgres_db.sh" script, which runs:

Code: Select all

sudo -u postgres psql -c "create user nagiosxi with password 'n@gweb';"
sudo -u postgres psql -c "create database nagiosxi owner nagiosxi;

Can you run the following commands and show the output?

Code: Select all

grep postgres /etc/passwd
grep postgres /etc/group

[Berto]

Here is the requested output.

[root@lnsvr0615 ~]# grep postgres /etc/passwd
postgres26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash
[root@lnsvr0615 ~]# grep postgres /etc/group
postgres26:

[jdalrymple]

Berto,

A couple of suggestions...

1) Can you just `sudo su - postgres` to get a shell as the postgres user then run the 2 commands:

Code: Select all

psql -c "create user nagiosxi with password 'n@gweb';"
psql -c "create database nagiosxi owner nagiosxi;

Then edit /tmp/nagiosxi/nagiosxi/create_postgres_db.sh to comment out those bits:

Code: Select all

#!/bin/sh

# sudo -u postgres psql -c "create user nagiosxi with password 'n@gweb';"
# sudo -u postgres psql -c "create database nagiosxi owner nagiosxi;"

Then try to run fullinstall again.

2) Can you show us your /etc/nsswitch.conf?

[Berto]

I have uploaded the request file. I sudo to postgres and did as requested but not being to familiar with postgres, on the second command I get the following prompt back;

-bash-4.1$ psql -c "create database nagiosxi owner nagiosxi;
>

Thinking of just needing to quit I did \q but I still get the same prompt, is there something I else I should be doing?

--Berto

[Berto]

Running the fullinstall script again, I now get this error.

Checking PostgresQL status...
PostgresQL running - continuing...
Creating role and database...
User 'nagiosxi' created successfully.
ERROR: PostgresQL 'nagiosxi' database was not created - exiting.
ERROR: Nagios XI database was not setup properly - exiting.

--Berto

[jdalrymple]

psql -c "create database nagiosxi owner nagiosxi;

You forgot the close quote (")