Issue connecting with SQLITE DB in Rasa X

[rsklearner (Selvakumar Raj)]

Hi,

I created a simple Bot using Rasa in local virtual environment. My Bot basically gets the entity from user input and hits the Sqlite3 DB using it in “where clause” and pulls the response. The bot works fine in rasa shell.

So I created another virtual environment and installed Rasa X in it. Then copied the nlu, rules, stories, action, domain and config files from my previous environment and copied them into this new folder. Now when I launch the Rasa X, it gets open in Chrome and it works fine till finding intent and going to the respective action. But the part where it hits the DB is not working there.

Please find screenshot and comments from Rasa X

Corresponding Action code

Corresponding Data Pull Function

Please let me know what I’m doing wrong.

[nik202]

@rsklearner did you run the custom action in second terminal? can you share the logs of custom action please?

[ChrisRahme (Chris Rahmé)]

I understand it’s working with Rasa Shell and not Rasa X, right?

Rasa X has problems like this, where the message won’t display. This especially happens in actions with SQL queries.

[nik202]

@ChrisRahme but rasa have in build sqlite3 db

[rsklearner (Selvakumar Raj)]

@nik202 Yes, I ran the actions in second terminal and it did not throw any error.

[rsklearner (Selvakumar Raj)]

@ChrisRahme Oh…so it cannot be fixed? I thought the UI of Rasa X looks fancier than the shell interface and thought of using it. So in this case, we have to come up with our own UI?

[rsklearner (Selvakumar Raj)]

@ChrisRahme After your reply I browsed thru the community conversation and came across this one…

How to connect Rasa/X to db

Hello all and @akelad, I have two questions reading connecting Rasa to DBs:: I would like to store conversation logs in a db. I have Rasa and Rasa X implemented/deployed LOCALLY. I know Rasa X has postgresql db build in, can I use this locally? If so, how (could you please provide an example). I have a sql db holding client information (name, phone, etc), I would like to know how I can query this db through Rasa (or Rasa X), instance for authentication purpose? Could you please explain ho…

akelad has mentioned that querying a db from Rasa X is not supported locally and it has to be deployed in some server.

So I hope this is the solution.

[ChrisRahme (Chris Rahmé)]

@rsklearner

Oh…so it cannot be fixed?

Sadly no, I’ve had this problem since January when I started using Rasa and it’s still not fixed.

@rsklearner

So in this case, we have to come up with our own UI?

You will have to use your own UI in the end anyway, you cannot grant your users access to Rasa X and all its data

There are multiple frontends you can use:

• Chatbot Widget by Jitesh Gaikwad (web)
• WebApp by me (web)
• Webchat by Botfront (web)
• Chatroom by ScalableMinds (web)
• Rasa Android by Dishant Gandhi (mobile - Android)
• MobApp by me (mobile - Android)
• Rasataurants by BtLutz (mobile - iOS)
• Rasa iOS/Android by Shantanupat (React Native)

@rsklearner

akelad has mentioned that querying a db from Rasa X is not supported locally and it has to be deployed in some server.

Yes, the server version is more stable.