[kronolith] free busy in LDAP

[Shane Boulter]

My problem seems different as I just tried it with just having one 
address book (my ldap one) and I still get the same results.  In the 
attendeesview page I get no free/busy information although the url does 
work.

shane

Chris Williamson wrote:

> 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.
> 
>