1. Open the GCP Console and navigate to the Cloud SQL instances page.
2. Select the PostgreSQL instance you want to remediate.
3. Click on the “Edit” button at the top of the page.
4. Scroll down to the “Flags” section.
5. Locate the “external-scripts-enabled” flag and set it to “off”.
6. Click on the “Save” button at the bottom of the page to save the changes.

​

1. Open the Cloud Shell in your GCP console.
2. Run the following command to list all the Cloud SQL instances in your GCP project:
   Copy

   Ask AI

   gcloud sql instances list
   

3. Identify the instance for which you want to remediate the PostgreSQL External Scripts Enabled Flag misconfiguration.
4. Run the following command to update the instance configuration:
   Copy

   Ask AI

   gcloud sql instances patch [INSTANCE_NAME] --database-flags=external_scripting=false
   

   Replace [INSTANCE_NAME] with the name of your Cloud SQL instance.
5. Confirm the update by running the following command:
   Copy

   Ask AI

   gcloud sql instances describe [INSTANCE_NAME]
   

   This will display the details of your Cloud SQL instance, including the updated configuration.

1. Connect to the GCP project using the google-auth and google-cloud-secret-manager libraries.

from google.auth import credentials
from google.cloud import secretmanager

# Set up credentials
credentials, project_id = google.auth.default()
client = secretmanager.SecretManagerServiceClient(credentials=credentials)

2. Retrieve the PostgreSQL instance name and configuration details from the GCP Secret Manager.

# Retrieve PostgreSQL instance name and configuration details from Secret Manager
name = "projects/{project_id}/secrets/{secret_name}/versions/latest".format(
    project_id=project_id,
    secret_name="postgres-config"
)
response = client.access_secret_version(name=name)
config = json.loads(response.payload.data.decode("UTF-8"))

3. Connect to the PostgreSQL instance using the psycopg2 library.

import psycopg2

# Connect to PostgreSQL instance
conn = psycopg2.connect(
    host=config["host"],
    port=config["port"],
    dbname=config["dbname"],
    user=config["user"],
    password=config["password"]
)

4. Disable the External Scripts Enabled flag by updating the postgresql.conf file.

# Disable External Scripts Enabled flag
with conn.cursor() as cursor:
    cursor.execute("ALTER SYSTEM SET external_scripts_enabled TO off;")
    conn.commit()

5. Restart the PostgreSQL instance for the changes to take effect.

# Restart PostgreSQL instance
with conn.cursor() as cursor:
    cursor.execute("SELECT pg_reload_conf();")
    conn.commit()