From owner-freebsd-python@FreeBSD.ORG Sat Aug 21 07:58:45 2010 Return-Path: <owner-freebsd-python@FreeBSD.ORG> Delivered-To: python@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 400F51065693; Sat, 21 Aug 2010 07:58:45 +0000 (UTC) (envelope-from zhoushuqun@gmail.com) Received: from mail-vw0-f54.google.com (mail-vw0-f54.google.com [209.85.212.54]) by mx1.freebsd.org (Postfix) with ESMTP id B4DE98FC0C; Sat, 21 Aug 2010 07:58:44 +0000 (UTC) Received: by vws7 with SMTP id 7so4435798vws.13 for <multiple recipients>; Sat, 21 Aug 2010 00:58:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:cc:content-type :content-transfer-encoding; bh=dWB15F2Xr1GtB5egKTKcM1WLWQfp70G8dywDLHA7IKU=; b=iPwSNyB9ILvIO94HnZKvIE3OIU3VXgVl/W+5yuYpaii1FHzOQELve4QltuWxos4w2u A3IGQ4sOIMcahq5e37uozjNkY5i8wF2DJ/haTCtsJnSOxbtXfAqqfp14WzJtmJ/IEsBx bXCbtUH5/QEzvJtevoQ6eYeyHZRI+Q601MHq8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=nYNWF/iUSfuvjvp3l/qdyNDwmvdiuHve0qnz1il2wzIHHFpBfLXVBswpjQEjwHYfa0 52PXlWbYfKZhrCmQDxhdsT5rNw8brzqL5D7SUIGChWSOscE69X3mwpUjJYPqtzptLxod QTC4v9147pekkQqUwLnqSuZv8QsUegZgM7+rg= Received: by 10.220.124.85 with SMTP id t21mr1161042vcr.5.1282377523563; Sat, 21 Aug 2010 00:58:43 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.162.72 with HTTP; Sat, 21 Aug 2010 00:58:23 -0700 (PDT) In-Reply-To: <20100820203545.GA43046@FreeBSD.cs.nctu.edu.tw> References: <AANLkTimsX59JLF47p3yFuE9nmzQoBqj5uXh0AHNkapbD@mail.gmail.com> <AANLkTim86Vim7N-S7dGp+bv8d+mETKnZ=q2afg5xueDc@mail.gmail.com> <20100820203545.GA43046@FreeBSD.cs.nctu.edu.tw> From: Sutra Zhou <zhoushuqun@gmail.com> Date: Sat, 21 Aug 2010 15:58:23 +0800 Message-ID: <AANLkTikZkgKPUVGZbWjor=v8XQqZVuCQZXNeZkcN2gru@mail.gmail.com> To: Li-Wen Hsu <lwhsu@freebsd.org> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Cc: wen heping <wenheping@gmail.com>, python@freebsd.org, Martin Wilke <miwi@freebsd.org> Subject: Re: python-2.7 released ! X-BeenThere: freebsd-python@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD-specific Python issues <freebsd-python.freebsd.org> List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-python>, <mailto:freebsd-python-request@freebsd.org?subject=unsubscribe> List-Archive: <http://lists.freebsd.org/pipermail/freebsd-python> List-Post: <mailto:freebsd-python@freebsd.org> List-Help: <mailto:freebsd-python-request@freebsd.org?subject=help> List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-python>, <mailto:freebsd-python-request@freebsd.org?subject=subscribe> X-List-Received-Date: Sat, 21 Aug 2010 07:58:45 -0000 On Sat, Aug 21, 2010 at 4:35 AM, Li-Wen Hsu <lwhsu@freebsd.org> wrote: > On Fri, Aug 20, 2010 at 15:39:31 +0800, Sutra Zhou wrote: >> After I installed python27, import sqlite3 failed: >> >> root@www:~%pkg_info -Ix py >> ap22-mod_python-3.3.1_3 Apache module that embeds the Python >> interpreter within the >> clearsilver-python-0.10.5 A fast, powerful, and language-neutral templat= e system >> py27-Genshi-0.6 =C2=A0 =C2=A0 Python toolkit for stream-based generation= of output for th >> py27-docutils-0.7 =C2=A0 Python Documentation Utilities >> py27-pygments-1.3.1 A syntax highlighter written in Python >> py27-pytz-2010k =C2=A0 =C2=A0 World Timezone Definitions for Python >> py27-setuptools-0.6c11 Download, build, install, upgrade, and >> uninstall Python pac >> py27-sqlite3-2.7_1 =C2=A0Standard Python binding to the SQLite3 library >> py27-subversion-1.6.12_1 Python bindings for version control system >> py27-xlrd-0.7.1_1 =C2=A0 Reading data and formatting information from Ex= cel files >> python27-2.7.0 =C2=A0 =C2=A0 =C2=A0An interpreted object-oriented progra= mming language >> root@www:~%python >> Python 2.7 (r27:82500, Aug 20 2010, 03:40:41) >> [GCC 4.2.1 20070719 =C2=A0[FreeBSD]] on freebsd8 >> Type "help", "copyright", "credits" or "license" for more information. >> >>> import sqlite3 >> Traceback (most recent call last): >> =C2=A0 File "<stdin>", line 1, in <module> >> =C2=A0 File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in = <module> >> =C2=A0 =C2=A0 from dbapi2 import * >> =C2=A0 File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 27, in <m= odule> >> =C2=A0 =C2=A0 from _sqlite3 import * >> ImportError: /usr/local/lib/python2.7/site-packages/_sqlite3.so: >> Undefined symbol "sqlite3_load_extension" >> >> Would you please tell me how to diagnose this problem? > > At this point the best way is rebuilding your databases/sqlite3 with > EXTENSION option on, then rebuilding databases/py-sqlite3 . > > I've filed a PR for turn this option default on: > http://www.freebsd.org/cgi/query-pr.cgi?pr=3D149842 > > Li-Wen > It works, thank you.