pkg/38090: databases/py-mysqldb out-of-date, breaks www/py-django

[mk%msu.edu@localhost]

>Number:         38090
>Category:       pkg
>Synopsis:       databases/py-mysqldb out-of-date, breaks www/py-django
>Confidential:   no
>Severity:       serious
>Priority:       low
>Responsible:    pkg-manager
>State:          open
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Sat Feb 23 02:20:00 +0000 2008
>Originator:     Matt Kolb
>Release:        4.0
>Organization:
Michigan State University
>Environment:
NetBSD clabba 4.0 NetBSD 4.0 (GENERIC) #0: Sun Dec 16 00:20:10 PST 2007  
builds@wb34:/home/builds/ab/netbsd-4-0-RELEASE/i386/200712160005Z-obj/home/builds/ab/netbsd-4-0-RELEASE/src/sys/arch/i386/compile/GENERIC
 i386
>Description:
The django version in www/py-django includes an option to be built with MySQL.  
This requires databases/py-mysql.  The version that is currently in pkgsrc is 
sorely out of date, and, though it builds, is not up to the requirement of 
django.

I took a quick look at the databases/py-mysql package, and ripped out the 
patches (effectively a similar thing had been done upstream, making the patches 
unnecessary), and removed the files/Site.in (no longer necessary, as far as I 
could see).  I'm including a patch.  As this has been apparently unmaintained 
for the last few years, I would be glad to take over maintainer-status.
>How-To-Repeat:
Install www/py-django with PKG_OPTIONS.django=mysql

Then start django server with DATABASE_ENGINE set to mysql.  The installed 
version of py-mysqldb is unsupported.
>Fix:
Note, you'll have to manually remove patches/patch-aa, patches/patch-ab and 
files/ with this patch, which is the output of:

cvs diff -u -N

If this patch format is unacceptable please let me know and I'll provide the 
patchset is whichever way you'd prefer.

Index: Makefile
===================================================================
RCS file: /cvsroot/pkgsrc/databases/py-mysqldb/Makefile,v
retrieving revision 1.22
diff -u -r1.22 Makefile
--- Makefile    5 Feb 2006 23:08:36 -0000       1.22
+++ Makefile    23 Feb 2008 01:53:20 -0000
@@ -1,8 +1,8 @@
 # $NetBSD: Makefile,v 1.22 2006/02/05 23:08:36 joerg Exp $
 
-DISTNAME=      MySQL-python-0.9.2
-PKGNAME=       ${PYPKGPREFIX}-mysqldb-0.9.2
-PKGREVISION=   3
+DISTNAME=      MySQL-python-1.2.2
+PKGNAME=       ${PYPKGPREFIX}-mysqldb-1.2.2
+PKGREVISION=   1
 CATEGORIES=    databases python
 MASTER_SITES=  ${MASTER_SITE_SOURCEFORGE:=mysql-python/}
 
