@here does cli support ingestion from SSL only mys...
# ingestiong
great-branch-515
09/13/2022, 9:15 AM@here does cli support ingestion from SSL only mysql databases?
I am getting error
Copy code
(pymysql.err.OperationalError) (3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')
(Background on this error at: <http://sqlalche.me/e/13/e3q8>) due to
'(3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')'.great-branch-515
09/13/2022, 10:01 AMI was able to solve it by using database URL. My recipe looks like
Copy code
source:
type: mysql
config:
sqlalchemy_uri: <mysql+pymysql://datahub>:${DATAHUB_MYSQL_PASSWORD}@<db-url>:3306/datahub?ssl_ca=mysql-ssl-ca-cert.pem&ssl_verify_cert=false
sink:
type: "datahub-rest"
config:
server: 'https://<datahub-gms>'4 Views