You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "laxmikantbpandhare (via GitHub)" <gi...@apache.org> on 2025/02/14 19:36:40 UTC
[I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
laxmikantbpandhare opened a new issue, #32266:
URL: https://github.com/apache/superset/issues/32266
### Bug description
Hi Team,
We are facing the below error while connecting to Apache Druid from the Superset Database connections option on UI.
Traceback (most recent call last):
File "/usr/mware/vsass/lib64/python3.9/site-packages/superset/commands/database/test_connection.py", line 170, in run
raise DBAPIError(ex_str or None, None, None)
sqlalchemy.exc.DBAPIError: (builtins.NoneType) None
(Background on this error at: https://sqlalche.me/e/14/dbapi)
**superset.exceptions.SupersetErrorsException: [SupersetError(message='(builtins.NoneType) None\n(Background on this error at: https://sqlalche.me/e/14/dbapi)', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'Apache Druid', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})]**
We manually tried a basic Python script for connection for Druid UI from the Superset server and "Connection is successful" indicates the Druid URL is working.
Is there any issue with the newer version of the superset? Appreciate your help and support.
For your information, below are the installed versions
**Apache Superset 4.1.0
Apache Druid 27.0.0
Python 3.9
PyDruid 0.6.9**
### Screenshots/recordings
_No response_
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2677354746
@sujiplr Druid is up and running with valid certificates.
I tested both the strings and it worked with below python code
engine = create_engine(druid_uri)
try:
connection = engine.connect()
print("Connection to Druid successful!")
connection.close()
except Exception as e:
print(f"Failed to connect to Druid: {e}")
So, Druid is working.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2660125333
<!-- Answer -->
The error you're encountering, `GENERIC_DB_ENGINE_ERROR`, is a common issue in Superset when the database returns an unexpected error. This error is often related to the database driver or connection handling <sup>[[1]](https://github.com/apache/superset/blob/master/superset/errors.py)</sup>.
To connect Apache Superset to Apache Druid, ensure that you are using the correct connection string format with the `pydruid` library:
```plaintext
druid://<User>:<password>@<Host>:<Port-default-9088>/druid/v2/sql
```
Make sure that the username, password, host, and port are correctly specified. Additionally, you can customize the connection by adding certificates in the **Root Certificate** field or by disabling SSL verification using the **Extras** field with the following configuration:
```json
engine_params: {
"connect_args": {
"scheme": "https",
"ssl_verify_cert": false
}
}
```
This setup should help in configuring your Druid database within Superset <sup>[[2]](https://github.com/apache/superset/blob/master/docs/docs/configuration/databases.mdx)</sup>.
If the connection works with a basic Python script but not within Superset, it might be worth checking the Superset logs for more detailed error messages. Also, ensure that the PyDruid version is compatible with Superset 4.1.0, which should be version 0.6.9 <sup>[[3]](https://github.com/apache/superset/blob/master/CHANGELOG/4.1.0.md)</sup>.
If these steps do not resolve the issue, consider reviewing the Superset logs for any additional error messages that might provide more insight into the problem.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/2301b1b9-34c4-413e-a9ed-ca30efcd73ef?feedback_type=other)</sup>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "sujiplr (via GitHub)" <gi...@apache.org>.
sujiplr commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2676995273
@laxmikantbpandhare try connection string as below.
druid+https://admin_User_ID:admin_password@server_router:443/druid/v2/sql
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "sujiplr (via GitHub)" <gi...@apache.org>.
sujiplr commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2677348306
@laxmikantbpandhare does your druid deployment on https has valid ssl certificate installed ? Does it have SSL error when you try from browser?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "sujiplr (via GitHub)" <gi...@apache.org>.
sujiplr commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2674572277
@laxmikantbpandhare , are you using https url for Druid ? can you share the connection string by masking host address and user credentials ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "sujiplr (via GitHub)" <gi...@apache.org>.
sujiplr commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2678340093
@laxmikantbpandhare , I'm suspecting this more of a connection string issue. I'm running Superset (4.1.1) against Druid .
We can connect on slack to check it, for further troubleshooting if needed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2686519110
The issue is fixed. The problem was with the certificates.
I added the below code in Seuciry Tabs under the Advanced option and it worked.
**{"connect_args":
{"scheme": "https", "ssl_verify_cert": false}}**
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare closed issue #32266: Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0)
URL: https://github.com/apache/superset/issues/32266
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2672665153
Any help or suggestion here please.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2675222544
@sujiplr we are using https only
Please find below Druid link we are trying
**druid://admin_User_ID:admin_password@server_router:9088/druid/v2/sql**
Let me know if anything else is required.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2677326895
@sujiplr - I tried as mentioned above but it still failed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "laxmikantbpandhare (via GitHub)" <gi...@apache.org>.
laxmikantbpandhare commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2684014470
My password has special characters and I did URL encoding of the password using the below code but it still failed
>>> import urllib.parse
>>> urllib.parse.quote_plus("kx@jj5/g")
'kx%40jj5%2Fg'
Referred - https://github.com/apache/superset/issues/29979#issuecomment-2311762527
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Installed Superset 4.1.0 and trying to create Database Connection for Apache Druid(27.0.0) [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #32266:
URL: https://github.com/apache/superset/issues/32266#issuecomment-2660221139
Pinging the Druid folks from the [Rolodex](https://docs.google.com/spreadsheets/d/1U1qxiLvOX0kBTUGME1AHHi6Ywel6ECF8xk_Qy-V9R8c/edit?gid=0#gid=0):
@betodealmeida
@sujiplr
@nytai
@villebro
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org