Mailing List Archive

How to solve "unable to open a temporary database file for storing temporary tables"
I get the following error after install trac:

Oops...

Trac detected an internal error:

malformed database schema - unable to open a temporary database file for
storing temporary tables
Traceback (most recent call last):
File
"/home/misc/rpm/tmp/trac-0.7.1-1mdk-buildroot//usr/lib/python2.3/site-packages/trac/core.py",
line 475, in cgi_start
File
"/home/misc/rpm/tmp/trac-0.7.1-1mdk-buildroot//usr/lib/python2.3/site-packages/trac/core.py",
line 453, in real_cgi_start
File
"/home/misc/rpm/tmp/trac-0.7.1-1mdk-buildroot//usr/lib/python2.3/site-packages/trac/core.py",
line 169, in open_environment
File
"/home/misc/rpm/tmp/trac-0.7.1-1mdk-buildroot//usr/lib/python2.3/site-packages/trac/Environment.py",
line 160, in get_version
File
"/home/misc/rpm/tmp/trac-0.7.1-1mdk-buildroot//usr/lib/python2.3/site-packages/trac/Environment.py",
line 88, in get_db_cnx
File
"/home/misc/rpm/tmp/python-sqlite-0.5.1-1mdk-buildroot//usr/lib/python2.3/site-packages/sqlite/__init__.py",
line 61, in connect
File
"/home/misc/rpm/tmp/python-sqlite-0.5.1-1mdk-buildroot//usr/lib/python2.3/site-packages/sqlite/main.py",
line 445, in __init__
DatabaseError: malformed database schema - unable to open a temporary
database file for storing temporary tables



From google, seen it is a problem of SQLlite. The user I use to run
apache have access right to tmp directory. Anyone encouter this and have
idea of how to fix it? By the way, I install trac on Mandrake 10 system
with following packages:

http://www.carfield.com.hk/web_site/?url=%2Fmirror%2Fpub%2Ftrac