paulpierre / RasaGPT

💬 RasaGPT is the first headless LLM chatbot platform built on top of Rasa and Langchain. Built w/ Rasa, FastAPI, Langchain, LlamaIndex, SQLModel, pgvector, ngrok, telegram
https://rasagpt.dev
MIT License
2.36k stars 227 forks source link

password authentication failed for user "api" #36

Open resulraveendran opened 1 year ago

resulraveendran commented 1 year ago

2023-07-07 10:41:29.083 UTC [6134] STATEMENT:  SELECT organization.id, organization.uuid, organization.display_name, organization.namespace, organization.bot_url, organization.status, organization.created_at, organization.updated_at FROM organization WHERE organization.namespace = 'openai';
07/07/2023 16:15:15
2023-07-07 10:45:15.963 UTC [26] LOG:  checkpoint starting: time
07/07/2023 16:15:21
2023-07-07 10:45:21.386 UTC [26] LOG:  checkpoint complete: wrote 55 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.411 s, sync=0.006 s, total=5.424 s; sync files=42, longest=0.004 s, average=0.001 s; distance=157 kB, estimate=157 kB
07/07/2023 16:22:42
2023-07-07 10:52:42.014 UTC [7501] ERROR:  operator does not exist: character varying = integer at character 233
07/07/2023 16:22:42
2023-07-07 10:52:42.014 UTC [7501] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
07/07/2023 16:22:42
2023-07-07 10:52:42.014 UTC [7501] STATEMENT:  SELECT organization.id, organization.uuid, organization.display_name, organization.namespace, organization.bot_url, organization.status, organization.created_at, organization.updated_at 
07/07/2023 16:22:42
    FROM organization 
07/07/2023 16:22:42
    WHERE organization.status = 2
07/07/2023 17:07:02
2023-07-07 11:37:02.307 UTC [11304] FATAL:  password authentication failed for user "api"
07/07/2023 17:07:02
2023-07-07 11:37:02.307 UTC [11304] DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
07/07/2023 17:07:14
2023-07-07 11:37:14.658 UTC [11321] FATAL:  password authentication failed for user "api"
07/07/2023 17:07:14
2023-07-07 11:37:14.658 UTC [11321] DETAIL:  Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
07/07/2023 17:20:16
2023-07-07 11:50:16.619 UTC [26] LOG:  checkpoint starting: time
07/07/2023 17:20:16
2023-07-07 11:50:16.933 UTC [26] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.303 s, sync=0.003 s, total=0.314 s; sync files=4, longest=0.003 s, average=0.001 s; distance=0 kB, estimate=141 kB````

what is the reason for this error and how to resolve it
youyi1314 commented 10 months ago

update DB_* from .env before install