[ejabberd] Port ejabberd Userdatabase to MySQL

Manuel Ritter ritter-net at web.de
Fri Oct 16 20:17:43 MSD 2009


Hi,
i tried it. I tried
# ejabberd
# (ejabberd@<hidden>) ejd2odbc:export_passwd("<hidden>","pass.sql")

I got a file with userdata but ejabberd is not working anymore.
If i type "ejabberdctl status" i got:
  Node 'ejabberd@<hidden>' is started. Status: started
  ejabberd is not running

ejabberdctl start gives:

RPC failed on the node 'ejabberd at ritter-systems': {'EXIT',
                                                     {badarg,
                                                         [{ets,
                                                              lookup,
                                                              [hooks,
                                                               
{ejabberd_ctl_process,
                                                                   
global}]},
                                                          {ejabberd_hooks,
                                                              run_fold,
                                                              4},
                                                          {ejabberd_ctl,
                                                              process,
                                                              1},
                                                          {rpc,
                                                              
'-handle_call/3-fun-0-',
                                                              5}]}}


In ejabberd.log there is no new message since i exported, sasl.log says

=PROGRESS REPORT==== 16-Oct-2009::17:24:07 ===
         supervisor: {local,crypto_sup}
            started: [{pid,<0.152.0>},
                      {name,crypto_server},
                      {mfa,{crypto_server,start_link,[]}},
                      {restart_type,permanent},
                      {shutdown,2000},
                      {child_type,worker}]

=PROGRESS REPORT==== 16-Oct-2009::17:24:07 ===
        application: crypto
         started_at: 'ejabberd@<hidden>'

=PROGRESS REPORT==== 16-Oct-2009::17:24:07 ===
         supervisor: {local,stringprep_sup}
            started: [{pid,<0.154.0>},
                      {name,stringprep},
                      {mfa,{stringprep,start_link,[]}},
                      {restart_type,permanent},
                      {shutdown,brutal_kill},
                      {child_type,worker}]

=CRASH REPORT==== 16-Oct-2009::17:24:08 ===
 crasher:
   pid: <0.36.0>
   registered_name: []
   error_info: {bad_return,{{ejabberd_app,start,[normal,[]]},
                             {'EXIT',{{case_clause,
                                          {aborted,
                                              {node_not_running,
                                                  'ejabberd@<hidden>'}}},
                                      [{ejabberd_config,set_opts,1},
                                       {ejabberd_app,start,2},
                                       
{application_master,start_it_old,4}]}}}}
   initial_call: {application_master,init,
                                    [<0.5.0>,
                                     <0.34.0>,
                                     {appl_data,
                                         ejabberd,
                                         [ejabberd,
                                          ejabberd_sup,
                                          ejabberd_auth,
                                          ejabberd_router,
                                          ejabberd_sm,
                                          ejabberd_s2s,
                                          ejabberd_local,
                                          ejabberd_listeners,
                                          ejabberd_iq_sup,
                                          ejabberd_service_sup,
                                          ejabberd_s2s_out_sup,
                                          ejabberd_s2s_in_sup,
                                          ejabberd_c2s_sup,
                                          ejabberd_mod_roster,
                                          ejabberd_mod_echo,
                                          ejabberd_mod_pubsub,
                                          ejabberd_mod_irc,
                                          ejabberd_mod_muc,
                                          ejabberd_offline,
                                          random_generator],
                                         undefined,
                                         {ejabberd_app,[]},
                                         [acl,
                                          adhoc,
                                          configure,
                                          cyrsasl_anonymous,
                                          cyrsasl,
                                          cyrsasl_digest,
                                          cyrsasl_plain,
                                          ejabberd_admin,
                                          ejabberd_app,
                                          ejabberd_auth_anonymous,
                                          ejabberd_auth,
                                          ejabberd_auth_external,
                                          ejabberd_auth_internal,
                                          ejabberd_auth_ldap,
                                          ejabberd_auth_odbc,
                                          ejabberd_auth_pam,
                                          ejabberd,
                                          ejabberd_c2s,
                                          ejabberd_c2s_config,
                                          ejabberd_config,
                                          ejabberd_ctl,
                                          ejabberd_frontend_socket,
                                          ejabberd_hooks,
                                          ejabberd_http,
                                          ejabberd_http_bind,
                                          ejabberd_http_poll,
                                          ejabberd_listener,
                                          ejabberd_local,
                                          ejabberd_logger_h,
                                          ejabberd_loglevel,
                                          ejabberd_node_groups,
                                          ejabberd_rdbms,
                                          ejabberd_receiver,
                                          ejabberd_router,
                                          ejabberd_s2s,
                                          ejabberd_s2s_in,
                                          ejabberd_s2s_out,
                                          ejabberd_service,
                                          ejabberd_sm,
                                          ejabberd_socket,
                                          ejabberd_sup,
                                          ejabberd_system_monitor,
                                          ejabberd_tmp_sup,
                                          ejabberd_update,
                                          ejabberd_web_admin,
                                          ejabberd_web,
                                          ejabberd_zlib,
                                          ejd2odbc,
                                          eldap,
                                          eldap_filter,
                                          eldap_pool,
                                          eldap_utils,
                                          'ELDAPv3',
                                          extauth,
                                          gen_iq_handler,
                                          gen_mod,
                                          gen_pubsub_node,
                                          gen_pubsub_nodetree,
                                          iconv,
                                          idna,
                                          jd2ejd,
                                          jlib,
                                          mod_adhoc,
                                          mod_announce,
                                          mod_caps,
                                          mod_configure2,
                                          mod_configure,
                                          mod_ctlextra,
                                          mod_disco,
                                          mod_echo,
                                          mod_http_bind,
                                          mod_http_fileserver,
                                          mod_irc,
                                          mod_irc_connection,
                                          mod_last,
                                          mod_last_odbc,
                                          mod_muc,
                                          mod_muc_log,
                                          mod_muc_room,
                                          mod_offline,
                                          mod_offline_odbc,
                                          mod_privacy,
                                          mod_privacy_odbc,
                                          mod_private,
                                          mod_private_odbc,
                                          mod_proxy65,
                                          mod_proxy65_lib,
                                          mod_proxy65_service,
                                          mod_proxy65_sm,
                                          mod_proxy65_stream,
                                          mod_pubsub,
                                          mod_register,
                                          mod_roster,
                                          mod_roster_odbc,
                                          mod_service_log,
                                          mod_shared_roster,
                                          mod_stats,
                                          mod_time,
                                          mod_vcard,
                                          mod_vcard_ldap,
                                          mod_vcard_odbc,
                                          mod_version,
                                          node_buddy,
                                          node_club,
                                          node_default,
                                          node_dispatch,
                                          node_pep,
                                          node_private,
                                          node_public,
                                          nodetree_default,
                                          nodetree_virtual,
                                          p1_fsm,
                                          p1_mnesia,
                                          ram_file_io_server,
                                          randoms,
                                          sha,
                                          shaper,
                                          stringprep,
                                          stringprep_sup,
                                          tls,
                                          translate,
                                          xml,
                                          xml_stream,
                                          'XmppAddr'],
                                         [],
                                         infinity,
                                         infinity},
                                     normal]}
   ancestors: [<0.34.0>]
   messages: [{'EXIT',<0.37.0>,normal}]
   links: [<0.34.0>,<0.5.0>]
   dictionary: []
   trap_exit: true
   status: running
   heap_size: 1597
   stack_size: 21
   reductions: 2041
 neighbours:



Has Any body an idea?
Greetings
Manuel Ritter


More information about the ejabberd mailing list