6.0.0-git
2021-01-18

[#2811] Free/Busy ...:Not found
Summary Free/Busy ...:Not found
Queue Kronolith
Queue Version 2.0.4
Type Bug
State Not A Bug
Priority 2. Medium
Owners
Requester aroen (at) juranet (dot) xs4all (dot) nl
Created 2005-10-19 (5570 days ago)
Due
Updated 2005-12-05 (5523 days ago)
Assigned 2005-10-19 (5570 days ago)
Resolved 2005-10-31 (5558 days ago)
Milestone
Patch No

History
2005-12-05 20:08:35 Chuck Hagenbuch Comment #21 Reply to this comment
Fwiw, I've committed an update that'll go into Kronolith 2.1 that uses 
HTTP_Request to retrieve FB data so we don't rely on allow_url_fopen.
2005-12-05 18:05:31 andreas (dot) schuerch (at) nativenet (dot) ch Comment #20 Reply to this comment
Ok, finally i found the answer...!

It was a simply a php.ini issue!



allow_url_fopen = On



Just to clear things up :)
2005-12-04 13:09:33 andreas (dot) schuerch (at) nativenet (dot) ch Comment #19 Reply to this comment
Exactly the same issue here!

I've tried the 2.0.5 release and also different CVS-Snapshots. (In the 
latest HEAD, this feature is broken:()

It doesn't matter if i put an URL or something stupid into the 
Free/Busy-Field in the adressbook! -Not Found, everytime!

The vfb is downloadable and contains some info. -as far as i can see:)

What could be wrong?!?

Thanks
2005-11-01 15:17:53 aroen (at) juranet (dot) xs4all (dot) nl Comment #18 Reply to this comment
Unfortunately this did not solve the problem.
2005-10-31 13:26:30 aroen (at) juranet (dot) xs4all (dot) nl Comment #17 Reply to this comment
I found this in the kronolith prefs.php: I think this might be the solution:

I will change the value to 'a:1:{i:0;s:8:"localsql";}' and I'll let 
you know the outcome.



Thanks for your help.



// address books to search for free/busy URLs.

$_prefs['search_abook'] = array(

     // If you want the localsql address book to be the default, use:

     // 'value' => 'a:1:{i:0;s:8:"localsql";}',

     'value' => 'a:0:{}',

     'locked' => false,

     'shared' => false,

     'type' => 'implicit',

     'desc' => _("Choose the address books to search for free/busy URLs:")

);


2005-10-31 12:23:27 aroen (at) juranet (dot) xs4all (dot) nl Comment #16 Reply to this comment
Just now, I have  removed all other addressbook entries in the php 
script. So I now have only one address book to choose from (I checked 
this for all Horde application).



But still no free/busy info retrieved.
2005-10-31 12:18:34 aroen (at) juranet (dot) xs4all (dot) nl Comment #15 Reply to this comment
The only configuration option that raises questions, is the "Settings 
for Clients -> Name of client addressbook "



I have a value "localsql" in this field, what does this option mean?

For the rest, I cannot find anything wrong with the configuration as 
you describe.
2005-10-31 09:06:49 Jan Schneider Comment #14
State ⇒ Not A Bug
Reply to this comment
Well, it's exactly what I said earlier. The free/busy URL is not found 
in the address book. Either you didn't specify the correct email 
address to identify the contact, or you configured Kronolith to search 
in the wrong address book, or you configured Turba incorrectly,....
2005-10-29 17:55:25 aroen (at) juranet (dot) xs4all (dot) nl Comment #13 Reply to this comment
Also not in the Apache logs.
2005-10-23 00:34:17 aroen (at) juranet (dot) xs4all (dot) nl Comment #12 Reply to this comment
When going to the "Edit Attendees" windows, the only thing that 
concerns f/b, is the query to the Turba database:



Oct 23 02:25:40 HORDE [debug] [turba] SQL query by 
Turba_Driver_sql::_search(): SELECT object_id, owner_id, object_type, 
object_members, object_uid, object_name, object_email, object_alias, 
object_homeaddress, object_workaddress, object_homephone, 
object_workphone, object_cellphone, object_fax, object_title, 
object_company, object_notes, object_pgppublickey, 
object_smimepublickey, object_freebusyurl FROM turba_objects WHERE 
(owner_id = ? AND (LOWER(object_email) LIKE LOWER(?))) [on line 80 of 
"/usr/local/www/horde/turba/lib/Driver/sql.php"]
2005-10-21 16:50:40 Jan Schneider Comment #11 Reply to this comment
Do you see the request to the f/b url in your server logs?
2005-10-21 10:03:50 aroen (at) juranet (dot) xs4all (dot) nl Comment #10 Reply to this comment
OK, but there is nothing to select in this database (kronolith_storage).

