Open Startouf opened 2 years ago
How to fix :
# postgresql.conf
shared_preload_libraries = 'pg_stat_statements'
Restart your DB server login to psql and create the extension (not sure if it had to be done on the admin db or the chatwoot db or both)
CREATE EXTENSION pg_stat_statements;
\c chatwoot_production
CREATE EXTENSION pg_stat_statements;
This should be added somewhere in the doc
@Startouf Thanks for reporting this. We will take a look and have it added to the documentation.
Had to do something similar for our setup. We actually needed pgcrypto
too
CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION pgcrypto;
As a sidenote: As part of the documentation, it'd be nice for administrators to know what these extensions are used for in the application if possible 😄
Describe the bug
Trying to setup a new chatwoot server, and running either db:chatwoot_prepare or db:schema:load
To Reproduce
My PG Setup
Expected behavior
A clear indication on what roles to give to chatwoot in the readme. Also, expecting chatwoot to get superadmin privilegies seems a bit excessive. Is there no other way to configure what you need ?
Screenshots
N/A
Browser logs
N/A
Server logs
N/A
Environment
Self hosted chatwoot, Linux VM deployment release/2.2.1
Desktop (please complete the following information):
Smartphone (please complete the following information): N/A
Additional context
Add any other context about the problem here.