Installing Roundcube with postgres

seems like you are

a bout 3

minutes away from deleting server

and reinstalling from the app store

:)

i had some issues with server after upgrade to 2.2 also.

those errors sound like the interaction with one of the other services.

1. try turning off all services in server.

2. turn on one at a time ( dns first )

3. check system log after each service and check for errors. leave web services until last.

Its nothing to do with the posted topic so i would suggest you post a new topic to get help from the broader community.

Good luck!

Thanks for that. I removed the plist file I had created in /Library/Server/Web/Config/apache2/webapps and it seems to have restored the Web and Wiki panes in Server App, however now my Calendar service is permanently on and won't turn off. Any ideas for a fix? What is the Console log for calendar? Is it caldavd? Thanks

Permanently on? After a restart? You have tried a restart, right?

/var/log/caldav/error.log

fully automated roundcube installer

http://topicdesk.com/downloads/roundcube

This is an automated installation of Roundcube.

It configures postgres, initializes the database, installs mcrypt and configures a Roundcube WebApp.

About 2 minutes to install, at the end it will load your default site (/mail) with Rouncube working.

This installation includes managesieve (vacation filters, etc) pre-configured..

Here is the log file:

2013-02-22 15:04:43+1300 [-] Log opened.

2013-02-22 15:04:43+1300 [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:43+1300 [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:43+1300 [-] ControlSocket starting on '/var/run/caldavd.sock'

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Migrating locations and resources

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Upgrading to version 1

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Moving calendar homes to /Library/Server/Calendar and Contacts/Data/Documents/calendars/__uids__

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Processing 2 calendar homes in /Library/Server/Calendar and Contacts/Data/Documents/calendars/__uids__

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Done processing calendar homes

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Fetching delegate assignments and auto-schedule settings from directory

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] No resource info found in directory

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Upgraded to version 1

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Upgrading to version 2

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Regular collection hidden: /Library/Server/Calendar and Contacts/Data/Documents/calendars/__uids__/67/2B/672B3EF4-0341-4CA9-9751-41B1FD 1D36FA/inbox

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Regular collection hidden: /Library/Server/Calendar and Contacts/Data/Documents/calendars/__uids__/DC/12/DC124B82-F619-490A-AFB2-DDE6C0 570D05/inbox

2013-02-22 15:04:43+1300 [-] [twistedcaldav.upgrade#warn] Upgraded to version 2

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaService#warn] Beginning database schema check.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaService#warn] Required database key VERSION: 12.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaService#warn] Actual database key VERSION: 12.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaService#warn] Schema version check complete: no upgrade needed.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaService#warn] Database schema check complete.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseDataService#warn] Beginning database data check.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseDataService#warn] Required database key CALENDAR-DATAVERSION: 3.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseDataService#warn] Actual database key CALENDAR-DATAVERSION: 3.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseDataService#warn] Data version check complete: no upgrade needed.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseDataService#warn] Database data check complete.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.migrate.UpgradeToDatabaseService#warn] Beginning filesystem -> database upgrade.

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.migrate.UpgradeToDatabaseService#warn] Migrating calendar UID '672B3EF4-0341-4CA9-9751-41B1FD1D36FA'

2013-02-22 15:04:43+1300 [-] [txdav.common.datastore.upgrade.migrate.UpgradeToDatabaseService#warn] Starting migration transaction calendar UID '672B3EF4-0341-4CA9-9751-41B1FD1D36FA'

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.caldav.datastore.sql.CalendarHome#warn] Splitting calendars for user 672B3EF4-0341-4CA9-9751-41B1FD1D36FA

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.caldav.datastore.sql.CalendarHome#warn] Calendar: 'calendar', split into 1

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.common.datastore.upgrade.migrate.UpgradeToDatabaseService#warn] Migrating calendar UID 'DC124B82-F619-490A-AFB2-DDE6C0570D05'

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.common.datastore.upgrade.migrate.UpgradeToDatabaseService#warn] Starting migration transaction calendar UID 'DC124B82-F619-490A-AFB2-DDE6C0570D05'

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.caldav.datastore.sql.CalendarHome#warn] Splitting calendars for user DC124B82-F619-490A-AFB2-DDE6C0570D05

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.caldav.datastore.sql.CalendarHome#warn] Calendar: 'calendar', split into 1

2013-02-22 15:04:44+1300 [PooledMemCacheProtocol,client] [txdav.common.datastore.upgrade.migrate.UpgradeToDatabaseService#warn] Filesystem upgrade complete, launching database service.

2013-02-22 15:04:45+1300 [-] [twistedcaldav.database#error] Database Proxies has different schema (v.3 vs. v.4)

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8008

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8800

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8443

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8843

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8008

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8800

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8443

2013-02-22 15:04:45+1300 [-] LimitingInheritingProtocolFactory starting on 8843

2013-02-22 15:04:45+1300 [-] Factory starting on 7654

2013-02-22 15:04:47+1300 [-] [notifications] 2013-02-22 15:04:47+1300 [-] Log opened.

2013-02-22 15:04:47+1300 [-] [notifications] 2013-02-22 15:04:47+1300 [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:47+1300 [-] [notifications] 2013-02-22 15:04:47+1300 [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:47+1300 [-] [notifications] 2013-02-22 15:04:47+1300 [-] AMPPushNotifierFactory starting on 62311

2013-02-22 15:04:47+1300 [-] [notifications] 2013-02-22 15:04:47+1300 [-] InternalNotificationFactory starting on 62309

2013-02-22 15:04:47+1300 [-] [notifications] 2013-02-22 15:04:47+1300 [-] set uid/gid 93/93

2013-02-22 15:04:47+1300 [-] [groupcacher] 2013-02-22 15:04:47+1300 [-] Log opened.

2013-02-22 15:04:47+1300 [-] [groupcacher] 2013-02-22 15:04:47+1300 [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:47+1300 [-] [groupcacher] 2013-02-22 15:04:47+1300 [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:47+1300 [-] [groupcacher] 2013-02-22 15:04:47+1300 [-] set uid/gid 93/93

2013-02-22 15:04:47+1300 [-] [groupcacher] 2013-02-22 15:04:47+1300 [-] [twistedcaldav.directory.directory.GroupMembershipCacherService#warn] Starting group membership cacher service

2013-02-22 15:04:48+1300 [-] [caldav-3] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-3] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-3] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-3] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-3] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [notifications] 2013-02-22 15:04:48+1300 [-] Starting factory <twext.internet.adaptendpoint.LegacyClientFactoryWrapper instance at 0x109966cf8>

2013-02-22 15:04:48+1300 [-] [notifications] 2013-02-22 15:04:48+1300 [-] Starting factory <twext.internet.adaptendpoint.LegacyClientFactoryWrapper instance at 0x109964a70>

2013-02-22 15:04:48+1300 [-] [caldav-7] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-7] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-7] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-7] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-7] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [caldav-2] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-2] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-2] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-2] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-2] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [caldav-6] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-6] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-6] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-6] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-6] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [caldav-0] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-0] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-0] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-0] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-0] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [caldav-5] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-5] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-5] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-5] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-5] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [caldav-1] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-1] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-1] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-1] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-1] [-] set uid/gid 93/93

