You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "FiiL123 (via GitHub)" <gi...@apache.org> on 2024/03/28 14:52:57 UTC
[I] Not accepting `*` in a database account password [superset]
FiiL123 opened a new issue, #27764:
URL: https://github.com/apache/superset/issues/27764
### Bug description
A postgres database connection with valid credentials does not work because there is a special character in the password(`*`).
We tried escaping the password string directly in the URL and in the DB with no change in behavior.
### How to reproduce the bug
1. Add database connection with a password containing `*`
2. Try to load schemas in SQL Lab
3. get an error
### Screenshots/recordings
_No response_
### Superset version
3.1.1
### Python version
3.10
### Node version
I don't know
### Browser
Chrome
### Additional context
Only error message in logs we get is when requesting schemas when exploring in sqllab.
`DatabaseRestApi.schemas.error`
All of the sqlalchemy libs we use.
```
flask-sqlalchemy 2.5.1
marshmallow-sqlalchemy 0.28.2
sqlalchemy-dremio 3.0.3
sqlalchemy-utils 0.38.3
sqlalchemy 1.4.51```
### 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] Not accepting `*` in a database account password [superset]
Posted by "betodealmeida (via GitHub)" <gi...@apache.org>.
betodealmeida commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2066840702
I'll fix this, thanks for the report!
--
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] Not accepting `*` in a database account password [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke closed issue #27764: Not accepting `*` in a database account password
URL: https://github.com/apache/superset/issues/27764
--
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] Not accepting `*` in a database account password [superset]
Posted by "dwierenga (via GitHub)" <gi...@apache.org>.
dwierenga commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2111153114
I have the same problem with a password with a % character in it. I've tried using a backslash to escape it and URL-encoding it, to no avail.
--
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] Not accepting `*` in a database account password [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2707089389
I believe this was fixed in October by https://github.com/apache/superset/pull/30532 so I will close this. If anyone experiences this problem persisting in 4.1.1 or 5.0.0 or later, please open a new issue.
--
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] Not accepting `*` in a database account password [superset]
Posted by "soniagtm (via GitHub)" <gi...@apache.org>.
soniagtm commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2066144110
I also encounter the same issue, particularly when the * is at the end of my password in the SQLAlchemy URI.
--
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] Not accepting `*` in a database account password [superset]
Posted by "wjf136 (via GitHub)" <gi...@apache.org>.
wjf136 commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2342618534
Facing the same issue. Hit problems with both `*` and `%`. Any potential updates on this?
--
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] Not accepting `*` in a database account password [superset]
Posted by "massynmantel (via GitHub)" <gi...@apache.org>.
massynmantel commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2041182958
When using tools like Amazon RDS with a Secrets Manager that is rotating the RDS credentials for you, you cannot enforce how strong the password will be. This is going to be a problem in large enterprise environments that have very strict password policies.
--
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] Not accepting `*` in a database account password [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #27764:
URL: https://github.com/apache/superset/issues/27764#issuecomment-2033219660
Pinging @dpgaspar @betodealmeida in case there's good reason for not accepting that particular character.
--
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