Description

Currently, BaseConnectorSettings relies on __main__ path to find config.yml and/or .env but __main__ is not defined when the connector is a python module (when src/__main__.py exists).

Reproducible Steps

Steps to create the smallest reproducible scenario:

1. Implement BaseConnectorSettings in a connector developed as a python module
2. Launch the connector

Expected Output

BaseConnectorSettings should find config.yml and/or .env from the entrypoint of a connector.

Actual Output

An error is raised.

Additional information

This fix is required for the migration of the connectors to their "manager supported" version.