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

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
py-mssql Python database interface for simple MS-SQL access
1.0.2_3 databases Deleted 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 1.0.2Version of this port present on the latest quarterly branch.
Broken BROKEN: Broken with current FreeTDS. Please use databases/py-pymssql instead
Deprecated DEPRECATED: Broken with current FreeTDS. Please use databases/py-pymssql instead
Expired This port expired on: 2015-10-28
Ignore IGNORE: is marked as broken: Broken with current FreeTDS. Please use databases/py-pymssql instead
There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org
search for ports maintained by this maintainer
Port Added: 2004-03-05 12:36:42
Last Update: 2015-10-28 20:45:48
SVN Revision: 400417
Also Listed In: python
License: LGPL21
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • py27-mssql>0:databases/py-mssql
No installation instructions: this port has been deleted.
The package name of this deleted port was:
PKGNAME: py27-mssql
Flavors: there is no flavor information for this port.
distinfo:
There is no distinfo for this port.

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py27-setuptools27>0 : devel/py-setuptools27
  2. python2.7 : lang/python27
  3. python2 : lang/python2
Runtime dependencies:
  1. py27-setuptools27>0 : devel/py-setuptools27
  2. python2.7 : lang/python27
  3. python2 : lang/python2
Library dependencies:
  1. libsybdb.so : databases/freetds
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. http://aarnet.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  2. http://distcache.FreeBSD.org/ports-distfiles/
  3. http://downloads.sourceforge.net/project/pymssql/pymssql/1.0.2/
  4. http://freefr.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  5. http://garr.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  6. http://heanet.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  7. http://hivelocity.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  8. http://ignum.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  9. http://internode.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  10. http://iweb.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  11. http://jaist.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  12. http://kent.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  13. http://master.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  14. http://nchc.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  15. http://ncu.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  16. http://netcologne.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  17. http://sunet.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  18. http://superb-dca3.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  19. http://switch.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  20. http://tenet.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  21. http://ufpr.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
  22. http://waix.dl.sourceforge.net/project/pymssql/pymssql/1.0.2/
Port Moves

Number of commits found: 25

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
28 Oct 2015 20:45:48
Original commit files touched by this commit  1.0.2_3
Revision:400417
rm search for other commits by this committer
Remove expired ports

databases/py-mssql: Broken with current FreeTDS. Please use databases/py-pymssql
net/py-medusa: Abandoned upstream, last release was in 2005
28 Sep 2015 18:43:53
Original commit files touched by this commit  1.0.2_3
Revision:398134
rm search for other commits by this committer
databases/py-mssql: mark broken and deprecated

pymssql 1.0.2 is known by its developers [1] to be broken with FreeTDS 0.91 and
later. It should be upgraded to 2.x anyway for Python 3. The bug is that DB
queries return no rows, and therefore it's unlikely to work for anyone.

[1] http://pymssql.org/en/latest/faq.html#queries-return-no-rows

Users should switch to using databases/py-pymssql instead.
Expiration date is set to 2015-10-28.

PR:		198719
Submitted by:	bilbo@hobbiton.org
24 Mar 2015 13:30:31
Original commit files touched by this commit  1.0.2_3
Revision:382092
amdmi3 search for other commits by this committer
- Clarify LICENSE
- Add LICENSE_FILE
- Strip library
27 Sep 2014 08:31:58
Original commit files touched by this commit  1.0.2_2
Revision:369379
riggs search for other commits by this committer
Modernise databases/freetds port
- Retire databases/freetds-msdblib port
  (no longer needed, recently updated upstream version has necessary compat
   option which is now enabled in the freetds port)
- Fix LIB_DEPENDS in dependent ports
- Bump PORTREVISION in freetds and dependent ports

PR:		193850
Submitted by:	5u623l20@gmail.com (maintainer)
22 Sep 2014 15:15:27
Original commit files touched by this commit  1.0.2_1
Revision:368959
riggs search for other commits by this committer
- Fix build breakage due to recent upgrade of databases/freetds
- Add LICENSE
- Modernise port Makefile
- Bump PORTREVISION
13 Jan 2014 21:00:04
Original commit files touched by this commit  1.0.2
Revision:339634
rene search for other commits by this committer
Python cleanup:
- USE_PYTHON* = 2.X -> USE_PYTHON* = 2
- USE_PYTHON* = 2.X+ -> USE_PYTHON* = yes
Reviewed by:	python (mva, rm)
Approved by:	portmgr-lurkers (mat)
28 Sep 2013 11:13:16
Original commit files touched by this commit  1.0.2
Revision:328563
mva search for other commits by this committer
- Convert to PYDISTUTILS_AUTOPLIST
- Enable stage support
- Limit to the supported python versions
- Change to new LIB_DEPENDS where necessary
- Switch to new OPTIONS framework where necessary
20 Sep 2013 16:13:49
Original commit files touched by this commit  1.0.2
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
16 Aug 2011 18:04:10
Original commit files touched by this commit  1.0.2

