CODEWITHSUNDEEP
xmppejabberd
AKA
AKA

Reputation: 6925

Moving ejabberd default DB to MySQL shows authentication failure

I am trying to setup an ejabberd server on my Amazon EC2 Ubuntu instance. With the default DB Provided by ejabberd, I can easily setup my connection. But I need to replace the mnesia DB with MySQL. I found some tutorials over the internet. From those tutorial I found out a solution. I will explain it as step by step.

I am using ejabberd 2.1.11. I made the following changes on ejabberd.cfg file

  1. Commented the following line :

    {auth_method, internal}

  2. Uncommented this:
    {auth_method, odbc}

  3. Configured my MySQL DB

    {odbc_server, {mysql, "localhost", "students", "root", ""}} // No Password set

  4. Change mod_last to mod_last_odbc

  5. Change mod_offline to mod_offline_odbc

  6. Change mod_roster to mod_roster_odbc

  7. Change mod_private to mod_private_odbc

  8. Change mod_privacy to mod_privacy_odbc

  9. Change mod_pubsub to mod_pubsub_odbc

  10. Change mod_vcard to mod_vcard_odbc

Then I installed ejabberd-mysql driver from the following link

http://stefan-strigler.de/2009/01/14/ejabberd-mysql-drivers-for-debian-and-ubuntu/

After making all these changes I restarted my ejabberd server.

Then I tried to login to my ejabberd server. It shows me the login prompt.

After entering the credentials it takes a lot time and then displays authentication failed.

Any help on the topic is appreciated.

Upvotes: 1

Views: 5071

Answers (2)

Rahul Gautam
Rahul Gautam

Reputation: 4837

Let's dig into problem

  • Your setup is working that means your config file is fine. But then Why does auth fails ?
  • What schema you have in your students database ?
    • If you have a proper schema installed then does the user present in ur db's users table?
    • Have you also updated conf/odbc.ini with proper mysql details.
    • Even if both the conditions meet then I'll advice you to set mysql password and try again.

Let me know if that helps or not.

Update :-

  • update your config with {loglevel, 5}
  • then hit the login and tail all the log files.

odbc.ini

  1 [ejabberd]
  2 Driver      = MySQL
  3 DATABASE    = students
  4 PWD     = 
  5 SERVER      = localhost
  6 SOCKET      = /tmp/mysql.sock
  7 UID     = root

Upvotes: 2

gauravD
gauravD

Reputation: 89

One Major basic part that one can easily miss is that data which was previously stored in mnesia database will no longer will be available for your new configuration so again you have to create one admin user like this to access your admin account.

./ejabberdctl register admin "password"

Upvotes: 0

Related Questions