[horde] Notifications in Kronolith

Steve Devine sd at msu.edu
Mon May 26 20:19:47 UTC 2008


Jan Schneider wrote:
> Zitat von Steve Devine <sd at msu.edu>:
>
>   
>> For some reason invitation notifications have stopped.
>>
>> When I create an event  and  invite someone the other person does  
>> not get the invite.
>> I do get notices when events are added to my  calendar or if I  
>> delete an event.
>> I do not get alarm notices when the  preset alarm times arrive.
>>  Kronollith H3 2.2.
>>
>> Any suggestions?  Debug mode seems to put event_attendees in as I  
>> would expect.
>>     
>
> Did you mark the checkbox to notify attendees? 
Yes I clicked the checkbox.
> Do you get any error  
> message? Anything in the logs?
>   
 From the logs the attendee is mailtest and the calendar owner is sd.
###############

  6 => 'horde.shares.kronolith',
) [pid 14915 on line 373 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:49 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name, attribute_key AS "key", attribute_value AS value FROM horde_datatree_attributes WHERE datatree_id IN (51, 112, 109, 210, 3) [pid 14915 on line 1083 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:49 HORDE [debug] [kronolith] Max memory usage: 2359296 bytes [pid 14915 on line 339 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Registry.php"]
May 26 16:11:49 HORDE [debug] [kronolith] Session data unchanged (id = d995d433bfe989b66ffdce13894d1cba) [pid 14915 on line 253 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/SessionHandler.php"]
May 26 16:11:52 HORDE [debug] [horde] Connected to the following memcache servers:ztest4.acns.msu.edu:11211 [pid 14924 on line 123 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Memcache.php"]
May 26 16:11:52 HORDE [debug] [horde] Read session data (id = d995d433bfe989b66ffdce13894d1cba) [pid 14924 on line 171 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/SessionHandler/memcache.php"]
May 26 16:11:52 HORDE [debug] [kronolith] Hook _horde_hook_share_init in application horde not called. [pid 14924 on line 1629 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_key = ?)   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id, array (
  0 => 'horde.groups',
  1 => 'user',
  2 => 'sd',
) [pid 14924 on line 1247 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id IN (317) AND group_uid = 'horde.groups' ORDER BY datatree_id [pid 14924 on line 340 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::_loadById(): SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id IN (?, ?) AND group_uid = ? ORDER BY datatree_id, array (
  0 => 317,
  1 => 0,
  2 => 'horde.groups',
) [pid 14924 on line 373 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_value = ?)  AND a2.attribute_name = ?  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, a2.attribute_value ORDER BY a2.attribute_value ASC, array (
  0 => 'horde.shares.kronolith',
  1 => 'owner',
  2 => 'sd',
  3 => 'name',
) [pid 14924 on line 1212 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_key = ? AND a1.attribute_value \& ?)  AND a2.attribute_name = ?  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, a2.attribute_value ORDER BY a2.attribute_value ASC, array (
  0 => 'horde.shares.kronolith',
  1 => 'perm_users',
  2 => 'sd',
  3 => 2,
  4 => 'name',
) [pid 14924 on line 1212 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_value \& ?)  AND a2.attribute_name = ?  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, a2.attribute_value ORDER BY a2.attribute_value ASC, array (
  0 => 'horde.shares.kronolith',
  1 => 'perm_creator',
  2 => 2,
  3 => 'name',
) [pid 14924 on line 1212 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_value \& ?)  AND a2.attribute_name = ?  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, a2.attribute_value ORDER BY a2.attribute_value ASC, array (
  0 => 'horde.shares.kronolith',
  1 => 'perm_default',
  2 => 2,
  3 => 'name',
) [pid 14924 on line 1212 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_key IN (?) AND a1.attribute_value \& ?)  AND a2.attribute_name = ?  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, a2.attribute_value ORDER BY a2.attribute_value ASC, array (
  0 => 'horde.shares.kronolith',
  1 => 'perm_groups',
  2 => '317',
  3 => 2,
  4 => 'name',
) [pid 14924 on line 1212 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id IN (51, 112, 109, 210, 3) AND group_uid = 'horde.shares.kronolith' ORDER BY datatree_id [pid 14924 on line 340 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::_loadById(): SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id IN (?, ?, ?, ?, ?, ?) AND group_uid = ? ORDER BY datatree_id, array (
  0 => 3,
  1 => 0,
  2 => 51,
  3 => 109,
  4 => 112,
  5 => 210,
  6 => 'horde.shares.kronolith',
) [pid 14924 on line 373 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS name, attribute_key AS "key", attribute_value AS value FROM horde_datatree_attributes WHERE datatree_id IN (51, 112, 109, 210, 3) [pid 14924 on line 1083 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] Kronolith_Driver_sql::saveEvent(): user = "sd"; query = "INSERT INTO kronolith_events (event_id, event_uid, event_creator_id, event_title, event_description, event_category, event_location, event_private, event_status, event_attendees, event_keywords, event_modified, event_start, event_end, event_alarm, event_recurtype, calendar_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; values = "c7f67d2860c7716f148aa0249e0baccb,20080526161152.37402ticqd7lxugw at ztest4.acns.msu.edu,sd,A meeting,,,CC215,0,2,a:1:{i:0;a:3:{s:10:"attendance";i:1;s:8:"response";i:1;s:4:"name";s:8:"mailtest";}},,1211832712,2008-05-27 08:00:00,2008-05-27 09:00:00,0,0,sd" [pid 14924 on line 557 of "/srv/www/ssl-htdocs/horde-webmail-1.1/kronolith/lib/Driver/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ? AND pref_scope = ?, values: sd, horde [pid 14924 on line 148 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Prefs/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] SQL Query by Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ? AND pref_scope = ?, values: sd, kronolith [pid 14924 on line 148 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Prefs/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] Kronolith_Driver_sql::getEvent(): user = "sd"; query = "SELECT event_id, event_uid, event_description, event_location, event_private, event_status, event_attendees, event_keywords, event_title, event_category, event_recurcount, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE event_id = ? AND calendar_id = ?"; values = "c7f67d2860c7716f148aa0249e0baccb,sd" [pid 14924 on line 378 of "/srv/www/ssl-htdocs/horde-webmail-1.1/kronolith/lib/Driver/sql.php"]
May 26 16:11:52 HORDE [debug] [kronolith] Max memory usage: 2621440 bytes [pid 14924 on line 339 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Registry.php"]
May 26 16:11:52 HORDE [debug] [kronolith] Session data unchanged (id = d995d433bfe989b66ffdce13894d1cba) [pid 14924 on line 253 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/SessionHandler.php"]
May 26 16:11:52 HORDE [debug] [horde] Connected to the following memcache servers:ztest4.acns.msu.edu:11211 [pid 14915 on line 123 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Memcache.php"]
May 26 16:11:52 HORDE [debug] [horde] Read session data (id = d995d433bfe989b66ffdce13894d1cba) [pid 14915 on line 171 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/SessionHandler/memcache.php"]
May 26 16:11:53 HORDE [debug] [kronolith] Hook _horde_hook_share_init in application horde not called. [pid 14915 on line 1629 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde.php"]
May 26 16:11:53 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_key = ?)   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id, array (
  0 => 'horde.groups',
  1 => 'user',
  2 => 'sd',
) [pid 14915 on line 1247 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:53 HORDE [debug] [kronolith] SQL Query by DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id IN (317) AND group_uid = 'horde.groups' ORDER BY datatree_id [pid 14915 on line 340 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:53 HORDE [debug] [kronolith] SQL Query by DataTree_sql::_loadById(): SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id IN (?, ?) AND group_uid = ? ORDER BY datatree_id, array (
  0 => 317,
  1 => 0,
  2 => 'horde.groups',
) [pid 14915 on line 373 of "/srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/DataTree/sql.php"]
May 26 16:11:53 HORDE [debug] [kronolith] SQL Query by DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND (a1.attribute_name = ? AND a1.attribute_value = ?)  AND a2.attribute_name = ?  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, a2.attribute_value ORDER BY a2.attribute_value ASC, array (
  0 => 'horde.shares.kronolith',
  1 => 'owner',
  2 => 'sd',
  3 => 'name',


##########################
>   
>> I also must admit I don't understand how kronolith sends out   
>> messages and alarms without a cronjob .. I mean is there a running  
>> process that send out these messages?
>>     
>
> It doesn't work without a cronjob, unless someone is using Kronolith  
> at the time the alarm goes off by chance. Read docs/INSTALL.
>
>   
Hmm  When I activate the crontab i get this :

PHP Fatal error:  Class 'Memcache' not found in /srv/www/ssl-htdocs/horde-webmail-1.1/lib/Horde/Memcache.php on line 108


> Jan.
>
>   


/sd
-- 
Steve Devine
Academic Technology Services
313 Computer Center
Michigan State University
East Lansing, MI 48824-1042
1-517-432-7327
Baseball is ninety percent mental; the other half is physical.
- Yogi Berra 



More information about the horde mailing list