RabbitMq authentication from external database e.g. Mysql

[akhiles...@paxcel.net]

Hi All,

I am using the Rabbitmq java client.I need to implement the authentication and authorization from the mysql database but got stuck,don't know how to proceed for this.

Can any one of you please guide me through this or any pointer regarding the same.

Thanks in advance,Any help would be appreciated.

[Simon MacMullen]

On 27/10/14 12:02, akhiles...@paxcel.net wrote:
> Hi All,
> I am using the Rabbitmq java client.I need to implement the
> authentication and authorization from the mysql database but got
> stuck,don't know how to proceed for this.

Several auth plugins are available:

rabbitmq_auth_backend_ldap (ships with server)
rabbitmq_auth_backend_http (community plugin repo)
rabbitmq_auth_backend_amqp (ditto)

None of these can handle mysql directly.

You could either

1) Write a new plugin patterned off one of the above talking to mysql.
You'd need to do this in Erlang.

or

2) Write a bridge from one of the latter two into mysql, accepting
requests over AMQP or HTTP, and sending responses based on what mysql
tells you. You could do this in any language.

Cheers, Simon

[Akhilesh Saini]

Thanks Simon,for quick response.

Basically I used the "rabbitmq_auth_backend_amqp" but it doesn't seem working fine to me.If I give the credentials of my rabbitmq users(shown in browser management plugin) it works fine no matter what I write in "ExampleAuthBackend" about username and password.

Here is the problem,What exactly I need to do is check the authentication (just handshaked with rabbitmq till now,not the connection established with rabbitmq) if authentication goes right connection made with rabbitmq and check for the authorization(i.e. whatever entitles particular user have with given credentials).

All the credentials must be fetched from database only.

P.S. - I want to to this whole stuff with amqp.

--

Regards

Akhilesh Saini