sslmode keyword is not recognized by superset

[tiago-as]

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 ):

{
    "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

[issue-label-bot]

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.57. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[tiago-as]

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": []
}

[tiago-as]

I've found this bug report on the Ubuntu launchpad, can be related: https://bugs.launchpad.net/ubuntu/+source/openssl/+bug/1888101

[stale]

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.

[mak705]

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'

[villebro]

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.

[junlincc]

@tiago-as please let us know if you need help on adding support to mariadb.
closing it for now.