Docker-jitsi-meet prosody mysql enable

Hi, I was install docker-jitsi-meet and it’s all good.but I want store user data in mysql.any one know about this how I have setup for that.I also try with myself but I’m getting some package errors but it’s still have installed in my server

#errors
modulemanager error Error initializing module ‘storage_sql’ on ‘meet .domain.com’: /usr/lib/prosody/util/sql.lua:11: module ‘DBI’ not found:
no field package.preload[‘DBI’]
no file ‘/usr/lib/prosody/DBI.lua’
no file ‘/usr/local/share/lua/5.2/DBI.lua’
no file ‘/usr/local/share/lua/5.2/DBI/init.lua’
no file ‘/usr/local/lib/lua/5.2/DBI.lua’
no file ‘/usr/local/lib/lua/5.2/DBI/init.lua’
no file ‘/usr/share/lua/5.2/DBI.lua’
no file ‘/usr/share/lua/5.2/DBI/init.lua’
no file ‘/usr/lib/prosody/DBI.so’
no file ‘/usr/local/lib/lua/5.2/DBI.so’
no file ‘/usr/lib/x86_64-linux-gnu/lua/5.2/DBI.so’
no file ‘/usr/lib/lua/5.2/DBI.so’
no file ‘/usr/local/lib/lua/5.2/loadall.so’
stack traceback:
[C]: in function ‘require’
/usr/lib/prosody/util/sql.lua:11: in main chunk
[C]: in function ‘require’
/usr/lib/prosody/modules/mod_storage_sql.lua:5: in main chunk
[C]: in function ‘xpcall’
/usr/lib/prosody/core/modulemanager.lua:183: in function 'do_load_module ’
/usr/lib/prosody/core/modulemanager.lua:261: in function ‘load’
/usr/lib/prosody/core/storagemanager.lua:86: in function ‘load_driver’
/usr/lib/prosody/core/storagemanager.lua:127: in function ‘get_driver’
/usr/lib/prosody/core/storagemanager.lua:184: in function </usr/lib/pros ody/core/storagemanager.lua:183>
(…tail calls…)
/usr/lib/prosody/modules/mod_auth_internal_hashed.lua:22: in main chunk
[C]: in function ‘xpcall’
/usr/lib/prosody/core/modulemanager.lua:183: in function 'do_load_module ’
/usr/lib/prosody/core/modulemanager.lua:261: in function ‘load’
/usr/lib/prosody/core/usermanager.lua:67: in function ‘initialize_host’
/usr/lib/prosody/util/prosodyctl.lua:142: in function ‘adduser’
/usr/bin/prosodyctl:464: in function ‘?’
/usr/bin/prosodyctl:1387: in function ‘func’
/usr/lib/prosody/util/async.lua:127: in function </usr/lib/prosody/util/ async.lua:125>
storagemanager error Failed to load storage driver plugin sql on meet .domain.com: /usr/lib/prosody/util/sql.lua:11: module ‘DBI’ not found:
no field package.preload[‘DBI’]
no file ‘/usr/lib/prosody/DBI.lua’
no file ‘/usr/local/share/lua/5.2/DBI.lua’
no file ‘/usr/local/share/lua/5.2/DBI/init.lua’
no file ‘/usr/local/lib/lua/5.2/DBI.lua’
no file ‘/usr/local/lib/lua/5.2/DBI/init.lua’
no file ‘/usr/share/lua/5.2/DBI.lua’
no file ‘/usr/share/lua/5.2/DBI/init.lua’
no file ‘/usr/lib/prosody/DBI.so’
no file ‘/usr/local/lib/lua/5.2/DBI.so’
no file ‘/usr/lib/x86_64-linux-gnu/lua/5.2/DBI.so’
no file ‘/usr/lib/lua/5.2/DBI.so’
no file ‘/usr/local/lib/lua/5.2/loadall.so’
stack traceback:
[C]: in function ‘require’
/usr/lib/prosody/util/sql.lua:11: in main chunk
[C]: in function ‘require’
/usr/lib/prosody/modules/mod_storage_sql.lua:5: in main chunk
[C]: in function ‘xpcall’
/usr/lib/prosody/core/modulemanager.lua:183: in function 'do_load_module ’
/usr/lib/prosody/core/modulemanager.lua:261: in function ‘load’
/usr/lib/prosody/core/storagemanager.lua:86: in function ‘load_driver’
/usr/lib/prosody/core/storagemanager.lua:127: in function ‘get_driver’
/usr/lib/prosody/core/storagemanager.lua:184: in function </usr/lib/pros ody/core/storagemanager.lua:183>
(…tail calls…)
/usr/lib/prosody/modules/mod_auth_internal_hashed.lua:22: in main chunk
[C]: in function ‘xpcall’
/usr/lib/prosody/core/modulemanager.lua:183: in function 'do_load_module ’
/usr/lib/prosody/core/modulemanager.lua:261: in function ‘load’
/usr/lib/prosody/core/usermanager.lua:67: in function ‘initialize_host’
/usr/lib/prosody/util/prosodyctl.lua:142: in function ‘adduser’
/usr/bin/prosodyctl:464: in function ‘?’
/usr/bin/prosodyctl:1387: in function ‘func’
/usr/lib/prosody/util/async.lua:127: in function </usr/lib/prosody/util/ async.lua:125>
storagemanager warn Falling back to null driver for accounts storage on meet.domain.com
Error: No data storage active

Hi, to get past the error I’m using the currently latest version of docker jitsi (stable-5390-3).
And in addition to that my prosody docker container image is configured like the following:

FROM jitsi/prosody:stable-5390-3

ENV DEBIAN_FRONTEND noninteractive

RUN apt-get update --yes  \
 && apt-get install --yes \
                lua-dbi-mysql

Now prosody starts when the sql storage is enabled, but I’m not sure how to check whether it is used correctly :open_mouth:

PS: /usr/lib/prosody/util/sql.lua:11: module ‘DBI’ not found: looks like the lua-dbi-mysql or some dependencies did not get installed correctly or are missing at all.

1 Like

I was fixed this problem.

So i just updated my docker prosody from jitsi and the database that i added is not working again,
do you guys have any idea how to fix it?

how did u fix this problem… i am receiving the same error when i do : prosodyctl register focus auth.my domain.com JICOFO_AUTH_PASSWORD