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
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
Looking for ejabberd docs?
To access the most up-to-date ejabberd documentation, please visit docs.ejabberd.im »
Problems with mod_roster_odbc
Submitted by jamaicada on Wed, 2010-01-27 13:46
Quote: When I turn off
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, []}, ... ]}.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
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:
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
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