Nagios Support Forum

Anybody experienced any issue on creating postgres db structure?
Here are the errors I have got:
1. SET standard_conforming_strings = off;

ERROR: parameter "standard_conforming_strings" cannot be changed

2. COMMENT ON SCHEMA public IS 'Standard public schema';

ERROR: must be owner of schema public

3. ALTER SEQUENCE xi_events_event_id_seq OWNED BY xi_event.event_id;


ERROR: syntax error at or near "OWNED" at character 39
LINE 1: ALTER SEQUENCE xi_events_event_id_seq OWNED BY xi_event.eve...
^

4. REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO 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

_____________________________________________________________
Then at the part to load initial postgres data, i am getting these errors...


ERROR: duplicate key violates unique constraint "xi_options_pkey"
.
.
.
ERROR: duplicate key violates unique constraint "xi_sysstat_pkey"
.
.
.
ERROR: duplicate key violates unique constraint "xi_usermeta_pkey"
ERROR: duplicate key violates unique constraint "xi_usermeta_pkey"
ERROR: duplicate key violates unique constraint "xi_users_pkey"

_________________________________________________________
Lastly, the final two lines to fix permissions on config files. The path is directing to nagios directory, not nagiosxi. Is there a typo on the script?


chown: cannot access '/usr/local/nagios/etc/hosts/*.cfg': No such file or directory
chown: cannot access '/usr/local/nagios/etc/services/*.cfg': No such file or directory

Did anyone get the same error? I don't want to proceed since I am not sure what consequences may come from this.

I did have problems at 3-dbservers script, it didn't let me initialize postgresql.(see post: http://support.nagios.com/forum/viewtop ... &t=91#p605) Someone suggested to remove /var/lib/pgsql/data folder. That seemed to fixed it, but i wonder if that was the proper way to do it. I don't know if that has caused all the above issues at B-installxi.

Any help would be appreciated. Thanks!

The postgres errors can safely be ignored from what we've seen in the past.

The chown commands that are failing might be indicative of a problem. The files that should have had their permissions reset should have been installed when you ran the ./A-subcomponents command. Verify the files exist with the following command:

ls -al /usr/local/nagios/etc