Hello All, We currently have running our chatbot in production server and all conversations are stored in SQLite but now we want to stored them in SQL Server table, we used the below configuration in our enpoints.yml: tracker_store: type: SQL dialect: "mssql" url: "000.000.00.0" db: "DB_NAME" port: "" username: "" password: " query: driver: "FreeTDS" but sometimes just stop working and does not save any conversation, we use rasa version 1.10.12

@kandykane Interesting you have’nt mentioned that you are using docker containers. so in this use-case scenario, you need to mention the image of SQL or Postgres in the docker-compose, because you are running in a container-based environment. Just for Demonstration purposes and here I’m using Postgres: version: "3" services: rasa: container_name: "rasa_server" user: root build: context: . volumes: - "./:/app" ports: - "5005:5005" action_server: container_name: "action_server" build: context: actions volumes: - "./actions:/app/actions" - "./data:/app/data" ports: - "5055:5055" db: container_name: postgresql_db image: postgres:latest restart: always environment: POSTGRES_USER: postgres POSTGRES_PASSWORD: 12453 POSTGRES_DB: chatbot # automatically restarts the container - Docker daemon on restart or # the container itself is manually restarted ports: - "5432:5432" # networks: # app_net: # ipv4_address: 192.168.0.2 pgadmin: container_name: pgadmin4 image: dpage/pgadmin4 restart: always environment: PGADMIN_DEFAULT_EMAIL: root@root.com PGADMIN_DEFAULT_PASSWORD: root # PGADMIN_LISTEN_PORT: 90 ports: - "5050:80" # networks: # app_net: # ipv4_address: 192.168.0.3 # networks: # app_net: # ipam: # driver: default # config: # - subnet: "192.168.0.0/24" # gateway: 192.168.0.1 Please cross check the code or ref on google or youtube for postgres docker image. Keep note, container IP changes dyanamically. I hope this will help you.

RASA Tracker connection with SQL Server

Rasa Open Source

nik202 (NiK202) January 10, 2022, 9:52pm 2

@kandykane how you installed the rasa chatbot for the production server?

@kandykane please also see this thread meanwhile : How can I install MySQL in my rasa environment? - #4 by nik202

Topic		Replies	Views
Rasa SQL DB configuration Rasa Open Source	2	832	April 28, 2020
How to access stored bot conversation from tracker and also how to store that in SQL Server? Rasa Open Source	9	309	July 19, 2023
Save chat in MSSQL server Rasa Open Source	2	670	March 23, 2020
Save conversation sqlite Rasa Open Source	5	2076	November 8, 2019
Tracker Stores - What does it include? Rasa Open Source	4	1437	February 10, 2022

RASA Tracker connection with SQL Server

Related Topics