Rasa core unable to connect to SSL enabled MySQL tracker store db

I’m getting following error: [ERROR] Could not create tables: (pymysql.err.OperationalError) (1045, “Access denied for user ‘username’@‘dbserver’ (using password: YES)”) (Background on this error at: http://sqlalche.me/e/13/e3q8)

Following is tracker store configurations in endpoints.yml.

tracker_store:
    type: SQL
    dialect: "mysql+pymysql"
    url: "<url>"
    username: "<username>"
    password: "<password>"
    db: "<dbname>"

I am using rasa==1.10.0 and our Linux CentOS rasa client fails to connect to SSL enabled MySQL tracker db. Can someone look in to this ? Thankyou.

You need to specify your certs. You can find info on this in the sqlalchemy docs.

One approach is to set these i the url option. Here’s an example postgres URL with SSL:

'postgresql://user:pass@host/dbname?alt_host=host1&alt_host=host2&ssl_cipher=%2Fpath%2Fto%2Fcrt'

Greg