Postgres permission problem

Setup and configuration
1

Hi All,

I am having problem while AppServer is trying to insert data to device_up. Gettin permission error like this: error="insert error: pq: permission denied for table device_up". I have followed the steps from documentation and add this:

    [application_server.integration.postgresql]

    dsn="postgres://chirpstack_as_events:*****@localhost/chirpstack_as_events?sslmode=disable"

    max_open_connections=0

    max_idle_connections=2

and

  [application_server.integration]
  # Enabled integrations.
  enabled=["mqtt","postgresql"]

to chirpstack-application-server.toml

Any ideas what could be wrong?

2

Probably the chirpstack_as_events user / role does not have ownership of the chirpstack_as_event database or device_up table :slight_smile:

This might be helpful: https://www.digitalocean.com/community/tutorials/how-to-use-roles-and-manage-grant-permissions-in-postgresql-on-a-vps--2.

4

All sorted… I didn’t restart the app_server after i granted the permissions before :sweat_smile: Thank you for the help!