Roundcube Community Forum

 

Cleanup Session Table and configuration of column IP

Started by Hakke, April 10, 2014, 04:58:11 AM

Previous topic - Next topic

Hakke

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

alec

Run bin/gc.sh script. Also, set in PHP session.gc_probability = 1 to enable session garbage collector.

alec

To be clear, gc.sh script does not clear session table. To do this run DELETE FROM session WHERE changed < NOW() - INTERVAL 1 DAY;