You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@solr.apache.org by Clay Harter <cl...@bahwancybertek.com.INVALID> on 2024/02/05 21:02:08 UTC

JDBC Driver with Basic Authentication ?

I have configured the BasicAuthPlugin in our Solr 8.11.1 installation but find that I can no longer use the Solr JDBC driver. Even when I supply the user and password properties in creating my Connection, I always get a 401 error:

java.sql.SQLException: java.sql.SQLException: java.io.IOException: Query to '/sql?stmt=select+id+from+data+limit+10&includeMetadata=true&user=xxxxxx&password=yyyyyy&aggregationMode=facet&indent=off' failed due to: (401) <html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 401 require authentication</title>
</head>
<body><h2>HTTP ERROR 401 require authentication</h2>
<table>
<tr><th>URI:</th><td>/solr/data_shard1_replica_n1/sql</td></tr>
<tr><th>STATUS:</th><td>401</td></tr>
<tr><th>MESSAGE:</th><td>require authentication</td></tr>
<tr><th>SERVLET:</th><td>default</td></tr>
</table>

</body>
</html>

It is as if these properties are being ignored by the JDBC driver.  Does the Solr JDBC driver support basic authentication?

Thanks,

Clay