Author Topic: Cleanup Session Table and configuration of column IP  (Read 4450 times)

Offline Hakke

  • Jr. Member
  • **
  • Posts: 13
Cleanup Session Table and configuration of column IP
« on: April 10, 2014, 04:58:11 AM »
Hello!

i just updated our Roundcube Installation from 0.9.5 to 1.0.0.... Thanks for your work and congratulation to the first official stable version :-) Everything works fine till now...

Now there are a few new questions...

Our session Table has a size of > 1 GB... Is there a possibility to cleanup this table? Is everything of this used?

The column IP only writes 192.168.100.230. Thats the internal IP of our Load Balancer. How is it possible to write the user IP into this table instead of our? Anyway.. is it necessary? :-)

Greetz

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: Cleanup Session Table and configuration of column IP
« Reply #1 on: April 10, 2014, 05:04:20 AM »
Run bin/gc.sh script. Also, set in PHP session.gc_probability = 1 to enable session garbage collector.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: Cleanup Session Table and configuration of column IP
« Reply #2 on: April 10, 2014, 05:34:54 AM »
To be clear, gc.sh script does not clear session table. To do this run DELETE FROM session WHERE changed < NOW() - INTERVAL 1 DAY;