[kronolith] Daily Agenda Emails

[Elliot Anders]

Is there any way to force reminders to look to the database every time  
it's run?  It only seems to look once an hour (making this difficult  
to troubleshoot.)  I changed kronolith/lib/Scheduler/kronolith.php
to 10 seconds like so:
// If we haven't fetched the list of calendars in over an hour,
         // re-list to pick up any new ones.
         if ($this->_runtime - $this->_listtime > 10) {

but it doesn't seem to help I just get:

Jul 26 11:24:28 HORDE [debug] [kronolith] Hook _horde_hook_share_init  
in application horde not called. [pid 19699 on line 16
30 of "/var/www/webmail/horde-webmail-1.1.1/lib/Horde.php"]

I've also deleted all prefs except my own from the horde_prefs table  
thinking maybe I could force it to find just me, but it seems to be  
checking elsewhere as well since it still errors as below.
Thanks again for your insight and help,
-Elliot


On Jul 26, 2008, at 8:52 AM, Jan Schneider wrote:

> Only a single connection to the database should be opened.
>
> Zitat von Elliot Anders <elliot at marlboro.edu>:
>
>> Interesting, so I had tried to look through the log before, but  
>> found nothing of note.  DEBUG turned on, I see a bunch of these:
>> Jul 25 20:30:27 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:  
>> cabr, kronolith [pid 1861 on line 148 of "/var/www/webmail/horde- 
>> webmail-1.1.1/lib/Horde/Prefs/sql.php"]
>>
>> Followed by a bunch more of these:
>>
>> Jul 25 20:30:27 HORDE [error] [kronolith] DB Error: connect  
>> failed:  [nativecode=Too many connections] ** mysqli(mysqli):// 
>> root:PASSWORD at unix/horde? 
>> charset 
>> = 
>> iso-8859-1&splitread=&driverconfig=horde&umask=63&table=horde_prefs  
>> [pid 1861 on line 138 of "/var/www/webmail/horde-webmail-1.1.1/lib/ 
>> Horde/Prefs/sql.php"]
>>
>> It never gets to my username as it fails before reaching the e's
>> This would point to the obvious situation where there are too many  
>> open connections.  We have something like 3000 users in the  
>> database, is there some way to have it close connections before  
>> opening the next or to specify max active connections?
>>
>> Thanks for the clue.
>> -Elliot
>>
>>
>>
>> On Jul 25, 2008, at 1:11 PM, Jan Schneider wrote:
>>
>>> Zitat von Elliot Anders <elliot at marlboro.edu>:
>>>
>>>> Is anyone successfully receiving daily agenda emails of kronolith  
>>>> events?
>>>> I'm running Webmail 1.1.1
>>>>
>>>> Cron is setup thusly:
>>>> */5 * * * * root /usr/bin/php /var/www/webmail/horde/scripts/ 
>>>> alarms.php
>>>> 10 9 * * * * root /usr/bin/php /var/www/webmail/horde/kronolith/ 
>>>> scripts/reminders.php
>>>>
>>>> I have set the preferences in Options -> Calendar -> Notifications
>>>> as:
>>>> Choose if you want to receive daily agenda email reminders: On  
>>>> all calendars I have read access to
>>>>
>>>> I have specified an appropriate email address in both the Horde  
>>>> Default Profile and Kronolith Email address on the Notifications  
>>>> page.
>>>>
>>>> VFS is SQL using horde defaults
>>>>
>>>> There are events in my Kronolith calendar.
>>>>
>>>> Am I missing something?
>>>
>>> No, this should work with all those settings. Anything in the logs?
>>>
>>> Jan.
>>>
>>> -- 
>>> Do you need professional PHP or Horde consulting?
>>> http://horde.org/consulting/
>>>
>>> --
>>> 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
>>
>> --
>> 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
>>
>
>
>
> Jan.
>
> -- 
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
> --
> 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