notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
py-mysqlclient MySQL database connector for Python
2.2.6 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.2.4Version of this port present on the latest quarterly branch.
Maintainer: fluffy@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2016-06-22 20:36:28
Last Update: 2024-11-20 18:10:55
Commit Hash: 42673dd
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
Also Listed In: python
License: GPLv2
WWW:
https://pypi.org/project/mysqlclient
Description:
MySQL database connector for Python (with Python 3 support).
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}mysqlclient>0:databases/py-mysqlclient@${PY_FLAVOR}
Conflicts:
CONFLICTS:
  • py*-MySQLdb
  • py*-MySQLdb5[0-9]
  • py*-MySQLdb
To install the port:
cd /usr/ports/databases/py-mysqlclient/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-mysqlclient
  • pkg install py311-mysqlclient
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py311-mysqlclient listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-mysqlclient
Package flavors (<flavor>: <package>)
  • py311: py311-mysqlclient
distinfo:
TIMESTAMP = 1732126185 SHA256 (mysqlclient-2.2.6.tar.gz) = c0b46d9b78b461dbb62482089ca8040fa916595b1b30f831ebbd1b0a82b43d53 SIZE (mysqlclient-2.2.6.tar.gz) = 91055

Packages (timestamps in pop-ups are UTC):
py37-mysqlclient
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--2.0.2---2.0.2-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 
py39-mysqlclient
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--2.2.0---2.2.12.2.1
FreeBSD:14:latest--2.1.1----2.1.1
FreeBSD:14:quarterly------2.2.12.2.1
FreeBSD:15:latest--n/a-n/a-2.2.12.2.1
 
py311-mysqlclient
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.2.62.2.6-2.2.62.2.6---
FreeBSD:13:quarterly2.2.42.2.4-2.2.42.2.4---
FreeBSD:14:latest2.2.62.2.6-2.2.62.2.6---
FreeBSD:14:quarterly2.2.42.2.4-2.2.42.2.4---
FreeBSD:15:latest2.2.62.2.6n/a-n/a---
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-setuptools>0 : devel/py-setuptools@py311
  2. py311-wheel>=0.37 : devel/py-wheel@py311
  3. pkgconf>=1.3.0_1 : devel/pkgconf
  4. python3.11 : lang/python311
  5. py311-build>=0 : devel/py-build@py311
  6. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. python3.11 : lang/python311
Library dependencies:
  1. libmysqlclient.so.21 : databases/mysql80-client
This port is required by:
for Build
  1. deskutils/py-paperless-ngx
  2. multimedia/mythtv
for Run
  1. audio/py-supysonic
  2. deskutils/py-paperless-ngx
  3. devel/py-sortinghat
  4. multimedia/mythtv
  5. net-mgmt/observium
  6. security/py-first-server
  7. www/seahub

Configuration Options:
===> The following configuration options are available for py311-mysqlclient-2.2.6: DOCS=on: Build and/or install documentation ===> Use 'make config' to modify these settings
Options name:
databases_py-mysqlclient
USES:
compiler:c11 dos2unix iconv mysql pkgconfig python ssl
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/m/mysqlclient/
  2. https://pypi.org/packages/source/m/mysqlclient/
Collapse this list.

Number of commits found: 33

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
2.2.6
20 Nov 2024 18:10:55
commit hash: 42673dd35c3303adefd946f608bcc433ab55a3a4commit hash: 42673dd35c3303adefd946f608bcc433ab55a3a4commit hash: 42673dd35c3303adefd946f608bcc433ab55a3a4commit hash: 42673dd35c3303adefd946f608bcc433ab55a3a4 files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.2.6 release

Release Notes:	https://github.com/PyMySQL/mysqlclient/releases/tag/v2.2.6
2.2.5
05 Nov 2024 18:06:14
commit hash: 7803d9a1a919a093f18ca7f4a9f1651afbe3da17commit hash: 7803d9a1a919a093f18ca7f4a9f1651afbe3da17commit hash: 7803d9a1a919a093f18ca7f4a9f1651afbe3da17commit hash: 7803d9a1a919a093f18ca7f4a9f1651afbe3da17 files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.2.5 release (+)

