[kronolith] Problems with Free/Busy URL

Tue Nov 19 15:51:18 UTC 2013

Zitat von Jens Grüntjes <jens.gruentjes at ebira.de>:

> Zitat von Jan Schneider <jan at horde.org>:
>
>> Zitat von Jens Grüntjes <jens.gruentjes at ebira.de>:
>>
>>> Zitat von Jan Schneider <jan at horde.org>:
>>>
>>>> Zitat von Jens Grüntjes <jens.gruentjes at ebira.de>:
>>>>
>>>>> Zitat von Michael J Rubinsky <mrubinsk at horde.org>:
>>>>>> Jens Grüntjes <jens.gruentjes at ebira.de> wrote:
>>>>>>
>>>>>> Quoting Jens Grüntjes <jens.gruentjes at ebira.de>
>>>>>>
>>>>>>> Zitat von Michael J Rubinsky <mrubinsk at horde.org>:
>>>>>>>
>>>>>>>> Quoting Jens Grüntjes <jens.gruentjes at ebira.de>:
>>>>>>>>
>>>>>>>>> Zitat von Michael J Rubinsky <mrubinsk at horde.org>:
>>>>>>>>>
>>>>>>>>>> Quoting Jens Grüntjes <jens.gruentjes at ebira.de>:
>>>>>>>>>>
>>>>>>>>>>> Hello folks,
>>>>>>>>>>>
>>>>>>>>>>> I'm a bit confused about the free/busy URLs in Kronolith.  
>>>>>>>>>>> I'm using the latest PEAR packages of Horde Groupware  
>>>>>>>>>>> 5.1.3 along with Kronolith 4.1.4.
>>>>>>>>>>>
>>>>>>>>>>> When I enter an event in Kronolith and I want to invite a  
>>>>>>>>>>> colleague to this event the following happens:
>>>>>>>>>>>
>>>>>>>>>>> The timeline of the whole day consists of nothing but  
>>>>>>>>>>> black diagonal lines for me and my colleague.
>>>>>>>>>>>
>>>>>>>>>>> I see a yellow "popup" in the browser saying "Die  
>>>>>>>>>>> Frei/Gebucht-URL für user.xxxx at xxxx.xx konnte nicht  
>>>>>>>>>>> gelesen werden." (English: The free/busy url for  
>>>>>>>>>>> user.xxxx at xxxx.xx cannot be retrieved.)
>>>>>>>>>>>
>>>>>>>>>>> According to this the logfile says:
>>>>>>>>>>> 2013-11-15T22:29:22+01:00 DEBUG: HORDE [kronolith] Die  
>>>>>>>>>>> Frei/Gebucht-URL für xxxxx.yyyy at yyyy.zz konnte nicht  
>>>>>>>>>>> gelesen werden. [pid 22637 on line 27 of  
>>>>>>>>>>> "/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
>>>>>>>>>>>
>>>>>>>>>>> The same message appears for my own user which is  
>>>>>>>>>>> automagically added as attendee.
>>>>>>>>>>>
>>>>>>>>>>> I have marked the entry for myself in a shared address  
>>>>>>>>>>> book as my own entry. Also I have added the Free/Busy URL  
>>>>>>>>>>> for me and my colleague in Turba.
>>>>>>>>>>>
>>>>>>>>>>> If I enter the address of my Free/Busy URL in the browser  
>>>>>>>>>>> I can download a file that looks like this:
>>>>>>>>>>>
>>>>>>>>>>> BEGIN:VCALENDAR
>>>>>>>>>>> VERSION:2.0
>>>>>>>>>>> PRODID:-//The Horde Project//Kronolith H5 (4.1.4)//EN
>>>>>>>>>>> METHOD:PUBLISH
>>>>>>>>>>> BEGIN:VFREEBUSY
>>>>>>>>>>> ORGANIZER;CN="Jens ZZZZZ":mailto:xxxx.yyyy at xxxx.yy
>>>>>>>>>>> DTSTAMP:20131115T202200Z
>>>>>>>>>>> DTSTART:20131114T230000Z
>>>>>>>>>>> DTEND:20131214T230000Z
>>>>>>>>>>> URL:https://xxxx.xxxxx.xxx/horde/kronolith/fb.php?u=xxxx
>>>>>>>>>>> FREEBUSY:20131118T170000Z/20131118T183000Z
>>>>>>>>>>> FREEBUSY:20131121T070000Z/20131121T090000Z
>>>>>>>>>>> FREEBUSY:20131125T183000Z/20131125T223000Z
>>>>>>>>>>> FREEBUSY:20131126T100000Z/20131126T133000Z
>>>>>>>>>>> END:VFREEBUSY
>>>>>>>>>>> END:VCALENDAR
>>>>>>>>>>>
>>>>>>>>>>> The same for my colleague:
>>>>>>>>>>> BEGIN:VCALENDAR
>>>>>>>>>>> VERSION:2.0
>>>>>>>>>>> PRODID:-//The Horde Project//Kronolith H5 (4.1.4)//EN
>>>>>>>>>>> METHOD:PUBLISH
>>>>>>>>>>> BEGIN:VFREEBUSY
>>>>>>>>>>> ORGANIZER;CN=Michael XXXXX:mailto:xxxxx.yyyy at xxx.yy
>>>>>>>>>>> DTSTAMP:20131115T212445Z
>>>>>>>>>>> DTSTART:20131114T230000Z
>>>>>>>>>>> DTEND:20131214T230000Z
>>>>>>>>>>> URL:https://xxxxx.yyy.zz/horde/kronolith/fb.php?u=zzzzz
>>>>>>>>>>> FREEBUSY:20131115T093000Z/20131115T112900Z
>>>>>>>>>>> FREEBUSY:20131116T080000Z/20131116T090000Z
>>>>>>>>>>> FREEBUSY:20131116T093000Z/20131116T103000Z
>>>>>>>>>>> FREEBUSY:20131116T140000Z/20131116T150000Z
>>>>>>>>>>> END:VFREEBUSY
>>>>>>>>>>> END:VCALENDAR
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Could it be that Kronolith searches for the complete  
>>>>>>>>>>> address "xxxx.yyyy at xxxx.yyyy" instead of using only the  
>>>>>>>>>>> username?
>>>>>>>>>>
>>>>>>>>>> Kronolith search Turba (or more accurately,the contacts/  
>>>>>>>>>> api) for the contact entry using the full email address.  
>>>>>>>>>> Kronolith uses the freebusy url from the contact found by  
>>>>>>>>>> the contacts/ api to request the freebusy information.
>>>>>>>>>
>>>>>>>>> This is what I expected. But I entered the freebusy url for  
>>>>>>>>> my colleague in the form  
>>>>>>>>> https://our.server.der/horde/kronolith/bf.php?u=mycollegue  
>>>>>>>>> in Turba. In the log files it looks as if Kronolith tries it  
>>>>>>>>> with  
>>>>>>>>> https://our.server.der/horde/kronolith/bf.php?u=mycollegue.fullname@our.domain
>>>>>>>>> Maybe I'm blind but I don't see what I'm doing wrong.
>>>>>>>>
>>>>>>>> Not sure then. Kronolith uses the results returned from the  
>>>>>>>> contacts/ api as-is. You can trace this yourself in  
>>>>>>>> Kronolith_Freebusy::getUrl().
>>>>>>>>
>>>>>>>> If you are an admin on the horde system, you can try putting  
>>>>>>>> this in the phpshell (admin->phpshell) be sure to select the  
>>>>>>>> "Calendar" scope in the drop down.
>>>>>>>>
>>>>>>>> var_dump(Kronolith_FreeBusy::getUrl('mycollegue.fullname at our.domain'));
>>>>>>>>
>>>>>>>> This will show you exactly what Turba is returning.
>>>>>>>>
>>>>>>>> This will show you the rest
>>>>>>>
>>>>>>> Unfortunately this only shows:
>>>>>>> PHP Code
>>>>>>>
>>>>>>> var_dump(Kronolith_FreeBusy::getUrl('mycollegue.fullname at our.domain'));
>>>>>>> Ergebnisse
>>>>>>>
>>>>>>> bool(false)
>>>>>>>
>>>>>>> (Of course I replaced the fake address with the real address)
>>>>>>>
>>>>>>> It seems like something else in my installation is strange.
>>>>>
>>>>>> Are you sure you choose the correct scope in the drop-down ?
>>>>>>
>>>>>> mike
>>>>>> Sent from mobile
>>>>>>
>>>>> Sorry, I chose Turba instead of Kronolith. This is the expected result:
>>>>>
>>>>> string(53) "https://mail.ebira.de/horde/kronolith/fb.php?u=mycolleague"
>>>>>
>>>>> When I enter this in the browser I get a download-link with the  
>>>>> file mycolleague.vfb with the contents I mentioned above.
>>>>>
>>>>> SO this looks correct to me.
>>>>> --
>>>>> Greetings Jens
>>>>
>>>> There is not a problem with getting the URL from the address  
>>>> book, but with reading the URL. That you are able to download the  
>>>> FB information from your local browser, doesn't mean that the  
>>>> Horde server can download it too.
>>>> -- 
>>>> Jan Schneider
>>>> The Horde Project
>>>> http://www.horde.org/
>>>
>>> Can someone advise me how to track this down? I first thought of  
>>> my firewall but everything concerning Horde is running on the same  
>>> host.
>>> --
>>> Greetings Jens
>>
>> That doesn't necessarily mean that you can resolve that host name  
>> on localhost. Use wget or curl to retrieve the FB URL *on* the  
>> Horde server.
>> -- 
>> Jan Schneider
>> The Horde Project
>> http://www.horde.org/
>
>
> Thanks Jan for the hint, it looks like a NAT and/or firewall  
> problem. Via wget I don't get a connection to the host at all. I  
> track this down further.
> --
> Greetings
> Jens

The solution was to put an entry in the /etc/hosts on the server  
running Horde like this:

192.168.1.20    mail.ebira.de

Before I made this entry the requests for the fb.php are vanished  
between firewall and mailserver.

Thanks for your help Michael and Jan
--
Greetings Jens