This message was deleted.
# generals
Slackbot
04/19/2023, 12:32 PMThis message was deleted.
t
Tejas Parbat
04/19/2023, 1:02 PMYou should be able access druid console on router port 8888(bydeafult) . e.g localhost:8888
How you are connecting deby database and what error it shows.
r
RAMESH ALLURI
04/19/2023, 1:31 PM@Tejas Parbat
HTTP ERROR 500 org.apache.druid.java.util.common.IAE: No userMap is available for authenticator with prefix: [MyBasicMetadataAuthenticator]
URI:/unified-console.html STATUS:500 MESSAGEorg.apache.druid.java.util.common.IAE No userMap is available for authenticator with prefix: [MyBasicMetadataAuthenticator] SERVLET:org.eclipse.jetty.servlet.DefaultServlet-591a4d25 CAUSED BYorg.apache.druid.java.util.common.IAE No userMap is available for authenticator with prefix: [MyBasicMetadataAuthenticator]
t
Tejas Parbat
04/19/2023, 1:34 PMCan you pls share how you are connecting derby database .
Tejas Parbat
04/19/2023, 1:36 PMalso looks like some issues with basic auth setup , Please use below sample configs
https://gist.github.com/davidagee/c0c839cd23f047b838e8a3ea73320346
r
RAMESH ALLURI
04/19/2023, 2:06 PMdruid.metadata.storage.type=derby
druid.metadata.storage.connector.connectURI=jdbc:derby://localhost:1527/var/druid/metadata.db;create=true
druid.metadata.storage.connector.host=localhost
druid.metadata.storage.connector.port=1527
RAMESH ALLURI
04/19/2023, 2:06 PMI kept this as it is
v
Vadim
04/19/2023, 4:14 PMJust to be clear: your metadata store configuration (connection to derby) and how you connect and authenticate to Druid (connecting to Druid to query it via JDBC or web console) are two totally different things that are not related to each other. If your Druid is generally working (i.e. you do not see a big scary warning when you open the web console) then you are connecting to Derby just fine
Vadim
04/19/2023, 4:15 PMport 8888 is the port where the router runs on. The router process starts by default (in the default configs).
Vadim
04/19/2023, 4:16 PMCan you access your router? it is where the web console is served from
r
RAMESH ALLURI
04/19/2023, 4:19 PMI just trying to setup druid cluster in my local
I ran start-single-server-small script
then created few tables in the server
from a java application connected trough the jdbc avatica and able to fetch data
RAMESH ALLURI
04/19/2023, 4:20 PMtill here everything is fine
i'm able to access 8888 port and load new data and query in ui every thing is fine
RAMESH ALLURI
04/19/2023, 4:21 PMI added basic authentication as per the doc
https://druid.apache.org/docs/latest/development/extensions-core/druid-basic-security.html#coordinator-security-api
RAMESH ALLURI
04/19/2023, 4:22 PMNo not able to connect to the server
RAMESH ALLURI
04/19/2023, 4:22 PM Copy code
Connection connection = DriverManager.getConnection("jdbc:avatica:remote:url=<http://localhost:8082/druid/v2/sql/avatica/>","admin","password2");RAMESH ALLURI
04/19/2023, 4:22 PMgetting this error
IAE: No userMap is available for authenticator with prefix: [MyBasicMetadataAuthenticator]
RAMESH ALLURI
04/19/2023, 4:23 PMNot use how to add this userMap
v
Vadim
04/19/2023, 4:25 PMI think you need to use these APIs to configure your user map: https://druid.apache.org/docs/latest/development/extensions-core/druid-basic-security.html#usercredential-management
g
Godwin Theophilus
04/19/2023, 11:16 PMHi @RAMESH ALLURI as part latest druid setup can you try to use start-druid command
Copy code
start-druid -m 5000mt
Tejas Parbat
04/20/2023, 7:38 AMbasic security API examples user management
https://apachedruidworkspace.slack.com/archives/C0303FDCZEZ/p1680079104087319?thread_ts=1680008828.277329&cid=C0303FDCZEZ