You can empty the table. This will invalidate all your sessions, that means all logged in user will get kicked out and need to re-login.
So, it's best to take the whole site offline before that, but i guess, you will do this for the update anyway.

Don't drop the table, just "delete from ezsession" and remove all entries with this.

There's a script called cleanup.php in common/scripts. You can use this to clean all sorts of things in the DB, including all sessions, or only expired sessions if you prefer.

As with anything else, I'd run a backup first, just to be on the safe side.

Great !
Thanks for the tips.

I just added a feature request that I think would help this issue - better control of anonymous sessions either by them timing out sooner or by disabling the storage of anonymous sessions entirely:

http://issues.ez.no/IssueView.php?Id=9536

...of course, even if this is implemented it will still be necessary to clean up expired sessions regularly like Joe explained, or with a cron job.

Matthew

You have a script:

./update/common/scripts/updatesession.php

See the details, but that's able to clear only the old sessions and keep the current onces. Put that into a cron.

X+

When I try to run the update/common/scripts/updatesession.php, I get the following error immediately back:

Fatal error: eZ publish did not finish its request
The execution of eZ publish was abruptly ended, the debug output is present below.

Hi,

looks like a php-cli problem. like the php-mysql extension isn't installed for the cli or wrong php version or something like that.

I believe the error you encounter is indeed a php-cli problem, possibly a reference problem.

I have encountered this problem, solved it on several occasions and documented my efforts and results.

The following reading should bring you up to speed as well as show you step by step how to solve this problem.

<i>http://ezpedia.org/wiki/en/ez/references
http://ezpedia.org/wiki/en/ez/sol...blish_command_line_scripts</i>

Cheers,
//kracker

Hi Xavier,

regarding your reply from Wednesday 22 November 2006 10:11:19 am:

I looked at ./update/common/scripts/updatesession.php and I can not find any DELETE statement, only UPDATE. Are you sure that the script is capable of clearing sessions from the ezsession table?

I am using eZ publish 3.8.8.

Cheers, Meinhard.

My bad,

./update/common/scripts/cleanup.php expired_session

is your friend.

X+

I don't think the script can clean all siteaccesses at once, so I did this (BASH):

for siteaccess in `ls ./settings/siteaccess`; do
  /usr/bin/php4 ./update/common/scripts/cleanup.php -s $siteaccess expired_session
done

Replace /usr/bin/php4 with your PHP path and you should be sorted.

There'a also a cronjob extension which cleans up the sessions:

http://ez.no/community/contribs/cronjobs/session_cleanup