[kronolith] freebusy URL not working AND event_alarm > 0 ?

[LALOT Dominique]

2011/8/26 Jan Schneider <jan at horde.org>

>
> Zitat von LALOT Dominique <dom.lalot at gmail.com>:
>
>
>  Hello,
>>
>> I was wondering why the FB were not working, so I looked at the SQL:
>>
>> SELECT event_id, event_uid, event_description, event_location,
>> event_private, event_status, event_attendees, event_title,
>> event_recurcount,
>> event_url, event_recurtype, event_recurenddate, event_recurinterval,
>> event_recurdays, event_start, event_end, event_allday, event_alarm,
>> event_alarm_methods, event_modified, event_exceptions, event_creator_id,
>> event_resources, event_baseid, event_exceptionoriginaldate FROM
>> kronolith_events WHERE calendar_id = 'xxx' *AND event_alarm > 0* AND
>> ((event_end >= '2011-08-23 22:00:00') OR (event_recurenddate >=
>> '2011-08-23
>> 22:00:00' AND event_recurtype <> 0))
>>
>
> What makes you think that this query is from generating free/busy
> information. Kronolith_FreeBusy::generate() does *not* request alarm-only
> events.
>


Well, I was normally alone, but it took times to get read of activesync
pollings, alarms (I am not sure to use in prod..) It seems you are right.
But just having a loop in IE http://bugs.horde.org/ticket/10462 I was
tailing -f the mysql log and the loop was looking at alarms massively.

Well, seems that FB is not finding the calendar id, should be somewhere in a
hook to write..

SELECT event_id, event_uid, event_description, event_location,
event_private, event_status, event_attendees, event_title, event_recurcount,
event_url, event_recurtype, event_recurenddate, event_recurinterval,
event_recurdays, event_start, event_end, event_allday, event_alarm,
event_alarm_methods, event_modified, event_exceptions, event_creator_id,
event_resources, event_baseid, event_exceptionoriginaldate FROM
kronolith_events WHERE *cal     endar_id = NULL* AND ((event_end >=
'2011-08-25 22:00:00' AND event_start <= '2011-09-25 21:59:59') OR
(event_recurenddate >= '2011-08-25 22:00:00' AND event_start <= '2011-09-25
21:59:59' AND event_recurtype <> 0))

But nevertheless, the management of alarms could be painful with thousands
users. And if somebody shares with me (10 shares for me in prod), it makes
10 selects quite often.

Dom



>
>  gives empty set
>>
>> So I tried to change
>>
>> SELECT event_id, event_uid, event_description, event_location,
>> event_private, event_status, event_attendees, event_title,
>> event_recurcount,
>> event_url, event_recurtype, event_recurenddate, event_recurinterval,
>> event_recurdays, event_start, event_end, event_allday, event_alarm,
>> event_alarm_methods, event_modified, event_exceptions, event_creator_id,
>> event_resources, event_baseid, event_exceptionoriginaldate FROM
>> kronolith_events WHERE calendar_id = 'rouanet.x'  AND ((event_end >=
>> '2011-08-23 22:00:00') OR (event_recurenddate >= '2011-08-23 22:00:00' AND
>> event_recurtype <> 0))
>>
>> gives the busy events..
>> Is there a reason to look at alarms for FB?
>>
>> and other little problem (no side effect at that time, but ..
>> I was also surprised that the fb URL was no correct:
>> fb.php?u= xxx
>> there is a space but it does not matter  as it's still working.
>>
>> my backend for ldap is:
>>        'freebusyUrl' => array('fields' => array('uid'), 'format' =>
>> Horde::url($GLOBALS['registry'**]->get('webroot', 'horde') .
>> '/kronolith/fb.php?u=%s', true)),
>>
>> --
>> Dominique LALOT
>> Ingénieur Systèmes et Réseaux
>> http://annuaire.univmed.fr/**showuser.php?uid=lalot<http://annuaire.univmed.fr/showuser.php?uid=lalot>
>> --
>> Kronolith mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: kronolith-unsubscribe at lists.**horde.org<kronolith-unsubscribe at lists.horde.org>
>>
>
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
> --
> Kronolith mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.**horde.org<kronolith-unsubscribe at lists.horde.org>
>



-- 
Dominique LALOT
Ingénieur Systèmes et Réseaux
http://annuaire.univmed.fr/showuser.php?uid=lalot