Prosody 0.11.2 (backport): no file '/usr/lib/prosody/DBI.lua'...

[Davide Marchi]

Hi Friends,

on Debian9 I'm setting up Prosody storage to MySQL.
So I've installed "lua-dbi-mysql" and created new user and db.

Reloaded Prosody, all seems fine, but if I run:

 prosodyctl register danjde server.test.org my-password

I get a long warning with a list of missing files:

modulemanager       error    Error initializing module 'storage_sql' on 'server.test.org': /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:178: in function 'do_load_module'
    /usr/lib/prosody/core/modulemanager.lua:256: 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/prosody/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:178: in function 'do_load_module'
    /usr/lib/prosody/core/modulemanager.lua:256: 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:459: in function '?'
    /usr/bin/prosodyctl:1368: 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 server.test.org: /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:178: in function 'do_load_module'
    /usr/lib/prosody/core/modulemanager.lua:256: 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/prosody/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:178: in function 'do_load_module'
    /usr/lib/prosody/core/modulemanager.lua:256: 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:459: in function '?'
    /usr/bin/prosodyctl:1368: 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 server.test.org
Error: No data storage active

Call yu suggest me please if  bug or my mistake?

Many thanks! :-)

Davide

[Kim Alvefur]

Hi,

On Tue, Jan 22, 2019 at 07:26:59AM -0800, Davide Marchi wrote:
> on Debian9 I'm setting up Prosody storage to MySQL.
> So I've installed "lua-dbi-mysql" and created new user and db.

> modulemanager error Error initializing module 'storage_sql' on
> 'server.test.org': /usr/lib/prosody/util/sql.lua:11: module 'DBI' not found:

The 'DBI' module is in the package 'lua-dbi-common', make sure you have
that installed.

If it is installed and it still does not work then check what files are
included in the package (`dpkg -L lua-dbi-common`) and what permissions
they have.

--
Zash

[Davide Marchi]

Hi Kim and thanks for your help!
I've solved removing the 0.7.x prosody stretch module (deb
http://packages.prosody.im/debian stretch main) and installing the
official stretch 0.5.x package.

Now "lua-dbi-mysql" is working fine ;-)

Thanks again!

Davide



Kim Alvefur ha scritto: