Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: Hakke on April 10, 2014, 04:58:11 AM

Title: Cleanup Session Table and configuration of column IP
Post by: Hakke 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
Title: Re: Cleanup Session Table and configuration of column IP
Post by: alec 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.
Title: Re: Cleanup Session Table and configuration of column IP
Post by: alec 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;