title: How to connect ejabberd with mysql on ubuntu?
body: <p>I have installed ejabberd on my localhost (WAMP) and its working properly for Mnesia database(default), Now I want to connect it with mysql but unable to do .
  I have tried with many link, example,
  Firstly created a database ejabberd with ejabberd schema and then
   1. Commented the line,</p>
  
  <pre><code>From {auth_method, internal}.
  To %%{auth_method, internal}.
  </code></pre>
  
  <p>after then,</p>
  
  <pre><code>FROM %%{auth_method, odbc}.
  To 
  {auth_method, odbc}.
  </code></pre>
  
  <p>then,</p>
  
  <pre><code>%%
  %% MySQL server:
  %%
  {odbc_server, {mysql, "localhost", "ejabberd", "root", "MyPassword"}}.
  </code></pre>
  
  <p>and finally added <strong>_odbc</strong> in some modules</p>
  
  <pre><code>{mod_last_odbc,     []},
  {mod_offline_odbc,  []},
  {mod_privacy_odbc,  []},
  {mod_private_odbc,  []},
  {mod_pubsub_odbc,   [ % requires mod_caps ...
  {mod_roster_odbc,   []},
  {mod_vcard_odbc,    []},
  </code></pre>
  
  <p>But after these steps unable to start ejabberd server, i tried many times but all time i need to reinstall the ejabberd, even rollback of processes does not worked.
  Your help would be appreciable. Thanks in advance.</p>