After setup of the webconsole,

[litebito]

Hi,

I completed the installation of the webconsole package following the instructions on linux.
After the installation, the first startup seems ok, until I login the webconsole via the browser the first time.
Immediately after logging in, I get a red banner at the bottom "An unhandled error has occurred. [Reload]"

When I check the linux console, I see the following:

MySQL connection successful.
Database tables do not exist. Creating database...
Installation script executed successfully.
Admin user added successfully.
Username: admin
Password: admin
Database tables created.
fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
      Unhandled exception in circuit 'fuN_aP5i0-m8qlbt8AWYUmTaE-pOJeB8Wo4PTTcg36o'.
      System.FormatException: The input string '' was not in a correct format.
         at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
         at System.Convert.ToInt32(String value)
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.Get_Charts_Data() in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 735
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.AfterInitializedAsync() in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 462
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.OnAfterRenderAsync(Boolean firstRender) in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 440
         at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)
fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
      Unhandled exception in circuit 'rYtwgfhVPDK37pRaiA1Rtu0Hl-vdkP7r5diJMOhee-0'.
      System.FormatException: The input string '' was not in a correct format.
         at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
         at System.Convert.ToInt32(String value)
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.Get_Charts_Data() in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 735
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.AfterInitializedAsync() in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 462
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.OnAfterRenderAsync(Boolean firstRender) in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 440
         at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)
fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
      Unhandled exception in circuit 'OyETg3XJzLeELMGX9qBn2XlLvR_wwEZqag9u-3hGjHY'.
      System.FormatException: The input string '' was not in a correct format.
         at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
         at System.Convert.ToInt32(String value)
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.Get_Charts_Data() in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 735
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.AfterInitializedAsync() in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 462
         at NetLock_RMM_Web_Console.Components.Pages.Dashboard.Dashboard.OnAfterRenderAsync(Boolean firstRender) in C:\Users\NicoMak\NetLock Root\NetLock-RMM-Web-Console\Components\Pages\Dashboard\Dashboard.razor:line 440
         at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle, ComponentState owningComponentState)
fail: Microsoft.AspNetCore.Components.Server.Circuits.RemoteNavigationManager[4]
      Navigation failed when changing the location to /dashboard
      System.Threading.Tasks.TaskCanceledException: A task was canceled.
         at Microsoft.JSInterop.JSRuntime.InvokeAsync[TValue](Int64 targetInstanceId, String identifier, Object[] args)
         at Microsoft.JSInterop.JSRuntimeExtensions.InvokeVoidAsync(IJSRuntime jsRuntime, String identifier, Object[] args)
         at Microsoft.AspNetCore.Components.Server.Circuits.RemoteNavigationManager.<>c__DisplayClass13_0.<<NavigateToCore>g__PerformNavigationAsync|0>d.MoveNext()
fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
      Unhandled exception in circuit 'fYwwU5X_y0w5BetcwSy-2zSnRjwf-IEM14wp_piOYFc'.
      System.Threading.Tasks.TaskCanceledException: A task was canceled.
         at Microsoft.JSInterop.JSRuntime.InvokeAsync[TValue](Int64 targetInstanceId, String identifier, Object[] args)
         at Microsoft.JSInterop.JSRuntimeExtensions.InvokeVoidAsync(IJSRuntime jsRuntime, String identifier, Object[] args)
         at Microsoft.AspNetCore.Components.Server.Circuits.RemoteNavigationManager.<>c__DisplayClass13_0.<<NavigateToCore>g__PerformNavigationAsync|0>d.MoveNext()

How can we resolve this?

[litebito]

Following our discussion on Discord, the used DB server and version are:

mysql -V
mysql  Ver 15.1 Distrib 10.5.27-MariaDB

[0x100001]

Here's a quick summary from Discord:

The issue arises when attempting to use MariaDB instead of MySQL. Currently, MariaDB is not officially supported by NetLock. I'll review the installation script to see if compatibility can be achieved without introducing additional issues down the line.