Is there some sort of walktrough of what should be in place before 
Free/Busy can be used?



- I have Free/Busy entries in Turba (My  Addressbook).



- The addressbook searched (within the options of the Kronolith and 
Turba) is the one  which contains Free/Busy urls.



- My personal information email address is the same email address as 
the addressbook entry in Turba.



- Within the Calender there is a button "My Calenders", Kronolith can 
propose the free/busy url for the selected calender (I have copied 
this (proposed) url to the Turba address book).



- All authorisations on the databases and filesystems are open for 
read, use, write (etc.)



- When a new event is saved, with required attendees, then an email is 
sent with an iTIP file to the attendees, this works fine,

   the attendees can even import the information into their own 
calender, even rejections are reported back to the applicant.



What am I missing?



Thnx!
2005-10-20 17:23:22 Chuck Hagenbuch Comment #9 Reply to this comment
Those queries are fine.
2005-10-20 12:00:07 aroen (at) juranet (dot) xs4all (dot) nl Comment #8 Reply to this comment
Herewith some debug info from horde logging facility:



Oct 20 13:53:35 HORDE [debug] [turba] SQL query by 
Turba_Driver_sql::_search(): SELECT object_id, owner_id, object_type, 
object_members, object_uid, object_name, object_email, object_alias, 
object_homeaddress, object_workaddress, object_homephone, 
object_workphone, object_cellphone, object_fax, object_title, 
object_company, object_notes, object_pgppublickey, 
object_smimepublickey, object_freebusyurl FROM turba_objects WHERE 
(owner_id = ? AND (LOWER(object_email) LIKE LOWER(?))) [on line 80 of 
"/usr/local/www/horde/turba/lib/Driver/sql.php"]

Oct 20 13:53:35 HORDE [debug] [kronolith] SQL search by myuser: query 
= "SELECT vfb_serialized FROM kronolith_storage WHERE vfb_email=? AND 
(vfb_owner=? OR vfb_owner='')" [on line 121 of 
"/usr/local/www/horde/kronolith/lib/Storage/sql.php"]



Thx!
2005-10-19 16:01:16 aroen (at) juranet (dot) xs4all (dot) nl Comment #7 Reply to this comment
Ok. I agree.

It is a little bit strange tough, when I use the fb url, as proposed 
by "My Calender", and paste it into my webbrowser then I can download 
an ICS file with the free/busy info. Why doesn't Kronolith find this?



Also there is no Free/Busy info available in the 
"horde.kronolith_storage"column.



I must add that the error message is different when there is no 
Free/Busy URL in Turba. In this case kronolith says that the Url can't 
be found.
No, you get the message if Kronolith doesn't find a free/busy url for
that email address. So, what I said: you configured something wrong.
2005-10-19 15:41:50 Jan Schneider Comment #6 Reply to this comment
No, you get the message if Kronolith doesn't find a free/busy url for 
that email address. So, what I said: you configured something wrong.
2005-10-19 15:33:35 aroen (at) juranet (dot) xs4all (dot) nl Comment #5 Reply to this comment
Hi Jan, I'm sure that I have configured something wrong.

The exact error message comes up at the top of  the attendees window:



"Error retrieving free/busy information for me@mydom.nl: Not found"



I must say that I have a SSL webserver and I access horde with https,

perhaps there could be something with SSL?
Then you configured something wrong. What is the exact error message?
2005-10-19 15:15:10 Jan Schneider Comment #4 Reply to this comment
Then you configured something wrong. What is the exact error message?
2005-10-19 15:10:16 aroen (at) juranet (dot) xs4all (dot) nl Comment #3 Reply to this comment
Hi Jan, Thanks for your reply. I have allready set the search for 
free/busy urls in my agenda options. I even tried to set the value for 
future lookups to 50 days. But still no result.
You probably didn't set the address book to search for free/busy urls
in your options.
2005-10-19 13:15:31 Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
You probably didn't set the address book to search for free/busy urls 
in your options.
2005-10-19 00:28:15 aroen (at) juranet (dot) xs4all (dot) nl Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Summary ⇒ Free/Busy ...:Not found
Queue ⇒ Kronolith
Reply to this comment
Hi all,



When trying to display attendees free/busy information there is no 
information retrieved, also when looking into kronolith_storage 
column, there is no data.



The store function doesn't seem to be called.

I have entries in Turba for all contacts within the Freebusy  field 
"https://mydom/horde/kronolith/fb.php?c=myuser".



What am I doing wrong and when is the store function called?

Thanks in advance.

--

My Kronolith version 2.0.4, Horde 3.0.5, Turba 2.0.3.

Saved Queries