Re: Indexing data from multiple data sources
The link you quote is Sematext's mirror of the Apache solr-user mailing list. There are others also providing copies of this list. As the cat is very much out of the bag your best course of action is to change all the logins and passwords that have been leaked and review your security procedures. Cheers Charlie On 18/04/2020 13:27, RaviKiran Moola wrote: Hi, Greetings of the day!!! Unfortunately we have enclosed our database source details in the Solr community post while sending our queries to solr support as mentioned in the below mail. We find that it has been posted with this link https://sematext.com/opensee/m/Solr/eHNlswSd1vD6AF?subj=RE+Indexing+data+from+multiple+data+sources As it is open to the world, what we are requesting here is, could you please remove that post as-soon-as possible before it creates any sucurity issues for us. Your help is very very appreciable!!! FYI. Here I'm attaching the below screenshot Thanks & Regards, Ravikiran Moola *From:* RaviKiran Moola *Sent:* Friday, April 17, 2020 9:13 PM *To:* solr-user@lucene.apache.org *Subject:* RE: Indexing data from multiple data sources Hi, Greetings!!! We are working on indexing data from multiple data sources (MySQL & MSSQL) in a single collection. We specified data source details like connection details along with the required fields for both data sources in a single data config file, along with specified required fields details in the managed schema and here fetching the same columns from both data sources by specifying the common “unique key”. Unable to index the data from the data sources using solr. Here I’m attaching the data config file and screenshot. Data config file: url="jdbc:mysql://182.74.133.92:3306/ra_dev" user="devuser" password="Welcome_009" batchSize="1" /> driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://182.74.133.92;databasename=BB_SOLR" user="matuser" password="MatDev:07"/> Thanks & Regards, Ravikiran Moola +91-9494924492 -- Charlie Hull OpenSource Connections, previously Flax tel/fax: +44 (0)8700 118334 mobile: +44 (0)7767 825828 web: www.o19s.com
Re: Indexing data from multiple data sources
Hi, Greetings of the day!!! Unfortunately we have enclosed our database source details in the Solr community post while sending our queries to solr support as mentioned in the below mail. We find that it has been posted with this link https://sematext.com/opensee/m/Solr/eHNlswSd1vD6AF?subj=RE+Indexing+data+from+multiple+data+sources As it is open to the world, what we are requesting here is, could you please remove that post as-soon-as possible before it creates any sucurity issues for us. Your help is very very appreciable!!! FYI. Here I'm attaching the below screenshot [cid:6ccc253a-a590-4e89-b5de-fd9a59d88aba] Thanks & Regards, Ravikiran Moola From: RaviKiran Moola Sent: Friday, April 17, 2020 9:13 PM To: solr-user@lucene.apache.org Subject: RE: Indexing data from multiple data sources Hi, Greetings!!! We are working on indexing data from multiple data sources (MySQL & MSSQL) in a single collection. We specified data source details like connection details along with the required fields for both data sources in a single data config file, along with specified required fields details in the managed schema and here fetching the same columns from both data sources by specifying the common “unique key”. Unable to index the data from the data sources using solr. Here I’m attaching the data config file and screenshot. Data config file: Thanks & Regards, Ravikiran Moola +91-9494924492
Indexing data from multiple data sources(CSV, RDBMS)
Hi, I am working on indexing data from multiple data sources using a single collection. I specified data sources information in the data-config file and also updated managed schema.xml by adding the fields from all the data sources by specifying the common unique key across all the sources. Here is a sample config file. > url="jdbc:mysql://localhost/aaa" user="***" password="***" batchSize="1" /> > driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://localhost;databasename=aaa" user="***" password="**"/> > > > > > > > > > > > Error Details: Full Import failed:java.lang.RuntimeException:java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Invalid type for data source: Jdbc-2 Processing Document #1 Thanks, Shravan
Re: Indexing data from multiple data sources
What does your Solr.log say? Any error ? > Am 17.04.2020 um 20:22 schrieb RaviKiran Moola > : > > > Hi, > > Greetings!!! > > We are working on indexing data from multiple data sources (MySQL & MSSQL) in > a single collection. We specified data source details like connection details > along with the required fields for both data sources in a single data config > file, along with specified required fields details in the managed schema and > here fetching the same columns from both data sources by specifying the > common “unique key”. > > Unable to index the data from the data sources using solr. > > Here I’m attaching the data config file and screenshot. > > Data config file: > > url="jdbc:mysql://182.74.133.92:3306/ra_dev" user="devuser" > password="Welcome_009" batchSize="1" /> > driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://182.74.133.92;databasename=BB_SOLR" user="matuser" > password="MatDev:07"/> > > > > > > > > > > > > > > Thanks & Regards, > Ravikiran Moola > +91-9494924492 >
RE: Indexing data from multiple data sources
Hi, Greetings!!! We are working on indexing data from multiple data sources (MySQL & MSSQL) in a single collection. We specified data source details like connection details along with the required fields for both data sources in a single data config file, along with specified required fields details in the managed schema and here fetching the same columns from both data sources by specifying the common “unique key”. Unable to index the data from the data sources using solr. Here I’m attaching the data config file and screenshot. Data config file: Thanks & Regards, Ravikiran Moola +91-9494924492