[kronolith] free busy in LDAP

[Shane Boulter]

Sorry I forgot to add that I'm running CVS HEAD of all applications.

shane

Shane Boulter wrote:

> I'm attempting to get the freebusy stuff to work in the kronolith.  I 
> have most of it working so far but can't seem to get it to show up in 
> the Free/Busy Attendees View within Kronolith itself.
> 
> Here's what I've done so far.  I've added the Calendar Schema to my ldap 
> instance.  I've added the calEntry objectclass to my user and put the 
> following url in the calFBURL attribute: 
> http://www1.ariasolutions.com/horde/kronolith/fb.php?c=sboulter
> 
> When I goto the url in my browser I do get my free/busy information.
> 
> When I goto the attendeesview page in krnolith however I do not see any 
> query in the access_logs of my server to the url that is entered in my 
> calFBURL attribute.
> 
> I'm unclear as to what I am missing as it all seems to work except for 
> this piece.
> 
> shane
> 
> 
> 
> 
> Here are the debug logs from horde
> 
> Aug 09 11:06:19 HORDE [debug] [kronolith] SQL Query by 
> DataTree_sql::_load(): SELECT datatree_id, datatree_parents FROM 
> horde_datatree WHERE datatree_name = 'turba' AND group_uid = 
> 'horde.perms' ORDER BY datatree_id [on line 103 of 
> "/usr/local/apache/php/lib/php/Horde/DataTree/sql.php"]
> 
> Aug 09 11:06:19 HORDE [debug] [turba] LDAP search by sboulter: root = 
> ou=People,ou=Samba,dc=ariasolutions,dc=com (209.91.93.124); filter = 
> "(&(mail=*sboulter at ariasolutions.com*))"; attributes = "dn, cn, mail, 
> givenname, telephonenumber, mobiletelephonenumber, calFBURL, sn"; 
> sizelimit = 0 [on line 119 of 
> "/usr/local/apache/htdocs/horde/turba/lib/Driver/ldap.php"]
> 
> Aug 09 11:06:19 HORDE [debug] [turba] SQL search by sboulter: table = 
> turba_objects; query = "SELECT object_id, owner_id, object_type, 
> object_members, 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 = 'sboulter' AND (object_email LIKE 
> LOWER('%sboulter at ariasolutions.com%')))" [on line 77 of 
> "/usr/local/apache/htdocs/horde/turba/lib/Driver/sql.php"]
> 
> Aug 09 11:06:19 HORDE [debug] [turba] LDAP search by sboulter: root = 
> ou=contacts,dc=ariasolutions,dc=com (209.91.93.124); filter = 
> "(&(mail=*sboulter at ariasolutions.com*))"; attributes = "dn, cn, mail, 
> homephone, telephonenumber, mobiletelephonenumber, homepostaladdress, 
> calFBURL, sn"; sizelimit = 200 [on line 119 of 
> "/usr/local/apache/htdocs/horde/turba/lib/Driver/ldap.php"]
> 
> Aug 09 11:06:19 HORDE [debug] [kronolith] SQL search by sboulter: query 
> = "SELECT vfb_serialized FROM kronolith_storage WHERE 
> vfb_email='sboulter at ariasolutions.com' AND (vfb_owner='sboulter' OR 
> vfb_owner='')" [on line 113 of 
> "/usr/local/apache/htdocs/horde/kronolith/lib/Storage/sql.php"]
> 
> 
> Access_Logs from http server when query done in free/busy in kronolith.
> 
> [09/Aug/2004:12:04:26 -0600] "GET 
> /horde/services/javascript.php?file=tooltip.js&app=horde HTTP/1.1" 200 1941
> 
> [09/Aug/2004:12:04:26 -0600] "POST /horde/kronolith/attendeesview.php 
> HTTP/1.1" 200 25612
> 192.168.1.107 - - [09/Aug/2004:12:04:26 -0600] "GET 
> /horde/services/javascript.php?file=goto.inc&app=kronolith HTTP/1.1" 200 
> 8419
> 
> [09/Aug/2004:12:04:27 -0600] "GET 
> /horde/services/javascript.php?file=open_compose_win.js&app=imp 
> HTTP/1.1" 200 1011
>