“Attack Event Rankings” cannot be queried in VSM Lite

Publication Date:  2014-02-27 Views:  266 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
None
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)
mysql> FLUSH PRIVILEGES;

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.

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

END