SQL injectionv3.9+
Detects injection of a SQL query using the input data from the client to the application.
Uses the following regex for matching:
[\s]*((delete)|(exec)|(drop\s*table)|(insert)|(shutdown)|(update)|(\bor\b))
Add this section to your kong.yaml configuration file:
_format_version: "3.0"
plugins:
- name: injection-protection
config:
injection_types:
- sql
locations:
- path_and_query
enforcement_mode: block
error_status_code: 400
error_message: Bad Request
Make the following request:
curl -i -X POST http://localhost:8001/plugins/ \
--header "Accept: application/json" \
--header "Content-Type: application/json" \
--data '
{
"name": "injection-protection",
"config": {
"injection_types": [
"sql"
],
"locations": [
"path_and_query"
],
"enforcement_mode": "block",
"error_status_code": 400,
"error_message": "Bad Request"
},
"tags": []
}
'
Make the following request:
curl -X POST https://{region}.api.konghq.com/v2/control-planes/{controlPlaneId}/core-entities/plugins/ \
--header "accept: application/json" \
--header "Content-Type: application/json" \
--header "Authorization: Bearer $KONNECT_TOKEN" \
--data '
{
"name": "injection-protection",
"config": {
"injection_types": [
"sql"
],
"locations": [
"path_and_query"
],
"enforcement_mode": "block",
"error_status_code": 400,
"error_message": "Bad Request"
},
"tags": []
}
'
Make sure to replace the following placeholders with your own values:
-
region: Geographic region where your Kong Konnect is hosted and operates. -
KONNECT_TOKEN: Your Personal Access Token (PAT) associated with your Konnect account. -
controlPlaneId: Theidof the control plane.
See the Konnect API reference to learn about region-specific URLs and personal access tokens.
echo "
apiVersion: configuration.konghq.com/v1
kind: KongClusterPlugin
metadata:
name: injection-protection
namespace: kong
annotations:
kubernetes.io/ingress.class: kong
konghq.com/tags: ''
labels:
global: 'true'
config:
injection_types:
- sql
locations:
- path_and_query
enforcement_mode: block
error_status_code: 400
error_message: Bad Request
plugin: injection-protection
" | kubectl apply -f -
Prerequisite: Configure your Personal Access Token
terraform {
required_providers {
konnect = {
source = "kong/konnect"
}
}
}
provider "konnect" {
personal_access_token = "$KONNECT_TOKEN"
server_url = "https://us.api.konghq.com/"
}
Add the following to your Terraform configuration to create a Konnect Gateway Plugin:
resource "konnect_gateway_plugin_injection_protection" "my_injection_protection" {
enabled = true
config = {
injection_types = ["sql"]
locations = ["path_and_query"]
enforcement_mode = "block"
error_status_code = 400
error_message = "Bad Request"
}
tags = []
control_plane_id = konnect_gateway_control_plane.my_konnect_cp.id
}
Add this section to your kong.yaml configuration file:
_format_version: "3.0"
plugins:
- name: injection-protection
service: serviceName|Id
config:
injection_types:
- sql
locations:
- path_and_query
enforcement_mode: block
error_status_code: 400
error_message: Bad Request
Make sure to replace the following placeholders with your own values:
-
serviceName|Id: Theidornameof the service the plugin configuration will target.
Make the following request:
curl -i -X POST http://localhost:8001/services/{serviceName|Id}/plugins/ \
--header "Accept: application/json" \
--header "Content-Type: application/json" \
--data '
{
"name": "injection-protection",
"config": {
"injection_types": [
"sql"
],
"locations": [
"path_and_query"
],
"enforcement_mode": "block",
"error_status_code": 400,
"error_message": "Bad Request"
},
"tags": []
}
'
Make sure to replace the following placeholders with your own values:
-
serviceName|Id: Theidornameof the service the plugin configuration will target.
Make the following request:
curl -X POST https://{region}.api.konghq.com/v2/control-planes/{controlPlaneId}/core-entities/services/{serviceId}/plugins/ \
--header "accept: application/json" \
--header "Content-Type: application/json" \
--header "Authorization: Bearer $KONNECT_TOKEN" \
--data '
{
"name": "injection-protection",
"config": {
"injection_types": [
"sql"
],
"locations": [
"path_and_query"
],
"enforcement_mode": "block",
"error_status_code": 400,
"error_message": "Bad Request"
},
"tags": []
}
'
Make sure to replace the following placeholders with your own values:
-
region: Geographic region where your Kong Konnect is hosted and operates. -
KONNECT_TOKEN: Your Personal Access Token (PAT) associated with your Konnect account. -
controlPlaneId: Theidof the control plane. -
serviceId: Theidof the service the plugin configuration will target.
See the Konnect API reference to learn about region-specific URLs and personal access tokens.
echo "
apiVersion: configuration.konghq.com/v1
kind: KongPlugin
metadata:
name: injection-protection
namespace: kong
annotations:
kubernetes.io/ingress.class: kong
konghq.com/tags: ''
config:
injection_types:
- sql
locations:
- path_and_query
enforcement_mode: block
error_status_code: 400
error_message: Bad Request
plugin: injection-protection
" | kubectl apply -f -
Next, apply the KongPlugin resource by annotating the service resource:
kubectl annotate -n kong service SERVICE_NAME konghq.com/plugins=injection-protection
Prerequisite: Configure your Personal Access Token
terraform {
required_providers {
konnect = {
source = "kong/konnect"
}
}
}
provider "konnect" {
personal_access_token = "$KONNECT_TOKEN"
server_url = "https://us.api.konghq.com/"
}
Add the following to your Terraform configuration to create a Konnect Gateway Plugin:
resource "konnect_gateway_plugin_injection_protection" "my_injection_protection" {
enabled = true
config = {
injection_types = ["sql"]
locations = ["path_and_query"]
enforcement_mode = "block"
error_status_code = 400
error_message = "Bad Request"
}
tags = []
control_plane_id = konnect_gateway_control_plane.my_konnect_cp.id
service = {
id = konnect_gateway_service.my_service.id
}
}
Add this section to your kong.yaml configuration file:
_format_version: "3.0"
plugins:
- name: injection-protection
route: routeName|Id
config:
injection_types:
- sql
locations:
- path_and_query
enforcement_mode: block
error_status_code: 400
error_message: Bad Request
Make sure to replace the following placeholders with your own values:
-
routeName|Id: Theidornameof the route the plugin configuration will target.
Make the following request:
curl -i -X POST http://localhost:8001/routes/{routeName|Id}/plugins/ \
--header "Accept: application/json" \
--header "Content-Type: application/json" \
--data '
{
"name": "injection-protection",
"config": {
"injection_types": [
"sql"
],
"locations": [
"path_and_query"
],
"enforcement_mode": "block",
"error_status_code": 400,
"error_message": "Bad Request"
},
"tags": []
}
'
Make sure to replace the following placeholders with your own values:
-
routeName|Id: Theidornameof the route the plugin configuration will target.
Make the following request:
curl -X POST https://{region}.api.konghq.com/v2/control-planes/{controlPlaneId}/core-entities/routes/{routeId}/plugins/ \
--header "accept: application/json" \
--header "Content-Type: application/json" \
--header "Authorization: Bearer $KONNECT_TOKEN" \
--data '
{
"name": "injection-protection",
"config": {
"injection_types": [
"sql"
],
"locations": [
"path_and_query"
],
"enforcement_mode": "block",
"error_status_code": 400,
"error_message": "Bad Request"
},
"tags": []
}
'
Make sure to replace the following placeholders with your own values:
-
region: Geographic region where your Kong Konnect is hosted and operates. -
KONNECT_TOKEN: Your Personal Access Token (PAT) associated with your Konnect account. -
controlPlaneId: Theidof the control plane. -
routeId: Theidof the route the plugin configuration will target.
See the Konnect API reference to learn about region-specific URLs and personal access tokens.
echo "
apiVersion: configuration.konghq.com/v1
kind: KongPlugin
metadata:
name: injection-protection
namespace: kong
annotations:
kubernetes.io/ingress.class: kong
konghq.com/tags: ''
config:
injection_types:
- sql
locations:
- path_and_query
enforcement_mode: block
error_status_code: 400
error_message: Bad Request
plugin: injection-protection
" | kubectl apply -f -
Next, apply the KongPlugin resource by annotating the httproute or ingress resource:
kubectl annotate -n kong httproute konghq.com/plugins=injection-protection
kubectl annotate -n kong ingress konghq.com/plugins=injection-protection
Prerequisite: Configure your Personal Access Token
terraform {
required_providers {
konnect = {
source = "kong/konnect"
}
}
}
provider "konnect" {
personal_access_token = "$KONNECT_TOKEN"
server_url = "https://us.api.konghq.com/"
}
Add the following to your Terraform configuration to create a Konnect Gateway Plugin:
resource "konnect_gateway_plugin_injection_protection" "my_injection_protection" {
enabled = true
config = {
injection_types = ["sql"]
locations = ["path_and_query"]
enforcement_mode = "block"
error_status_code = 400
error_message = "Bad Request"
}
tags = []
control_plane_id = konnect_gateway_control_plane.my_konnect_cp.id
route = {
id = konnect_gateway_route.my_route.id
}
}