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