[kronolith] Daily Agenda Emails

[Elliot Anders]

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