sylvio search for other commits by this committer
- Update to 1.0.2
25 Feb 2011 00:12:12
Original commit files touched by this commit  1.0.1_1
  Sanity Test Failure
miwi search for other commits by this committer
- Move over to py25+ or above
- While here kick md5 support
23 May 2010 21:16:16
Original commit files touched by this commit  1.0.1

linimon search for other commits by this committer
Reset perky@FreeBSD.org due to maintainer-timeouts and no response
to email.

Hat:            portmgr
22 Aug 2009 00:18:43
Original commit files touched by this commit  1.0.1

amdmi3 search for other commits by this committer
- Switch SourceForge ports to the new File Release System: categories starting
with D
09 Feb 2009 16:23:26
Original commit files touched by this commit  1.0.1

vsevolod search for other commits by this committer
- Update py-mssql to 1.0.1

PR:             ports/131407
Submitted by:   Wen Heping <wenheping [at] gmail.com>
Approved by:    perky (maintainer)
30 Jul 2007 09:42:28
Original commit files touched by this commit  0.8.0

alexbl search for other commits by this committer
 - Make Python 2.5.1 the default Python version
 - Add significantly better support in bsd.python.mk for working with
   Python Eggs and the easy_install system

Tested by:      pointyhat runs
Approved by:    pav (portmgr)
Most work by:   perky
Thanks to:      pav
11 Feb 2007 14:52:06
Original commit files touched by this commit  0.8.0

perky search for other commits by this committer
Update to 0.8.0

PR:             108962
Submitted by:   Uwe Laverenz <uwe@laverenz.de>
04 May 2006 21:41:12
Original commit files touched by this commit  0.7.3

edwin search for other commits by this committer
Remove USE_REINPLACE from all categories starting with D
22 Jan 2006 08:23:41
Original commit files touched by this commit  0.7.3

edwin search for other commits by this committer
SHA256ify

Approved by:    krion@
06 Sep 2005 12:44:42
Original commit files touched by this commit  0.7.3

vsevolod search for other commits by this committer
Update to 0.7.3.

Submitted by:   Andrzej Kuku?a <akukula@gmail.com>
Approved by:    perky (mentor, maintainer)
25 Jul 2005 13:16:14
Original commit files touched by this commit  0.7.1

perky search for other commits by this committer
This patch should be removed before 0.7.1 update.

Pointy hat goes to:     vsevolod
24 Jul 2005 13:22:04
Original commit files touched by this commit  0.7.1

vsevolod search for other commits by this committer
Update to 0.7.1.

Approved by:    perky (mentor, maintainer)
05 May 2005 08:47:45
Original commit files touched by this commit  0.6.0_1

perky search for other commits by this committer
Fix build for the recent freetds library and unmark BROKEN.
30 Apr 2005 01:02:40
Original commit files touched by this commit  0.6.0_1

kris search for other commits by this committer
BROKEN: Does not compile
11 Apr 2005 20:52:52
Original commit files touched by this commit  0.6.0_1

pav search for other commits by this committer
- Chase freetds shlib bump
07 Nov 2004 16:24:48
Original commit files touched by this commit  0.6.0

perky search for other commits by this committer
Update to 0.6.0
05 Mar 2004 12:36:16
Original commit files touched by this commit  0.5.1

perky search for other commits by this committer
Add new port for py-mssql 0.5.1,
A simple database interface to MS-SQL for Python.

Number of commits found: 25

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
gnutlsMar 31
postgresql10-serverMar 29
postgresql11-serverMar 29
postgresql12-serverMar 29
postgresql96-serverMar 29
gitlab-ceMar 26
rubygem-jsonMar 26
jenkinsMar 25
jenkins-ltsMar 25
phpmyadminMar 25
phpmyadmin5Mar 25
puppet6Mar 23
puppetdb5Mar 23
puppetdb6Mar 23
puppetserver5Mar 23

9 vulnerabilities affecting 78 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-03-31 16:53:36


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38971
Broken 593
Deprecated 528
Ignore 864
Forbidden 5
Restricted 150
No CDROM 72
Vulnerable 23
Expired 3
Set to expire 502
Interactive 0
new 24 hours 6
new 48 hours18
new 7 days63
new fortnight91
new month156

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.