Roundcube Community Forum

 

Roundcube on 10.8.5 Server Not Running

Started by dkrajc, September 17, 2014, 12:50:05 PM

Previous topic - Next topic

dkrajc

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

SKaero

Make sure the database service is running.

dkrajc

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$

dkrajc

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"?


SKaero

It looks like thats is your problem but I'm not too familiar with postgres so I can't be of much help.