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.

This is the configuration I have done :

<dataConfig>
<dataSource name="mongod" type="JdbcDataSource"
driver="com.mongodb.jdbc.MongoDriver" url="*mongodb://<<IP
Address>>:27017/<<DB NAME>>*" *batchsize="-1" *user="*<<username>>*"
password="*<<password>>*"/>
<document name="products">
    <entity name="products"
    dataSource="mongod"
    transformer="TemplateTransformer,ProdsCatsFieldTransformer"
    onError="continue"
    pk="uuid"
    query="SELECT orgidStr,idStr,name,code,descr
iption,price,images,categoriesStr,enddate_solar,begin_date_
solar,status_solar,current_stock_solar,retprice_solar,
distprice_solar,listprice_solar,mfgprice_solar,out_of_
stock_solar,hide_product_solar,saleprice_solar,metakey_
solar,sales_enabled,new_product,has_sku,configurable,
rating,updatedAt,comparable,hide_price FROM products WHERE orgidStr =
'${dataimporter.request.orgid}'"


However it throws error when I run FULL IMPORT -

  getNext() failed for query 'SELECT orgidStr,idStr,name,code,descr
iption,price,images,categoriesStr,enddate_solar,begin_date_
solar,status_solar,current_stock_solar,retprice_solar,
distprice_solar,listprice_solar,mfgprice_solar,out_of_
stock_solar,hide_product_solar,saleprice_solar,metakey_
solar,sales_enabled,new_product,has_sku,configurable,
rating,updatedAt,comparable,hide_price FROM
products':java.lang.RuntimeException:
db error [not authorized for query on *<<DB NAME>>*.*<<COLLECTION NAME>>*]

​Any idea what could be the issue.​?Appreciate you help!!!

​Thank You!​

Best Regards,
​Abhijit​

Reply via email to