ejabberd development
  1. ejabberd development
  2. EJAB-1463

Error "undef node_pep" when using mod_pubsub_odbc

    Details

      Description

      Hi I am getting this error in the logs when I try the module mod_pubsub_odbc. I have configured the ejabberd to connect to odbc server (MSSQL 2008).

      =ERROR REPORT==== 2011-06-14 13:18:30 ===
      E(<0.352.0>:mod_pubsub_odbc:3624) : transaction return internal error: {aborted,
      {undef,
      [

      {node_pep, get_entity_subscriptions_for_send_last, ["pubsub.mywebsite.com", {jid, "rafay", "mywebsite.com", "1076373710130837674495443", "rafay", "mywebsite.com", "1076373710130837674495443"}

      ]},

      {mod_pubsub_odbc, node_call, 3}

      ,

      {ejabberd_odbc, execute_bloc, 1}

      ,

      {ejabberd_odbc, run_sql_cmd, 4}

      ,

      {p1_fsm, handle_msg, 10}

      ,

      {proc_lib, init_p, 5}

      ]}}

      =ERROR REPORT==== 2011-06-14 13:18:40 ===
      E(<0.339.0>:mod_pubsub_odbc:3624) : transaction return internal error:

      {aborted, {aborted, no_transaction}

      }

        Issue Links

          Activity

          Hide
          Badlop
          added a comment -

          You have a mistake in your configuration. If you use mod_pubsub_odbc, then you must also use the _odbc plugins.

          This is the correct configuration, and it is shown in the ejabberd Guide:

          {modules,
           [
            ...
            {mod_pubsub_odbc, [
                          {access_createnode, pubsub_createnode},
                          {plugins, ["flat_odbc", "hometree_odbc", "pep_odbc"]}
                         ]},
            ...
           ]}.
          
          Show
          Badlop
          added a comment - You have a mistake in your configuration. If you use mod_pubsub_odbc, then you must also use the _odbc plugins. This is the correct configuration, and it is shown in the ejabberd Guide: {modules, [ ... {mod_pubsub_odbc, [ {access_createnode, pubsub_createnode}, {plugins, ["flat_odbc", "hometree_odbc", "pep_odbc"]} ]}, ... ]}.
          Hide
          Mohammed Abdur Rafay
          added a comment -

          The issues is resolved with the mentioned configuration changes.

          Show
          Mohammed Abdur Rafay
          added a comment - The issues is resolved with the mentioned configuration changes.
          Hide
          Alexey Kasyanchuk
          added a comment -

          Same problem... this is my mod_pubsub_odbc section

          {mod_pubsub_odbc, [

          {access_createnode, pubsub_createnode}

          ,

          {ignore_pep_from_offline, true}

          ,

          {last_item_cache, false}

          ,

          {plugins, ["flat_odbc", "hometree_odbc", "pep_odbc"]}

          ]}

          ejabberd 2.1.8

          Show
          Alexey Kasyanchuk
          added a comment - Same problem... this is my mod_pubsub_odbc section {mod_pubsub_odbc, [ {access_createnode, pubsub_createnode} , {ignore_pep_from_offline, true} , {last_item_cache, false} , {plugins, ["flat_odbc", "hometree_odbc", "pep_odbc"]} ]} ejabberd 2.1.8
          Hide
          Badlop
          added a comment -

          Alexey, maybe you are modifying the wrong ejabberd.cfg file? Try removing all the {mod_pubsub_odbc in the file; does the ERROR still appear?

          Show
          Badlop
          added a comment - Alexey, maybe you are modifying the wrong ejabberd.cfg file? Try removing all the {mod_pubsub_odbc in the file; does the ERROR still appear?
          Hide
          Alexey Kasyanchuk
          added a comment -

          Ok, I commented those strings and error messages gone, when i back strings: no messages too (yes, strange)

          But this is not real reason of the problem (i was confident in config, becouse ejabberd have worked good for a long time with those strings but suddenly it became crashing and was showing wrong work (it was 2.1.7, then i updated it to 2.1.8 and it didn't help so those strings was one part of possible causes)
          the real problem: some data in mysql tables that makes ejabberd crash's... i will find it and recreate new ticket... thank's for help.

          Show
          Alexey Kasyanchuk
          added a comment - Ok, I commented those strings and error messages gone, when i back strings: no messages too (yes, strange) But this is not real reason of the problem (i was confident in config, becouse ejabberd have worked good for a long time with those strings but suddenly it became crashing and was showing wrong work (it was 2.1.7, then i updated it to 2.1.8 and it didn't help so those strings was one part of possible causes) the real problem: some data in mysql tables that makes ejabberd crash's... i will find it and recreate new ticket... thank's for help.

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Start Date:
                Days since last comment:
                2 years, 39 weeks, 4 days ago

                Issue deployment