Due to default case-insensitive collation in MySQL or MariaDB databases, third-party authentication user IDs are not case-sensitive and could cause different IDs to match.
This issue has been addressed by https://github.com/python-social-auth/social-app-django/pull/566 and fix released in 5.4.1.
An immediate workaround would be to change collation of the affected field:
ALTER TABLE `social_auth_usersocialauth` MODIFY `uid` varchar(255) COLLATE `utf8_bin`;
This issue was discovered by folks at https://opencraft.com/.
{ "nvd_published_at": "2024-04-24T20:15:07Z", "cwe_ids": [ "CWE-178", "CWE-303" ], "severity": "MODERATE", "github_reviewed": true, "github_reviewed_at": "2024-04-24T18:47:21Z" }