[kronolith] Daily Agenda Emails

[Jan Schneider]

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/