No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


“Attack Event Rankings” cannot be queried in VSM Lite

Publication Date:  2014-02-27 Views:  687 Downloads:  0
Issue Description
The VSM Lite version is V200R002C00SPC300. After running a period time, there is data in "Attack Event Trend", but no data in "Attack Event Rankings"

Alarm Information
Handling Process
1. login the mysql database and implement the following command to add user %
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Admin@123' WITH GRANT OPTION;        (here Admin@123 should be the password of mysql database)

2.Then, check again, the user % should be in your database.
mysql> select host,user,password from mysql.user;

3. Wait for several minutes,  "Attack Event Rankings" works fine.
Root Cause
The root cause is no wild card user % in database, which results in insufficient permission to call stored procedure.

R&D need to verify the feature compeletely and avoid this kind of bug.