You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/08/10 14:43:09 UTC
[GitHub] [incubator-superset] tiago-as opened a new issue #10565: sslmode keyword is not recognized by superset
tiago-as opened a new issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565
I was trying to use mysqldb python module to connect to mariadb as I stated in this issue: https://github.com/apache/incubator-superset/issues/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 ):
```
{
"metadata_params": {},
"engine_params": {
"connect_args":{
"sslmode":"require",
"sslrootcert": "<path_to_file>"
}
}
}
```
When testing the connection, the server gave me this error:
```
Unexpected error __init__() got an unexpected keyword argument 'sslmode'
ERROR:superset.views.core:Unexpected error __init__() got an unexpected keyword argument 'sslmode'
INFO:werkzeug:127.0.0.1 - - [10/Aug/2020 12:50:25] "POST /superset/testconn HTTP/1.1" 400 -
```
Am I doing something wrong?
Thanks in advance for any help
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] tiago-as commented on issue #10565: sslmode keyword is not recognized by superset
Posted by GitBox <gi...@apache.org>.
tiago-as commented on issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565#issuecomment-673405465
I've found this bug report on the Ubuntu launchpad, can be related: https://bugs.launchpad.net/ubuntu/+source/openssl/+bug/1888101
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10565: sslmode keyword is not recognized by superset
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565#issuecomment-671398022
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.57. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] villebro commented on issue #10565: sslmode keyword is not recognized by superset
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565#issuecomment-729507619
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.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] tiago-as commented on issue #10565: sslmode keyword is not recognized by superset
Posted by GitBox <gi...@apache.org>.
tiago-as commented on issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565#issuecomment-672879392
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:
```
{
"metadata_params": {},
"engine_params": {
"connect_args":{
"ssl": {
"sslca": "<PATH_TO_CERT>"
}
}
},
"metadata_cache_timeout": {},
"schemas_allowed_for_csv_upload": []
}
```
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] mak705 commented on issue #10565: sslmode keyword is not recognized by superset
Posted by GitBox <gi...@apache.org>.
mak705 commented on issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565#issuecomment-729486579
import psycopg2
conn = psycopg2.connect(
dbname='yourdb', user='dbuser', password='abcd1234',
host='server', port='5432',
sslmode='verify-ca', sslrootcert="server-ca.pe"
)
got the same error `issue in resolving connect() got an unexpected keyword argument 'sslmode'`
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] commented on issue #10565: sslmode keyword is not recognized by superset
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10565:
URL: https://github.com/apache/incubator-superset/issues/10565#issuecomment-707094557
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 `.pinned` to prevent stale bot from closing the 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.
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