notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Current status

The server has been repaired, with a new power supply, for $23. I am waiting for lower COVID rates before visiting the datacenter to return it.
Port details
py-pymssql Python database interface for MS-SQL. Version 2
2.1.4 databases on this many watch lists=1 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.1.4Version of this port present on the latest quarterly branch.
Maintainer: ports@thelanman.net search for ports maintained by this maintainer
Port Added: 2015-09-28 18:36:18
Last Update: 2021-04-07 08:09:01
Commit Hash: cf118cc
People watching this port, also watch:: json-c, rubywarden, sysinfo, miller
Also Listed In: python
License: LGPL21
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}pymssql>0:databases/py-pymssql@${PY_FLAVOR}
To install the port: cd /usr/ports/databases/py-pymssql/ && make install clean
To add the package: pkg install py37-pymssql
PKGNAME: py37-pymssql
Package flavors (<flavor>: <package>)
  • py37: py37-pymssql
distinfo:
Packages: (move your mouse over the cells for more information)
py27-pymssql
ABIlatestquarterly
FreeBSD:11:aarch642.1.32.1.4
FreeBSD:11:amd64--
FreeBSD:11:armv6-2.1.4
FreeBSD:11:i386--
FreeBSD:11:mips-2.1.4
FreeBSD:11:mips64-2.1.4
FreeBSD:12:aarch642.1.3-
FreeBSD:12:amd64--
FreeBSD:12:armv62.1.32.1.4
FreeBSD:12:armv72.1.32.1.4
FreeBSD:12:i386--
FreeBSD:12:mips2.1.32.1.4
FreeBSD:12:mips642.1.32.1.4
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips2.1.4-
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py36-pymssql
ABIlatestquarterly
FreeBSD:11:aarch642.1.3-
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch642.1.3-
FreeBSD:12:amd64--
FreeBSD:12:armv62.1.3-
FreeBSD:12:armv72.1.3-
FreeBSD:12:i386--
FreeBSD:12:mips2.1.3-
FreeBSD:12:mips642.1.3-
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py37-pymssql
ABIlatestquarterly
FreeBSD:11:aarch64-2.1.4
FreeBSD:11:amd64-2.1.4
FreeBSD:11:armv6-2.1.4
FreeBSD:11:i386-2.1.4
FreeBSD:11:mips-2.1.4
FreeBSD:11:mips64-2.1.4
FreeBSD:12:aarch64-2.1.4
FreeBSD:12:amd64-2.1.4
FreeBSD:12:armv6-2.1.4
FreeBSD:12:armv7-2.1.4
FreeBSD:12:i386-2.1.4
FreeBSD:12:mips-2.1.4
FreeBSD:12:mips64-2.1.4
FreeBSD:12:powerpc64-2.1.4
FreeBSD:13:aarch642.1.42.1.4
FreeBSD:13:amd64-2.1.4
FreeBSD:13:armv62.1.42.1.4
FreeBSD:13:armv72.1.42.1.4
FreeBSD:13:i386-2.1.4
FreeBSD:13:mips2.1.4-
FreeBSD:13:mips64--
FreeBSD:13:powerpc642.1.42.1.4
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv62.1.4-
FreeBSD:14:armv72.1.4-
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc642.1.4-
 
py38-pymssql
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd642.1.4-
FreeBSD:11:armv6--
FreeBSD:11:i3862.1.4-
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64--
FreeBSD:12:amd642.1.4-
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i3862.1.4-
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd642.1.4-
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i3862.1.4-
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch642.1.4-
FreeBSD:14:amd642.1.4-
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i3862.1.4-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py37-setuptools-git>0 : devel/py-setuptools-git@py37
  2. cython-3.7 : lang/cython@py37
  3. py37-setuptools>0 : devel/py-setuptools@py37
  4. python3.7 : lang/python37
Runtime dependencies:
  1. py37-setuptools>0 : devel/py-setuptools@py37
  2. python3.7 : lang/python37
