Hello, I’m attempting to use the JDBC drivers included with the 9.8 packages to connect to a 9.8 SOLR server which has been configured with Basic Auth. When attempting to make any queries, I get back an HTTP 401 error.
I see that the credentials are being passed in the query string, which is not Basic Auth (since they should be in the headers instead). Example of a returned error: java.sql.SQLException: java.sql.SQLException: java.io.IOException: Query to '/sql?stmt=select+tableCat,+tableSchem,+tableName,+tableType,+remarks+from+metadata.TABLES+where++tableSchem+like+'%25'+and+tableName+like+'application'&includeMetadata=true&password=***ENCODEDPWHERE***&user=***USERNAMEHERE***&aggregationMode=facet&indent=off' failed due to: (401) Is there some trick to getting the JDBC drivers to work correctly with Basic Auth? I’m attempting to use the JDBC drivers with DBeaver, and I also noticed that none of the examples (DbVisualizer, SQuirreL, etc.) show a configuration with credentials configured. I'm wondering if there is some flag or parameter to be added in the driver config to let it know how to craft the request to the server. Many thanks! -- *Marcus R. Matos*CISSP, CSSLP, CISM, PMI-ACP || Always Learning Solutions Development & Delivery Leader || Bridging Business & Technology Dallas, TX || mobile: 214-531-9365 || e-mail: mar...@matosconsulting.com
