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:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to