Need to support migrations executed on behalf of a user with readWrite privilege

[jchu59]

What version of Flyway are you using?

release-4.0.3-mongodb

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin, SBT plugin, ANT tasks)

Java API

What database are you using (type & version)?

MongoDB 3.3

What operating system are you using?

OSX El Capitan

What did you do?

(Please include the content causing the issue, any relevant configuration settings, and the command you ran)
execute mongoFlyway.migrate on server where db is not yet created

What did you expect to see?

migration work

What did you see instead?

We have a microservice architecture in which each microservice uses a mongo client on behalf of a user with only readWrite privileges. When a db is not yet created, or also in the case where it is created but the schema_version collection is not yet created, a listDatabases method is called which is not available for a regular user. This throws a FlywayException and migration dies. Our workaround is to catch the exception on listDatabases and then make a call to find the schema_version collection.

[khatkar]

@jchu59 When migrate is run for a non-existing db, mongoFlyway will create one. I am not able to replicate your error. Can you create a sample git repo with the error producing code?

[jchu59]

Your tests use a non-authenticating instance of Embedded Mongo. I can try to create a test case with an authenticating instance which Embedded Mongo now supports to reproduce the problem in a test on a branch of mongo-flyway. I would just send you our test code but it is owned by a corporation. In the meantime, you can reproduce this on any live authenticating database pretty easily when connecting with a regular readWrite user.

[khatkar]

Test using non-authenticated instance of Mongo is irrelevant to this issue.