Authentication error when accessing mongodb through Spring Boot app

I found the problem. For completeness of this thread, I'll share the answer, including the code. The issue was that I used the application property spring.data.mongodb.uri wrong: it did not have the username and password in the URI, because I mistakenly believed that spring.data.mongodb.username and spring.data.mongodb.password covered that. So, either use the uri with username and password, or use the host and database (and maybe also port) spring properties explicitly.Here is the code. It will work in the spring boot app with mongoDB support (use initializr or IntelliJ to create that project).I have a model:

package net.IndyStef.model;import org.springframework.data.annotation.Id;import org.springframework.data.mongodb.core.mapping.Document;@Document(collection = "person")public class Person {@Idprivate String id;private String name;private Integer age;public Person() {}public Person(String id) {    this.id = id;}public Person(String id, String name, Integer age) {    this.id = id;    this.name = name;    this.age = age;}... getters/setters omitted for breverity ...}

The data is read and written through a repository:

package net.IndyStef.repository;import net.okrongli.model.Person;import org.springframework.data.mongodb.repository.MongoRepository;/** * Created by IndyStef on 23/08/16. */public interface PersonRepository extends MongoRepository<Person, String> {}

The database name, host, and credentials are in the application.properties file:

spring.data.mongodb.host=192.168.1.90spring.data.mongodb.database=peoplespring.data.mongodb.username=userspring.data.mongodb.password=password#spring.data.mongodb.uri=mongodb://192.168.1.90/people

Important is to not mix the uri with database and username. If you use uri, it needs to include the username and password, like this:

spring.data.mongodb.uri=mongodb://user:password@192.168.1.90/people

To test this, I used a simple Spring command line runner:

package net.IndyStef;import net.IndyStef.model.Person;import net.IndyStef.repository.PersonRepository;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.CommandLineRunner;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import java.util.List;@SpringBootApplicationpublic class MongoDbTestApplication implements CommandLineRunner {    public static void main(String[] args) {        SpringApplication.run(MongoDbTestApplication.class, args);    }    @Autowired    private PersonRepository repository;    @Override    public void run(String... args) {        repository.save(new Person("peter.pan", "Peter Pan", 865));        List<Person> people = repository.findAll();        for (Person person: people) {            System.out.println(person);        }    }}

I hope this explanation helps others that couldn't figure it out, like myself for a couple of days.

Thanks,

Stefan

As of Spring Boot 1.5.15, you can add the following line to your application.properties file:

spring.data.mongodb.uri=mongodb://username:password@localhost:27017/?authSource=admin&authMechanism=SCRAM-SHA-1spring.data.mongodb.database=mycollection

This is what worked for me at then end:

spring.data.mongodb.uri=mongodb://user:password@******.mongodb.net:27017/dbname?ssl=true&authSource=admin&authMechanism=SCRAM-SHA-1

I had to add ssl=true, otherwise I was getting error:

com.mongodb.MongoSocketReadException: Prematurely reached end of stream