Hello,

I created a fresh Trac environment in /opt/trac/test1. I can open the
sqlite database just fine:

  # cd /opt/trac
  # sqlite3 test1/db/trac.db
  SQLite version 3.3.3
  Enter ".help" for instructions
  sqlite> SELECT value FROM system WHERE name='database_version';
  20
  sqlite> .quit

I can also access this Trac environment just fine using trac-admin:

  # trac-admin test1
  Welcome to trac-admin 0.10.4
  Interactive Trac administration console.
  Copyright (c) 2003-2006 Edgewall Software

  Type:  '?' or 'help' for help on commands.

  Trac [/opt/trac/test1]> component list

  Name        Owner
  --------------------
  component1  somebody
  component2  somebody

  Trac [/opt/trac/test1]> quit

I configured apache using mod_python according to the instructions on
<http://trac.edgewall.org/wiki/TracOnRhel4> and got the following installed:

  # rpm -q httpd trac mod_python python-sqlite sqlite
  httpd-2.0.52-28.ent.centos4
  trac-0.10.4-1.el4.rf
  mod_python-3.1.3-5.1
  python-sqlite-1.1.7-1.2
  sqlite-3.3.3-1.2

When I try to access Trac I get 'Internal Server Error' in my browser
and the following in apache's error_log:

----
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend: Traceback (most recent call last):
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in
HandlerDispatch\n    result = object(req)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line
87, in handler\n    gateway.run(dispatch_request)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/web/wsgi.py", line 87, in run\n
  response = application(self.environ, self._start_response)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/web/main.py", line 391, in
dispatch_request\n    env = _open_environment(env_path, run_once=run_once)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/web/main.py", line 58, in
_open_environment\n    env_cache[env_path] = open_environment(env_path)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/env.py", line 463, in
open_environment\n    if env.needs_upgrade():
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/env.py", line 343, in
needs_upgrade\n    if participant.environment_needs_upgrade(db):
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/env.py", line 397, in
environment_needs_upgrade\n    dbver = self.env.get_version(db)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/env.py", line 257, in
get_version\n    cursor.execute("SELECT value FROM system WHERE
name='database_version'")
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/usr/lib/python2.3/site-packages/trac/db/util.py", line 51, in
execute\n    return self.cursor.execute(sql)
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend:   File
"/var/tmp/python-sqlite-root//usr/lib/python2.3/site-packages/sqlite/main.py",
line 244, in execute
[Tue May 15 17:44:34 2007] [error] [client 82.171.210.164] PythonHandler
trac.web.modpython_frontend: DatabaseError: unsupported file format
----

According to <http://trac.edgewall.org/ticket/3112> the problem could be
that my libphp5.so (I installed PHP5 from the CentOS Plus repository) is
linked against a different version of sqlite. Does anyone know how I can
verify this?

I didn't build any software myself (and I'm not planning to, I want to
be able to keep this server up-to-date using just the package manager),
but if I can somehow see that there is something about PHP that could be
fixed somehow (by linking to another version of sqlite?) I could maybe
ask the packager to consider changing this.

I have been struggling to get Trac to work with mod_python and sqlite
now for about three weeks and would really like to get this to work.

Thanks in advance,

Nils Breunese.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to