You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "andylamp (via GitHub)" <gi...@apache.org> on 2023/08/07 04:35:38 UTC
[GitHub] [airflow] andylamp commented on a diff in pull request #32867: Sanitize the conn_id to disallow potential script execution
andylamp commented on code in PR #32867:
URL: https://github.com/apache/airflow/pull/32867#discussion_r1285367974
##########
airflow/models/connection.py:
##########
@@ -43,6 +47,30 @@ def parse_netloc_to_hostname(*args, **kwargs):
return _parse_netloc_to_hostname(*args, **kwargs)
+def sanitize_conn_id(conn_id: str | None) -> str | None:
+ """
+ Sanitizes the connection id and allows only specific characters to be within. Namely,
+ it allows alphanumeric characters plus the symbols @,#,$,%,&,!,-,_,. and () from 1
+ and up to 200 consecutive matches.
+
+ The character selection is such that it prevents the injection of javascript or
+ executable bits in order to avoid any awkward behavior in the front-end.
+
+ :param conn_id: The connection id to sanitize.
+ :return: the sanitized string, `None` otherwise.
+ """
+ # check if `conn_id` or our match group is `None`
+ if conn_id is None or (res := re2.match(_RE_SANITIZE_CONN_ID, conn_id)) is None:
+ # comment, so it works...?
+ # log.warning(
+ # "We failed to match `conn_id` with value: %s to the allowed pattern or it was None",
+ # conn_id,
+ # )
Review Comment:
Yes, to indicate where my logging was as per my reply above. Happy to remove it completely if you guys are OK with no logging.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org