Re: django/python missing sqlite

[George Georgalis <george%galis.org@localhost>]

On Sun 12 Apr 2009 at 01:27:42 PM +0200, Joerg Sonnenberger wrote:
>On Sun, Apr 12, 2009 at 01:17:54PM +0200, Joerg Sonnenberger wrote:
>> On Sun, Apr 12, 2009 at 12:17:52AM -0700, George Georgalis wrote:
>> > Not sure what you're getting at here. As far as I can tell/tried. Can you
>> > be more specific about what you want me to do?
>> 
>> OK, let's make it simpler. Just apply the attached patch in
>> www/py-django and rebuild. It should make it work without py-sqlite3.

...not sure what happened to my prior reply, thats GMT -0700:
Apr 12 13:37:22 host=smtp.gmail.com tls=on auth=on 
user=george%galis.org@localhost from=geo%fuji.galis.org@localhost 
recipients=pkgsrc-users%netbsd.org@localhost,galis%galis.org@localhost 
mailsize=5051 smtpstatus=250 smtpmsg='250 2.0.0 OK 1239568644 
b8sm8789878rvf.22' exitcode=EX_OK

anyway, it doesn't solve the problem. after cleaning and
reinstalling with the patch, in /var/db/pkg I find, (in reverse
time order)

drwxr-xr-x 2 root root    4096 Apr 13 13:09 libffi-3.0.8
drwxr-xr-x 2 root root    4096 Apr 13 13:09 db4-4.7.25.3
drwxr-xr-x 2 root root    4096 Apr 13 13:09 py25-setuptools-0.6c9
drwxr-xr-x 2 root root    4096 Apr 13 13:11 py25-mxDateTime-2.0.6nb1
drwxr-xr-x 2 root root    4096 Apr 13 13:11 postgresql82-client-8.2.13
drwxr-xr-x 2 root root    4096 Apr 13 13:14 sqlite3-3.6.11
drwxr-xr-x 2 root root    4096 Apr 13 14:34 python25-2.5.2nb5
drwxr-xr-x 2 root root    4096 Apr 13 14:34 py25-sqlite2-2.5.0a
drwxr-xr-x 2 root root    4096 Apr 13 14:34 py25-psycopg-1.1.21nb3
drwxr-xr-x 2 root root    4096 Apr 13 14:34 py25-flup-2311
drwxr-xr-x 2 root root    4096 Apr 13 14:34 py25-django-1.0.2nb1
-rw-r--r-- 1 root root 2310144 Apr 13 14:34 pkgdb.byfile.db

and the error persists:

File "/usr/pkg/lib/python2.5/site-packages/django/db/backends/sqlite3/base.py", 
line 27, in <module>
    raise ImproperlyConfigured, "Error loading %s module: %s" % (module, exc)
django.core.exceptions.ImproperlyConfigured: Error loading sqlite3 module: No 
module named _sqlite3

# find /usr/pkg -maxdepth 2 -iname \*sqlite\*
/usr/pkg/include/sqlite3ext.h
/usr/pkg/include/sqlite3.h
/usr/pkg/bin/sqlite3
/usr/pkg/lib/libsqlite3.a
/usr/pkg/lib/libsqlite3.so
/usr/pkg/lib/libsqlite3.so.0
/usr/pkg/lib/libsqlite3.so.0.8.6
/usr/pkg/lib/libsqlite3.la

seems the django deps installed sqlite3 but is looking for lib
installed by py-sqlite3

George




>Index: Makefile
>===================================================================
>RCS file: /home/joerg/repo/netbsd/pkgsrc/www/py-django/Makefile,v
>retrieving revision 1.15
>diff -u -p -r1.15 Makefile
>--- Makefile   29 Jan 2009 09:35:54 -0000      1.15
>+++ Makefile   12 Apr 2009 11:16:20 -0000
>@@ -21,7 +21,7 @@ DEPENDS+=    ${PYPKGPREFIX}-flup-[0-9]*:../
> 
> .include "options.mk"
> 
>-post-extract:
>+pre-configure:
>       rm -r ${WRKSRC}/django/db/backends/oracle
> .if empty(PKG_OPTIONS:Mmysql)
>       rm -r ${WRKSRC}/django/db/backends/mysql
>Index: distinfo
>===================================================================
>RCS file: /home/joerg/repo/netbsd/pkgsrc/www/py-django/distinfo,v
>retrieving revision 1.8
>diff -u -p -r1.8 distinfo
>--- distinfo   17 Dec 2008 19:55:38 -0000      1.8
>+++ distinfo   12 Apr 2009 11:16:44 -0000
>@@ -4,3 +4,4 @@ SHA1 (Django-1.0.2-final.tar.gz) = f2d90
> RMD160 (Django-1.0.2-final.tar.gz) = 0cfea620df0831310da4ef51ef6ee4ef1b65974e
> Size (Django-1.0.2-final.tar.gz) = 4649433 bytes
> SHA1 (patch-aa) = 54a532d9c6761f80a10c633bb6192faccb5ab64b
>+SHA1 (patch-ab) = 620e958ab3b4c3cf7ceb507b52ac64b522a6e4a8
>Index: patches/patch-ab
>===================================================================
>RCS file: patches/patch-ab
>diff -N patches/patch-ab
>--- /dev/null  1 Jan 1970 00:00:00 -0000
>+++ patches/patch-ab   12 Apr 2009 11:16:42 -0000
>@@ -0,0 +1,25 @@
>+$NetBSD$
>+
>+--- django/db/backends/sqlite3/base.py.orig   2009-04-11 22:01:24.000000000 
>+0200
>++++ django/db/backends/sqlite3/base.py
>+@@ -12,18 +12,11 @@ from django.db.backends.sqlite3.creation
>+ from django.db.backends.sqlite3.introspection import DatabaseIntrospection
>+ 
>+ try:
>+-    try:
>+-        from sqlite3 import dbapi2 as Database
>+-    except ImportError, e1:
>+-        from pysqlite2 import dbapi2 as Database
>++    from pysqlite2 import dbapi2 as Database
>+ except ImportError, exc:
>+     import sys
>+     from django.core.exceptions import ImproperlyConfigured
>+-    if sys.version_info < (2, 5, 0):
>+-        module = 'pysqlite2'
>+-    else:
>+-        module = 'sqlite3'
>+-        exc = e1
>++    module = 'pysqlite2'
>+     raise ImproperlyConfigured, "Error loading %s module: %s" % (module, exc)
>+ 
>+ try: