Re: [Motion-user] Question about sqlite3 and locking / read-only mode

[tosiara <to...@gm...>]

So, it works from command line, but does not work from php script?

On Mon, Apr 24, 2023, 22:21 Chris Clemson <Chr...@go...>
wrote:

> Hi Everyone,
>
> I am using motion with 5 cameras and an sqlite database.
>
> I am trying to use PHP to create an interface for it, which is partially
> working, but quite often the DB goes into "read-only" mode, even though I
> can manipulate the database from the sqlite3 command in a bash shell.
>
> I did notice that I get the following messages on start up:
>
> dbse_init_sqlite3: Setting busy timeout to 0 msec
>
>
> Could this be the problem? How can I change the timeout to a couple of seconds or something?
> My setup is too simple to warrant a whole mysql (or similar) setup, and I want as fewer dependencies as possible.
> If I stop motion (and/or apache) and start it again, that usually fixes the problem, but it's difficult to tell when this happens, unless I write some sort of log parser, which seems a bit of a kludge.
>
> Thanks,
>
> Chris
>
>
> _______________________________________________
> Motion-user mailing list
> Mot...@li...
> https://lists.sourceforge.net/lists/listinfo/motion-user
> https://motion-project.github.io/
>
> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user