DB Connect Error [nagiosxi]: Database connection failed

[scottwilkerson]

don't rerun the install, that will not help.

Lets run the following

Code: Select all

ls -l /tmp/.s.PGSQL.5432.lock
tail /var/lib/pgsql/pgstartup.log
chage -l postgres

[mcwhorts]

Here is what I get after running those commands:

ls -l /tmp/.s.PGSQL.5432.lock
ls: /tmp/.s.PGSQL.5432.lock: No such file or directory
watcher-root--> tail /var/lib/pgsql/pgstartup.log
FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
/etc/profile: line 39: HISTSIZE: readonly variable
/etc/profile: line 60: HISTCONTROL: readonly variable
/etc/profile: line 61: HISTFILE: readonly variable
/etc/profile: line 62: HISTFILESIZE: readonly variable
/etc/profile: line 63: HISTIGNORE: readonly variable
/etc/profile: line 64: HISTSIZE: readonly variable
/etc/profile: line 65: HISTTIMEFORMAT: readonly variable
/etc/profile: line 79: PROMPT_COMMAND: readonly variable
FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
watcher-root--> chage -l postgres
Last password change : May 25, 2010
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : -1
Maximum number of days between password change : -1
Number of days of warning before password expires : -1

[scottwilkerson]

fixed via remote session with

Code: Select all

chmod 777 /tmp