#594 mod_mam_archive sql error

Reporter Stelios Koroneos
Owner Zash
Stars ★ (1)  
  • Priority-Medium
  • Type-Defect
  • Status-Duplicate
  1. Stelios Koroneos on

    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

  2. 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.

  3. Zash on

    • owner Zash
    • tags Status-Duplicate

New comment