ejabberd - Comments for "Problems with mod_roster_odbc"

Hi, I am also facing the

Rohit — Tue, 30 Oct 2012 11:59:22 +0000

Hi,

I am also facing the issue related to mod_roster_odbc.

I sucessfully configured the odbc but the roster does not appear in the rosterusers table.
If i add roster from web admin than also it does not insert in the rosterusers table. I tried various settings but stuck here.

Please help.

Regards,
Rohit

I am also getting an

cloudos — Thu, 20 Sep 2012 10:52:05 +0000

I am also getting an 'econnrefused' error. Please, can you post how did you solve it?

Yes. But I don't know what

jamaicada — Mon, 01 Feb 2010 10:59:06 +0000

Yes. But I don't know what this mean

=ERROR REPORT==== 2010-01-27 15:31:18 ===
E(<0.297.0>:ejabberd_odbc:491) : mysql_conn: Received unknown signal, exiting : {mysql_recv,
                                                                                 <0.298.0>,
                                                                                 closed,
                                                                                 normal}
=INFO REPORT==== 2010-01-27 15:31:18 ===
I(<0.297.0>:ejabberd_odbc:489) : Closing connection #Port<0.2711>: ok
=ERROR REPORT==== 2010-01-27 15:31:18 ===
** Generic server <0.296.0> terminating
** Last message in was {'DOWN',#Ref<0.0.0.9423>,process,<0.297.0>,normal}
** When Server state == {state,<0.297.0>,mysql}
** Reason for termination ==
** connection_dropped
=ERROR REPORT==== 2010-01-27 15:31:18 ===
E(<0.274.0>:ejabberd_odbc:491) : mysql_conn: Received unknown signal, exiting : {mysql_recv,
                                                                                 <0.275.0>,

=ERROR REPORT==== 2010-01-27 15:31:18 ===
E(<0.680.0>:ejabberd_odbc:491) : mysql_conn: Failed connecting to "mysql.host.com":3306 : {error,
                                                                                       "connect failed : {error,econnrefused}"}

but with mysql-client i can connect to mysql.host.com easily with login and password provided in ejabberd.cfg. I do this from the host where ejabberd installed.

Re: Problems with mod_roster_odbc

zinid — Mon, 01 Feb 2010 02:55:33 +0000

Quote:

Also, it appers in roster (in database), but problem with subscribing each other.

Take a look at logs. Are there any errors?

Thank you for your answer but

jamaicada — Sun, 31 Jan 2010 22:13:13 +0000

Thank you for your answer but I double checked if mod_roster turn on.

cat /etc/ejabberd/ejabberd.cfg | grep mod_roster
  {mod_roster_odbc,   []},

Only I see that mod_roster_odbc is on - in ejabberd.cfg and in web-admin. No mod_roster...
Also, it appers in roster (in database), but problem with subscribing each other.

Quote: When I turn off

mfoss — Thu, 28 Jan 2010 15:56:49 +0000

Quote:

When I turn off mod_roster_odbc - all works fine with mod_roster.

Make sure you only enable one module.
Good:

{modules, [
  ...
  {mod_roster, []},
  %%{mod_roster_odbc, []},
  ...
]}.

Good:

{modules, [
  ...
  %%{mod_roster, []},
  {mod_roster_odbc, []},
  ...
]}.

Bad!!:

{modules, [
  ...
  {mod_roster, []},
  {mod_roster_odbc, []},
  ...
]}.

Quote:

I have a problem with mod_roster_odbc. Users can't send each other subscriptions.
There are no messages in client about subscriptions.

Go to the ejabberd WebAdmin, an URL like
http://localhost:5280/admin/server/example.org/node/ejabberd@localhost/m...
Check mod_roster_odbc is enabled, and mod_roster isn't enabled.

When a user adds a contact, check in WebAdmin if the roster item appears:
http://localhost:5280/admin/server/example.org/user/badlop/roster/
Also see in your MySQL database if it appears in the table "rosteritem".