I am using SQL tracker store. Storing trackers this way allows to query the event database by sender_id, timestamp, action name, intent name and typename. But, I want to store more information to my database like intent confidence, conversation text etc to my SQL database.
Is there any simpler way of doing it or making a custom tracker by extending the base class TrackerStore the only resort.
Hi @gaushh, can you help me with storing my conversations in the SQL db via TrackerStore?
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?