Changelog:	https://github.com/PyMySQL/mysqlclient/releases/tag/v2.2.5
2.2.4
01 Aug 2024 12:09:22
commit hash: 9c4a2df695542b84a036078a55756d75a6e60609commit hash: 9c4a2df695542b84a036078a55756d75a6e60609commit hash: 9c4a2df695542b84a036078a55756d75a6e60609commit hash: 9c4a2df695542b84a036078a55756d75a6e60609 files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.2.4 release (+)

What's Changed:

2.2.2:
    Support MySQL 8.3: conn.kill() and conn.shutdown() are deprecated.
    use ruff for formatter
    doc: add link to README
2.2.3:
    fix Connection.kill() broken since 2.2.2
2.2.4:
    Support ssl=True
2.2.1
26 Dec 2023 15:08:50
commit hash: fbaaec4765246bf63a2e68bf4f20e8eec2f6c175commit hash: fbaaec4765246bf63a2e68bf4f20e8eec2f6c175commit hash: fbaaec4765246bf63a2e68bf4f20e8eec2f6c175commit hash: fbaaec4765246bf63a2e68bf4f20e8eec2f6c175 files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.2.1 release (+)

Drop incorporated patch

Changelog:	https://github.com/PyMySQL/mysqlclient/releases/tag/v2.2.1
2.2.0
03 Oct 2023 20:37:25
commit hash: a63cc035abee4d9e1a89c8ac57c9efeb9ae974f5commit hash: a63cc035abee4d9e1a89c8ac57c9efeb9ae974f5commit hash: a63cc035abee4d9e1a89c8ac57c9efeb9ae974f5commit hash: a63cc035abee4d9e1a89c8ac57c9efeb9ae974f5 files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
Author: Rozhuk Ivan
databases/py-mysqlclient: fix build with mariadb

PR:	272481
MFH:	2023Q4
2.2.0
18 Jul 2023 00:53:09
commit hash: 9a80a6ee5e8ebf5c279b3d7a9e7e8b7dbabbaf0acommit hash: 9a80a6ee5e8ebf5c279b3d7a9e7e8b7dbabbaf0acommit hash: 9a80a6ee5e8ebf5c279b3d7a9e7e8b7dbabbaf0acommit hash: 9a80a6ee5e8ebf5c279b3d7a9e7e8b7dbabbaf0a files touched by this commit
Charlie Li (vishwin) search for other commits by this committer
devel/py-setuptools: convert individual consumers to ${PY_SETUPTOOLS}

Currently a no-op, but in the future outputs the correct setuptools
port depending on whether USES_PYTHON=distutils is specified.

With hat: python
PR: 270510, 270358
2.2.0
27 Jun 2023 19:34:34
commit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacbcommit hash: 3d9a815d9c5acbb71f4bb07738bdeab4879feacb files touched by this commit
Rene Ladan (rene) search for other commits by this committer
all: remove explicit versions in USES=python for "3.x+"

The logic in USES=python will automatically convert this to 3.8+ by
itself.

Adjust two ports that only had Python 3.7 mentioned but build fine
on Python 3.8 too.

finance/quickfix: mark BROKEN with PYTHON

libtool: compile:  c++ -DHAVE_CONFIG_H -I. -I../.. -I -I. -I.. -I../.. -I../C++
-DLIBICONV_PLUG -DPYTHON_MAJOR_VERSION=3 -Wno-unused-variable
-Wno-maybe-uninitialized -O2 -pipe -DLIBICONV_PLUG -fstack-protector-strong
-fno-strict-aliasing -DLIBICONV_PLUG -Wall -ansi
-Wno-unused-command-line-argument -Wpointer-arith -Wwrite-strings
-Wno-overloaded-virtual -Wno-deprecated-declarations -Wno-deprecated -std=c++0x
-MT _quickfix_la-QuickfixPython.lo -MD -MP -MF
.deps/_quickfix_la-QuickfixPython.Tpo -c QuickfixPython.cpp  -fPIC -DPIC -o
.libs/_quickfix_la-QuickfixPython.o
warning: unknown warning option '-Wno-maybe-uninitialized'; did you mean
'-Wno-uninitialized'? [-Wunknown-warning-option]
QuickfixPython.cpp:175:11: fatal error: 'Python.h' file not found
          ^~~~~~~~~~
1 warning and 1 error generated.

