Alert Pattern help Page
The Alerts options allows you to view all suspicious SQL queries been detected by GreenSQL, by default the Alert option shows the Alerts from all protected Databases, you have the option to customize the view to a specific database by selecting a specific database.Vew Alert Pattern
| Pattern | select * from admin where name = ? or ?=? and pwd=sha(? or ?=?) |
| Alert ID | 9 |
| Time | 2010-09-08 08:37:41 |
| Listener | Default MySQL Proxy |
| DB | greendb |
Matching queries:
| Query: | SELECT * FROM admin WHERE name = 'test' OR 'a'='a' AND pwd=SHA('test' OR 'a'='a') |
| Time: | 2010-09-08 08:37:41 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 6593 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'hi' OR 'a'='a' AND pwd=SHA('hi' OR 'a'='a') |
| Time: | 2010-09-06 04:18:20 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 6467 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'kukucs' or ''='' AND pwd=SHA('kukucs' or ''='') |
| Time: | 2010-09-05 17:50:06 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 6451 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'x' OR 'x'='x;' AND pwd=SHA('x' OR 'x'='x') |
| Time: | 2010-09-04 20:04:09 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 6371 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'x' OR 'x'='x' AND pwd=SHA('x' OR 'x'='x') |
| Time: | 2010-09-04 20:03:52 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 6370 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'a' OR '1'='1' AND pwd=SHA('a' OR '1'='1') |
| Time: | 2010-09-02 15:50:19 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5735 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '1' or '1'='1' AND pwd=SHA('1' or '1'='1') |
| Time: | 2010-09-01 05:33:07 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5649 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '' or 'a'='a' AND pwd=SHA('' or 'a'='a') |
| Time: | 2010-08-26 06:36:31 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5514 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '' or 'x'='x' AND pwd=SHA('' or 'x'='x') |
| Time: | 2010-08-21 11:53:28 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5356 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '' or '1'='1' AND pwd=SHA('' or '1'='1') |
| Time: | 2010-08-20 10:56:10 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5337 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '1' OR '1'='1' AND pwd=SHA('1' OR '1'='1 --') |
| Time: | 2010-08-14 10:51:18 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5175 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '1' OR '1'='1' AND pwd=SHA('1' OR '1'='1') |
| Time: | 2010-08-14 10:50:41 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5173 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '1' OR '1'='1' AND pwd=SHA('1' OR '1'='1') |
| Time: | 2010-08-11 23:19:44 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5074 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '' or 1='1' AND pwd=SHA('' or 1='1') |
| Time: | 2010-08-10 13:43:35 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5054 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '' or 0='' AND pwd=SHA('' or 0='') |
| Time: | 2010-08-07 15:16:14 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 5005 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'anything' OR 'x'='x' AND pwd=SHA('anything' OR 'x'='x') |
| Time: | 2010-08-06 04:14:28 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 4952 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'anything' OR 'x'='x' AND pwd=SHA('anything' OR 'x'='x') |
| Time: | 2010-08-02 18:43:59 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 4749 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'test' or 'a'='a' AND pwd=SHA('test' or 'a'='a') |
| Time: | 2010-07-30 11:16:38 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 4681 |
|
| |
| Query: | SELECT * FROM admin WHERE name = '' OR ''='' AND pwd=SHA('' OR ''='') |
| Time: | 2010-07-29 15:02:56 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 4637 |
|
| |
| Query: | SELECT * FROM admin WHERE name = 'z' OR 'x'='x' AND pwd=SHA('z' OR 'x'='x') |
| Time: | 2010-07-28 23:45:53 |
| DB User: | |
| Risk: | 45 blocked |
| Reason: | Query uses sensitive tables Query has 'or' token True expression detected (SQL tautology) Query blocked because it is not in whitelist. |
| ID: | 4629 |
|
| |