On Friday, January 29, 2016 at 7:34:57 AM UTC-8, peter wrote:
>
> The strange thing is that it works okay with another app. So what I can I
> do about permissions. The permissions for the databases folder are okay. If
> I change the permissions on those files the changes are non persistent. So
> I am stuck.
>
You need to find out what's creating those files, and have it do the job
correctly.
/dps
>
>
> On Friday, 29 January 2016 14:58:26 UTC, Niphlod wrote:
>>
>> file permissions should be the issue because those files are not usual
>> ones.
>>
>> On Friday, January 29, 2016 at 3:45:09 PM UTC+1, peter wrote:
>>>
>>> I am restating my problem with all that I now know.
>>>
>>>
>>>> I have a version of sqlite3 that is 3.7...
>>>>
>>>> I have been having problems with the database being locked.
>>>>
>>>> So I tried
>>>> db.executesql("PRAGMA journal_mode=WAL;")
>>>>
>>>> (just once)
>>>>
>>>> I then cannot access the application without getting a
>>>>
>>>> OperationalError: unable to open database file
>>>>
>>>>
>>> If I look in the databases folder, I see that there are two file
>>> storage.sqlite-wal and
>>> storage.sqlite-shm
>>>
>>> The first of these has 0 bytes as its size.
>>> Both of them have the 'wrong' permissions in that they do not include
>>> group write permissions.
>>> If I change the permissions of the two files, then reload the page, it
>>> works.
>>> However I will soon again get the 'unable to open database error', and
>>> the persmissions will need resetting.
>>>
>>> Does anyone have any idea why I am getting these permission issues with
>>> the WAL file?
>>>
>>> I set up a very simple application and WAL worked okay on that, so WAL
>>> is possible on my system.
>>>
>>> If I turn WAL off and go back to DELETE everything works fine, but I am
>>> at risk of database locking. so I would prefer to be able to use Write
>>> Ahead Logging.
>>>
>>> Thanks for any help
>>> Peter
>>>
>>>
>>>
>>>
>>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
