RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1885641 - python36:3.6 Rebase python-PyMySQL to the 0.10.x release
Summary: python36:3.6 Rebase python-PyMySQL to the 0.10.x release
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 8
Classification: Red Hat
Component: python-PyMySQL
Version: 8.1
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: rc
: 8.4
Assignee: Michal Schorm
QA Contact: Lukáš Zachar
Lenka Špačková
URL:
Whiteboard:
Depends On:
Blocks: 1820628 1827261 1920596
TreeView+ depends on / blocked
 
Reported: 2020-10-06 15:10 UTC by Michal Schorm
Modified: 2021-05-18 16:12 UTC (History)
5 users (show)

Fixed In Version: python-PyMySQL-0.10.1-2.module+el8.4.0+9657+a4b6a102
Doc Type: Enhancement
Doc Text:
Documented in Bug 1820628.
Clone Of:
: 1920596 (view as bug list)
Environment:
Last Closed: 2021-05-18 16:12:12 UTC
Type: Bug
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

Description Michal Schorm 2020-10-06 15:10:55 UTC 
A plan was made to rebase python-PyMySQL to the latest upstream version (currently 0.10.1)

Right now, there are two module streams which PyMySQL is a part of.
In "python36" stream, there is PyMySQL 0.8.0 version,
while in "python38" stream, there is PyMySQL 0.9.3 version

A customer requests has been made to add support for:
  * "caching_sha2_password" authentication mechanism, which is now a default authentication mechanism to connect to MySQL 8.0 database.
    * upstream added support for this authentication mechanism in PyMySQL-0.9.0 with aditional fixes though the 0.9.x release.
  * "auth_ed25519" authentication mechanism, which is used to connect to MariaDB DB and which is more secure than the default one used to connect to MariaDB databases.
    * upstream added support for this authentication mechanism in PyMySQL-0.10.0

---

There is a one particular change which we will need to tak a special care of.
In the PyMySQL-0.9.0 release, the upstream switched the default charset from "latin1" to "utf8mb4".
This was done to align with MySQL 8.0, which switched its default charset to "utf8mb4" too.

Currently, the PyMySQL-0.8.0 in "python36" stream has the old default, while PyMySQL-0.9.3 in the "python38" stream has the new deafult.
To avoid any issues in application which do not set the charset and rely on the default instead, we plan to revert this upstream change in the "python36" stream.
Comment 1 Michal Schorm 2020-10-06 15:18:29 UTC 
PyMySQL upstream changelog:
  https://github.com/PyMySQL/PyMySQL/blob/master/CHANGELOG.md

Commit that changed the default charset:
  https://github.com/PyMySQL/PyMySQL/pull/692/files
Comment 15 errata-xmlrpc 2021-05-18 16:12:12 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (python36:3.6 bug fix and enhancement update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2021:1930
Note You need to log in before you can comment on or make changes to this bug.