Database (MySQL) conncectivity for custom actions

varunsapre10 · February 3, 2020, 6:16pm

Hi @nitz Try installing rasa==1.6.1 and rasa-sdk==1.6.1.

nitz · February 6, 2020, 9:36am

hi @varunsapre10 i tried to install rasa sdk 1.6.1 some error appeared ERROR: rasa 1.6.0a1 has requirement rasa-sdk~=1.5.0, but you’ll have rasa-sdk 1.6.0 which is incompatible.

Bro help me with it tell me when u will be free, can we just fix this out ??

nitz · February 14, 2020, 7:14am

hey @Ujjwalsas9 can u share ur action.py file as i m working on that onle and getting the same issue

JiteshGaikwad · February 15, 2020, 1:33pm

hey @nitz, can you upgrade your rasa using the below command and check if you still face the same error:

pip install --upgrade rasa

JiteshGaikwad · February 15, 2020, 2:57pm

Hey @nitz, I have written the sample code to fetch data from MySQL DB into custom actions, you can get the code here:

Let me know if this helps you

nitz · February 17, 2020, 8:42am

ye sure will try it nd will let u know, thanks @JiteshGaikwad Btw this is my action.py file check it out once actions.py (1.1 KB)

zaidalvi · March 30, 2020, 10:57am

I have a problem. Everything works fine when I run my code on Rasa X. But when I try to implement it with my custom web app or Slack the database queries aren’t executing. Any ideas as to why this is happening?

zaidalvi · March 30, 2020, 11:01am

I am using @JiteshGaikwad Webapp to connect with my Rasa bot. I have the rest uncommented in my credentials file. The code is code working till my custom actions but not executing my sql queries

Prskriti · April 22, 2020, 8:52pm

Same here sql queries are not getting executed. @JiteshGaikwad Could u please help us out in this Action server is running but not getting queried data as response

JiteshGaikwad · April 23, 2020, 4:31am

@Prskriti, can you share the contents of action.py file.

Prskriti · April 23, 2020, 5:22am

Here are the contents of actions.py:

actions.py (727 Bytes)

JiteshGaikwad · April 23, 2020, 6:58am

hey @Prskriti, can you test this file and check whether you are able to get the result.

github.com

JiteshGaikwad/MoodBot/blob/master/dbConnect.py

# This is a simple module to fetch data from MySQL db.
# python -m pip install mysql-connector //run this command if you face import error
# references: https://www.w3schools.com/python/python_mysql_getstarted.asp

import mysql.connector
import traceback

def getData(query:str):
        """
         @query: sql query that needs to be executed.

         returns the data being executed in "List" format
        """

        try:

            # Setup the connection.
            # Pass your database details here
            mydb = mysql.connector.connect(
                host="localhost",

This file has been truncated. show original

Prskriti · April 23, 2020, 10:21am

I had tested dbConnect.py working and is giving desired output:

JiteshGaikwad · April 23, 2020, 11:00am

Can you check whether it’s printing the result of the below line in your actions.py file:

github.com

JiteshGaikwad/MoodBot/blob/2a885d88ef338445539c19be5628093a45dc99ca/actions.py#L33


def run(self, dispatcher: CollectingDispatcher,
        tracker: Tracker,
        domain: Dict[Text, Any]) -> List[Dict[Text, Any]]:


    # write the sql query here.
    query = "select * from customer"
    
    #pass the sql query to the getData method and store the results in `data` variable.
    data = getData(query)
    
    print("data: ",data)


    dispatcher.utter_message(text="Hello World!",json_message=data)


    return []

JiteshGaikwad · April 23, 2020, 11:02am

Also do check the value of client = tracker.get_slot('id') of your actions.py file.

zaidalvi · April 23, 2020, 5:59pm

I had the same issues. The elements were being returned as null but the data was present.

zaidalvi · April 23, 2020, 6:09pm

This might solve your problem: dispatcher.utter_message(text=f"data : {data}")

I hope @JiteshGaikwad can give us a better fix because this doesn’t print in a format

JiteshGaikwad · April 23, 2020, 6:29pm

@zaidalvi, can you just show me the output of data object

zaidalvi · April 23, 2020, 6:53pm

This is the output for the data object:

data: [(‘Taste of China / Huaxia Chinese Restaurant’,), (‘Mei Kong’,), (‘Desi Dera Restaurant’,), (‘Punj Vehra’,), (‘Lalqila Restaurant’,)]

JiteshGaikwad · April 24, 2020, 4:29am

hey @zaidalvi, check this stakoverflow solution, it may help you:

Topic		Replies	Views
Problem with Custom Action Rasa Open Source	14	1712	May 23, 2019
Error in custom actions Rasa Open Source	3	1999	October 4, 2018
Error using custom actions Rasa Open Source	3	1150	February 25, 2020
Error with Custom Actions Rasa Open Source	7	3022	August 17, 2021
Facing problem executing custom actions Rasa Open Source	30	12834	June 6, 2023

Database (MySQL) conncectivity for custom actions

Related topics