V.2.0
User Guide
GreenSQL User Guide
Page 2 of 111
Table of Contents
1. Introduction ...................................................................... 7
1.1 Overview ................................................................................................. 7
1.2 Document Conventions .......................................................................... 8
2.
Getting Started ................................................................. 9
2.1 System Requirements ............................................................................. 9
2.2 Supported Database Servers ................................................................. 10
2.3 Login 10
2.4 Workflow .............................................................................................. 10
2.5 GreenSQL Common Functions .............................................................. 11
2.6 GreenSQL Top Toolbar .......................................................................... 12
2.7 Dashboard ............................................................................................ 13
2.8 Components ......................................................................................... 14
2.8.1 Services/Processes .......................................................................... 14
2.8.2 GreenSQL Directory ......................................................................... 15
3.
Policies .......................................................................... 16
3.1 Overview ............................................................................................... 16
3.2 Types of Policies ................................................................................... 17
3.3 Creating a Policy ................................................................................... 17
3.3.1 Creating a Learning Mode Policy ..................................................... 18
3.3.2 Creating a Database Firewall Policy ................................................. 22
3.3.3 Creating a Risk-Based IPS/IDS Policy ................................................ 27
3.4 Customizing the Policy Display.............................................................. 30
3.5 Reordering Policies ............................................................................... 30
3.6 Creating Policy Objects ......................................................................... 31
3.6.1 Creating IP Addresses ...................................................................... 31
3.6.2 Creating IP Address Ranges ............................................................. 33
3.6.3 Creating IP Groups ........................................................................... 33
3.6.4 Creating Database Users ................................................................. 34
3.6.5 Creating Database User Groups ....................................................... 36
3.6.6 Creating Application Names ............................................................ 36
3.6.7 Creating Application Name Groups ................................................. 37
3.6.8 Creating a Schedule ......................................................................... 38
3.6.9 Creating a Schedule Group .............................................................. 41
GreenSQL User Guide
Page 3 of 111
3.6.10 Creating a Table ............................................................................... 41
3.6.11 Creating a Tables Group .................................................................. 43
3.7 Risk Profiles .......................................................................................... 44
3.7.1 Creating Risk Profiles ....................................................................... 44
3.7.2 Creating Pattern Groups .................................................................. 47
3.7.3 Creating Risk Patterns ..................................................................... 48
3.8 Creating Query Groups ......................................................................... 50
3.9 Editing Query Groups ............................................................................ 51
3.10 Creating Query Patterns ....................................................................... 53
3.11 Selecting an Error Template .................................................................. 55
4.
Databases and Proxies .................................................. 56
4.1 Overview ............................................................................................... 56
4.2 Databases Page Overview ..................................................................... 57
4.3 Creating and Managing Proxies ............................................................ 58
4.4 Creating Databases ............................................................................... 60
4.5 Editing Databases ................................................................................. 61
4.6 Deleting Databases ............................................................................... 64
4.7 Uploading SSL Certificates .................................................................... 64
5.
Caching ......................................................................... 66
5.1 Overview ............................................................................................... 66
5.2 Cache Settings ...................................................................................... 66
5.3 Caching Process .................................................................................... 68
6.
Alerts ............................................................................. 70
6.1 Overview ............................................................................................... 70
6.2 Alerts Page Overview ............................................................................ 70
6.3 Creating Alerts ...................................................................................... 71
6.4 Creating Contacts ................................................................................. 73
6.5 Creating SMTP Servers .......................................................................... 74
7.
Logs .............................................................................. 75
7.1 Overview ............................................................................................... 75
7.2 Logs Page Overview .............................................................................. 75
7.3 Traffic Logs ............................................................................................ 77
7.4 Intrusion Logs ....................................................................................... 80
7.5 System Logs .......................................................................................... 80
7.6 Configuring Syslog Settings ................................................................... 83
GreenSQL User Guide
Page 4 of 111
7.7 Configuring Log Settings ....................................................................... 84
8.
Reports .......................................................................... 85
8.1 Overview ............................................................................................... 85
8.2 Generate and View Reports .................................................................. 85
9.
Auditing ......................................................................... 88
9.1 Overview ............................................................................................... 88
9.2 Auditing Page Overview ........................................................................ 88
9.3 Viewing the Audit Log ........................................................................... 89
9.4 Auditing Policy ...................................................................................... 91
9.5 Viewing Audit Log Archives ................................................................... 94
9.6 Configuring Audit Settings .................................................................... 94
9.6.1 Auditing Rotation ............................................................................ 95
9.6.2 Auditing Settings ............................................................................. 95
10.
System Settings ............................................................. 97
10.1 Overview ............................................................................................... 97
10.2 Global Cache Settings ........................................................................... 98
10.2.1 Disable/Enable Caching Globally ..................................................... 99
10.2.2 Modify Maximum Cache Size ........................................................... 99
10.2.3 Modify Caching Per Connection Size ............................................. 100
10.2.4 Modify Caching Queries ........................................................ 100
10.2.5 Modify Caching Procedures ................................................... 100
10.3 Setting the Default Error Response ..................................................... 101
10.4 Selecting SMTP Servers ....................................................................... 101
10.5 Users and Management Permissions .................................................. 101
10.5.1 Creating Profiles ............................................................................ 102
10.5.2 Creating Administration Users ....................................................... 104
10.6 Backup GreenSQL Settings .................................................................. 105
10.7 Restore GreenSQL Settings ................................................................. 105
10.8 License installation ............................................................................. 106
10.9 Viewing license information ............................................................... 107
10.10 Logs Cleanup ....................................................................................... 107
10.11 Factory Reset ...................................................................................... 108
11.
Appendix...................................................................... 110
GreenSQL User Guide
Page 5 of 111
Important Notice
© Copyright GreenSQL Ltd 2007 – 2010. All rights reserved.
GreenSQL Ltd. (GreenSQL) reserves the right to make corrections, modifications, enhancements,
improvements, and other changes to its products and services at any time and to discontinue any
product or service without notice. Customers should obtain the latest relevant information before
placing orders and should verify that such information is current and complete. All products are sold
subject to GreenSQL's terms and conditions of sale supplied at the time of order acknowledgment.
GreenSQL warrants performance of its products to the specifications applicable at the time of sale in
accordance with GreenSQL's standard warranty. Testing and other quality control techniques are used
to the extent GreenSQL deems necessary to support this warranty. Except where mandated by
government requirements, testing of all parameters of each product is not necessarily performed.
GreenSQL assumes no liability for third-party applications assistance. Customers are responsible for their
products and applications using GreenSQL components. To minimize the risks associated with customer
products and applications, customers should provide adequate design and operating safeguards.
GreenSQL does not warrant or represent that any license, either express or implied, is granted under any
GreenSQL patent right, copyright or other GreenSQL intellectual property right relating to any
combination, machine, or process in which GreenSQL products or services are used. Information
published by GreenSQL regarding third-party products or services does not constitute a license from
GreenSQL to use such products or services or a warranty or endorsement thereof. Use of such
information may require a license from a third party under the patents or other intellectual property of
the third party, or a license from GreenSQL under the patents or other intellectual property of GreenSQL.
Resale of GreenSQL products or services with statements different from or beyond the parameters stated
by GreenSQL for that product or service voids all express and any implied warranties for the associated
GreenSQL product or service and is an unfair and deceptive business practice. GreenSQL is not
responsible or liable for any such statements.
All company and brand products and service names are trademarks or registered trademarks of their
respective holders.
All text and figures included in this publication are the exclusive property of GreenSQL Ltd (GreenSQL),
and may not be copied, reproduced, or used in any way without the express written permission of
GreenSQL. Information in this document is subject to change without notice and does not represent a
commitment on the part of GreenSQL. Although the information in this document has been carefully
reviewed, GreenSQL does not warrant it to be free of errors or omissions. GreenSQL reserves the right to
make corrections, updates, revisions or changes to the information in this document.
GreenSQL Ltd.