> Finally I found that in > order to write to the database, Sqlite for some reason needs to have > write permissions to the _folder_ the file resides in.
"Some reason" here is a necessity to create a journal file at the same directory to be able to restore the database in case of crash or power outage. To create files in the directory one must have write permissions to it. Pavel On Fri, Jun 11, 2010 at 7:22 AM, Otto Kekäläinen <o...@sange.fi> wrote: > Hello, > > You website states that bugs reports should be sent to this list > (http://www.sqlite.org/src/wiki?name=Bug+Reports). > > ** > Bug report: unhelpful error message when directory permissions are wrong > > Steps to reproduce: > 1. Make new database in the directory /var/database/ with root permissions. > 2. Change file ower to normal user > 3. Try to open database and make changes to it as the normal user > > What happends: > There is the error message "sqlite: Unable to open database file" > > What was expected: > The error message: "sqlite: Unable to write to database due to file or > folder permissions" > > I just spent several hours trying to debug a PySqlite app which gave > the "unable to open database file" error. Finally I found that in > order to write to the database, Sqlite for some reason needs to have > write permissions to the _folder_ the file resides in. > > Please change the error message to be more descriptive so that others > could save time debugging the issue. You can find on Google tons of > people wondering about this error, but few will ever find the > solutions. Fixing the error message would solve it. > ** > > -- > Otto Kekäläinen > www.sange.fi > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
