changeset 1841:0a7053d14b43

mod_mam_sql, mod_mam_muc_sql: Begone, unsupported and unmaintained experiments
author Kim Alvefur <zash@zash.se>
date Fri, 11 Sep 2015 10:43:16 +0200
parents 3bd265f7a95f
children 98ad01cc83cf
files mod_mam_muc_sql/mod_mam_muc_sql.lua mod_mam_sql/README.markdown mod_mam_sql/mod_mam_sql.lua
diffstat 3 files changed, 0 insertions(+), 845 deletions(-) [+]
line wrap: on
line diff
--- a/mod_mam_muc_sql/mod_mam_muc_sql.lua	Fri Sep 11 09:42:52 2015 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,301 +0,0 @@
--- XEP-0313: Message Archive Management for Prosody
--- Copyright (C) 2011-2012 Kim Alvefur
---
--- This file is MIT/X11 licensed.
-
-local xmlns_mam     = "urn:xmpp:mam:tmp";
-local xmlns_delay   = "urn:xmpp:delay";
-local xmlns_forward = "urn:xmpp:forward:0";
-
-local st = require "util.stanza";
-local rsm = module:require "mod_mam/rsm";
-local jid_bare = require "util.jid".bare;
-local jid_split = require "util.jid".split;
-local jid_prep = require "util.jid".prep;
-local host = module.host;
-
-local serialize, deserialize = require"util.json".encode, require"util.json".decode;
-local unpack = unpack;
-local tostring = tostring;
-local time_now = os.time;
-local t_insert = table.insert;
-local m_min = math.min;
-local timestamp, timestamp_parse = require "util.datetime".datetime, require "util.datetime".parse;
-local default_max_items, max_max_items = 20, module:get_option_number("max_archive_query_results", 50);
---local rooms_to_archive = module:get_option_set("rooms_to_archive",{});
-
-local sql, setsql, getsql = {};
-do -- SQL stuff
-local dburi;
-local connection;
-local connections = module:shared "/*/sql/connection-cache";
-local build_url = require"socket.url".build;
-local resolve_relative_path = require "core.configmanager".resolve_relative_path;
-local params = module:get_option("mam_sql", module:get_option("sql"));
-
-local function db2uri(params)
-	return build_url{
-		scheme = params.driver,
-		user = params.username,
-		password = params.password,
-		host = params.host,
-		port = params.port,
-		path = params.database,
-	};
-end
-
-local function test_connection()
-	if not connection then return nil; end
-	if connection:ping() then
-		return true;
-	else
-		module:log("debug", "Database connection closed");
-		connection = nil;
-		connections[dburi] = nil;
-	end
-end
-local function connect()
-	if not test_connection() then
-		prosody.unlock_globals();
-		local dbh, err = DBI.Connect(
-			params.driver, params.database,
-			params.username, params.password,
-			params.host, params.port
-		);
-		prosody.lock_globals();
-		if not dbh then
-			module:log("debug", "Database connection failed: %s", tostring(err));
-			return nil, err;
-		end
-		module:log("debug", "Successfully connected to database");
-		dbh:autocommit(false); -- don't commit automatically
-		connection = dbh;
-
-		connections[dburi] = dbh;
-	end
-	return connection;
-end
-
-do -- process options to get a db connection
-	local ok;
-	prosody.unlock_globals();
-	ok, DBI = pcall(require, "DBI");
-	if not ok then
-		package.loaded["DBI"] = {};
-		module:log("error", "Failed to load the LuaDBI library for accessing SQL databases: %s", DBI);
-		module:log("error", "More information on installing LuaDBI can be found at http://prosody.im/doc/depends#luadbi");
-	end
-	prosody.lock_globals();
-	if not ok or not DBI.Connect then
-		return; -- Halt loading of this module
-	end
-
-	params = params or { driver = "SQLite3" };
-
-	if params.driver == "SQLite3" then
-		params.database = resolve_relative_path(prosody.paths.data or ".", params.database or "prosody.sqlite");
-	end
-
-	assert(params.driver and params.database, "Both the SQL driver and the database need to be specified");
-
-	dburi = db2uri(params);
-	connection = connections[dburi];
-
-	assert(connect());
-
-end
-
-function getsql(sql, ...)
-	if params.driver == "PostgreSQL" then
-		sql = sql:gsub("`", "\"");
-	end
-	-- do prepared statement stuff
-	local stmt, err = connection:prepare(sql);
-	if not stmt and not test_connection() then error("connection failed"); end
-	if not stmt then module:log("error", "QUERY FAILED: %s %s", err, debug.traceback()); return nil, err; end
-	-- run query
-	local ok, err = stmt:execute(...);
-	if not ok and not test_connection() then error("connection failed"); end
-	if not ok then return nil, err; end
-
-	return stmt;
-end
-function setsql(sql, ...)
-	local stmt, err = getsql(sql, ...);
-	if not stmt then return stmt, err; end
-	return stmt:affected();
-end
-function sql.rollback(...)
-	if connection then connection:rollback(); end -- FIXME check for rollback error?
-	return ...;
-end
-function sql.commit(...)
-	if not connection:commit() then return nil, "SQL commit failed"; end
-	return ...;
-end
-
-end
-
-local archive_store = "archive2";
-
--- Handle archive queries
-module:hook("iq/bare/"..xmlns_mam..":query", function(event)
-	local origin, stanza = event.origin, event.stanza;
-	local room = jid_split(stanza.attr.to);
-	local query = stanza.tags[1];
-
-	local room_obj = hosts[module.host].modules.muc.rooms[jid_bare(stanza.attr.to)];
-	if not room_obj then
-		return -- FIXME not found
-	end
-	local from = jid_bare(stanza.attr.from);
-
-	if room_obj._affiliations[from] == "outcast"
-		or room_obj._data.members_only and not room_obj._affiliations[from] then
-		return -- FIXME unauth
-	end
-
-	if stanza.attr.type == "get" then
-		local qid = query.attr.queryid;
-
-		-- Search query parameters
-		local qwith = query:get_child_text("with");
-		local qstart = query:get_child_text("start");
-		local qend = query:get_child_text("end");
-		local qset = rsm.get(query);
-		module:log("debug", "Archive query, id %s with %s from %s until %s)",
-			tostring(qid), qwith or "anyone", qstart or "the dawn of time", qend or "now");
-
-		if qstart or qend then -- Validate timestamps
-			local vstart, vend = (qstart and timestamp_parse(qstart)), (qend and timestamp_parse(qend))
-			if (qstart and not vstart) or (qend and not vend) then
-				origin.send(st.error_reply(stanza, "modify", "bad-request", "Invalid timestamp"))
-				return true
-			end
-			qstart, qend = vstart, vend;
-		end
-
-		local qres;
-		if qwith then -- Validate the 'with' jid
-			local pwith = qwith and jid_prep(qwith);
-			if pwith and not qwith then -- it failed prepping
-				origin.send(st.error_reply(stanza, "modify", "bad-request", "Invalid JID"))
-				return true
-			end
-			local _, _, resource = jid_split(qwith);
-			qwith = jid_bare(pwith);
-			qres = resource;
-		end
-
-		-- RSM stuff
-		local qmax = m_min(qset and qset.max or default_max_items, max_max_items);
-		local first, last;
-		local n = 0;
-
-		local sql_query = ([[
-		SELECT `id`, `when`, `stanza`
-		FROM `prosodyarchive`
-		WHERE `host` = ? AND `user` = ? AND `store` = ?
-		AND `when` BETWEEN ? AND ?
-		%s
-		AND `id` > ?
-		LIMIT ?;
-		]]):format(qres and [[AND `resource` = ?]] or "")
-
-		local p = {
-			host, room, archive_store,
-			qstart or 0, qend or time_now(),
-			qset and tonumber(qset.after) or 0,
-			qmax
-		};
-		if qres then
-			t_insert(p, 6, qres);
-		end
-		module:log("debug", "getsql(sql_query, "..table.concat(p, ", "));
-		local data, err = getsql(sql_query, unpack(p));
-		if not data then
-			origin.send(st.error_reply(stanza, "cancel", "internal-server-error", "Error loading archive: "..tostring(err)));
-			return true
-		end
-
-		for item in data:rows() do
-			local id, when, orig_stanza = unpack(item);
-			--module:log("debug", "id is %s", id);
-
-			local fwd_st = st.message{ to = stanza.attr.from, from = stanza.attr.to }
-				:tag("result", { xmlns = xmlns_mam, queryid = qid, id = id }):up()
-				:tag("forwarded", { xmlns = xmlns_forward })
-					:tag("delay", { xmlns = xmlns_delay, stamp = timestamp(when) }):up();
-			orig_stanza = st.deserialize(deserialize(orig_stanza));
-			orig_stanza.attr.xmlns = "jabber:client";
-			fwd_st:add_child(orig_stanza);
-			origin.send(fwd_st);
-			last = id;
-			n = n + 1;
-			if not first then
-				first = id;
-			end
-		end
-		-- That's all folks!
-		module:log("debug", "Archive query %s completed", tostring(qid));
-
-		local reply = st.reply(stanza);
-		if last then
-			-- This is a bit redundant, isn't it?
-			reply:query(xmlns_mam):add_child(rsm.generate{first = first, last = last, count = n});
-		end
-		origin.send(reply);
-		return true
-	end
-end);
-
--- Handle messages
-local function message_handler(event)
-	local origin, stanza = event.origin, event.stanza;
-	local orig_type = stanza.attr.type or "normal";
-	local orig_to = stanza.attr.to;
-	local orig_from = stanza.attr.from;
-
-	-- Still needed?
-	if not orig_from then
-		orig_from = origin.full_jid;
-	end
-
-	-- Only store groupchat messages
-	if not (orig_type == "groupchat" and (stanza:get_child("body") or stanza:get_child("subject"))) then
-		return;
-	end
-
-	local room = jid_split(orig_to);
-	local room_obj = hosts[host].modules.muc.rooms[orig_to]
-	if not room_obj then return end
-
-	local when = time_now();
-	local stanza = st.clone(stanza); -- Private copy
-	--stanza.attr.to = nil;
-	local nick = room_obj._jid_nick[orig_from];
-	if not nick then return end
-	stanza.attr.from = nick;
-	local _, _, nick = jid_split(nick);
-	-- And stash it
-		local ok, err = setsql([[
-		INSERT INTO `prosodyarchive`
-		(`host`, `user`, `store`, `when`, `resource`, `stanza`)
-		VALUES (?, ?, ?, ?, ?, ?);
-		]], host, room, archive_store, when, nick, serialize(st.preserialize(stanza)))
-		if ok then
-			sql.commit();
-		else
-			module:log("error", "SQL error: %s", err);
-			sql.rollback();
-		end
-	--[[ This was dropped from the spec
-	if ok then
-		stanza:tag("archived", { xmlns = xmlns_mam, by = host, id = id }):up();
-	end
-	--]]
-end
-
-module:hook("message/bare", message_handler, 2);
-
-module:add_feature(xmlns_mam);
--- a/mod_mam_sql/README.markdown	Fri Sep 11 09:42:52 2015 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,98 +0,0 @@
----
-labels:
-- 'Stage-Alpha'
-- Deprecated
-summary: 'XEP-0313: Message Archive Management using SQL'
-...
-
-**Note:** This module is unsupported and not up to date with the MAM
-specification
-
-Introduction
-============
-
-This is an old fork of mod\_mam with the purpose of figuring out and
-testing an appropriate schema for future inclusion in prosodys
-mod\_storage\_sql. That work is currently available in
-mod\_storage\_sql2, pending merging with mod\_storage\_sql.
-
-It talks SQL directly, bypassing prosodys storage layer.
-
-It is no longer maintained and is unlikely to work with modern clients.
-
-Details
-=======
-
-See [mod\_mam](mod_mam.html) for details.
-
-Usage
-=====
-
-First copy the module to the prosody plugins directory.
-
-Then add "mam\_sql" to your modules\_enabled list:
-
-``` lua
-modules_enabled = {
-  -- ...
-    "mam_sql",
-  -- ...
-}
-```
-
-You should probably run the SQL to create the archive table/indexes:
-
-``` sql
-CREATE TABLE `prosodyarchive` (
-    `host` TEXT,
-    `user` TEXT,
-    `store` TEXT,
-    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
-    `when` INTEGER,
-    `with` TEXT,
-    `resource` TEXT,
-    `stanza` TEXT
-    );
-CREATE INDEX `hus` ON `prosodyarchive` (`host`, `user`, `store`);
-CREATE INDEX `with` ON `prosodyarchive` (`with`);
-CREATE INDEX `thetime` ON `prosodyarchive` (`when`);
-```
-
-(**NOTE**: I ran the following SQL to initialize the table/indexes on
-MySQL):
-
-``` sql
-CREATE TABLE prosodyarchive (
-  `host`     VARCHAR(1023) NOT NULL,
-  `user`     VARCHAR(1023) NOT NULL,
-  `store`    VARCHAR(1023) NOT NULL,
-  `id`       INTEGER PRIMARY KEY AUTO_INCREMENT,
-  `when`     INTEGER     NOT NULL,
-  `with`     VARCHAR(2047) NOT NULL,
-  `resource` VARCHAR(1023),
-  `stanza`   TEXT        NOT NULL
-);
-CREATE INDEX hus ON prosodyarchive (host, user, store);
-CREATE INDEX `with` ON prosodyarchive (`with`);
-CREATE INDEX thetime ON prosodyarchive (`when`);
-```
-
-You may want to tweak the column sizes a bit; I did for my own purposes.
-
-Configuration
-=============
-
-This module uses the same configuration settings that
-[mod\_mam](mod_mam.html) does, in addition to the [SQL storage
-settings](http://prosody.im/doc/modules/mod_storage_sql). You may also
-name the SQL connection settings 'mam\_sql' if you want.
-
-Compatibility
-=============
-
-  ------- ----------------------
-  0.8     ?
-  0.9     Works
-  0.10    Use mod\_mam instead
-  trunk   Use mod\_mam instead
-  ------- ----------------------
--- a/mod_mam_sql/mod_mam_sql.lua	Fri Sep 11 09:42:52 2015 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,446 +0,0 @@
--- XEP-0313: Message Archive Management for Prosody
--- Copyright (C) 2011-2012 Kim Alvefur
---
--- This file is MIT/X11 licensed.
-
-local xmlns_mam     = "urn:xmpp:mam:tmp";
-local xmlns_delay   = "urn:xmpp:delay";
-local xmlns_forward = "urn:xmpp:forward:0";
-
-local st = require "util.stanza";
-local rsm = module:require "mod_mam/rsm";
-local jid_bare = require "util.jid".bare;
-local jid_split = require "util.jid".split;
-local jid_prep = require "util.jid".prep;
-local host = module.host;
-
-local dm_load = require "util.datamanager".load;
-local dm_store = require "util.datamanager".store;
-local rm_load_roster = require "core.rostermanager".load_roster;
-
-local serialize, deserialize = require"util.json".encode, require"util.json".decode;
-local unpack = unpack;
-local tostring = tostring;
-local time_now = os.time;
-local t_insert = table.insert;
-local m_min = math.min;
-local timestamp, timestamp_parse = require "util.datetime".datetime, require "util.datetime".parse;
-local default_max_items, max_max_items = 20, module:get_option_number("max_archive_query_results", 50);
-local global_default_policy = module:get_option("default_archive_policy", false);
--- TODO Should be possible to enforce it too
-
-local sql, setsql, getsql = {};
-do -- SQL stuff
-local dburi;
-local connection;
-local connections = module:shared "/*/sql/connection-cache";
-local build_url = require"socket.url".build;
-local resolve_relative_path = require "core.configmanager".resolve_relative_path;
-local params = module:get_option("mam_sql", module:get_option("sql"));
-
-local function db2uri(params)
-	return build_url{
-		scheme = params.driver,
-		user = params.username,
-		password = params.password,
-		host = params.host,
-		port = params.port,
-		path = params.database,
-	};
-end
-
-local connect
-
-local function test_connection()
-	if not connection then return nil; end
-	if connection:ping() then
-		return true;
-	else
-		module:log("debug", "Database connection closed");
-		module:log("debug", "Attempting to reconnect");
-		connection = nil;
-		return connect();
-	end
-end
-function connect()
-	if not test_connection() then
-		prosody.unlock_globals();
-		local dbh, err = DBI.Connect(
-			params.driver, params.database,
-			params.username, params.password,
-			params.host, params.port
-		);
-		prosody.lock_globals();
-		if not dbh then
-			module:log("debug", "Database connection failed: %s", tostring(err));
-			return nil, err;
-		end
-		module:log("debug", "Successfully connected to database");
-		dbh:autocommit(false); -- don't commit automatically
-		connection = dbh;
-
-		connections[dburi] = dbh;
-	end
-	return connection;
-end
-
-do -- process options to get a db connection
-	local ok;
-	prosody.unlock_globals();
-	ok, DBI = pcall(require, "DBI");
-	if not ok then
-		package.loaded["DBI"] = {};
-		module:log("error", "Failed to load the LuaDBI library for accessing SQL databases: %s", DBI);
-		module:log("error", "More information on installing LuaDBI can be found at http://prosody.im/doc/depends#luadbi");
-	end
-	prosody.lock_globals();
-	if not ok or not DBI.Connect then
-		return; -- Halt loading of this module
-	end
-
-	params = params or { driver = "SQLite3" };
-
-	if params.driver == "SQLite3" then
-		params.database = resolve_relative_path(prosody.paths.data or ".", params.database or "prosody.sqlite");
-	end
-
-	assert(params.driver and params.database, "Both the SQL driver and the database need to be specified");
-
-	dburi = db2uri(params);
-	connection = connections[dburi];
-
-	assert(connect());
-
-end
-
-function getsql(sql, ...)
-	if params.driver == "PostgreSQL" then
-		sql = sql:gsub("`", "\"");
-	end
-	if not connection then
-		return nil, 'connection failed';
-	end
-	if not test_connection() then
-		return nil, 'connection failed';
-	end
-	-- do prepared statement stuff
-	local stmt, err = connection:prepare(sql);
-	if not stmt and not test_connection() then
-		return nil, "connection failed";
-	end
-	if not stmt then module:log("error", "QUERY FAILED: %s %s", err, debug.traceback()); return nil, err; end
-	-- run query
-	local ok, err = stmt:execute(...);
-	if not ok and not test_connection() then
-		return nil, "connection failed";
-	end
-	if not ok then return nil, err; end
-
-	return stmt;
-end
-function setsql(sql, ...)
-	local stmt, err = getsql(sql, ...);
-	if not stmt then return stmt, err; end
-	return stmt:affected();
-end
-function sql.rollback(...)
-	if connection then connection:rollback(); end -- FIXME check for rollback error?
-	return ...;
-end
-function sql.commit(...)
-	if not connection:commit() then return nil, "SQL commit failed"; end
-	return ...;
-end
-
-end
-
--- For translating preference names from string to boolean and back
-local default_attrs = {
-	always = true, [true] = "always",
-	never = false, [false] = "never",
-	roster = "roster",
-}
-
-do
-	local prefs_format = {
-		[false] = "roster",
-		-- default ::= true | false | "roster"
-		-- true = always, false = never, nil = global default
-		["romeo@montague.net"] = true, -- always
-		["montague@montague.net"] = false, -- newer
-	};
-end
-
-local archive_store = "archive2";
-local prefs_store = archive_store .. "_prefs";
-local function get_prefs(user)
-	return dm_load(user, host, prefs_store) or
-		{ [false] = global_default_policy };
-end
-local function set_prefs(user, prefs)
-	return dm_store(user, host, prefs_store, prefs);
-end
-
-
--- Handle prefs.
-module:hook("iq/self/"..xmlns_mam..":prefs", function(event)
-	local origin, stanza = event.origin, event.stanza;
-	local user = origin.username;
-	if stanza.attr.type == "get" then
-		local prefs = get_prefs(user);
-		local default = prefs[false];
-		default = default ~= nil and default_attrs[default] or global_default_policy;
-		local reply = st.reply(stanza):tag("prefs", { xmlns = xmlns_mam, default = default })
-		local always = st.stanza("always");
-		local never = st.stanza("never");
-		for k,v in pairs(prefs) do
-			if k then
-				(v and always or never):tag("jid"):text(k):up();
-			end
-		end
-		reply:add_child(always):add_child(never);
-		origin.send(reply);
-		return true
-	else -- type == "set"
-		local prefs = {};
-		local new_prefs = stanza:get_child("prefs", xmlns_mam);
-		local new_default = new_prefs.attr.default;
-		if new_default then
-			prefs[false] = default_attrs[new_default];
-		end
-
-		local always = new_prefs:get_child("always");
-		if always then
-			for rule in always:childtags("jid") do
-				local jid = rule:get_text();
-				prefs[jid] = true;
-			end
-		end
-
-		local never = new_prefs:get_child("never");
-		if never then
-			for rule in never:childtags("jid") do
-				local jid = rule:get_text();
-				prefs[jid] = false;
-			end
-		end
-
-		local ok, err = set_prefs(user, prefs);
-		if not ok then
-			origin.send(st.error_reply(stanza, "cancel", "internal-server-error", "Error storing preferences: "..tostring(err)));
-		else
-			origin.send(st.reply(stanza));
-		end
-		return true
-	end
-end);
-
--- Handle archive queries
-module:hook("iq/self/"..xmlns_mam..":query", function(event)
-	local origin, stanza = event.origin, event.stanza;
-	local query = stanza.tags[1];
-	if stanza.attr.type == "get" then
-		local qid = query.attr.queryid;
-
-		-- Search query parameters
-		local qwith = query:get_child_text("with");
-		local qstart = query:get_child_text("start");
-		local qend = query:get_child_text("end");
-		local qset = rsm.get(query);
-		module:log("debug", "Archive query, id %s with %s from %s until %s)",
-			tostring(qid), qwith or "anyone", qstart or "the dawn of time", qend or "now");
-
-		if qstart or qend then -- Validate timestamps
-			local vstart, vend = (qstart and timestamp_parse(qstart)), (qend and timestamp_parse(qend))
-			if (qstart and not vstart) or (qend and not vend) then
-				origin.send(st.error_reply(stanza, "modify", "bad-request", "Invalid timestamp"))
-				return true
-			end
-			qstart, qend = vstart, vend;
-		end
-
-		local qres;
-		if qwith then -- Validate the 'with' jid
-			local pwith = qwith and jid_prep(qwith);
-			if pwith and not qwith then -- it failed prepping
-				origin.send(st.error_reply(stanza, "modify", "bad-request", "Invalid JID"))
-				return true
-			end
-			local _, _, resource = jid_split(qwith);
-			qwith = jid_bare(pwith);
-			qres = resource;
-		end
-
-		-- RSM stuff
-		local qmax = m_min(qset and qset.max or default_max_items, max_max_items);
-		local last;
-
-		local sql_query = ([[
-		SELECT `id`, `when`, `stanza`
-		FROM `prosodyarchive`
-		WHERE `host` = ? AND `user` = ? AND `store` = ?
-		AND `when` BETWEEN ? AND ?
-		%s %s
-		AND `id` > ?
-		LIMIT ?;
-		]]):format(qwith and [[AND `with` = ?]] or "", qres and [[AND `resource` = ?]] or "")
-
-		local p = {
-			host, origin.username, archive_store,
-			qstart or 0, qend or time_now(),
-			qset and tonumber(qset.after) or 0,
-			qmax
-		};
-		if qwith then
-			if qres then
-				t_insert(p, 6, qres);
-			end
-			t_insert(p, 6, qwith);
-		end
-		local data, err = getsql(sql_query, unpack(p));
-		if not data then
-			origin.send(st.error_reply(stanza, "cancel", "internal-server-error", "Error loading archive: "..tostring(err)));
-			return true
-		end
-
-		for item in data:rows() do
-			local id, when, orig_stanza = unpack(item);
-			--module:log("debug", "id is %s", id);
-
-			local fwd_st = st.message{ to = origin.full_jid }
-				:tag("result", { xmlns = xmlns_mam, queryid = qid, id = id })
-				:tag("forwarded", { xmlns = xmlns_forward })
-					:tag("delay", { xmlns = xmlns_delay, stamp = timestamp(when) }):up();
-			orig_stanza = st.deserialize(deserialize(orig_stanza));
-			orig_stanza.attr.xmlns = "jabber:client";
-			fwd_st:add_child(orig_stanza);
-			origin.send(fwd_st);
-			last = id;
-		end
-		-- That's all folks!
-		module:log("debug", "Archive query %s completed", tostring(qid));
-
-		local reply = st.reply(stanza);
-		if last then
-			-- This is a bit redundant, isn't it?
-			reply:query(xmlns_mam):add_child(rsm.generate{last = last});
-		end
-		origin.send(reply);
-		return true
-	end
-end);
-
-local function has_in_roster(user, who)
-	local roster = rm_load_roster(user, host);
-	module:log("debug", "%s has %s in roster? %s", user, who, roster[who] and "yes" or "no");
-	return roster[who];
-end
-
-local function shall_store(user, who)
-	-- TODO Cache this?
-	local prefs = get_prefs(user);
-	local rule = prefs[who];
-	module:log("debug", "%s's rule for %s is %s", user, who, tostring(rule))
-	if rule ~= nil then
-		return rule;
-	else -- Below could be done by a metatable
-		local default = prefs[false];
-		module:log("debug", "%s's default rule is %s", user, tostring(default))
-		if default == nil then
-			default = global_default_policy;
-			module:log("debug", "Using global default rule, %s", tostring(default))
-		end
-		if default == "roster" then
-			return has_in_roster(user, who);
-		end
-		return default;
-	end
-end
-
--- Handle messages
-local function message_handler(event, c2s)
-	local origin, stanza = event.origin, event.stanza;
-	local orig_type = stanza.attr.type or "normal";
-	local orig_to = stanza.attr.to;
-	local orig_from = stanza.attr.from;
-
-	if not orig_from and c2s then
-		orig_from = origin.full_jid;
-	end
-	orig_to = orig_to or orig_from; -- Weird corner cases
-
-	-- Don't store messages of these types
-	if orig_type == "error"
-	or orig_type == "headline"
-	or orig_type == "groupchat"
-	or not stanza:get_child("body") then
-		return;
-		-- TODO Maybe headlines should be configurable?
-	end
-
-	local store_user, store_host = jid_split(c2s and orig_from or orig_to);
-	local target_jid = c2s and orig_to or orig_from;
-	local target_bare = jid_bare(target_jid);
-	local _, _, target_resource = jid_split(target_jid);
-
-	if shall_store(store_user, target_bare) then
-		module:log("debug", "Archiving stanza: %s", stanza:top_tag());
-
-		--local id = uuid();
-		local when = time_now();
-		-- And stash it
-		local ok, err = setsql([[
-		INSERT INTO `prosodyarchive`
-		(`host`, `user`, `store`, `when`, `with`, `resource`, `stanza`)
-		VALUES (?, ?, ?, ?, ?, ?, ?);
-		]], store_host, store_user, archive_store, when, target_bare, target_resource, serialize(st.preserialize(stanza)))
-		if ok then
-			sql.commit();
-		else
-			module:log("error", "SQL error: %s", err);
-			sql.rollback();
-		end
-		--[[ This was dropped from the spec
-		if ok then
-			stanza:tag("archived", { xmlns = xmlns_mam, by = host, id = id }):up();
-		end
-		--]]
-	else
-		module:log("debug", "Not archiving stanza: %s", stanza:top_tag());
-	end
-end
-
-local function c2s_message_handler(event)
-	return message_handler(event, true);
-end
-
--- Stanzas sent by local clients
-module:hook("pre-message/bare", c2s_message_handler, 2);
-module:hook("pre-message/full", c2s_message_handler, 2);
--- Stanszas to local clients
-module:hook("message/bare", message_handler, 2);
-module:hook("message/full", message_handler, 2);
-
-module:add_feature(xmlns_mam);
-
--- In the telnet console, run:
--- >hosts["this host"].modules.mam_sql.environment.create_sql()
-function create_sql()
-	local stm = getsql[[
-	CREATE TABLE `prosodyarchive` (
-		`host` TEXT,
-		`user` TEXT,
-		`store` TEXT,
-		`id` INTEGER PRIMARY KEY AUTOINCREMENT,
-		`when` INTEGER,
-		`with` TEXT,
-		`resource` TEXT,
-		`stanza` TEXT
-	);
-	CREATE INDEX `hus` ON `prosodyarchive` (`host`, `user`, `store`);
-	CREATE INDEX `with` ON `prosodyarchive` (`with`);
-	CREATE INDEX `thetime` ON `prosodyarchive` (`when`);
-	]];
-	stm:execute();
-	sql.commit();
-end