Tracker store: Could not create tables

Welcome to the Rasa Community Forum!
1

I’m getting this error:

Could not create tables: (pymysql.err.OperationalError) (1045, “Access denied for user _____’ (using password: YES)”) (Background on this error at: http://sqlalche.me/e/e3q8)

my tracker_store:

tracker_store: type: SQL dialect: “mysql+pymysql” # the dialect used to interact with the db url: “localhost” # (optional) host of the sql db, e.g. “localhost” db: “mydb” # path to your db username: “admin” # username used for authentication password: “admin” # password used for authentication

any idea what i’m doing wrong?

Also, is there a way to require ssl in sql dialect?

2

@Juste can you take a look when you have a chance? thank you!

3

Hi @codingmt , Were you able to connect / access the database with the same credentials ?

Hope your database is hosted on the same machine as that of Rasa.

5

@siriusraja Sorry I’m new to development. The database is not hosted on my computer but I’m able to connect to it via MySQLClient. Does it have to be hosted on your machine?

6

Hi @maliha1

Its not necessary to host your Database in the same machine. If its hosted on a different machine, then update your tracker store config with the database server name.

url: <This should be your database server name if its hosted on a different machine>

Also ensure you can connect to your database via MySQLClient from your rasa server to check connectivity at network level.

7

Hi @siriusraja,

thank you for your help! my post was dummy data but I sholudn’t have put down localhost.

I finally figured it out. It was just cert issues I had. I had to uninstall and reinstall mysql and also get rid of pymysql completely. I had to connect via python code first to see if it’s working and it wasn’t until i reinstalled it.

thanks again! appreciate it!

8

@maliha1 How did you add the certs in the tracker store configuration? Tracker store doesn’t have any configuration for adding path to certs.