[horde] Cleaning Session Data in MySQL Database

[Jan Schneider]

Zitat von Brian Spraker <spraker at yahoo.com>:

> Hello everyone,
>
> I have the newest version of Horde GroupWare (1.2.7).
>
> I originally started with the horde binary package that could be easily
> installed with Ubuntu.  Then I opted to remove this and go with the newest
> version and install it myself (which was just a matter of unzipping  
> the tar file
> and placing it in a web directory).
>
> I have two issues - one horde related and the other is most likely kronolith
> related.
>
> First issue is in regards to session data cleanup.  I use the
> 'horde_sessionhandler' table in the 'horde' database to store session data.
> However, the old sessions never appear to be removed/deleted.  I  
> have 100+ rows
> in the horde_sessionhandler table currently and I may have only ten  
> users; four
> of which use WebMail while all others check via POP3.

Do you have any error messages regarding garbage collection in your horde log?

> Curious to know why the session data doesn't get deleted/removed  
> after a period
> of time.  I have to manually do this and therefore - if any users are logged
> into webmail when I do so, they get logged out and must log back in.

Garbage collection is triggered by PHP. Maybe your site is not busy  
enough to have triggered the GC so far. Tweak your PHP setting for  
more often GC.
There's also the the possibility of failure in the GC routines of  
Horde's session handler code. Check the horde logs.

> Second issue is in regards to Kronolith's reminder function.  The  
> daily agenda
> e-mails work normally.  However, they actual reminders of an event never are
> sent.  This worked previously when I used the binary-installed  
> version of Horde
> on Ubuntu.  Now since changing over (and running all of the update  
> scripts that
> were needed), the reminders are not e-mailed.  I have them setup to send a
> reminder e-mail 15 minutes before by default.
>
> If I set the cron script to run the reminders.php file every five  
> minutes when I
> have the daily agendas set to enabled on my account and there is at least one
> event on the day, I get those daily agenda e-mails every five  
> minutes when the
> script runs.  But nothing in the way of an actual event reminder.
>
> I'm kind of surprised that there are not two separate scripts for  
> this actually;

There are. horde/scripts/alarms.php is for sending reminders.

> if someone wants to receive both their daily agenda and reminders,  
> this is not
> possible - otherwise they receive their daily agenda every five minutes (or
> whatever recurrence time is set for the cron job).
>
> Looking for any kind of advice on these two items.  In regards to  
> the Kronolith
> reminder function, I'm more interested in trying to get this fixed  
> so that event
> reminders are sent 15 minutes prior to the event (or whatever  
> threshold is set
> for the reminder) over the daily agendas (which work).
>
> Brian S.
> BsnTech Networks
>
>
>
>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/