Page 2 of 2
Re: DB Connect Error [nagiosxi]: Database connection failed
Posted: Tue Nov 27, 2012 3:20 pm
by 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
Re: DB Connect Error [nagiosxi]: Database connection failed
Posted: Tue Nov 27, 2012 3:26 pm
by 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
Re: DB Connect Error [nagiosxi]: Database connection failed
Posted: Tue Nov 27, 2012 3:59 pm
by scottwilkerson
fixed via remote session with