Index: PLIST
===================================================================
RCS file: /cvsroot/pkgsrc/databases/py-mysqldb/PLIST,v
retrieving revision 1.4
diff -u -r1.4 PLIST
--- PLIST       14 Sep 2003 16:43:48 -0000      1.4
+++ PLIST       23 Feb 2008 01:53:20 -0000
@@ -1,49 +1,2 @@
-@comment $NetBSD: PLIST,v 1.4 2003/09/14 16:43:48 recht Exp $
-${PYSITELIB}/CompatMysqldb.py
-${PYSITELIB}/CompatMysqldb.pyc
-${PYSITELIB}/CompatMysqldb.pyo
-${PYSITELIB}/MySQLdb/__init__.py
-${PYSITELIB}/MySQLdb/__init__.pyc
-${PYSITELIB}/MySQLdb/__init__.pyo
-${PYSITELIB}/MySQLdb/connections.py
-${PYSITELIB}/MySQLdb/connections.pyc
-${PYSITELIB}/MySQLdb/connections.pyo
-${PYSITELIB}/MySQLdb/constants/CLIENT.py
-${PYSITELIB}/MySQLdb/constants/CLIENT.pyc
-${PYSITELIB}/MySQLdb/constants/CLIENT.pyo
-${PYSITELIB}/MySQLdb/constants/CR.py
-${PYSITELIB}/MySQLdb/constants/CR.pyc
-${PYSITELIB}/MySQLdb/constants/CR.pyo
-${PYSITELIB}/MySQLdb/constants/ER.py
-${PYSITELIB}/MySQLdb/constants/ER.pyc
-${PYSITELIB}/MySQLdb/constants/ER.pyo
-${PYSITELIB}/MySQLdb/constants/FIELD_TYPE.py
-${PYSITELIB}/MySQLdb/constants/FIELD_TYPE.pyc
-${PYSITELIB}/MySQLdb/constants/FIELD_TYPE.pyo
-${PYSITELIB}/MySQLdb/constants/FLAG.py
-${PYSITELIB}/MySQLdb/constants/FLAG.pyc
-${PYSITELIB}/MySQLdb/constants/FLAG.pyo
-${PYSITELIB}/MySQLdb/constants/REFRESH.py
-${PYSITELIB}/MySQLdb/constants/REFRESH.pyc
-${PYSITELIB}/MySQLdb/constants/REFRESH.pyo
-${PYSITELIB}/MySQLdb/constants/__init__.py
-${PYSITELIB}/MySQLdb/constants/__init__.pyc
-${PYSITELIB}/MySQLdb/constants/__init__.pyo
-${PYSITELIB}/MySQLdb/converters.py
-${PYSITELIB}/MySQLdb/converters.pyc
-${PYSITELIB}/MySQLdb/converters.pyo
-${PYSITELIB}/MySQLdb/cursors.py
-${PYSITELIB}/MySQLdb/cursors.pyc
-${PYSITELIB}/MySQLdb/cursors.pyo
-${PYSITELIB}/MySQLdb/sets.py
-${PYSITELIB}/MySQLdb/sets.pyc
-${PYSITELIB}/MySQLdb/sets.pyo
-${PYSITELIB}/MySQLdb/times.py
-${PYSITELIB}/MySQLdb/times.pyc
-${PYSITELIB}/MySQLdb/times.pyo
-${PYSITELIB}/_mysql.so
-${PYSITELIB}/_mysql_exceptions.py
-${PYSITELIB}/_mysql_exceptions.pyc
-${PYSITELIB}/_mysql_exceptions.pyo
-@dirrm ${PYSITELIB}/MySQLdb/constants
-@dirrm ${PYSITELIB}/MySQLdb
+@comment $NetBSD$
+${PYSITELIB}/MySQL_python-1.2.2-py2.4-netbsd-4.0-i386.egg
Index: distinfo
===================================================================
RCS file: /cvsroot/pkgsrc/databases/py-mysqldb/distinfo,v
retrieving revision 1.7
diff -u -r1.7 distinfo
--- distinfo    26 Feb 2006 16:37:41 -0000      1.7
+++ distinfo    23 Feb 2008 01:53:20 -0000
@@ -1,7 +1,5 @@
 $NetBSD: distinfo,v 1.7 2006/02/26 16:37:41 joerg Exp $
 
-SHA1 (MySQL-python-0.9.2.tar.gz) = b6959ee5e28847e557229ddc318b097f10144ff2
-RMD160 (MySQL-python-0.9.2.tar.gz) = f7ef371e8f2c0a3b6979a99bfa368e4342aa4080
-Size (MySQL-python-0.9.2.tar.gz) = 64258 bytes
-SHA1 (patch-aa) = 27ab8d1f675197e1fdaf5760dbdad5ea95043f59
-SHA1 (patch-ab) = d063f5a51fef1ed20015a7370ff80f37c7317bf5
+SHA1 (MySQL-python-1.2.2.tar.gz) = 945a04773f30091ad81743f9eb0329a3ee3de383
+RMD160 (MySQL-python-1.2.2.tar.gz) = 3f3ff52102c41f86de3181d33132f15a9882a5b1
+Size (MySQL-python-1.2.2.tar.gz) = 87078 bytes