[horde] Troubleshooting CalDav

[Brian Spraker]

      From: Michael J Rubinsky <mrubinsk at horde.org>
 To: horde at lists.horde.org 
 Sent: Friday, March 4, 2016 10:14 AM
 Subject: Re: [horde] Troubleshooting CalDav
   

Quoting Brian Spraker <spraker at yahoo.com>:

> From: Jan Schneider <jan at horde.org>
>  To: horde at lists.horde.org
>  Sent: Friday, March 4, 2016 3:49 AM
>  Subject: Re: [horde] Troubleshooting CalDav
>
>
> Zitat von Brian Spraker <spraker at yahoo.com>:
>
>> Using GroupWare 5.2.12.
>>
>> Attempting to connect a Thunderbird mail client to CalDAV.
>> Went into the Share settings in Horde to get the CalDAV Subscription 
>> URL.Entered this into Thunderbird as  Network Calendar under the 
>> CalDAV option.Popup box asked for the username and password for the 
>> user, which was entered.Thunderbird says that the calendar is 
>> 'momentarily unavailable'.Looking at the server logs, I see these 
>> three connections:
>> PROPFIND <URL> HTTP/1.1 207 1359OPTIONS <URL> HTTP/1.1 200 
>> 826PROPFIND <URL> HTTP/1.1 500 775
>> So an internal server error seems to be occurring as the last 
>> connection and it fails.  Nothing in the horde log.
>> I then took the WebDAV/iCS Subscription URL and put it into my web 
>> browser.  XML file came up saying permission is denied.
>> Went to the Sharing settings of the calendar and turned on sharing 
>> to be public (although I really don't like that idea).  Refreshed 
>> that WebDAV/iCS link and it still said permission denied.   
>> Sharing 
>> was then turned back off.
>> Brian S.
>
> Make sure that you copied the URL from the user that you shared the 
> calendar with, not from the user that shared the calendar. And of 
> course make sure to use the credentials in Thunderbird of the user 
> that you shared with too.
>
> --
> Jan Schneider
> The Horde Project
> http://www.horde.org/
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
> I believe the problem has been partially fixed.  I now get  
> prompted to download the ICS file if I put in the WebDAV/iCS link in  
> a web browser.  Upon opening, the iCS file does have all of the  
> items in it.
> I no longer have the message in Thunderbird saying that the calendar  
> is momentarily unavailable.  However, the CalDAV link doesn't  
> appear to be loading anything into Thunderbird; the calendar is  
> empty in Thunderbird.
>
> The permission denied issue - the "share_owner" row in the  
> kronolith_shares table had a capital letter to start off.  This  
> has been an issue with other customers in the past where they login  
> and get 'permission denied' when trying to look at their  
> calendars.  If their username is any different when they login  
> versus what shows in the database case-sensitive wise, it doesn't  
> work.
> Is there any 'long term' fix for ensuring that Horde doesn't check  
> the case sensitive username?

Yes, in current stable code you need to utilize a username hook to  
normalize the usernames if your auth backend is not case sensitive but  
your sql storage is. See horde/config/hooks.php for more information.

In Horde 6 there is an option to always lowercase usernames, negating  
the need for this hook.



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject

-- 
Horde mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org

Thank you for the note on the hooks.  I have uncommented the proper items in the hooks.php.dist file and renamed it to hooks.php.  Attempted to login with a mix of upper and lowercase letters and it still works with the calendars.
I also did get the CalDAV to finally work as well.  Didn't do anything different other than unsubscribing from the calendar in Thunderbird and re-setting it back up again.
Brian S.