Gnucash thinks data file is read-only, how to open it for writing?

[John Ralls]

On Jul 17, 2013, at 1:24 PM, Ben Finney <ben+gnome at benfinney.id.au> wrote:

> John Ralls <jralls at ceridwen.us> writes:
> 
>> On Jul 15, 2013, at 6:03 PM, Ben Finney <ben+gnome at benfinney.id.au> wrote:
>>> The file has the correct filesystem permissions to allow me to write it.
>>> I can't find any lock file remaining in the directory. How can I
>>> instruct Gnucash to open the file for writing?
>> 
>> Might the enclosing directory be read-only?
> 
>    $ ls -ld foo/ foo/foo.gnucash
>    drwxrwxr-x 2 bignose bignose  4096 Jul 18 06:17 foo/
>    -rw-r--r-- 1 bignose bignose 89088 Jul 18 06:17 foo/foo.gnucash
> 
>> Are you using a SQL backend?
> 
>    $ file foo/foo.gnucash
>    foo.gnucash: SQLite 3.x database
> 
>> What OS are you using?
> 
> Debian Jessie (which is the current “testing” suite for Debian).
> 
> What other diagnostic information can I provide?

OK, the lock is inside the database instead of a separate file -- that's so that the same code will work
with the Postgresql and and MySQL server backends, where we can't open files separate from the
database.

You can use the sqlite3 command-line tool to remove the lock:
sqlite> DELETE FROM gnclock;
sqlite> ^D

Regards,
John Ralls