i have an error when i start the lora app server
i tried a lot to fix it but i can’t
plz help me to fix it
this screenshot is when i tap :" lora-app-server --config /etc/lora-app-server/lora-app-server.toml"
i have an error when i start the lora app server
i tried a lot to fix it but i can’t
plz help me to fix it
this screenshot is when i tap :" lora-app-server --config /etc/lora-app-server/lora-app-server.toml"
It looks like you didn’t initialize the database fully, see the complete example from the documentation:
-- set up the users and the passwords
-- (note that it is important to use single quotes and a semicolon at the end!)
create role chirpstack_as with login password 'dbpassword';
create role chirpstack_ns with login password 'dbpassword';
-- create the database for the servers
create database chirpstack_as with owner chirpstack_as;
create database chirpstack_ns with owner chirpstack_ns;
-- change to the ChirpStack Application Server database
\c chirpstack_as
-- enable the pq_trgm and hstore extensions
-- (this is needed to facilitate the search feature)
create extension pg_trgm;
-- (this is needed to store additional k/v meta-data)
create extension hstore;
-- exit psql
\q
https://www.chirpstack.io/guides/debian-ubuntu/#setup-postgresql-databases-and-users
thank you i fix it ;*