Setting up MySQL as Tracker Store in Rasa скачать в хорошем качестве

Setting up MySQL as Tracker Store in Rasa

Setting MySQL as Tracker Store Make sure you have installed MySQL on your system. Step_1: Connect to MySQL Server & create a db Step_2 : Now we need to set up SQL as Tracker store in endpoints.yml file Step_3 : Now we need to install pymsql module for dialect here I am using "mysql+pymysql" as my dialect Step_4 : now lets test whether this works or not so now my connection to mysql db is successfully completed, now lets test the bot.. Now lets check whether we have received the data in our db.. as you can see that I have successfully setup the MySQL as my tracker store... Now some of you might face errors during the setup errors like sqlalchemy.exc.CompileError: (in table ‘events’, column ‘sender_id’): VARCHAR requires a length on dialect mysql this issue is related to SQLalchemy, so to solve this issue go to python directory and check for SQLalchemy module and follow the steps: path: sqlalchemy-dialects-mysql-base.py go to line no. 1947 and the below code: if type_.length is None: type_.length = 1024 # change 1024 to whatever lenght value you need that's it save the file and restart the server, it will work!!!! Thanks for watching.... If you have any query, you can post it on the RASA community http://forum.rasa.com