I included modules in solrconfig.xml, i thought it was enought. I will try later and post the result here. bin/solr start -e techproducts -Dsolr.modules=sql
Thanks! Em qui., 10 de ago. de 2023 às 09:40, Eric Pugh < ep...@opensourceconnections.com> escreveu: > You need to enable the sql module. I suspect you won’t be the first > person with this email now that we have added modules. It would be nice if > the UI told you that you need to restart Solr with that setting! > > SQL Query Language :: Apache Solr Reference Guide > <https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#module> > solr.apache.org > <https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#module> > [image: favicon.ico] > <https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#module> > <https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#module> > > > bin/solr start -e techproducts -Dsolr.modules=sql > > > > > On Aug 10, 2023, at 8:36 AM, Kojo <rbsnk...@gmail.com> wrote: > > Hi, > I'm trying to get the SQL query requestHandler up and running using this > config: <requestHandler name="/sql" class="solr.SQLHandler">. > > My setup involves solr-9.0.0 in cloud mode with ZooKeeper. > > I went through the Solr documentation, but I'm hitting a roadblock with > just that. Do you know any other sources that might help? I've already > checked out the official Solr documentation here: > > https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#configuration > > Here's what I've tried so far, but sadly, no luck: > > - Tried a query on the admin page. > - Attempted to connect via sqlalchemy-solr. > - Gave a shot at sending a request to the _sql/ endpoint. > > On the config side of things: > > - Initially, I thought I could get away with no extra config, as per Solr's > docs. Supposedly, the /sql request handler should already be good to go in > a regular Solr installation. > > - Then I got a bit fancy and added the request handler config directly into > the solrconfig.xml file like this: > > <requestHandler name="/sql" class="solr.SQLHandler"> > <lst name="defaults"> > <str name="config">solrconfig.xml</str> > </lst> > </requestHandler> > > > To solve this puzzle, I tried these moves: > > Grabbed the solr-core-9.0.0.jar library from > /server/solr-webapp/webapp/WEB-INF/lib/ and threw it into > <solr_home>/server/lib/. > I doubled down and copied the solr-sql-9.0.0.jar from > <solr_home>/modules/sql/lib/ to both <solr_home>/server/lib/ and > <solr_home>/server/lib/ext/. > Oh, and I also tweaked the solrconfig.xml file by sticking in a line to > point to the outside library directory: > > <lib dir="${solr.install.dir:../../../..}/lib/ext/" regex=".*\.jar" /> > > > I'm reaching out to see if I'm on the right track here. If I am, I'm > planning to keep poking around and maybe get some error logs to show you > later. But if I'm off the mark, your tips or suggestions for other places > to look would be awesome. > > Thanks a bunch for your help! > > Cheers, > Koji > > > _______________________ > *Eric Pugh **| *Founder & CEO | OpenSource Connections, LLC | 434.466.1467 > | http://www.opensourceconnections.com | My Free/Busy > <http://tinyurl.com/eric-cal> > Co-Author: Apache Solr Enterprise Search Server, 3rd Ed > <https://www.packtpub.com/big-data-and-business-intelligence/apache-solr-enterprise-search-server-third-edition-raw> > This e-mail and all contents, including attachments, is considered to be > Company Confidential unless explicitly stated otherwise, regardless > of whether attachments are marked as such. > >