Reviewed by:	portmgr, vishwin, yuri
Differential Revision:	<https://reviews.freebsd.org/D40568>
2.2.0
24 Jun 2023 13:38:02
commit hash: 399e1b7e12ec8add88ad5aba627a71c5a50d41fdcommit hash: 399e1b7e12ec8add88ad5aba627a71c5a50d41fdcommit hash: 399e1b7e12ec8add88ad5aba627a71c5a50d41fdcommit hash: 399e1b7e12ec8add88ad5aba627a71c5a50d41fd files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.2.0 release (+)

Changelog:	https://github.com/PyMySQL/mysqlclient/releases/tag/v2.2.0
2.1.1
11 Jan 2023 15:58:34
commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656commit hash: 77d68471aded6907dbbcb5ef50d557e4c69db656 files touched by this commit
Dmitry Marakasov (amdmi3) search for other commits by this committer
*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
2.1.1
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.1.1
23 Jun 2022 16:23:54
commit hash: 88acfca540184a18564d81dd1932d242d8151cf3commit hash: 88acfca540184a18564d81dd1932d242d8151cf3commit hash: 88acfca540184a18564d81dd1932d242d8151cf3commit hash: 88acfca540184a18564d81dd1932d242d8151cf3 files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.1.1 release (+)

Changelog:	https://github.com/PyMySQL/mysqlclient/releases/tag/v2.1.1
2.1.0
18 Nov 2021 18:00:08
commit hash: 9aa0c3ca74d10a93b844e76f29c2b612a43f3fcdcommit hash: 9aa0c3ca74d10a93b844e76f29c2b612a43f3fcdcommit hash: 9aa0c3ca74d10a93b844e76f29c2b612a43f3fcdcommit hash: 9aa0c3ca74d10a93b844e76f29c2b612a43f3fcd files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.1.0 release

