Hi Shawn, One thing that popped in my mind is I saw your code wherein the password for mysql is not included in quotes or double quotes.
password=REDACTED Whereas mine were included. password="*<<password>>*" Do you think that could be a possible issue here? 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:33 AM, Abhijit Pawar <[email protected]> wrote: > 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 <(469)%20287-2005> > > > > 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 >> >> >
