Creating product directory...
Adding password for user nagiosadmin
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Stopping postgresql service: ^[[60G[^[[0;31mFAILED^[[0;39m]^M
Starting postgresql service: ^[[60G[^[[0;32m OK ^[[0;39m]^M
psql: FATAL: database "nagiosxi" does not exist
psql: FATAL: database "nagiosxi" does not exist
Note: You can usually ignore SQL import warning messages.
Building latest perms binary...
/tmp/nagiosxi/nagiosxi/basedir/scripts /tmp/nagiosxi
/tmp/nagiosxi
Step completed.
I got the psql service to restart and ran the script again. I was wondering if there was anything in my output that would be an error that was causing my grief?
[root@nagiosxi nagiosxi]# ./B-installxi
Creating product directory...
Adding password for user nagiosadmin
CREATE ROLE
CREATE DATABASE
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
SET
ERROR: parameter "standard_conforming_strings" cannot be changed
SET
SET
SET
ERROR: must be owner of schema public
SET
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
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
SET
ERROR: parameter "standard_conforming_strings" cannot be changed
SET
SET
SET
SET
setval
--------
20
(1 row)
setval
--------
16
(1 row)
setval
--------
25
(1 row)
setval
--------
15
(1 row)
setval
--------
14
(1 row)
setval
--------
142
(1 row)
setval
--------
53
(1 row)
setval
--------
21
(1 row)
setval
--------
33
(1 row)
setval
--------
28
(1 row)
setval
--------
170
(1 row)
setval
--------
25
(1 row)
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
Note: You can usually ignore SQL import warning messages.
Building latest perms binary...
/tmp/nagiosxi/nagiosxi/basedir/scripts /tmp/nagiosxi
/tmp/nagiosxi
Step completed.
I checked with our proxy administrator and it seems that everything is going through the proxy well.
I am running the scripts in the /tmp directory. I started from fresh install and ran through all the scripts. Here is what I got on the B-installxi the first time.
Creating product directory...
Adding password for user nagiosadmin
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Stopping postgresql service: [FAILED]
Starting postgresql service: [ OK ]
psql: FATAL: database "nagiosxi" does not exist
psql: FATAL: database "nagiosxi" does not exist
Note: You can usually ignore SQL import warning messages.
Building latest perms binary...
/tmp/nagiosxi/nagiosxi/basedir/scripts /tmp/nagiosxi
/tmp/nagiosxi
Step completed.
I got the service to restart and ran the script again.
[root@nagiosxi nagiosxi]# ./B-installxi
Creating product directory...
Adding password for user nagiosadmin
CREATE ROLE
CREATE DATABASE
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
SET
ERROR: parameter "standard_conforming_strings" cannot be changed
SET
SET
SET
ERROR: must be owner of schema public
SET
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
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
SET
ERROR: parameter "standard_conforming_strings" cannot be changed
SET
SET
SET
SET
setval
--------
20
(1 row)
setval
--------
16
(1 row)
setval
--------
25
(1 row)
setval
--------
15
(1 row)
setval
--------
14
(1 row)
setval
--------
142
(1 row)
setval
--------
53
(1 row)
setval
--------
21
(1 row)
setval
--------
33
(1 row)
setval
--------
28
(1 row)
setval
--------
170
(1 row)
setval
--------
25
(1 row)
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
Note: You can usually ignore SQL import warning messages.
Building latest perms binary...
/tmp/nagiosxi/nagiosxi/basedir/scripts /tmp/nagiosxi
/tmp/nagiosxi
Step completed.
The webpage doesn't have any colors and the access nagiosxi link is broken.
The proxy is probably blocking PHP's connection to mysql. It uses localhost port 3306 (I think) to connect to it. Is the proxy set up to allow traffic for both mysql and postgresql?
If you've got the proxy turned off, I strongly recommend starting from the beginning of the install scripts. I know it's a bit of a pain, but it's the best way to be sure. Also, (this may be obvious but we've had recent problems with it), make sure you're install of RHEL is registered with the RHN (Redhat Network) because if it's not you won't have access to their repos and you'll be missing a lot of the required packages.
The proxy isn't off, I just took it out of all the settings so the server won't use it to get to localhost. I have ran through the scripts a number of times after rebuilding the server. I have saved the output of all the scripts that I ran. I have checked with the proxy admin to see if I am getting any traffic blocked or if there is any traffic that is not using the proxy. We will buy this product if I can get it running in our environment. It is costing more money than its worth to try and troubleshoot the issues that I'm having. I'm about out of options and will look for a different product. I tried calling someone at the nagios contact and left voice mail and haven't heard back from anyone. I believe our issue is more difficult than being able to troubleshoot over a general forum. If there is anyway that I can talk to someone that could get us over this issue? I will buy if I can get it running.
I didn't. I assumed that the scripts from nagiosxi would have everything. I will start over with a new server, install nagios core, and let you know how it works out.