DB user pass authentication

Introduction

DB user pass authentication is only used for building database connectors. Here, database access is authenticated with username and password over SSL (if unavailable, falling back to no SSL).

How it works

Here's how basic authentication works:

1. Patchworks sends an API request to the required database (e.g. MySQL). The request includes username and password authentication credentials in the HTTP header of the request, encoded in Base64 format.

2. Upon receipt of the request, authentication credentials are extracted from the request header and validated.

3. If the credentials provided are valid, access is granted for the requested resource. If the credentials are invalid or missing, an appropriate error response is returned and access is denied.

User experience of db user pass authentication

When a Patchworks user adds an instance of a connector and chooses to authenticate with db user pass authentication, they will see something similar to the example below:

Related information

• Building a database connector

• Configuring a database connection