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

          Expenses

            Activity

            Hide
            badlop 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 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
            rafay Mohammed Abdur Rafay added a comment -

            The issues is resolved with the mentioned configuration changes.

            Show
            rafay Mohammed Abdur Rafay added a comment - The issues is resolved with the mentioned configuration changes.
            Hide
            deg 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
            deg 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 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 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
            deg 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
            deg 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:

                  Development