"Active gateways" issue in dashboard

miimote · April 14, 2021, 6:21pm

Hi,
As you can see in the attached screenshoot I’m having an issue with the dashboard. I’ve got two gateways; both are actives as seen in the map, but the gauge says that one of them is inactive.
Moreover “Device data rate usage” doesn’t reflects some messages with DR0.

My versions are
ii chirpstack-application-server 3.14.0 armhf
ii chirpstack-gateway-bridge 3.10.0 armhf
ii chirpstack-network-server 3.12.3 armhf

Thanks in advance

tunglt · June 3, 2021, 11:01am

We have the same problem in our production after moving to chirpstack-application-server 3.15
After digging in codes, we find a way to troubleshoot this issue:

github.com

brocaar/chirpstack-application-server/blob/2c2dd7ae86b94ddc811e7586ba2766fd22e82462/internal/storage/gateway.go#L594

    
      
          		return GatewayPing{}, nil, errors.Wrap(err, "get gateway ping rx for ping id error")
          	}
          
          
	return ping, rx, nil
          }
          
          
// GetGatewaysActiveInactive returns the active / inactive gateways.
          func GetGatewaysActiveInactive(ctx context.Context, db sqlx.Queryer, organizationID int64) (GatewaysActiveInactive, error) {
          	var out GatewaysActiveInactive
          	err := sqlx.Get(db, &out, `
          		with gateway_active_inactive as (
          			select
          				g.last_seen_at as last_seen_at,
          				make_interval(secs => coalesce(gp.stats_interval / 1000000000, 30)) * 1.5 as stats_interval
          			from
          				gateway g
          			left join gateway_profile gp
          				on g.gateway_profile_id = gp.gateway_profile_id
          			where
          				$1 = 0 or g.organization_id = $1
          		)

We find out that in our gateways table : all gateway items has gateway_profile_id column empty.
After setting this id to the good one, the dashboard works correctly.

clarizzamorales · June 6, 2022, 7:26pm

Where can I find this configuration? Thank you!

brocaar · June 13, 2022, 10:57am

Please create a gateway-profile and then assign it to your gateway (gateway configuration).