Library dependencies:
  1. libsybdb.so : databases/freetds
There are no ports dependent upon this port

Configuration Options:
Options name:

USES:

Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/p/pymssql/
  2. https://pypi.org/packages/source/p/pymssql/
Collapse this list.
Port Moves
  • port moved here from databases/py-mssql on 2015-10-28
    REASON: Broken with current FreeTDS

Number of commits found: 12

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
07 Apr 2021 08:09:01
 files touched by this commit commit hash:cf118ccf875508b9a1c570044c93cfcc82bd455c  2.1.4
mat search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  2.1.4
mat search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
28 Dec 2020 23:02:15
Original commit files touched by this commit Revision:559531  2.1.4
antoine search for other commits by this committer
Drop python 2.7 support from a few ports

With hat:	portmgr
24 Dec 2020 13:46:02
Original commit files touched by this commit Revision:559094  2.1.4
kai search for other commits by this committer
Relax hardcoded paths to fix build with Python 3.8.7

Since r558913 Python 3.8 incorporates BPO-42604 [1] which changed the
shared libs naming scheme.  This means "EXT_SUFFIX" is now derived from
SOABI and yields with Python 3.8 to ".cpython-38.so" instead of ".so".

The affected ports strip the libaries in the "post-install" target via
hardcoded path(s) and the build fails at the end because the new extension
is not expected at this place.

Remedy the issue by adding wildcards to these paths.  This should also
prepare the ports for future Python releases, which will use the new shared
libs naming scheme.

[1] https://bugs.python.org/issue42604

PR:		252057
Reported by:	John Kennedy
Reviewed by:	fluffy, koobs
Approved by:	koobs (python)
04 Apr 2019 19:37:23
Original commit files touched by this commit Revision:497863  2.1.4
leres search for other commits by this committer
databases/py-pymssql: Update to 2.1.4 and unbreak Python 3 build.

PR:		236998
Submitted by:	Henrik Hudson
Approved by:	Henrik Hudson (maintainer), ler (mentor, implicit)
20 Jun 2018 17:05:44
Original commit files touched by this commit Revision:472884  2.1.3
mat search for other commits by this committer
Use PY_FLAVOR for dependencies.

FLAVOR is the current port's flavor, it should not be used outside of
this scope.

Sponsored by:	Absolight
30 Nov 2017 15:50:34
Original commit files touched by this commit Revision:455210  2.1.3  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)
22 Nov 2017 13:30:29
Original commit files touched by this commit Revision:454687  2.1.3
swills search for other commits by this committer
databases/py-pymssql: Update to 2.1.3

PR:		221358
Submitted by:	David Wahlund <david@dafnet.se>
Approved by:	ports@thelanman.net (maintainer timeout, >3 months)
21 Oct 2016 12:51:41
Original commit files touched by this commit Revision:424411  2.1.1  Sanity Test Failure
mat search for other commits by this committer
${RM} already has -f.

PR:		213570
Submitted by:	mat
Exp-run by:	antoine
Sponsored by:	Absolight
18 Jul 2016 21:06:53
Original commit files touched by this commit Revision:418751  2.1.1
amdmi3 search for other commits by this committer
- Fix build after FreeTDS update by porting upstream commit ec46fea

PR:		210363
Reported by:	ports@thelanman.net (maintainer), pkg-fallout
Approved by:	portmgr blanket
01 Apr 2016 14:00:57
Original commit files touched by this commit Revision:412346  2.1.1
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
28 Sep 2015 18:36:11
Original commit files touched by this commit Revision:398133  2.1.1
rm search for other commits by this committer
PyMSSQL is a MS-SQL database adapter for the Python programming
language. It was written from scratch using FreeTDS library.

This is the version 2 release branch.

WWW: http://www.pymssql.org/
WWW: https://github.com/pymssql/pymssql

PR:		198694
Submitted by:	ports@thelanman.net (based on)

Number of commits found: 12