How to clear the user sessions and all other MySQL tables when old sessions are still displayed

03/26/2020 44 7304

DESCRIPTION:

Sometimes in the user session menu, sessions will continue to be displayed even if the customer it's already disconnected. We can clean this MySQL table with the command Truncate Table below.

RESOLUTION:

Here's how to clear the old user sessions by cleaning the MySQL tables:

1. Open SSH connection to appliance. Enabling and obtaining SSH access to the SonicWall / Aventail appliance
2. Login as username “root”  and the same password to access at management interface (AMC) and copy the below commands one by one, it will clear all the old user sessions along with MySQL tables.
   mysql --database=troubleshooting -e 'TRUNCATE TABLE sessionInformation;'
mysql --database=troubleshooting -e 'TRUNCATE TABLE failedSignatures;'
mysql --database=troubleshooting -e 'TRUNCATE TABLE accessChecks;'
mysql --database=troubleshooting -e 'TRUNCATE TABLE byteCountSnapshots;'
mysql --database=troubleshooting -e 'TRUNCATE TABLE epcState;'
mysql --database=troubleshooting -e 'TRUNCATE TABLE userLockout;'
3. If you have an High Availability, then repeat on both nodes to clear out all of the tables.