Connecting to mysql using sqlalchemy

Rasa Open Source
1

I am storing an entity value in a database using custom actions and storing in mysql using sqlalchemy but getting error in rasa run actions

  File "C:\Users\AnshalK\PycharmProjects\rasax\rasax2\actions\sqlmy.py", line 6, in <module>
    import pymysql
ModuleNotFoundError: No module named 'pymysql'
  \

and in server running 
2022-05-30 12:05:01 INFO     root  - Rasa server is up and running.
2022-05-30 12:08:23 ERROR    rasa.core.actions.action  - Failed to run custom action 'action_email'. Couldn't connect to the server at 'http://localhost:5055/webho
ok'. Is the server running? Error: Cannot connect to host localhost:5055 ssl:default [Connect call failed ('127.0.0.1', 5055)]
2022-05-30 12:08:23 ERROR    rasa.core.processor  - Encountered an exception while running action 'action_email'.Bot will continue, but the actions events are lost
. Please check the logs of your action server for more information.
Traceback (most recent call last):
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\connector.py", line 936, in _wrap_create_connection
    return await self._loop.create_connection(*args, **kwargs)  # type: ignore  # noqa
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\asyncio\base_events.py", line 962, in create_connection
    raise exceptions[0]
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\asyncio\base_events.py", line 949, in create_connection
    await self.sock_connect(sock, address)
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\asyncio\selector_events.py", line 473, in sock_connect
    return await fut
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\asyncio\selector_events.py", line 503, in _sock_connect_cb
    raise OSError(err, f'Connect call failed {address}')
ConnectionRefusedError: [Errno 10061] Connect call failed ('127.0.0.1', 5055)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\rasa\core\actions\action.py", line 684, in run
    json=json_body, method="post", timeout=DEFAULT_REQUEST_TIMEOUT
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\rasa\utils\endpoints.py", line 151, in request
    **kwargs,
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\client.py", line 1012, in __aenter__
    self._resp = await self._coro
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\client.py", line 483, in _request
    timeout=real_timeout
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\connector.py", line 523, in connect
    proto = await self._create_connection(req, traces, timeout)
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\connector.py", line 859, in _create_connection
    req, traces, timeout)
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\connector.py", line 1004, in _create_direct_connection
    raise last_exc
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\connector.py", line 986, in _create_direct_connection
    req=req, client_error=client_error)
  File "c:\users\anshalk\appdata\local\programs\python\python37\lib\site-packages\aiohttp\connector.py", line 943, in _wrap_create_connection
    raise client_error(req.connection_key, exc) from exc
aiohttp.client_exceptions.ClientConnectorError: Cannot connect to host localhost:5055 ssl:default [Connect call failed ('127.0.0.1', 5055)]

During handling of the above exception, another exception occurred:

please help pymysql already installed

2

Are you running Rasa in a virtual environment? Did you install pymysql in that virtual environment?

3

Yes I am running it in virtual environment and pymysql is already installed connection is also working if i give the value explicitly but it is not being able to get the value from rasa action server it is not connecting the module to the action server @ChrisRahme