Thanks Shawn. As you rightly mentioned I will check with some who is familiar with JDBC for mongDB. Thank you and take care.
Best Regards, <http://www.ibizsoftinc.com/> <http://www.ibizsoftinc.com/> Abhijit Pawar Office : +1 (469) 287 2005 x 110 Follow us on: On Wed, Jan 18, 2017 at 9:26 AM, Shawn Heisey <[email protected]> wrote: > On 1/16/2017 1:04 PM, Abhijit Pawar wrote: > > Hello, > > > > Need your help on one small problem I am facing in SOLR. > > > > I have added authentication for our mongodb database in > data-source-config > > file in SOLR. > > <snip> > > > rating,updatedAt,comparable,hide_price FROM > > products':java.lang.RuntimeException: > > db error [not authorized for query on *<<DB NAME>>*.*<<COLLECTION > NAME>>*] > > I'll say the same thing I told you when you asked about this on the IRC > channel: > > When accessed this way (via JDBC), JDBC is saying that the user isn't > authorized. It doesn't have enough permissions to do the query that > Solr asked it to do. It might be a result of misconfiguration, but > since I'm unfamiliar with the driver, and the error message isn't > complete, I cannot say. > > As for why you're running into this authorization issue, that is going > to require the expertise of someone who is familiar with the JDBC driver > for MongoDB. You're going to need to ask someone in the MongoDB world > about this. The error message you've included here does not mean much > to me. It would probably mean more to a MongoDB expert. > > Your Solr logfile should contain a much larger error message, one that > includes a large java stacktrace. This will likely be helpful to > whoever you contact for help on the issue. > > At the following URL, you can see a working configuration for DIH with > MySQL -- the one that I use. This is not directly relevant for MongoDB, > but maybe you can find something useful in the config: > http://apaste.info/rG6yU > > I found a third-party project for importing from MongoDB into Solr: > > https://github.com/james75/SolrMongoImporter > > I do not know anything about this project, but it comes up in google > search results, so hopefully it's a good project. > > Thanks, > Shawn > >
