Not reading from SQL

[specialcoconut]

Hello all!

I'm just trying to spin up a small instance of resgrid for training/exercises in the emergency services space - I've managed to get the web ui up and running with all the required dependencies looking OK in theory :)

The issue I have now is the web ui appears to be writing to the database but not reading the database. (e.g. I can make a call and it appears in the SQL database, but once the call is created it then does not appear in the calls list)

Running on truenas scale ElectricEel-24.10.2.1 as a set of docker containers, using the supplied yml file for installation.

Below are the errors produced from the docker-web-1 log file.

Thanks in advance, and any assistance with this would be greatly appreciated.

{"EventId":6,"LogLevel":"Error","Category":"Microsoft.AspNetCore.Session.DistributedSession","Message":"Session cache read exception, Key:b7967ee8-6732-8d9c-bbc8-e18dd8fef502","Exception":"System.ArgumentNullException: Value cannot be null. (Parameter \u0027configuration\u0027) at StackExchange.Redis.ConfigurationOptions.DoParse(String configuration, Boolean ignoreUnknown) in //src/StackExchange.Redis/ConfigurationOptions.cs:line 649 at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.Connect() at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.GetAndRefresh(String key, Boolean getData) at Microsoft.AspNetCore.Session.DistributedSession.Load()","State":{"Message":"Session cache read exception, Key:b7967ee8-6732-8d9c-bbc8-e18dd8fef502","sessionKey":"b7967ee8-6732-8d9c-bbc8-e18dd8fef502","{OriginalFormat}":"Session cache read exception, Key:{sessionKey}"}}
{"EventId":6,"LogLevel":"Error","Category":"Microsoft.AspNetCore.Session.DistributedSession","Message":"Session cache read exception, Key:1fdea8c9-8837-f01c-0d01-a06fc51b18d8","Exception":"System.ArgumentNullException: Value cannot be null. (Parameter \u0027configuration\u0027) at StackExchange.Redis.ConfigurationOptions.DoParse(String configuration, Boolean ignoreUnknown) in //src/StackExchange.Redis/ConfigurationOptions.cs:line 649 at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.Connect() at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.GetAndRefresh(String key, Boolean getData) at Microsoft.AspNetCore.Session.DistributedSession.Load()","State":{"Message":"Session cache read exception, Key:1fdea8c9-8837-f01c-0d01-a06fc51b18d8","sessionKey":"1fdea8c9-8837-f01c-0d01-a06fc51b18d8","{OriginalFormat}":"Session cache read exception, Key:{sessionKey}"}}
{"EventId":6,"LogLevel":"Error","Category":"Microsoft.AspNetCore.Session.DistributedSession","Message":"Session cache read exception, Key:8ba048e1-2993-7461-d6b1-143f91123373","Exception":"System.ArgumentNullException: Value cannot be null. (Parameter \u0027configuration\u0027) at StackExchange.Redis.ConfigurationOptions.DoParse(String configuration, Boolean ignoreUnknown) in //src/StackExchange.Redis/ConfigurationOptions.cs:line 649 at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.Connect() at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.GetAndRefresh(String key, Boolean getData) at Microsoft.AspNetCore.Session.DistributedSession.Load()","State":{"Message":"Session cache read exception, Key:8ba048e1-2993-7461-d6b1-143f91123373","sessionKey":"8ba048e1-2993-7461-d6b1-143f91123373","{OriginalFormat}":"Session cache read exception, Key:{sessionKey}"}}
{"EventId":6,"LogLevel":"Error","Category":"Microsoft.AspNetCore.Session.DistributedSession","Message":"Session cache read exception, Key:dd4ab98d-608a-8db0-1668-09f8edea63d6","Exception":"System.ArgumentNullException: Value cannot be null. (Parameter \u0027configuration\u0027) at StackExchange.Redis.ConfigurationOptions.DoParse(String configuration, Boolean ignoreUnknown) in //src/StackExchange.Redis/ConfigurationOptions.cs:line 649 at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.Connect() at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.GetAndRefresh(String key, Boolean getData) at Microsoft.AspNetCore.Session.DistributedSession.Load()","State":{"Message":"Session cache read exception, Key:dd4ab98d-608a-8db0-1668-09f8edea63d6","sessionKey":"dd4ab98d-608a-8db0-1668-09f8edea63d6","{OriginalFormat}":"Session cache read exception, Key:{sessionKey}"}}
{"EventId":6,"LogLevel":"Error","Category":"Microsoft.AspNetCore.Session.DistributedSession","Message":"Session cache read exception, Key:a754bf70-adf1-b2dc-9700-ea2d34e759aa","Exception":"System.ArgumentNullException: Value cannot be null. (Parameter \u0027configuration\u0027) at StackExchange.Redis.ConfigurationOptions.DoParse(String configuration, Boolean ignoreUnknown) in /_/src/StackExchange.Redis/ConfigurationOptions.cs:line 649 at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.Connect() at Microsoft.Extensions.Caching.StackExchangeRedis.RedisCache.GetAndRefresh(String key, Boolean getData) at Microsoft.AspNetCore.Session.DistributedSession.Load()","State":{"Message":"Session cache read exception, Key:a754bf70-adf1-b2dc-9700-ea2d34e759aa","sessionKey":"a754bf70-adf1-b2dc-9700-ea2d34e759aa","{OriginalFormat}":"Session cache read exception, Key:{sessionKey}"}}

[ucswift]

So that looks like an issue reading from the Redis in memory cache. Is redis properly setup and running and the connection string correct for it?

[specialcoconut]

I believe redis is set up - to my knowledge at least which is admittedly lacking.

[INFO wait] --------------------------------------------------------
[INFO wait] Checking availability of host [redis:6379]
[INFO wait] Host [redis:6379] is now available!

Certainly there is an initial connection. Though admittedly that could be something basic like a ping.

Part of that is also Resgrid.Config: Setting Value for System.String RedisConnectionString

Only relevant environment variable I could find is
declare -x RESGRID__CacheConfig__RedisConnectionString="redis:6379,Password=,allowAdmin=True"

Can confirm that curl can hit redis:6379 and docker-redis-1:6379 with (52) empty reply from server which I assume is normal

Can run redis-cli inside docker-redis-1 and it connects and alleges 11 connected clients.

To be honest it's probably something really daft but any assistance would be appreciated. Totally fine with just a point in the right direction, not expecting you to sort out my entire life :)

[ucswift]

Then the Redis errors are probably unrelated to your issue. If do you anything else does it save and show? Like making a new unit/user or setting your status or staffing? It's possible that the web is having issues talking to the api used for some operations.

[ucswift]

Are you able to open up the dev tools on the browser and see if there are any errors there? Also the api container, see if there is anything there.