[Buildroot] [PATCH v5] domoticz: new package

[Thiago A. Corrêa]

On Thu, May 19, 2016 at 6:21 PM, Arnout Vandecappelle <arnout at mind.be> wrote:
> On 05/18/16 20:43, Thiago A. Corrêa wrote:
>> There is a problem with domoticz on JFFS2 systems, because it enables
>> some pragmas. Sqlite then tries to mmap on JFFS2 which is not
>> supported and everything fails, Domoticz can't even create the tables.
>>  I fixed it changing sqlite.mk to add:
>>
>> +SQLITE_CFLAGS += -DSQLITE_TEMP_STORE=3
>> +SQLITE_CFLAGS += -DSQLITE_SHM_DIRECTORY=/tmp
>> +SQLITE_CFLAGS += -DSQLITE_OMIT_WAL
>
>  If I understand correctly, the problem is that domoticz is creating sqlite
> tables with pragmas that don't work on JFFS2, right? In that case, it's a
> problem of domoticz and it shouldn't affect all other users of sqlite. In other
> words, it's not OK to change the build options of sqlite.

I would think it's a problem with SQLite, it just happens that we
figured it out with Domoticz. The pragmas are documented, any software
could attempt to use them.

>  On the other hand, if sqlite never works at all on jffs2, then I think it could
> be useful to add a config option to sqlite "support filesystems without mmap".
>
>>
>> Maybe it could be added to the patch, checking if JFFS2 output is enabled.
>
>  No, it's very well possible (likely even) that the filesystem on which the
> database is stored is different from the rootfs.
>

They could be on different partitions all using JFFS2.
UBIFS happens to support mmap, don't know of other embedded filesystems.