Apple’s Worldwide Developers Conference returns June 10, 2024

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

Level 1

19 points

Calendar broken after Lion to Mavericks server update

I updated from a working Lion Server setup to Mavericks, then installed the Mavericks Server tools. Now calendars don't work anymore.

- Can't connect with Lion Calendar app

- Can't connect with Mavericks Calendar app

- Can't connect with iOS Calendar app

- Can't connect with Maverick Server Calendar Webapp

All I get is a 500 error code with CalDAVAccountRefreshQueueableOperation

In the caldav log I see errors like:

pg.ProgrammingError: ERROR: column "default_events" does not exist

pg.ProgrammingError: ERROR: relation "imip_invitation_work" does not exist

I tried all kind of things, absolutely lost. I try now to go back to Lion. Can please someone at apple help me? Did someone test upgrading from Lion?

Posted on Oct 25, 2013 5:58 AM

22 replies

Oct 29, 2013 5:27 AM in response to _morgen__

When I do a traceroute for those ports they take me to the server. I should mention all the other services are still working, it's just caldav.

I tried http://officeserver.yourcreativepeople.com:8008 and https://officeserver.yourcreativepeople.com:8443 and I don't get any response. Just hangs for a long time then fails to open page.

I have been trying to connect with iCal and the iOS calendar. They also hang for a long time. Then tell me a secured server cannot be found and ask if I want to look for a unsecure server, and then return an unknown error. We have always had the secure sever pop-up.

_morgen__

Level 1

140 points

Oct 29, 2013 5:42 AM in response to keyboardboy1

Try changing the logging level to "debug" via:

sudo calendarserver_config DefaultLogLevel=debug

Then watch /var/log/caldavd/error.log while you try to connect to port 8008 and 8443 using curl.

(Afterwards you can change the log level back with "sudo calendarserver_config DefaultLogLevel=warn")

Oct 30, 2013 7:31 AM in response to gnaegi

following my results from various commands you provided. thank you very much!

sudo psql -h /var/run/caldavd/ccs_postgres_3d403b3009fe0c830944d87bd751fbe9 -d caldav -U caldav

psql (9.2.4)

Type "help" for help.

caldav=# select calendar_resource_id from calendar_bind where calendar_resource_name is null;

calendar_resource_id

----------------------

711

467

711

1206

711

368

383

307

1206

711

1206

711

connecting to the ical server

curl -vv -k https://***:8443/

* Adding handle: conn: 0x7fb10b00aa00

* Adding handle: send: 0

* Adding handle: recv: 0

* Curl_addHandleToPipeline: length: 1

* - Conn 0 (0x7fb10b00aa00) send_pipe: 1, recv_pipe: 0

* About to connect() to *** port 8443 (#0)

* Trying ***...

* Connected to *** () port 8443 (#0)

* SSL 3.0 connection using TLS_RSA_WITH_AES_128_CBC_SHA

* Server certificate:

* Server certificate: COMODO High-Assurance Secure Server CA

* Server certificate: AddTrust External CA Root

> GET / HTTP/1.1

> User-Agent: curl/7.30.0

> Host: ***:8443

> Accept: */*

< HTTP/1.1 401 Unauthorized

< Content-Length: 141

* Server Twisted/12.2.0 TwistedWeb/9.0.0 is not blacklisted

< Server: Twisted/12.2.0 TwistedWeb/9.0.0

< DAV: 1, access-control, calendar-access, calendar-schedule, calendar-auto-schedule, calendar-availability, inbox-availability, calendar-proxy, calendarserver-private-events, calendarserver-private-comments, calendarserver-sharing, calendarserver-sharing-no-scheduling, calendar-query-extended, calendar-default-alarms, calendar-managed-attachments, calendarserver-partstat-changes, extended-mkcol, calendarserver-principal-property-search, calendarserver-principal-search, calendarserver-home-sync

< Date: Wed, 30 Oct 2013 14:25:43 GMT

< Strict-Transport-Security: max-age=604800

< WWW-Authenticate: digest nonce="02e398a35ef4690d76e99281", realm="***", opaque="a342f21efcb3b72e5b88d7fac069e4fb-MDJlMzk4YTM1ZWY0NjkwZDc2ZTk5MjgxLDMxLj I0LjE0LjI0MiwxMzgzMTQzMTQz", algorithm="md5"

< Content-Type: text/html;charset=utf-8

< Connection: close

* Closing connection 0

<html><head><title>Unauthorized</title></head><body><h1>Unauthorized</h1><p>You are not authorized to access this resource.</p></body></html>

on the client i get a status code "500" CalDAVAccountRefreshQueueableOperation as soon as the iCal has connected to the server.

_morgen__

Level 1

140 points

Oct 30, 2013 9:18 AM in response to ives.leutenegger

Ok, running these two sql statements within psql should clean up the bad data:

update CALENDAR_BIND set CALENDAR_RESOURCE_NAME = 'Shared_' || CALENDAR_RESOURCE_ID || '_' || CALENDAR_HOME_RESOURCE_ID where CALENDAR_RESOURCE_NAME is null;

update ADDRESSBOOK_BIND set ADDRESSBOOK_RESOURCE_NAME = 'Shared_' || ADDRESSBOOK_RESOURCE_ID || '_' || ADDRESSBOOK_HOME_RESOURCE_ID where ADDRESSBOOK_RESOURCE_NAME is null;

The problem data is left over from the Lion Server era with calendars that had been shared to someone else but never accepted by the recipient.

Oct 30, 2013 9:55 AM in response to _morgen__

Thank you so much! I does work again! Wohooo ! 🙂

jake11

Level 1

34 points

Dec 3, 2013 12:40 PM in response to _morgen__

Trying to follow the steps outlined here for troubleshooting this issue. Where do I find the value to "replace the ccs_postgres_NNN value above with whatever is on your server"

I guess I need the postgres NNN value?

Thanks in advance!

_morgen__

Level 1

140 points

Dec 3, 2013 1:47 PM in response to jake11

Look in the /var/run/caldavd directory -- you should see a ccs_postgres_ directory in there.

Calendar broken after Lion to Mavericks server update