[horde] Cleaning Session Data in MySQL Database

[Brian Spraker]

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.

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.

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; 
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