[ejabberd] mod_pubsub_odbc with mysql sends forbidden

Schumann Sebastian Sebastian.Schumann at t-com.sk
Thu Oct 15 14:29:10 MSD 2009


Hi all

I use MySQL with ODBC. All works besides pubsub.

If I use mod_pubsub with

[{access_createnode, pubsub_createnode},
 {pep_sendlast_offline, false},
 {last_item_cache, false},
 {plugins,
  ["flat", "hometree",
   "pep"]}]

I can publish mood and activity just fine.

Using mod_pubsub_odbc with

[{access_createnode, pubsub_createnode},
 {pep_sendlast_offline, false},
 {last_item_cache, false},
 {plugins,
  ["flat_odbc", "hometree_odbc",
   "pep_odbc"]}]

gives me a forbidden:

<!-- Out -->
<iq type="set" id="94">
<pubsub xmlns="http://jabber.org/protocol/pubsub">
<publish node="http://jabber.org/protocol/mood">
<item id="0">
<mood xmlns="http://jabber.org/protocol/mood">
<happy />
</mood>
</item>
</publish>
</pubsub>
</iq>

<!-- In -->
<iq from='me at ip'<mailto:from='me at ip'> to='me at IP/Gajim'<mailto:to='me at IP/Gajim'> id='94' type='error'>
<error code='403' type='auth'>
<forbidden xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'/>
</error>
<pubsub xmlns='http://jabber.org/protocol/pubsub'>
<publish node='http://jabber.org/protocol/mood'>
<item id='0'>
<mood xmlns='http://jabber.org/protocol/mood'>
<happy/>
</mood>
</item>
</publish>
</pubsub>
</iq>

Here is the MySQL communication that happens:
1 select node, parent, type, nodeid from pubsub_node where host='me at ip'<mailto:host='me at ip'> and node='http://jabber.org/protocol/mood';
2 select name,val from pubsub_node_option where nodeid='10';
3 select affiliation from pubsub_state where nodeid='10' and jid=me at ip'<mailto:jid=me at ip'>;
4 select subscriptions from pubsub_state where nodeid='10' and jid='me at ip/Gajim'<mailto:jid='me at ip/Gajim'>;

3+4 return an empty set.

Any hints would be appreciated.

Best regards
Sebastian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20091015/35ae622a/attachment.html>


More information about the ejabberd mailing list