sqlite3 insert using python and python cgi

Question

In db.py,I can use a function(func insert) insert data into sqlite correctly.
Now I want to insert data into sqlite through python-fastcgi, in fastcgi (just named post.py ) I can get the request data correctly,but when I call db.insert,it gives me internal server error.

I already did chmod 777 slqite.db. Anyone know whats problem?

turn on the debug flag of fastcgi, and find where is the bug. — Mayli
– Mayli, Commented May 29, 2012 at 5:49

Mil0R3 · Accepted Answer · 2013-10-12 03:29:26Z

4

Ffinally I found the answer:

the sqlite3 library needs write permissions also on the directory that contains it, probably because it needs to create a lockfile.

Therefor when I use sql to insert data there is no problem, but when I do it through web cgi,fastcgi etc）to insert data there would be an error.

Just add write permission to the directory.

answered May 29, 2012 at 9:15

Mil0R3

3,9564 gold badges36 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1