Everyone,
Up until yesterday the Rounccube install on a 10.8.5 server was running correctly. The computer was restarted and now every time some tries to connect to the web interface the get the:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
I inherited this server, so I am not sure how everything was set up. I went to /usr/local/topicdesk/roundcube/0.9.5a/logs/errors in the error log being repeated is the following:
could not connect to server: Connection refused
Is the server running on host "localhost" (fe80::1) and accepting
TCP/IP connections on port 5432? in /usr/local/topicdesk/roundcube/0.9.5a/program/lib/Roundcube/rcube_db.php on line 158 (GET /roundcube/)
[17-Sep-2014 12:38:26 -0400]: DB Error: SQLSTATE[08006] [7] could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (fe80::1) and accepting
TCP/IP connections on port 5432? (GET /roundcube/)
[17-Sep-2014 12:39:05 -0400]: DB Error: SQLSTATE[08006] [7] could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
I am not sure how to get the database to reconnect back. I have yet to try to restart the server to see if that solves the issue.
Any help would be greatly appreciated.
Thanks
Dan
Make sure the database service is running.
Here is what I get when I run sudo serveradmin fullstatus postgres:
postgres:dataDirHasBeenInitialized = yes
postgres:PG_VERSION = "9.2.1"
postgres:dataDir = "/Library/Server/PostgreSQL/Data"
postgres:postgresIsResponding = no
postgres:dataDirIsDirectory = yes
postgres:PGserverVersion = 0
postgres:dataDirExists = yes
postgres:setStateVersion = 1
postgres:state = "RUNNING"
mail:~ ladmin$
Just tried to list the databases and got the following:
ail:~ ladmin$ sudo psql -U _postgres --list
Password:
psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
It looks like thats is your problem but I'm not too familiar with postgres so I can't be of much help.