Author Topic: Roundcube on 10.8.5 Server Not Running  (Read 3010 times)

Offline dkrajc

  • Newbie
  • *
  • Posts: 3
Roundcube on 10.8.5 Server Not Running
« on: September 17, 2014, 12:50:05 PM »
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

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,882
    • SKaero - Custom Roundcube development
Re: Roundcube on 10.8.5 Server Not Running
« Reply #1 on: September 17, 2014, 01:26:17 PM »
Make sure the database service is running.

Offline dkrajc

  • Newbie
  • *
  • Posts: 3
Re: Roundcube on 10.8.5 Server Not Running
« Reply #2 on: September 17, 2014, 03:16:26 PM »
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$

Offline dkrajc

  • Newbie
  • *
  • Posts: 3
Re: Roundcube on 10.8.5 Server Not Running
« Reply #3 on: September 17, 2014, 03:29:22 PM »
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"?


Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,882
    • SKaero - Custom Roundcube development
Re: Roundcube on 10.8.5 Server Not Running
« Reply #4 on: September 17, 2014, 04:32:54 PM »
It looks like thats is your problem but I'm not too familiar with postgres so I can't be of much help.