ejabberd - Comments for "mod_roster_obdc and virtual hosts"

Ah, I didn't think about

mfoss — Tue, 06 Nov 2007 23:50:16 +0000

Ah, I didn't think about that. You are right, each ODBC database can only be used for a single vhost.

If you have several vhosts, the solution is to use several databases. Create them using the same method than the first one. And then configure ejabberd to use a database for each host. For example:

{host_config, "example.org", [
	{odbc_server, {mysql, "localhost", "ejabberd_org", "usernameee", "passworddd"}}.
]}.
{host_config, "example.com", [
	{odbc_server, {mysql, "localhost", "ejabberd_com", "usernameee", "passworddd"}}.
]}.

username not include server

vinnitu — Tue, 06 Nov 2007 17:46:28 +0000

username not include server name
and JID it is member jid of roster for user with given username

so, trouble exists

But the key of the table

mfoss — Tue, 06 Nov 2007 17:30:25 +0000

But the key of the table includes the Username and the JID, right? Since the JID includes the server, the problem should not exist.

This is also described in the database schema:

src/odbc/mysql.sql wrote:

CREATE TABLE rosterusers (
username varchar(250) NOT NULL,
jid varchar(250) NOT NULL,
nick text NOT NULL,
subscription character(1) NOT NULL,
ask character(1) NOT NULL,
askmessage text NOT NULL,
server character(1) NOT NULL,
subscribe text NOT NULL,
type text
) CHARACTER SET utf8;

CREATE UNIQUE INDEX i_rosteru_user_jid ON rosterusers(username(75), jid(75));
CREATE INDEX i_rosteru_username ON rosterusers(username);
CREATE INDEX i_rosteru_jid ON rosterusers(jid);