Configuring Postgresql

Rasa Open Source
1

Capture 1.1
Capture 1.11187×345 55.2 KB
Capture 1

Can’t able to configure postgresql database in RASA open source. How to configure a database. please someone elaborate with steps. Thank you.

2

hi :smiley: You can try this in your endpoint.yml?

tracker_store:
   type: SQL
   dialect: "postgresql"
   url: "host to database server"
   db: "name of database"
   username: "user to login"
   password: "123"
1 Like
3

Capture 2
Capture 21132×294 21.5 KB
I have tried the commands in endpoint. The server has been up but it showing the following error. Please look into it. Thank you

4

Did you remove this parte?

query:
  driver: my-driver
1 Like
5

Capture 2
Capture 21127×476 54.8 KB
I have removed the driver part but still can’t able to start the server. What I am missing? I have attached the screenshot, pls look into it. Thank You.

6

“Erro while attempting to bind address (‘0.0.0.0’,5005) …”

If the port in your rasa is already active(in use) in another program, you should use another port or kill the active process to make the port free.

To be honest, i think its running normally. This error is referencing the last try to up server :smiley: Check your database. Rasa create table named “events” if not…

you can kill the program running in 5005 port with the command

linux/mac: kill -9 $(lsof -t -i:5005)

i dont know how to do that in windows but i think you can fallow this steps: spring boot - Windows Kill Process By PORT Number - Stack Overflow

Try again to up rasa after the stop service running 5005 port

an alternative is try to run Rasa in a diferente port like

rasa run -m models --enable-api -p 5006 --endpoints endpoints.yml

Rasa default port is 5005 but with parameter -p 5006, its start on 5006 port

1 Like
7

@Vedha27 try this thread solution hope it will work: Rasa deployment to Google chat - #13 by nik202

1 Like
8

Capture 2
Capture 2962×223 8.83 KB
Hey Thanks man your method has worked and the server has been up. But I can’t able to store any specific information like I have mentioned it in the screenshot. What should be done to store specific input of the user?

9

Yeah man, It works but I can’t able to store specific input of any user messages. How can I save specific user Input.

10

Nice! :smiley:

In this case, i think you need to create a custom action to make database insert

look this topic, maybe can help you :blush:

11

Thanks man. I am looking into it. Will update you when I get any results and also Please help me if I get any error :slight_smile: