Hi,
I am using jdbc input plugin in logstash to ship the documents from mongodb to elasticsearch. I gave jdbc_user and jdbc_password but getting below error.
jdbc - Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaSql::SQLException: Query failed with error code 13 and error message 'there are no users authenticated' on server xx.xx.xx.xx:port
I am confused what privilages should the mongodb user should have to ship the data to elasticsearch. I tried with read user who is having only read permission and user having both read and write permissions. no luck nothing worked.
What privilages should the mongodb user should have to connect from logstash jdbc plugin.
help is really appreciated