2013-02-22 15:04:48+1300 [-] [caldav-4] Reading configuration from file: /Library/Server/Calendar and Contacts/Config/caldavd.plist

2013-02-22 15:04:48+1300 [-] [caldav-4] [-] Log opened.

2013-02-22 15:04:48+1300 [-] [caldav-4] [-] twistd 12.0.0 (/System/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/ Contents/MacOS/Python 2.7.2) starting up.

2013-02-22 15:04:48+1300 [-] [caldav-4] [-] reactor class: twext.internet.kqreactor.KQueueReactor.

2013-02-22 15:04:48+1300 [-] [caldav-4] [-] set uid/gid 93/93

2013-02-22 15:45:44+1300 [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-6] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-4] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-7] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-5] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-2] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-3] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] (TCP Port 8843 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8443 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8800 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8008 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8843 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8443 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8800 Closed)

2013-02-22 15:45:44+1300 [-] (TCP Port 8008 Closed)

2013-02-22 15:45:44+1300 [-] (UNIX Port '/var/run/caldavd.sock' Closed)

2013-02-22 15:45:44+1300 [-] [caldav-6] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-6] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [caldav-4] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-4] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [caldav-2] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-2] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [caldav-3] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-3] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [caldav-0] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-0] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-0] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [caldav-1] [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [caldav-1] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-1] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [-] (TCP Port 62309 Closed)

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [-] (TCP Port 62311 Closed)

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [APNProviderProtocol (TLSMemoryBIOProtocol),client] Stopping factory <twext.internet.adaptendpoint.LegacyClientFactoryWrapper instance at 0x109966cf8>

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [APNProviderProtocol (TLSMemoryBIOProtocol),client] Stopping factory <twext.internet.adaptendpoint.LegacyClientFactoryWrapper instance at 0x109964a70>

