sqlite3 permission issue
chris
chris.stromberger at gmail.com
Tue Mar 4 16:10:32 EST 2008
I am trying to execute an update to a sqlite3 db via a python cgi
script. I can execute a select via a cgi script, but when I attempt
an update, I get an "unable to open database file" error. But the
error comes on the update statement, not on the connect.
So the script has:
conn = sqlite3.connect('db')
c = conn.cursor()
--we get here ok--
c.execute("insert into contact ...") <-- this statement produces the
error
I can run the exact same python code from the command line and it
works, so it has something to do with the user that runs the cgi
(apache I assume). I chmodded the db file to 666, but it did not
help.
Any ideas?
Thanks,
Chris
More information about the Python-list
mailing list