Re: SQL module does not work in Solr release 9.0.0

2022-09-25 Thread Kevin Risden
Farrukh - we have already answered your thread - it helps if you subscribe to users mailing list to see the responses. Kevin Risden On Sun, Sep 25, 2022 at 11:49 AM Kevin Risden wrote: > Farrukh - It looks like you have been building Solr (based on seeing > Calcite 1.32 in the logs which was o

Re: SQL module does not work in Solr release 9.0.0

2022-09-25 Thread Kevin Risden
Farrukh - It looks like you have been building Solr (based on seeing Calcite 1.32 in the logs which was only recently updated) - can you try out https://github.com/apache/solr/pull/1044 with security manager enabled to see if that fixes the issue you ran into? Kevin Risden On Sun, Sep 25, 2022 a

Re: SQL module does not work in Solr release 9.0.0

2022-09-25 Thread Kevin Risden
So the stack trace lines up with https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/config/CalciteSystemProperty.java#L189 It looks like Calcite / Solr SQL doesn't like the Java security manager being enabled; there is an exception checking those paths. A workaround

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
On Sat, 24 Sep 2022, 20:17 Farrukh Zamir, wrote: > Following are the links to images of my error mentioned in previous mail. > Sequence wise. > > > https://drive.google.com/file/d/16Z-nQHhvzXVQ2oSyfqsdCSZTofLDcuZ9/view?usp=drivesdk > > > https://drive.google.com/file/d/1oIMKI_3cdUwCiZ-86XLH8VfQXB

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
Following are the links to images of my error mentioned in previous mail. Sequence wise. https://drive.google.com/file/d/16Z-nQHhvzXVQ2oSyfqsdCSZTofLDcuZ9/view?usp=drivesdk https://drive.google.com/file/d/1oIMKI_3cdUwCiZ-86XLH8VfQXB9URqwn/view?usp=drivesdk https://drive.google.com/file/d/1AL-DFI

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Mike Drob
The mailing list removes images, you may need to upload them and link from an external service. On Sat, Sep 24, 2022 at 7:22 AM Farrukh Zamir wrote: > Also i am seeing this error in log while /sql handler is initialized. > [image: Untitled23.png] > > On Sat, Sep 24, 2022 at 2:16 PM Farrukh Zamir

Re: SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
Also i am seeing this error in log while /sql handler is initialized. [image: Untitled23.png] On Sat, Sep 24, 2022 at 2:16 PM Farrukh Zamir wrote: > Hi, > i have installed solr 9.0.0 on my server on windows. It installed > successfully. Cloud mode required for sql was also configured > successfu

SQL module does not work in Solr release 9.0.0

2022-09-24 Thread Farrukh Zamir
Hi, i have installed solr 9.0.0 on my server on windows. It installed successfully. Cloud mode required for sql was also configured successfully./sql handle is also being shown in plugins in core. [image: image.png] But when i execute sql query. Following error shows. i have said the library path a