Databases
StackOverflow2013
Postsdbo
POHow to access ejabberd web console after connecting it to mysql?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to access ejabberd web console after connecting it to mysql?
    primarykey
    data
    text
    <p>I am new to ejabberd. I have connected ejabberd to mysql. Users are registering successfully but i can't access the ejabberd web console. It is giving error on ejabberdctl live-</p> <pre><code>W(&lt;0.348.0&gt;:ejabberd_web_admin:224) : Access of "admin" from "127.0.0.1" failed with error: "bad-password" </code></pre> <p>i have register admin with following command and it has successfully registered users in mysql. </p> <pre><code>ejabberdctl register admin localhost password </code></pre> <p>The lines of ejabberd.cfg file which i changed to connect to mysql are as follows- </p> <pre><code>{auth_method, odbc}. %% To use both anonymous and internal authentication: {host_config, "public.example.org", [{auth_method, [odbc, anonymous]}]}. {odbc_server, "DSN=testing;UID=root;PWD=india"}. {acl, admin, {user, "admin", "localhost"}}. {mod_last_odbc, []}, {mod_offline_odbc, [{access_max_user_messages, max_user_offline_messages}]}, {mod_privacy_odbc, []}, {mod_private_odbc, []}, {mod_pubsub_odbc, [ {access_createnode, pubsub_createnode}, {ignore_pep_from_offline, true}, % reduces resource comsumption, but XEP incompliant %%{ignore_pep_from_offline, false}, % XEP compliant, but increases resource comsumption {last_item_cache, false}, {plugins, ["flat", "hometree", "pep"]} % pep requires mod_caps ]}, {mod_roster_odbc, []}, {mod_vcard_odbc, []}, </code></pre> <p>Please response with the answer. I got stuck in this problem.</p> <p>On startup ejabberd using - ejabberdctl live, the following report is also shown-</p> <pre><code>=INFO REPORT==== 2013-12-29 16:48:05 === I(&lt;0.40.0&gt;:cyrsasl_digest:44) : FQDN used to check DIGEST-MD5 SASL authentication: </code></pre> <p>Does it affect anything in authenticating? I am using ejabberd- 2.1.12 and mysql 5.5</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJagveer Singh Rajput
    1. USJagveer Singh Rajput
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COif you read carefully, it says you have BAD PASSWORD. please check ur password, blank / caps, before you pull ur hair out.
      singulars
      1. POHow to access ejabberd web console after connecting it to mysql?
      1. This table or related slice is empty.
    2. COI have checked it... It is correct. I dont know why it is giving error in password
      singulars
      1. POHow to access ejabberd web console after connecting it to mysql?
      1. USJagveer Singh Rajput
    3. COI have added some more info in question... Please help...
      singulars
      1. POHow to access ejabberd web console after connecting it to mysql?
      1. USJagveer Singh Rajput
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload