Sep 22 15:32:47 ubuntu dotnet[4147723]: [15:32:47 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:47 ubuntu dotnet[4147723]: [15:32:47 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.4665ms Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:49 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:32:49 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:32:49 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:49 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 15:32:49 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:49 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:32:49 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 3.3038ms Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:49 ubuntu dotnet[4147723]: [15:32:49 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 3.7005ms Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:51 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:32:51 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:32:51 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:51 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 15:32:51 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:51 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:32:51 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.2086ms Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:51 ubuntu dotnet[4147723]: [15:32:51 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.629ms Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:54 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:32:54 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:32:54 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:54 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 15:32:54 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:54 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:32:54 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.5043ms Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:54 ubuntu dotnet[4147723]: [15:32:54 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.8995ms Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:56 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:32:56 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:32:56 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:56 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 15:32:56 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:56 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:32:56 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.1087ms Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.5485ms Sep 22 15:32:56 ubuntu dotnet[4147723]: [15:32:56 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:56 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:32:56 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:32:56 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:58 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:32:58 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:32:58 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:58 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 15:32:58 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:32:58 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:32:58 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.0883ms Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:32:58 ubuntu dotnet[4147723]: [15:32:58 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.4792ms Sep 22 15:32:59 ubuntu dotnet[4147723]: [15:32:59 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 22 15:32:59 ubuntu dotnet[4147723]: [15:32:59 INF] Executing endpoint '/hubs/device/negotiate' Sep 22 15:32:59 ubuntu dotnet[4147723]: [15:32:59 INF] Executed endpoint '/hubs/device/negotiate' Sep 22 15:32:59 ubuntu dotnet[4147723]: [15:32:59 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 0.6941ms Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=Neot1qQUSAvnyFyvELT0ZA - null null Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executing endpoint '/hubs/device' Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:33:00 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 22 15:33:00 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=S-FwSNd8QpmGsNE2lRawUA, IP=130.61.36.218 Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at S-FwSNd8QpmGsNE2lRawUA Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:33:00 ubuntu dotnet[4147723]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 22 15:33:00 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt", n0."Id", n0."ClassroomId", n0."CreatedAt", n0."DurationSeconds", n0."ExpiresAt", n0."Message", n0."Priority", n0."SenderName", n0."SenderUserId", n0."Shake", n0."TenantId", n0."Title", n0."Voice" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 22 15:33:00 ubuntu dotnet[4147723]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 22 15:33:00 ubuntu dotnet[4147723]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (0ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:00 ubuntu dotnet[4147723]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 22 15:33:00 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/schooladmin/devices - null null Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executing endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Route matched with {action = "GetDevices", controller = "SchoolAdmin"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDevices() on controller ClassNotify.Server.Controllers.SchoolAdminController (ClassNotify.Server). Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (1ms) [Parameters=[@__tenantId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:33:00 ubuntu dotnet[4147723]: WHERE d."TenantId" = @__tenantId_0 Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT t."Id", t."CreatedAt", t."IsActive", t."Name" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "Tenants" AS t Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:00 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:33:00 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executing OkObjectResult, writing value of type 'System.Collections.Generic.List`1[[ClassNotify.Shared.Models.DeviceAdminDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed action ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server) in 2.2042ms Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Executed endpoint 'ClassNotify.Server.Controllers.SchoolAdminController.GetDevices (ClassNotify.Server)' Sep 22 15:33:00 ubuntu dotnet[4147723]: [15:33:00 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/schooladmin/devices - 200 null application/json; charset=utf-8 2.5986ms Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/api/device-command/send - application/json 75 Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Route matched with {action = "SendCommand", controller = "DeviceCommand"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SendCommand(ClassNotify.Server.Controllers.SendDeviceCommandRequest) on controller ClassNotify.Server.Controllers.DeviceCommandController (ClassNotify.Server). Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:01 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:33:01 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:33:01 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 Sep 22 15:33:01 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executed DbCommand (2ms) [Parameters=[@p0='?', @p1='?', @p2='?' (DbType = DateTime), @p3='?' (DbType = DateTime), @p4='?', @p5='?', @p6='?' (DbType = Int64), @p7='?' (DbType = DateTime), @p8='?', @p9='?' (DbType = Int32), @p10='?', @p11='?' (DbType = DateTime), @p12='?', @p13='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:01 ubuntu dotnet[4147723]: INSERT INTO "DeviceCommands" ("Id", "CommandType", "CompletedAt", "CreatedAt", "CreatedBy", "DeviceId", "DurationMs", "ExpiresAt", "Parameters", "ResultCode", "ResultMessage", "StartedAt", "Status", "TenantId") Sep 22 15:33:01 ubuntu dotnet[4147723]: VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Created remote command cmd_ea7d508ae750465182905beeb31e1430 (RestartClient) for Device dev_59e35e79 (Tenant t_beijing_no4, TTL 2m) by 鍖椾含鍥涗腑绠＄悊鍛?Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:01 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:01 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:01 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 15:33:01 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executed DbCommand (1ms) [Parameters=[@p1='?', @p0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:01 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "Status" = @p0 Sep 22 15:33:01 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Dispatched command cmd_ea7d508ae750465182905beeb31e1430 (RestartClient) to device dev_59e35e79 via SignalR S-FwSNd8QpmGsNE2lRawUA Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executing OkObjectResult, writing value of type '<>f__AnonymousType4`4[[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[ClassNotify.Shared.Models.DeviceCommandDto, ClassNotify.Shared, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[System.Boolean, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.String, System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server) in 276.5126ms Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.SendCommand (ClassNotify.Server)' Sep 22 15:33:01 ubuntu dotnet[4147723]: [15:33:01 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/api/device-command/send - 200 null application/json; charset=utf-8 276.9361ms Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/device-command/cmd_ea7d508ae750465182905beeb31e1430 - null null Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Executing endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server)' Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Route matched with {action = "GetCommand", controller = "DeviceCommand"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetCommand(System.String) on controller ClassNotify.Server.Controllers.DeviceCommandController (ClassNotify.Server). Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Executed DbCommand (1ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:03 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:03 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:03 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 15:33:03 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Executing OkObjectResult, writing value of type 'ClassNotify.Shared.Models.DeviceCommandDto'. Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Executed action ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server) in 1.4383ms Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Executed endpoint 'ClassNotify.Server.Controllers.DeviceCommandController.GetCommand (ClassNotify.Server)' Sep 22 15:33:03 ubuntu dotnet[4147723]: [15:33:03 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/device-command/cmd_ea7d508ae750465182905beeb31e1430 - 200 null application/json; charset=utf-8 1.8462ms Sep 22 15:33:06 ubuntu dotnet[4147723]: [15:33:06 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:06 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:06 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:06 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched') Sep 22 15:33:08 ubuntu dotnet[4147723]: [15:33:08 INF] Request starting HTTP/1.1 POST http://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - null 0 Sep 22 15:33:08 ubuntu dotnet[4147723]: [15:33:08 INF] Executing endpoint '/hubs/device/negotiate' Sep 22 15:33:08 ubuntu dotnet[4147723]: [15:33:08 INF] Executed endpoint '/hubs/device/negotiate' Sep 22 15:33:08 ubuntu dotnet[4147723]: [15:33:08 INF] Request finished HTTP/1.1 POST https://classnotify.paradise.eu.org/hubs/device/negotiate?negotiateVersion=1 - 200 316 application/json 0.3083ms Sep 22 15:33:08 ubuntu dotnet[4147723]: [15:33:08 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/hubs/device?id=2XcHxjqkfGzR7U_1apAfsQ - null null Sep 22 15:33:08 ubuntu dotnet[4147723]: [15:33:08 INF] Executing endpoint '/hubs/device' Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?', @__tokenHash_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE d."Id" = @__deviceId_0 AND d."DeviceTokenHash" = @__tokenHash_1 AND d."IsActive" Sep 22 15:33:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Replacing previous ConnectionId S-FwSNd8QpmGsNE2lRawUA with IVvyvWUO2IT9LVsRcRtb9A for Device dev_59e35e79 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Device dev_59e35e79 connected via SignalR. ConnectionId=IVvyvWUO2IT9LVsRcRtb9A, IP=130.61.36.218 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Removed replaced connection S-FwSNd8QpmGsNE2lRawUA from class group t:t_beijing_no4:c:cls_802; current connection is IVvyvWUO2IT9LVsRcRtb9A Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Device dev_59e35e79 authenticated successfully. Joined group t:t_beijing_no4:c:cls_802 at IVvyvWUO2IT9LVsRcRtb9A Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (0ms) [Parameters=[@__tenantId_0='?', @__classId_1='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT c."TenantId", c."Id", c."CreatedAt", c."DisplayName", c."Grade", c."RoomNumber" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "Classrooms" AS c Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE c."TenantId" = @__tenantId_0 AND c."Id" = @__classId_1 Sep 22 15:33:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (1ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT n."Id", n."AcknowledgedAt", n."DeviceId", n."DeviceReceivedAt", n."DisplayedAt", n."FailedAt", n."FailureReason", n."NotificationId", n."Status", n."UpdatedAt", n0."Id", n0."ClassroomId", n0."CreatedAt", n0."DurationSeconds", n0."ExpiresAt", n0."Message", n0."Priority", n0."SenderName", n0."SenderUserId", n0."Shake", n0."TenantId", n0."Title", n0."Voice" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "NotificationReceipts" AS n Sep 22 15:33:09 ubuntu dotnet[4147723]: INNER JOIN "Notifications" AS n0 ON n."NotificationId" = n0."Id" Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE n."DeviceId" = @__deviceId_0 AND n."Status" = 'Sent' Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (0ms) [Parameters=[@__deviceId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE d."DeviceId" = @__deviceId_0 AND d."Status" IN ('Pending', 'Dispatched') Sep 22 15:33:09 ubuntu dotnet[4147723]: ORDER BY d."CreatedAt" Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Device dev_59e35e79 connected with 1 pending command(s) to catch up. Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (0ms) [Parameters=[@__commandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE d."Id" = @__commandId_0 Sep 22 15:33:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (1ms) [Parameters=[@__p_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT d."Id", d."ClassroomId", d."CreatedAt", d."DeviceTokenHash", d."Hostname", d."InstallationId", d."IsActive", d."LastHeartbeatAt", d."RawDeviceToken", d."TenantId" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "Devices" AS d Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE d."Id" = @__p_0 Sep 22 15:33:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (2ms) [Parameters=[@p1='?', @p0='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: UPDATE "Devices" SET "LastHeartbeatAt" = @p0 Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE "Id" = @p1; Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (0ms) [Parameters=[@__result_CommandId_0='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:09 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE d."Id" = @__result_CommandId_0 Sep 22 15:33:09 ubuntu dotnet[4147723]: LIMIT 1 Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Executed DbCommand (2ms) [Parameters=[@p6='?', @p0='?' (DbType = DateTime), @p1='?' (DbType = Int64), @p2='?' (DbType = Int32), @p3='?', @p4='?' (DbType = DateTime), @p5='?'], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:09 ubuntu dotnet[4147723]: UPDATE "DeviceCommands" SET "CompletedAt" = @p0, "DurationMs" = @p1, "ResultCode" = @p2, "ResultMessage" = @p3, "StartedAt" = @p4, "Status" = @p5 Sep 22 15:33:09 ubuntu dotnet[4147723]: WHERE "Id" = @p6; Sep 22 15:33:09 ubuntu dotnet[4147723]: [15:33:09 INF] Recorded execution result for Command cmd_ea7d508ae750465182905beeb31e1430 (Device dev_59e35e79): Status=Succeeded, ResultCode=0, Duration=376ms Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Executing endpoint 'HTTP: GET /api/health' Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:10 ubuntu dotnet[4147723]: SELECT 1 Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Setting HTTP status code 200. Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Executed endpoint 'HTTP: GET /api/health' Sep 22 15:33:10 ubuntu dotnet[4147723]: [15:33:10 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 12.8109ms Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Request starting HTTP/1.1 GET http://classnotify.paradise.eu.org/api/health - null null Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Executing endpoint 'HTTP: GET /api/health' Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:12 ubuntu dotnet[4147723]: SELECT 1 Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Setting HTTP status code 200. Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Writing value of type '<>f__AnonymousType28`6' as Json. Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Executed endpoint 'HTTP: GET /api/health' Sep 22 15:33:12 ubuntu dotnet[4147723]: [15:33:12 INF] Request finished HTTP/1.1 GET https://classnotify.paradise.eu.org/api/health - 200 null application/json; charset=utf-8 13.0519ms Sep 22 15:33:16 ubuntu dotnet[4147723]: [15:33:16 INF] Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] Sep 22 15:33:16 ubuntu dotnet[4147723]: SELECT d."Id", d."CommandType", d."CompletedAt", d."CreatedAt", d."CreatedBy", d."DeviceId", d."DurationMs", d."ExpiresAt", d."Parameters", d."ResultCode", d."ResultMessage", d."StartedAt", d."Status", d."TenantId" Sep 22 15:33:16 ubuntu dotnet[4147723]: FROM "DeviceCommands" AS d Sep 22 15:33:16 ubuntu dotnet[4147723]: WHERE d."Status" IN ('Pending', 'Dispatched')