Still can't solve the problem... however, now I can confirm this is not
sqlite problem. I just login in as "apache" (the user that run httpd" to
run some python script to connect to "/var/www/trac/db/trac.db" (The db
file):
>>> import sqlite
>>> cx = sqlite.connect("/var/www/trac/db/trac.db")
>>> cu = cx.cursor()
>>> cu.execute("select * from SQLITE_MASTER")
>>> print cu.fetchall()
All work fine! However, the CGI still give me the following 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 "/usr/lib/python2.3/site-packages/sqlite/main.py", line 445, in
__init__
self.db = _sqlite.connect(database, mode)
DatabaseError: malformed database schema - unable to open a temporary
database file for storing temporary tables
--
''~``
( o o )
+------------------.oooO--(_)--Oooo.------------------+
We are limited, not by our abilities, but by our vision.
| |
| http://www.carfield.com.hk |
| .oooO |
| ( ) Oooo. |
+---------------------\ (----( )--------------------+
\_) ) /
(_/
sqlite problem. I just login in as "apache" (the user that run httpd" to
run some python script to connect to "/var/www/trac/db/trac.db" (The db
file):
>>> import sqlite
>>> cx = sqlite.connect("/var/www/trac/db/trac.db")
>>> cu = cx.cursor()
>>> cu.execute("select * from SQLITE_MASTER")
>>> print cu.fetchall()
All work fine! However, the CGI still give me the following 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 "/usr/lib/python2.3/site-packages/sqlite/main.py", line 445, in
__init__
self.db = _sqlite.connect(database, mode)
DatabaseError: malformed database schema - unable to open a temporary
database file for storing temporary tables
--
''~``
( o o )
+------------------.oooO--(_)--Oooo.------------------+
We are limited, not by our abilities, but by our vision.
| |
| http://www.carfield.com.hk |
| .oooO |
| ( ) Oooo. |
+---------------------\ (----( )--------------------+
\_) ) /
(_/