2013-02-22 15:45:44+1300 [-] [caldav-5] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-5] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [groupcacher] 2013-02-22 15:45:44+1300 [-] Received SIGTERM, shutting down.

2013-02-22 15:45:44+1300 [-] [groupcacher] 2013-02-22 15:45:44+1300 [-] [twistedcaldav.directory.directory.GroupMembershipCacherService#warn] Stopping group membership cacher service

2013-02-22 15:45:44+1300 [-] [caldav-7] [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [caldav-7] [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [notifications] 2013-02-22 15:45:44+1300 [-] Server Shut Down.

2013-02-22 15:45:44+1300 [-] [groupcacher] 2013-02-22 15:45:44+1300 [-] Main loop terminated.

2013-02-22 15:45:44+1300 [-] [groupcacher] 2013-02-22 15:45:44+1300 [-] Server Shut Down.

2013-02-22 15:45:45+1300 [twisted.internet.protocol.Factory] (TCP Port 7654 Closed)

2013-02-22 15:45:45+1300 [-] Main loop terminated.

2013-02-22 15:45:45+1300 [-] Server Shut Down.

If I install this will it fix my original problem (see above for error)?

@Rikki Sixx

It looks like your original issue is an error reading web settings in Server.app.

You may want to try deleted all sites and recreating them.

You may also want to delete all .prev files from

/Library/Server/Web/Config/apache/Sites

the topicdesk-Rouncube installer won't solve your website configuration issue.

Wow! UptimeJeff you are f**kin awesome. This installer is great.Couple of clicks and voila... I have webmail. Thank you sooooooo much. You are a God, legend and all together Apple Guru. I salute you and your efforts. Great work man.

Just one question, where does this install the Roundcube directory?

Hey Rikki

You will find the install at:

/usr/local/topicdesk/roundcube/WebApp

Its installed as a webapp, so you can enable/diable the webapp per site (server.app, web, sites, advanced settings)

If you prefer, you can copy the install to another location.. so if you roundcube installed within a directory if your default website, you can move our version to the same path.

Jeff

Thanks Jeff. Will you be adding instructions on how to update the version of Roundcube to the latest once this version is installed?

You can upgrade anytime with the standard roundcube upgrade directions..

We are wrapping up the v0.9.4 installer. If topicdesk-roundcube v0.9.0 is detected, it will update it to 0.9.4.

Jeff

I'd like to add a quick "thank you" for this. Worked well. For a reason I could never diagnose, my manual setup using Mysql wouldn't ever connect.

So thanks again

@nick101

I'm glad this worked out well for you... Very nice to hear :-)

Jeff