Changelog:      https://github.com/PyMySQL/mysqlclient/releases/tag/v2.1.0
Sponsored by:   Netzkommune GmbH
2.0.3
29 Oct 2021 09:50:18
commit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08acommit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08acommit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08acommit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08a files touched by this commit
Stefan Eßer (se) search for other commits by this committer
*/*: Remove redundant '-[0-9]*' from CONFLICTS

The conflict checks compare the patterns first against the package
names without version (as reported by "pkg query "%n"), then - if
there was no match - agsinst the full package names including the
version (as reported by "pkg query "%n-%v").

Many CONFLICTS definitions used patterns like "bash-[0-9]*" to filter
for the bash package in any version. But that pattern is functionally
identical with just "bash".

Approved by:	portmgr (blanket)
2.0.3
16 Aug 2021 12:11:54
commit hash: 53dd641cbd9c7deff06c3742111bca49e68307efcommit hash: 53dd641cbd9c7deff06c3742111bca49e68307efcommit hash: 53dd641cbd9c7deff06c3742111bca49e68307efcommit hash: 53dd641cbd9c7deff06c3742111bca49e68307ef files touched by this commit
Dima Panov (fluffy) search for other commits by this committer
databases/py-mysqlclient: update to 2.0.3 release
2.0.2
07 Apr 2021 08:09:01
commit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455c files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
2.0.2
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
2.0.2
12 Dec 2020 11:11:22
Revision:557812Original commit files touched by this commit
fluffy search for other commits by this committer
databases/py-mysqlclient: update to 2.0.2 release
2.0.1
03 Jul 2020 09:06:50
Revision:541089Original commit files touched by this commit
fluffy search for other commits by this committer
databases/py-mysqlclient: update to 2.0.1 release

* Dropped Python 2 support
* Dropped Django 1.11 support
* Add context manager interface to Connection which closes the connection on
``__exit__``.
* Add ``ssl_mode`` option.
* Fixed multithread safety issue in fetching row.
* Removed obsolete members from Cursor. (e.g. `messages`, `_warnings`,
`_last_executed`)
1.4.6_2
22 Jun 2020 16:50:32
Revision:539884Original commit files touched by this commit
fluffy search for other commits by this committer
databases/py-mysqlclient: revert gc threaded patch

It caused python sigabort with a "GC object already tracked" message in
singlethreaded app.
This happens only with a fetchmany() on a streaming cursor,
MySQLdb.cursors.SSCursor.

PR:		246313
Reported by:	Jeroen Pulles <jeroen.pulles@gmail.com>
MFH:		2020Q2
1.4.6_1
28 Mar 2020 13:16:55
Revision:529631Original commit files touched by this commit
fluffy search for other commits by this committer
databases/py-mysqlclient: pet port

- Change MASTER_SITES from GitHub to CHEESESHOP
- Use USE_PYTHON=concurrent instead of setting DOCSDIR manually
- Point WWW link to official PyPI page in pkg-descr

Submitted by:	sunpoet via private mail
1.4.6_1
28 Mar 2020 12:22:18
Revision:529330Original commit files touched by this commit
fluffy search for other commits by this committer
databases/py-mysqlclient: Add some gc safety around _mysql__fetch_row

- Users of gc.get_referrers() could cause a SystemError to be raised if this
function is running in a different python thread.
- While here, take maintainership

Obtained from:	PyMySQL repo
1.4.6
28 Mar 2020 11:26:59
Revision:529327Original commit files touched by this commit
rene search for other commits by this committer
Return Neels ports to the pool on his request.

Submitted by:	neelc@neelc.org (former maintainer) via freebsd-ports
1.4.6
11 Jan 2020 04:47:01
Revision:522627Original commit files touched by this commit
fluffy search for other commits by this committer
databases/py-mysqlclient: update to 1.4.6 release

* The cp1252 encoding is used when charset is "latin1". (#390)
* The auth_plugin option is added. (#389)
* charset option is passed to mysql_options(mysql, MYSQL_SET_CHARSET_NAME,
charset) before mysql_real_connect is called. This avoid extra SET NAMES
<charset> query when creating connection.
* --static build supports libmariadbclient.a
* Try mariadb_config when mysql_config is not found
* Fixed warning happend in Python 3.8 (#359)
* Fixed SEGV MySQLdb.escape_string("1") when libmariadb is used and no
connection is created. (#367)
* Fixed many circular references are created in Cursor.executemany(). (#375)

PR:		243076
Submitted by:	fluffy
Approved by:	maintainer timeout (>1w)
1.4.2.p1_1
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
1.4.2.p1
08 Jul 2019 12:17:04
Revision:506211Original commit files touched by this commit
pkubaj search for other commits by this committer
databases/py-mysqlclient: fix build with GCC-based architectures

Since the switch to MySQL 5.7, C11-aware compiler is required:
/usr/bin/ld: cannot find -latomic

Approved by:	mentors (implicit approval)
1.4.2.p1
03 May 2019 11:33:25
Revision:500718Original commit files touched by this commit
swills search for other commits by this committer
databases/py-mysqlclient: Update to 1.4.2.post1

PR:		237709
Submitted by:	Neel Chauhan <neel@neelc.org> (maintainer)
1.3.13
28 Jul 2018 14:44:02
Revision:475576Original commit files touched by this commit
miwi search for other commits by this committer
- Update to 1.3.13

PR:		230106
Sponsored by:	iXsystems Inc.
1.3.12
30 Nov 2017 15:50:34
Revision:455210Original commit files touched by this commit Sanity Test Failure
mat search for other commits by this committer
Convert Python ports to FLAVORS.

  Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
1.3.12
03 Nov 2017 13:01:57
Revision:453402Original commit files touched by this commit
dvl search for other commits by this committer
Upgrade to 1.3.12

maintainer timeout

PR:		222983
Submitted by:	Neel Chauhan
1.3.8
10 Dec 2016 13:39:22
Revision:428295Original commit files touched by this commit
antoine search for other commits by this committer
Move py35-mysqlclient and py35-psycopg2 to match existing naming convention
1.3.8
10 Oct 2016 19:16:36
Revision:423679Original commit files touched by this commit
pawel search for other commits by this committer
- Update to version 1.3.8 [1]
- Install doc files only when needed

PR:		213171 [1]
Submitted by:	Neel Chauhan (maintainer) [1]
1.3.7
22 Jun 2016 20:36:20
Revision:417332Original commit files touched by this commit
pawel search for other commits by this committer
MySQL database connector for Python (with Python 3 support).

WWW: https://github.com/PyMySQL/mysqlclient-python

PR:		209548
Submitted by:	Neel Chauhan <neel@neelc.org>

Number of commits found: 33