1 Topic by schnappi (edited by schnappi 2016-01-31 02:22:16)

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Topic: roundcubemail session table never cleaned/ pruned in database

Hi,

Noticed that the roundcubemail session table never gets cleaned.

My php.ini (and it seems any other php.ini file) in original form on an Ubuntu installation shows

"session.gc_probability = 0"

If this is changed to "session.gc_probability = 1" will this table be cleaned?

This is not an iRedMail issue really. Probably more of a php issue but this seemed like as good a place as any to ask.

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.0
- Linux/BSD distribution name and version: Ubuntu 14 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue: NA
====

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,163

Re: roundcubemail session table never cleaned/ pruned in database

Seems Roundcube doesn't offer a script to clean expired session. I suggest you ask for support in Roundcube mailing list instead.

3 Reply by schnappi

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Re: roundcubemail session table never cleaned/ pruned in database

Know this is old but here is the answer from Roundcube:
https://github.com/roundcube/roundcubemail/issues/3573

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,163

Re: roundcubemail session table never cleaned/ pruned in database

iRedMail has daily cron job to run script "bin/cleandb.py" (in Roundcube directory), it will clean up the expired sessions, and other data which is supposed to be removed.

5 Reply by schnappi

  • schnappi
  • Member
  • Offline
  • Registered: 2015-02-13
  • Posts: 166

Re: roundcubemail session table never cleaned/ pruned in database

Great. So basically editing session.gc_maxlifetime, session.gc_probability, or session.gc_divisor serves no purpose in terms of cleaning the roundcubemail session table in iRedMail, correct?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,163

Re: roundcubemail session table never cleaned/ pruned in database

You don't need to modify any settings (except "session_lifetime" in Roundcube config file - if you want to change).