-
Products
-
SonicPlatform
SonicPlatform is the cybersecurity platform purpose-built for MSPs, making managing complex security environments among multiple tenants easy and streamlined.
Discover More
-
-
Solutions
-
Federal
Protect Federal Agencies and Networks with scalable, purpose-built cybersecurity solutions
Learn MoreFederalProtect Federal Agencies and Networks with scalable, purpose-built cybersecurity solutions
Learn More - Industries
- Use Cases
-
-
Partners
-
Partner Portal
Access to deal registration, MDF, sales and marketing tools, training and more
Learn MorePartner PortalAccess to deal registration, MDF, sales and marketing tools, training and more
Learn More - SonicWall Partners
- Partner Resources
-
-
Support
-
Support Portal
Find answers to your questions by searching across our knowledge base, community, technical documentation and video tutorials
Learn MoreSupport PortalFind answers to your questions by searching across our knowledge base, community, technical documentation and video tutorials
Learn More - Support
- Resources
- Capture Labs
-
- Company
- Contact Us
How to clear the user sessions and all other MySQL tables when old sessions are still displayed
03/26/2020 
50 People found this article helpful
483,314 Views
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:
- Open SSH connection to appliance. Enabling and obtaining SSH access to the SonicWall / Aventail appliance
- 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;' - If you have an High Availability, then repeat on both nodes to clear out all of the tables.
Related Articles
- How to Set Timeout for Inactive Tunnel Connections
- Commands for silent installation of NetExtender via CMD line
- Users on Netextender 10.3.0 version failing to connect with the following error message " Cannot get a response from the server "
YES
NO