Trac install generates error on RH Enterprise Linux 4.0 and FreeBSD 6.2

[kazam@…]

• Python: Python-2.4.4
• Sqlite: sqlite-3.3.8
• Mod Python: mod_python-3.2.10
• Trac: trac-0.10.2

When I configure it with Apache HTTP server the following error is generated. I read that this error was due to using Sqlite with --enable-threadsafe but I rebuilt sqlite without the flag and it is still giving an error.
NOTE: Wrong, no don't do that, the --enable-threadsafe flag is mandatory, see the PySqlite page
— cboos

Manager(self).get_connection()
[Wed Nov 29 22:55:15 2006] [error] [client 192.168.0.88] PythonHandler trac.web.modpython_frontend:   File "/usr/local/lib/python2.4/site-packages/trac/db/api.py", line 75, in get_connection
    return self._cnx_pool.get_cnx(self.timeout or None)
[Wed Nov 29 22:55:15 2006] [error] [client 192.168.0.88] PythonHandler trac.web.modpython_frontend:   File "/usr/local/lib/python2.4/site-packages/trac/db/pool.py", line 101, in get_cnx
    cnx = self._connector.get_connection(**self._kwargs)
[Wed Nov 29 22:55:15 2006] [error] [client 192.168.0.88] PythonHandler trac.web.modpython_frontend:   File "/usr/local/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 113, in get_connection
    return SQLiteConnection(path, params)
[Wed Nov 29 22:55:15 2006] [error] [client 192.168.0.88] PythonHandler trac.web.modpython_frontend:   File "/usr/local/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 140, in __init__ assert have_pysqlite > 0
[Wed Nov 29 22:55:15 2006] [error] [client 192.168.0.88] PythonHandler trac.web.modpython_frontend: AssertionError

---

Note: what is obviously missing are the pysqlite2 Python bindings for SQLite; again, please see the PySqlite page.

[Christian Boos]

This is an installation issue.

[gregoryba@…]

i'm getting the same error under freebsd 6.2:

Oops…

Trac detected an internal error:

Traceback (most recent call last):

File "/usr/local/share/trac/cgi-bin/trac.cgi", line 20, in ?

cgi_frontend.run()

File "/usr/local/lib/python2.4/site-packages/trac/web/cgi_frontend.py", line 68, in run

gateway.run(dispatch_request)

File "/usr/local/lib/python2.4/site-packages/trac/web/wsgi.py", line 87, in run

response = application(self.environ, self._start_response)

File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 391, in dispatch_request

env = _open_environment(env_path, run_once=run_once)

File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 51, in _open_environment

return open_environment(env_path)

File "/usr/local/lib/python2.4/site-packages/trac/env.py", line 463, in open_environment

if env.needs_upgrade():

File "/usr/local/lib/python2.4/site-packages/trac/env.py", line 341, in needs_upgrade

db = self.get_db_cnx()

File "/usr/local/lib/python2.4/site-packages/trac/env.py", line 203, in get_db_cnx

return DatabaseManager(self).get_connection()

File "/usr/local/lib/python2.4/site-packages/trac/db/api.py", line 76, in get_connection

return self._cnx_pool.get_cnx(self.timeout or None)

File "/usr/local/lib/python2.4/site-packages/trac/db/pool.py", line 101, in get_cnx

cnx = self._connector.get_connection(self._kwargs)

File "/usr/local/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 113, in get_connection

return SQLiteConnection(path, params)

File "/usr/local/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 140, in init

assert have_pysqlite > 0

AssertionError

pkg_info:

apache-2.0.59 Version 2 of Apache web server with prefork MPM. autoconf-2.59_2 Automatically configure source code on many Un*x platforms automake-1.9.6_1 GNU Standards-compliant Makefile generator (1.9) bash-3.1.17 The GNU Project's Bourne Again SHell clearsilver-python-0.10.4 A fast, powerful, and language-neutral template system daemontools-0.76_12 Service monitoring and logging utilities by djb db41-4.1.25_4 The Berkeley DB package, revision 4.1 db42-4.2.52_5 The Berkeley DB package, revision 4.2 expat-2.0.0_1 XML 1.0 parser written in C gettext-0.16.1_3 GNU gettext package gmake-3.81_2 GNU version of 'make' utility help2man-1.36.4_1 Automatically generating simple manual pages from program o iperf-2.0.2_1 A tool to measure maximum TCP and UDP bandwidth libiconv-1.9.2_2 A character set conversion library libtool-1.5.22_4 Generic shared library support script m4-1.4.9 GNU m4 neon-0.26.3 An HTTP and WebDAV client library for Unix systems net-snmp-5.3.1_3 An extendable SNMP implementation netcat-1.10_2 Simple utility which reads and writes data across network c nss_ldap-1.255 RFC 2307 NSS module openldap-client-2.3.35 Open source LDAP client implementation p5-gettext-1.05_1 Message handling functions pam_ldap-1.8.2 A pam module for authenticating with LDAP pam_mkhomedir-0.1 Create HOME with a PAM module on demand pcre-7.0_1 Perl Compatible Regular Expressions library perl-5.8.8 Practical Extraction and Report Language pkg-config-0.21 A utility to retrieve information about installed libraries portaudit-0.5.11 Checks installed ports against a list of security vulnerabi portupgrade-2.2.6_3,2 FreeBSD ports/packages administration and management tool s postfix-2.4.1,1 A secure alternative to widely-used Sendmail py24-docutils-0.4 Python Documentation Utilities py24-pysqlite-2.0.7_1 A DB-API v2 Python library for the SQLite 3 embedded SQL en python24-2.4.4 An interpreted object-oriented programming language rssh-2.3.2 A Restricted Secure SHell only for sftp or/and scp rsync-2.6.9 A network file distribution/synchronization utility ruby-1.8.6,1 An object-oriented interpreted scripting language ruby18-bdb-0.6.0 Ruby interface to Sleepycat's Berkeley DB revision 2 or lat screen-4.0.3 A multi-screen window manager silvercity-0.9.7 A lexing package for over 20 programming and markup languag sqlite3-3.3.16 An SQL database engine in a C library w/ Tcl wrapper subversion-python-1.4.3_2 Version control system sudo-1.6.8.12_2 Allow others to run commands as root trac-0.10.4 An enhanced wiki and issue tracking system for software pro vim-7.0.224_1 Vi "workalike", with many additional features

[gregoryba@…]

actually seems to be a problem with the fbsd package name:

$ python Python 2.4.4 (#2, May 31 2007, 20:33:55) [GCC 3.4.6 [FreeBSD] 20060305] on freebsd6 Type "help", "copyright", "credits" or "license" for more information.

import sqlite

Traceback (most recent call last):

File "<stdin>", line 1, in ?

ImportError: No module named sqlite

import pysqlite2