I am using jitsi release stable-7439 that comprises of prosody 0.12.1 and Lua 5.4.
I tried to enable sql storage support in prosody but it seems that there are some missing dependencies regarding Lua DB API in Lua 5.4 which prevents prosody from properly bootstrapping sql storage.
Below are the errors from prosody logs:
modulemanager error Error initializing module 'storage_sql' on 'muc.meet.jitsi': /usr/share/lua/5.4/prosody/util/startup.lua:202: module 'DBI' not found: No LuaRocks module found for DBI no field package.preload['DBI']
So, I looked up the errors and found that LuaDBI dependency is required for Lua to capitalize on SQL capabilities.
But since jitsi release stable-7439 consists of Lua 5.4 internally, this version of Lua does not support the LuaDBI dependency so as to speak from this link about the module.
Does this mean latest releases of Jitsi will no longer support prosody having SQL storage?