problems with a lot of active sessions

[jose miguelg]

Hello,
today we are realise that we find a lot of sesseions active without IP and without name, we attached a picture of this.

thanks

 

[IgorG]

What sort of output of following SQL query in psa database:

mysql> select * from sessions;

 

[jose miguelg]

I do this, but dont' appears anything. I attached a image.

 

[IgorG]

You should login to psa database first. You can use

# plesk db

command for this.

 

[jose miguelg]

I cant', it answer that the order is not valid

 

[IgorG]

What is your Plesk version? 'plesk db' command is actual only for Plesk 11.5
If you have other version, login to psa database with

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

 

[jose miguelg]

11.0.9 Actualizar #60

 

[jose miguelg]

I attached you the result.

 

[IgorG]

Now just try to delete these sessions with

mysql> delete * from sessions;

And check you initial page.

 

[jose miguelg]

ok. we delete all the sessions, but why appears all this sessions???