Hello, I am running chirpstack on windows.
Postresql, Redis, MQTT, CGB, CNS - are started and the application server is closed after connecting to pg
Hi @A3M,
Could you provide us some more details to assist?
What are you seeing in the logs? (make sure you’re set to 4 - info at least for the app server).
time=“2020-12-07T21:21:50+03:00” level=fatal msg=“setip storage error: storage: applying PostreSQL data migrations error: pq: class operator “gin_trgm_ops” for method “gin” handling 0027_global_search.sql”
Ah, so that error is caused by the migrations the application server is attempting to run. Specifically 0027_global_search.sql which uses the gin_trgm_ops
method which isn’t installed on your database it appears. Did you follow the setup instructions including the postgres extensions creation?
https://www.chirpstack.io/application-server/install/debian/
-- enable the trigram and hstore extensions
\c chirpstack_as
create extension pg_trgm;
create extension hstore;
Oh, now I’ll try, I know for sure that I installed these methods, but I also deleted the database by creating a new one.
Thanks, the problem was this, I forgot that I was doing a new base for AS, and forgot to add it again.