Problems with mod_roster_odbc

Hello!
I have a problem with mod_roster_odbc. Users can't send each other subscriptions.
There are no messages in client about subscriptions. When I turn off mod_roster_odbc - all works fine with mod_roster.
No problems with connection to mysql server - all registrations stored in databases looks good and works.
I installed ejabberd 2.1.2 from Debian Sid repo and mysql-*.beam files according this manual http://support.process-one.net/doc/display/MESSENGER/Using+ejabberd+with...
Sorry for my bad english. I'm russian :)
My setup list
-Debian Lenny up-to-date
-ejabberd 2.1.2 from Debian Sid repo.
-Psi 0.14 (Also tried Gadjim, qutim, qip infium)
-mysql-server 5.0.51a-24
-no firewalls

Quote: When I turn off

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

Thank you for your answer but

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.

Re: Problems with mod_roster_odbc

Quote:

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

Take a look at logs. Are there any errors?

Yes. But I don't know what

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.

I am also getting an

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

Hi, I am also facing the

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

Syndicate content