Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

postgres/roundcube issues since 2.1.1

Since installation of the Server App 2.1.1 update, roundcube is no longer accessible. I get the following when attempting to login:


DB Error in /Library/Server/Web/Data/Sites/Default/webmail/program/include/rcube_mdb2.php (107): _doConnect: [Error message: unable to establish a connection]

[Native message: ]

** pgsql(pgsql)://roundcube:xxx@localhost/roundcubemail

Warning: session_start(): Cannot send session cache limiter - headers already sent in /Library/Server/Web/Data/Sites/Default/webmail/program/include/rcmail.php on line 784


I've attempted to create a new postgres database for roundcube to use, but in the end, the result was the same. The installation tests return the following result:


Check DB config

DSN (write): NOT OK(MDB2 Error: connect failed)

Make sure that the configured database exists and that the user has write privileges
DSN: pgsql://roundcube:xxx@localhost/roundcubemail


Additionally, I cannot seem to access port 5432 via telnet on the local server. I started looking at making changes to tge postgres configuration files: postgresql.conf and pg_hba.conf in /library/server/postgres/data


Note: everything worked perfectly before 2.1.1


Any help would be appreciated. I'm four hours into this with no results...

Mac mini, OS X Server

Posted on Oct 13, 2012 8:14 AM

Reply
Question marked as Best reply

Posted on Oct 13, 2012 8:24 AM

For everything not Apple I use a MySQL database because of the wide support and I suggest you do the same.


Download MySQL here:

http://www.mysql.com/downloads/mysql/


You'll want the following package:

Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive


I suggest you use the following program to administer MySQL:

MySQL Workbench (GUI Tool)

4 replies
Question marked as Best reply

Oct 13, 2012 8:24 AM in response to niwrik

For everything not Apple I use a MySQL database because of the wide support and I suggest you do the same.


Download MySQL here:

http://www.mysql.com/downloads/mysql/


You'll want the following package:

Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive


I suggest you use the following program to administer MySQL:

MySQL Workbench (GUI Tool)

Oct 15, 2012 11:32 AM in response to niwrik

For everything not Apple I use a MySQL database because of the wide support and I suggest you do the same.


Download MySQL here:

http://www.mysql.com/downloads/mysql/


You'll want the following package:

Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive


I suggest you use the following program to administer MySQL:

MySQL Workbench (GUI Tool)


(please mark this post as the answer to mark this question as answered)

postgres/roundcube issues since 2.1.1

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.