[kronolith] free busy in LDAP

[Chris Williamson]

I have found that Free/Busy will work only if you have one address book 
defined.
  Mine will work with LDAP only if I remove the localsql address book.  Does
anyone know how to tell Kronolith which Address book to pull Free / Busy info
from so I can have multiple address books?


Quoting Shane Boulter <sboulter at ariasolutions.com>:

> 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
>
> --
> Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org



Chris Williamson
Systems/Database Administrator
Salem Academy and College
336-917-5464

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.