Greetings to all.
I am testing 0.10 (Prosody 0.10 nightly build 200 (2016-01-16, fdbe9ccac17d)) with mod_mam_archive and mysql storage and i am getting the following error in the logs when a client (Xabber) requests the history from the server
(and client does not get history back :D )
mod_mam works with the mysql storage fine. (tested with Conversations on android)
Jan 17 08:18:46 c2s2a6fb80 error Traceback[c2s]: /usr/lib/prosody/core/moduleapi.lua:142: Failed to load plugin library 'sql', error: /usr/lib/prosody/modules/sql.lib.lua: No such file or directory
stack traceback:
[C]: in function 'error'
/usr/lib/prosody/core/moduleapi.lua:142: in function 'require'
/usr/lib/prosody/modules/mod_mam_archive.lua:137: in function 'get_db'
/usr/lib/prosody/modules/mod_mam_archive.lua:189: in function '?'
/usr/lib/prosody/util/events.lua:78: in function </usr/lib/prosody/util/events.lua:74>
(tail call): ?
(tail call): ?
/usr/lib/prosody/modules/mod_iq.lua:54: in function '?'
/usr/lib/prosody/util/events.lua:78: in function </usr/lib/prosody/util/events.lua:74>
(tail call): ?
/usr/lib/prosody/core/stanza_router.lua:188: in function 'core_post_stanza'
/usr/lib/prosody/core/stanza_router.lua:135: in function 'core_process_stanza'
/usr/lib/prosody/modules/mod_c2s.lua:244: in function 'func'
/usr/lib/prosody/util/async.lua:88: in function </usr/lib/prosody/util/async.lua:86>
Config for the modules looks like this
modules_enabled = {
-- Generally required
"roster"; -- Allow users to have a roster. Recommended ;)
"saslauth"; -- Authentication for clients and servers. Recommended if you want to log in.
"tls"; -- Add support for secure TLS on c2s/s2s connections
"dialback"; -- s2s dialback support
"disco"; -- Service discovery
-- Not essential, but recommended
"private"; -- Private XML storage (for room bookmarks, etc.)
"vcard"; -- Allow users to set vCards
--"privacy"; -- Support privacy lists
"compression"; -- Stream compression
-- Nice to have
"legacyauth"; -- Legacy authentication. Only used by some old clients and bots.
"version"; -- Replies to server version requests
"uptime"; -- Report how long server has been running
"time"; -- Let others know the time here on this server
"ping"; -- Replies to XMPP pings with pongs
"pep"; -- Enables users to publish their mood, activity, playing music and more
"register"; -- Allow users to register on this server using a client and change passwords
"adhoc"; -- Support for "ad-hoc commands" that can be executed with an XMPP client
-- Admin interfaces
--"admin_adhoc"; -- Allows administration via an XMPP client that supports ad-hoc commands
--"admin_telnet"; -- Opens telnet console interface on localhost port 5582
-- Other specific functionality
--"bosh"; -- Enable BOSH clients, aka "Jabber over HTTP"
--"httpserver"; -- Serve static files from a directory over HTTP
--"groups"; -- Shared roster support
--"announce"; -- Send announcement to all online users
--"welcome"; -- Welcome users who register accounts
--"watchregistrations"; -- Alert admins of registrations
--"motd"; -- Send a message to users when they log in
-- Debian: do not remove this module, or you lose syslog
-- support
"posix"; -- POSIX functionality, sends server to background, enables syslog, etc.
--stelios
"carbons"; -- XEP0280
"carbons_adhoc";
"carbons_copies";
"smacks"; --XEP0198
"mam"; --XEP 0313
"mam_archive"; --XEP 0136
"csi";
"throttle_presence";
"message_logging";
"lastactivity"; --XEP 0012
"blocklist"; --XEP 0191
};
--enable carbon copies for all
carbons_copies_default = true ;
sql ={ driver = "MySQL", database = "prosody", username = "prosody", password = "foobar", host = "localhost" }
storage="sql";
storage = {
archive2 = "sql";
}
default_archive_policy = true
max_archive_query_results = 50;
prosodyctl about
general error The version of LuaExpat on your system does not support stanza size limits, which may leave servers on untrusted networks (e.g. the internet) vulnerable to denial-of-service attacks. You should upgrade to LuaExpat 1.3.0 or higher as soon as possible. See http://prosody.im/doc/depends#luaexpat for more information.
Prosody 0.10 nightly build 200 (2016-01-16, fdbe9ccac17d)
# Prosody directories
Data directory: /var/lib/prosody
Config directory: /etc/prosody
Source directory: /usr/lib/prosody
Plugin directories:
/usr/lib/prosody/modules
/usr/local/lib/prosody/modules
/usr/lib/prosody/modules/
# Lua environment
Lua version: Lua 5.1
Lua module search paths:
/usr/local/share/lua/5.1//?.lua
/usr/local/share/lua/5.1//?/init.lua
/root/.luarocks/share/lua/5.1//?.lua
/root/.luarocks/share/lua/5.1//?/init.lua
/usr/lib/prosody/?.lua
/usr/local/share/lua/5.1/?.lua
/usr/local/share/lua/5.1/?/init.lua
/usr/local/lib/lua/5.1/?.lua
/usr/local/lib/lua/5.1/?/init.lua
/usr/share/lua/5.1/?.lua
/usr/share/lua/5.1/?/init.lua
Lua C module search paths:
/usr/local/lib/lua/5.1//?.so
/root/.luarocks/lib/lua/5.1//?.so
/usr/lib/prosody/?.so
/usr/local/lib/lua/5.1/?.so
/usr/lib/x86_64-linux-gnu/lua/5.1/?.so
/usr/lib/lua/5.1/?.so
/usr/local/lib/lua/5.1/loadall.so
LuaRocks: Installed (2.0.8)
# Lua module versions
lfs: LuaFileSystem 1.5.0
luaevent: 0.3.0
lxp: LuaExpat 1.2.0
socket: LuaSocket 3.0-rc1
ssl: 0.5.PR
Zash
on
Hi! Thanks for the detailed report. This error is the same as reported in #550.
However mod_mam_archive is a community module not written or supported by the core prosody team. Reaching out to the author might be a good idea.
Greetings to all. I am testing 0.10 (Prosody 0.10 nightly build 200 (2016-01-16, fdbe9ccac17d)) with mod_mam_archive and mysql storage and i am getting the following error in the logs when a client (Xabber) requests the history from the server (and client does not get history back :D ) mod_mam works with the mysql storage fine. (tested with Conversations on android) Jan 17 08:18:46 c2s2a6fb80 error Traceback[c2s]: /usr/lib/prosody/core/moduleapi.lua:142: Failed to load plugin library 'sql', error: /usr/lib/prosody/modules/sql.lib.lua: No such file or directory stack traceback: [C]: in function 'error' /usr/lib/prosody/core/moduleapi.lua:142: in function 'require' /usr/lib/prosody/modules/mod_mam_archive.lua:137: in function 'get_db' /usr/lib/prosody/modules/mod_mam_archive.lua:189: in function '?' /usr/lib/prosody/util/events.lua:78: in function </usr/lib/prosody/util/events.lua:74> (tail call): ? (tail call): ? /usr/lib/prosody/modules/mod_iq.lua:54: in function '?' /usr/lib/prosody/util/events.lua:78: in function </usr/lib/prosody/util/events.lua:74> (tail call): ? /usr/lib/prosody/core/stanza_router.lua:188: in function 'core_post_stanza' /usr/lib/prosody/core/stanza_router.lua:135: in function 'core_process_stanza' /usr/lib/prosody/modules/mod_c2s.lua:244: in function 'func' /usr/lib/prosody/util/async.lua:88: in function </usr/lib/prosody/util/async.lua:86> Config for the modules looks like this modules_enabled = { -- Generally required "roster"; -- Allow users to have a roster. Recommended ;) "saslauth"; -- Authentication for clients and servers. Recommended if you want to log in. "tls"; -- Add support for secure TLS on c2s/s2s connections "dialback"; -- s2s dialback support "disco"; -- Service discovery -- Not essential, but recommended "private"; -- Private XML storage (for room bookmarks, etc.) "vcard"; -- Allow users to set vCards --"privacy"; -- Support privacy lists "compression"; -- Stream compression -- Nice to have "legacyauth"; -- Legacy authentication. Only used by some old clients and bots. "version"; -- Replies to server version requests "uptime"; -- Report how long server has been running "time"; -- Let others know the time here on this server "ping"; -- Replies to XMPP pings with pongs "pep"; -- Enables users to publish their mood, activity, playing music and more "register"; -- Allow users to register on this server using a client and change passwords "adhoc"; -- Support for "ad-hoc commands" that can be executed with an XMPP client -- Admin interfaces --"admin_adhoc"; -- Allows administration via an XMPP client that supports ad-hoc commands --"admin_telnet"; -- Opens telnet console interface on localhost port 5582 -- Other specific functionality --"bosh"; -- Enable BOSH clients, aka "Jabber over HTTP" --"httpserver"; -- Serve static files from a directory over HTTP --"groups"; -- Shared roster support --"announce"; -- Send announcement to all online users --"welcome"; -- Welcome users who register accounts --"watchregistrations"; -- Alert admins of registrations --"motd"; -- Send a message to users when they log in -- Debian: do not remove this module, or you lose syslog -- support "posix"; -- POSIX functionality, sends server to background, enables syslog, etc. --stelios "carbons"; -- XEP0280 "carbons_adhoc"; "carbons_copies"; "smacks"; --XEP0198 "mam"; --XEP 0313 "mam_archive"; --XEP 0136 "csi"; "throttle_presence"; "message_logging"; "lastactivity"; --XEP 0012 "blocklist"; --XEP 0191 }; --enable carbon copies for all carbons_copies_default = true ; sql ={ driver = "MySQL", database = "prosody", username = "prosody", password = "foobar", host = "localhost" } storage="sql"; storage = { archive2 = "sql"; } default_archive_policy = true max_archive_query_results = 50; prosodyctl about general error The version of LuaExpat on your system does not support stanza size limits, which may leave servers on untrusted networks (e.g. the internet) vulnerable to denial-of-service attacks. You should upgrade to LuaExpat 1.3.0 or higher as soon as possible. See http://prosody.im/doc/depends#luaexpat for more information. Prosody 0.10 nightly build 200 (2016-01-16, fdbe9ccac17d) # Prosody directories Data directory: /var/lib/prosody Config directory: /etc/prosody Source directory: /usr/lib/prosody Plugin directories: /usr/lib/prosody/modules /usr/local/lib/prosody/modules /usr/lib/prosody/modules/ # Lua environment Lua version: Lua 5.1 Lua module search paths: /usr/local/share/lua/5.1//?.lua /usr/local/share/lua/5.1//?/init.lua /root/.luarocks/share/lua/5.1//?.lua /root/.luarocks/share/lua/5.1//?/init.lua /usr/lib/prosody/?.lua /usr/local/share/lua/5.1/?.lua /usr/local/share/lua/5.1/?/init.lua /usr/local/lib/lua/5.1/?.lua /usr/local/lib/lua/5.1/?/init.lua /usr/share/lua/5.1/?.lua /usr/share/lua/5.1/?/init.lua Lua C module search paths: /usr/local/lib/lua/5.1//?.so /root/.luarocks/lib/lua/5.1//?.so /usr/lib/prosody/?.so /usr/local/lib/lua/5.1/?.so /usr/lib/x86_64-linux-gnu/lua/5.1/?.so /usr/lib/lua/5.1/?.so /usr/local/lib/lua/5.1/loadall.so LuaRocks: Installed (2.0.8) # Lua module versions lfs: LuaFileSystem 1.5.0 luaevent: 0.3.0 lxp: LuaExpat 1.2.0 socket: LuaSocket 3.0-rc1 ssl: 0.5.PR
Hi! Thanks for the detailed report. This error is the same as reported in #550. However mod_mam_archive is a community module not written or supported by the core prosody team. Reaching out to the author might be a good idea.