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

03/26/2020 49 People found this article helpful 196,112 Views

Download

Print

Share

• LinkedIn
• Twitter
• Facebook
• Email
• Copy URL The link has been copied to clipboard

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.

Related Articles

• Printer Redirection with RDP through Secure Mobile Access
• EPC check based on Windows version
• SMA1000: How to manage Connect Tunnel client Auto-updates

Categories

• Secure Mobile Access > SMA 1000 Series