You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Mysurf Mail <st...@gmail.com> on 2013/05/31 17:03:54 UTC
installing & configuring solr over ms sql server - tutorial needed
I am trying to config solr over ms sql server.
I found only this tutorial
<http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
is a bit old (2011)
Is there an updated / formal tutorial?
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Diaconescu Stefan Andrei <di...@gmail.com>.
I think that the main idea is that, as mentioned before, you first have
install andrun SOLR;
For this use the official tutorial, it is simple and it works, i used it a
few months ago. Use also the examples, they are good to get an initial idea
about solr.
Then you setup sqlserver.
Then you have to take data from sqlserver and into solr, operation called
import.
For this you can either use the standard import, as explained in the
official documentation(or the tutorial you mentioned),
or you can import by running a program you write that simply posts to solr
bits of sql files , which contain info from mysql server, and which will
become documents into solr; the xml structure is also explained in the
official docs.
hope this helps.
On Fri, May 31, 2013 at 6:42 PM, Alexandre Rafalovitch
<ar...@gmail.com>wrote:
> What's wrong with the one you found. Just ignore steps 1-4 and go
> right into driver and DIH setup. If you hit any problems, you now have
> a specific question to ask.
>
> Regards,
> Alex.
> Personal blog: http://blog.outerthoughts.com/
> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
> - Time is the quality of nature that keeps events from happening all
> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
> book)
>
>
> On Fri, May 31, 2013 at 11:29 AM, Mysurf Mail <st...@gmail.com>
> wrote:
> > Thanks.
> > A tutorial on getting solr over mssql ?
> > I didnt find it even with jetty
> >
> >
> >
> > On Fri, May 31, 2013 at 6:21 PM, Alexandre Rafalovitch
> > <ar...@gmail.com>wrote:
> >
> >> You have two mostly-separate issues here. Running Solr in Tomcat and
> >> indexing MSSql server.
> >>
> >> Try just running a default embedded-Jetty example until you get data
> >> import sorted out. Then, you can worry about Tomcat. And it would be
> >> easier to help with one problem at a time.
> >>
> >> Regards,
> >> Alex.
> >> Personal blog: http://blog.outerthoughts.com/
> >> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
> >> - Time is the quality of nature that keeps events from happening all
> >> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
> >> book)
> >>
> >>
> >> On Fri, May 31, 2013 at 11:03 AM, Mysurf Mail <st...@gmail.com>
> >> wrote:
> >> > I am trying to config solr over ms sql server.
> >> > I found only this tutorial
> >> > <http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
> >> > is a bit old (2011)
> >> > Is there an updated / formal tutorial?
> >>
>
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Mysurf Mail <st...@gmail.com>.
btw: The other stages still refer to location relative to tomcat
On Sat, Jun 1, 2013 at 12:02 AM, Mysurf Mail <st...@gmail.com> wrote:
> for instance step 5 - Download and install a SQL Server JDBC drive.
> Where do I put it when using jetty?
>
> * Just asked here a question if an official tutorial for ms sql server
> exists before I try to go through several tutorials.
>
>
>
> On Fri, May 31, 2013 at 6:42 PM, Alexandre Rafalovitch <arafalov@gmail.com
> > wrote:
>
>> What's wrong with the one you found. Just ignore steps 1-4 and go
>> right into driver and DIH setup. If you hit any problems, you now have
>> a specific question to ask.
>>
>> Regards,
>> Alex.
>> Personal blog: http://blog.outerthoughts.com/
>> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
>> - Time is the quality of nature that keeps events from happening all
>> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
>> book)
>>
>>
>> On Fri, May 31, 2013 at 11:29 AM, Mysurf Mail <st...@gmail.com>
>> wrote:
>> > Thanks.
>> > A tutorial on getting solr over mssql ?
>> > I didnt find it even with jetty
>> >
>> >
>> >
>> > On Fri, May 31, 2013 at 6:21 PM, Alexandre Rafalovitch
>> > <ar...@gmail.com>wrote:
>> >
>> >> You have two mostly-separate issues here. Running Solr in Tomcat and
>> >> indexing MSSql server.
>> >>
>> >> Try just running a default embedded-Jetty example until you get data
>> >> import sorted out. Then, you can worry about Tomcat. And it would be
>> >> easier to help with one problem at a time.
>> >>
>> >> Regards,
>> >> Alex.
>> >> Personal blog: http://blog.outerthoughts.com/
>> >> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
>> >> - Time is the quality of nature that keeps events from happening all
>> >> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
>> >> book)
>> >>
>> >>
>> >> On Fri, May 31, 2013 at 11:03 AM, Mysurf Mail <st...@gmail.com>
>> >> wrote:
>> >> > I am trying to config solr over ms sql server.
>> >> > I found only this tutorial
>> >> > <http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
>> >> > is a bit old (2011)
>> >> > Is there an updated / formal tutorial?
>> >>
>>
>
>
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Mysurf Mail <st...@gmail.com>.
My problem was with sql server.
This <http://danpincas.com/2013/03/03/searching-with-solr-part-1.html> is a
great "step by step"
On Sat, Jun 1, 2013 at 2:06 AM, bbarani <bb...@gmail.com> wrote:
> Why dont you follow this one tutorial to set the SOLR on tomcat..
>
> http://wiki.apache.org/solr/SolrTomcat
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/installing-configuring-solr-over-ms-sql-server-tutorial-needed-tp4067344p4067488.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
Re: installing & configuring solr over ms sql server - tutorial
needed
Posted by bbarani <bb...@gmail.com>.
Why dont you follow this one tutorial to set the SOLR on tomcat..
http://wiki.apache.org/solr/SolrTomcat
--
View this message in context: http://lucene.472066.n3.nabble.com/installing-configuring-solr-over-ms-sql-server-tutorial-needed-tp4067344p4067488.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Mysurf Mail <st...@gmail.com>.
Hi,
I am still having a problem with this
<http://www.chrisumbel.com/article/lucene_solr_sql_server>tutorial trying
to get solr on tomcat.
in step 4 when I copy apache-solr-1.4.0\example\solr to my tomcat dir I get
a folder with bin and collection1 folder.
Do I need them?
should I create conf under solr or under collection1?
I dont have any solrconfig or schema files under solr. only under
collection1.
On Sat, Jun 1, 2013 at 12:26 AM, bbarani <bb...@gmail.com> wrote:
> solrconfig.xml - the lib directives specified in the configuration file are
> the lib locations where Solr would look for the jars.
>
> solr.xml - In case of the Multi core setup, you can have a sharedLib for
> all
> the collections. You can add the jdbc driver into the sharedLib folder.
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/installing-configuring-solr-over-ms-sql-server-tutorial-needed-tp4067344p4067465.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
Re: installing & configuring solr over ms sql server - tutorial
needed
Posted by bbarani <bb...@gmail.com>.
solrconfig.xml - the lib directives specified in the configuration file are
the lib locations where Solr would look for the jars.
solr.xml - In case of the Multi core setup, you can have a sharedLib for all
the collections. You can add the jdbc driver into the sharedLib folder.
--
View this message in context: http://lucene.472066.n3.nabble.com/installing-configuring-solr-over-ms-sql-server-tutorial-needed-tp4067344p4067465.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Mysurf Mail <st...@gmail.com>.
for instance step 5 - Download and install a SQL Server JDBC drive.
Where do I put it when using jetty?
* Just asked here a question if an official tutorial for ms sql server
exists before I try to go through several tutorials.
On Fri, May 31, 2013 at 6:42 PM, Alexandre Rafalovitch
<ar...@gmail.com>wrote:
> What's wrong with the one you found. Just ignore steps 1-4 and go
> right into driver and DIH setup. If you hit any problems, you now have
> a specific question to ask.
>
> Regards,
> Alex.
> Personal blog: http://blog.outerthoughts.com/
> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
> - Time is the quality of nature that keeps events from happening all
> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
> book)
>
>
> On Fri, May 31, 2013 at 11:29 AM, Mysurf Mail <st...@gmail.com>
> wrote:
> > Thanks.
> > A tutorial on getting solr over mssql ?
> > I didnt find it even with jetty
> >
> >
> >
> > On Fri, May 31, 2013 at 6:21 PM, Alexandre Rafalovitch
> > <ar...@gmail.com>wrote:
> >
> >> You have two mostly-separate issues here. Running Solr in Tomcat and
> >> indexing MSSql server.
> >>
> >> Try just running a default embedded-Jetty example until you get data
> >> import sorted out. Then, you can worry about Tomcat. And it would be
> >> easier to help with one problem at a time.
> >>
> >> Regards,
> >> Alex.
> >> Personal blog: http://blog.outerthoughts.com/
> >> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
> >> - Time is the quality of nature that keeps events from happening all
> >> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
> >> book)
> >>
> >>
> >> On Fri, May 31, 2013 at 11:03 AM, Mysurf Mail <st...@gmail.com>
> >> wrote:
> >> > I am trying to config solr over ms sql server.
> >> > I found only this tutorial
> >> > <http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
> >> > is a bit old (2011)
> >> > Is there an updated / formal tutorial?
> >>
>
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Alexandre Rafalovitch <ar...@gmail.com>.
What's wrong with the one you found. Just ignore steps 1-4 and go
right into driver and DIH setup. If you hit any problems, you now have
a specific question to ask.
Regards,
Alex.
Personal blog: http://blog.outerthoughts.com/
LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
- Time is the quality of nature that keeps events from happening all
at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
book)
On Fri, May 31, 2013 at 11:29 AM, Mysurf Mail <st...@gmail.com> wrote:
> Thanks.
> A tutorial on getting solr over mssql ?
> I didnt find it even with jetty
>
>
>
> On Fri, May 31, 2013 at 6:21 PM, Alexandre Rafalovitch
> <ar...@gmail.com>wrote:
>
>> You have two mostly-separate issues here. Running Solr in Tomcat and
>> indexing MSSql server.
>>
>> Try just running a default embedded-Jetty example until you get data
>> import sorted out. Then, you can worry about Tomcat. And it would be
>> easier to help with one problem at a time.
>>
>> Regards,
>> Alex.
>> Personal blog: http://blog.outerthoughts.com/
>> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
>> - Time is the quality of nature that keeps events from happening all
>> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
>> book)
>>
>>
>> On Fri, May 31, 2013 at 11:03 AM, Mysurf Mail <st...@gmail.com>
>> wrote:
>> > I am trying to config solr over ms sql server.
>> > I found only this tutorial
>> > <http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
>> > is a bit old (2011)
>> > Is there an updated / formal tutorial?
>>
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Mysurf Mail <st...@gmail.com>.
Thanks.
A tutorial on getting solr over mssql ?
I didnt find it even with jetty
On Fri, May 31, 2013 at 6:21 PM, Alexandre Rafalovitch
<ar...@gmail.com>wrote:
> You have two mostly-separate issues here. Running Solr in Tomcat and
> indexing MSSql server.
>
> Try just running a default embedded-Jetty example until you get data
> import sorted out. Then, you can worry about Tomcat. And it would be
> easier to help with one problem at a time.
>
> Regards,
> Alex.
> Personal blog: http://blog.outerthoughts.com/
> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
> - Time is the quality of nature that keeps events from happening all
> at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
> book)
>
>
> On Fri, May 31, 2013 at 11:03 AM, Mysurf Mail <st...@gmail.com>
> wrote:
> > I am trying to config solr over ms sql server.
> > I found only this tutorial
> > <http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
> > is a bit old (2011)
> > Is there an updated / formal tutorial?
>
Re: installing & configuring solr over ms sql server - tutorial needed
Posted by Alexandre Rafalovitch <ar...@gmail.com>.
You have two mostly-separate issues here. Running Solr in Tomcat and
indexing MSSql server.
Try just running a default embedded-Jetty example until you get data
import sorted out. Then, you can worry about Tomcat. And it would be
easier to help with one problem at a time.
Regards,
Alex.
Personal blog: http://blog.outerthoughts.com/
LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
- Time is the quality of nature that keeps events from happening all
at once. Lately, it doesn't seem to be working. (Anonymous - via GTD
book)
On Fri, May 31, 2013 at 11:03 AM, Mysurf Mail <st...@gmail.com> wrote:
> I am trying to config solr over ms sql server.
> I found only this tutorial
> <http://www.chrisumbel.com/article/lucene_solr_sql_server>whih
> is a bit old (2011)
> Is there an updated / formal tutorial?