-
Notifications
You must be signed in to change notification settings - Fork 14.1k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
sslmode keyword is not recognized by superset #10565
Comments
Issue-Label Bot is automatically applying the label Links: app homepage, dashboard and code for this bot. |
I was using Ubuntu 20.04 without success. I downgraded the operating system to Ubuntu 18.04 and to use Python 3.6. I was able to connect using PyMySQL with the following URI: mysql+pymysql://USERNAME:PASSWORD@IP_ADDRESS/DATABASE And with the following JSON in the extra field:
|
I've found this bug report on the Ubuntu launchpad, can be related: https://bugs.launchpad.net/ubuntu/+source/openssl/+bug/1888101 |
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue |
import psycopg2 conn = psycopg2.connect( got the same error |
We're currently adding native functionality for validating root certs to Postgres (See #11720). Once this gets merged I am happy to collaborate on adding support to other dbs (e.g. MySQL), as it is fairly simple due to the driver taking care of the majority of the heavy lifting. |
@tiago-as please let us know if you need help on adding support to mariadb. |
I was trying to use mysqldb python module to connect to mariadb as I stated in this issue: #10495
After some research I figured why not try to use pymysql as shown here: https://docs.sqlalchemy.org/en/13/core/engines.html#mysql
I was getting some good feedback since the errors from the server were changing. Eventually Superset gave me an error requesting the pynacl module besause we are using ed25519 on the database I want to connect to. After installing the pynacl module I provided the following parameters to the connection:
URI: mysql+pymysql://username:pwd@host/database
Extra parameters (from here https://superset.incubator.apache.org/installation.html#ssl-access-to-databases ):
When testing the connection, the server gave me this error:
Am I doing something wrong?
Thanks in advance for any help
The text was updated successfully, but these errors were encountered: