[prosody-users] Error initializing module 'storage_sql' on module 'DBI' not found

[b***@gmail.com]

Good day for everyone!

After upgrading my home XMPP server to 0.11.0 release I faced to the
problem on starting prosody daemon:
Error initializing module 'storage_sql' on 'chat.example.com': /usr/lib/
prosody/util/startup.lua:141: module 'DBI' not found
But I have this module installed via
apt install lua-dbi-postgresql

Have anybody idea what causes this problem and how can I fix it?

If you have some proposals please answer.

P.S. for more information I attach log and Dockerfile.

[b***@gmail.com]

If smb is interested in problem, the fault reason was in the old debian old
lua-dbi-postgresql package, with offered postgres driver only for Lua 5.1:
/.
/usr
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/liblua5.1-dbi-postgresql.so.0.0.0
/usr/lib/x86_64-linux-gnu/lua
/usr/lib/x86_64-linux-gnu/lua/5.1
/usr/share
/usr/share/doc
/usr/share/doc/lua-dbi-postgresql
/usr/share/doc/lua-dbi-postgresql/changelog.Debian.gz
/usr/share/doc/lua-dbi-postgresql/copyright
/usr/lib/x86_64-linux-gnu/liblua5.1-dbi-postgresql.so.0
/usr/lib/x86_64-linux-gnu/lua/5.1/dbdpostgresql.so

So I just changed container image from jessie to buster and now everything
is fine :)

Post by b***@gmail.com
Good day for everyone!
After upgrading my home XMPP server to 0.11.0 release I faced to the
Error initializing module 'storage_sql' on 'chat.example.com': /usr/lib/
prosody/util/startup.lua:141: module 'DBI' not found
But I have this module installed via
apt install lua-dbi-postgresql
Have anybody idea what causes this problem and how can I fix it?
If you have some proposals please answer.
P.S. for more information I attach log and Dockerfile.

[Kim Alvefur]

Hi,

This is expected with the switch from Lua 5.1 to 5.2, see this section
in the the upgrade notes:
https://prosody.im/doc/release/0.11.0#lua-5.2
--
Regards,
Kim "Zash" Alvefur

[d***@gmail.com]

Hm I see. Not optimal, because the stable update on my ubuntu xenial
distribution is now broken.

But I don't fully understand why this had to be, because regarding to the
documentation, prosody 0.11 still supports lua 5.1, so the xenial package
should simply use just this.

What is the best way to configure prosody to use lua5.1? I reinstalled
lua5.1, changed the "RUNTIME" setting in /etc/init.d/prosody" and did a
systemd daemon reload, but it still wants to use lua 5.2

[Mark Zenhorst]

Hello,

I'm trying to update the lua-dbi-mysql installed as I encountered the same
error and found the note only after the upgrade failed (ubuntu auto updates)

I have installed the luarocks.
Using that, the package lua-dbi-mysql is not found.

How did you update yours?
Can you share the commands?

Kind regads,
Mark

Post by b***@gmail.com
If smb is interested in problem, the fault reason was in the old debian
old lua-dbi-postgresql package, with offered postgres driver only for Lua
/.
/usr
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/liblua5.1-dbi-postgresql.so.0.0.0
/usr/lib/x86_64-linux-gnu/lua
/usr/lib/x86_64-linux-gnu/lua/5.1
/usr/share
/usr/share/doc
/usr/share/doc/lua-dbi-postgresql
/usr/share/doc/lua-dbi-postgresql/changelog.Debian.gz
/usr/share/doc/lua-dbi-postgresql/copyright
/usr/lib/x86_64-linux-gnu/liblua5.1-dbi-postgresql.so.0
/usr/lib/x86_64-linux-gnu/lua/5.1/dbdpostgresql.so
So I just changed container image from jessie to buster and now
everything is fine :)

Post by b***@gmail.com
Good day for everyone!
After upgrading my home XMPP server to 0.11.0 release I faced to the
Error initializing module 'storage_sql' on 'chat.example.com': /usr/lib/
prosody/util/startup.lua:141: module 'DBI' not found
But I have this module installed via
apt install lua-dbi-postgresql
Have anybody idea what causes this problem and how can I fix it?
If you have some proposals please answer.
P.S. for more information I attach log and Dockerfile.