pkg/39954: databases/py-sqlite3 and www/ap2-python

[lloyd%must-have-coffee.gen.nz@localhost]

>Number:         39954
>Category:       pkg
>Synopsis:       databases/py-sqlite3 and www/ap2-python
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Tue Nov 18 21:30:00 +0000 2008
>Originator:     Lloyd Parkes
>Release:        4.0.1
>Organization:
Must Have Coffee
>Environment:
NetBSD netbsd.... 4.0.1 NetBSD 4.0.1 (GENERIC) #0: Tue Oct  7 22:58:48 PDT 2008 
 
builds@wb30:/home/builds/ab/netbsd-4-0-1-RELEASE/i386/200810080053Z-obj/home/builds/ab/netbsd-4-0-1-RELEASE/src/sys/arch/i386/compile/GENERIC
 i386
>Description:
databases/py-sqlite3 and www/ap2-python define the symbols in their respective 
shared libraries with names that conflict with one another (or with Apache 
itself). The end result Apache dumps core with SIGSEGV after one initialisation 
function gets called twice and another doesn't get called at all.

>How-To-Repeat:
Install www/trac to use mod_python and watch Apache dump core.


>Fix:
Whitespace in the following patch may be munged, but it's only three lines 
added to each package's Makefile.

NetBSD-4.0.1@netbsd$ pkgdiff www/ap2-python/Makefile
$NetBSD$

--- www/ap2-python/Makefile.orig        2008-09-16 09:20:23.000000000 +1200
+++ www/ap2-python/Makefile
@@ -26,6 +26,10 @@ PY_PATCHPLIST=       YES
 
 PKG_APACHE_ACCEPTED=   apache2 apache22
 
+# mod_python and the python 2.5.2 builtin sqlite define conflicting
+# shared library symbols. Fixed in Python 2.6. py-sqlite2 works fine.
+CONFLICTS=     py25-sqlite3-[0-9]*
+
 .include "../../lang/python/extension.mk"
 .include "../../mk/apache.mk"
 .include "../../mk/bsd.pkg.mk"
NetBSD-4.0.1@netbsd$ pkgdiff databases/py-sqlite3/Makefile
$NetBSD$

--- databases/py-sqlite3/Makefile.orig  2008-08-27 12:28:57.000000000 +1200
+++ databases/py-sqlite3/Makefile
@@ -18,6 +18,10 @@ PYDISTUTILSPKG=              yes
 PYTHON_VERSIONS_ACCEPTED=25
 PY_SETUP_SUBST+=       SQLITE_PREFIX=${BUILDLINK_PREFIX.sqlite3}
 
+# mod_python and the python 2.5.2 builtin sqlite define conflicting
+# shared library symbols. Fixed in Python 2.6. py-sqlite2 works fine.
+CONFLICTS=             ap*-py25-python-[0-9]*
+
 # ignore errors due to missing files (EXTRACT_ELEMENTS!)
 do-patch:
        set -e;                                                         \