I want to use sql tracker store to store the conversation history in db but it seems it is not working for me. I am having MySQL database which i want to connect for that i am using below code in my endpoint.yml tracker_store: type: SQL dialect: "sqlite" # the dialect used to interact with the db url: "localhost" # (optional) host of the sql db db: "chatbot" # path to your db username: "root" # username used for authentication password: "test" # password used for authentication when i am running rasa shell -m models --endpoints endpoints.yml i am getting below error. " sqlite:////absolute/path/to/file.db" % (url,) sqlalchemy.exc.ArgumentError: Invalid SQLite URL: sqlite://root:test@localhost/c hatbot Valid SQLite URL forms are: sqlite:///:memory: (or, sqlite://) sqlite:///relative/path/to/file.db sqlite:////absolute/path/to/file.db When i tried to connect the same db using python code it worked for me. Below is my python code. import mysql.connector mydb = mysql.connector.connect(host="localhost",port="3306",user="root",database="chatbot",password="test") mycursor = mydb.cursor() sql = "Show tables;" mycursor.execute(sql) myresult = mycursor.fetchall() print(myresult) for x in myresult: print(x) Please help me how can i resolve this.

[image] indranil180: sqlalchemy.exc.CompileError: (in table ‘events’, column ‘sender_id’): VARCHAR re quires a length on dialect mysql Ahh OK, this was a nasty bug with sqlalchemy. Try this solution please . If that works then we can probably make a fix for this

Sql_tracker_store giving error

Rasa Open Source

MetcalfeTom (Thomas Metcalfe) August 12, 2019, 6:23pm 10

Ahh OK, this was a nasty bug with sqlalchemy. Try this solution please. If that works then we can probably make a fix for this

Topic		Replies	Views
Importing Conversations Rasa Open Source	2	1027	July 22, 2019
Save conversation sqlite Rasa Open Source	5	2146	November 8, 2019
SQL Tracker_store Rasa Open Source	4	1010	April 27, 2019
Rasa SQL DB configuration Rasa Open Source	2	888	April 28, 2020
SQL Tracker_store affecting conversation flow by giving "action_default_fallback" Rasa Open Source testing	0	209	March 1, 2023

Sql_tracker_store giving error

Related topics