Ubuntu Server Edition, I am introducing a new high performance data storage system to host the Manager data. I had a quick look and it appears that the process to change the Manager data location has been superseded by some other method now.
Could someone point me in the correct direction please?
Current Data location is the default ~/.local/share/Manager/
The About Manager option to change path no longer exists
Yep there appear to have been some changes but on the Ubuntu server side. Using Ubuntu 20.04.1 LTS. This is what I have done and it may help some other crew with Manager data relocation plans:
Since mono is gone what is the correct way to specify the NAS data location in the systemd service unit configuration file please? I have relocated Manager data from ~/.local/share/Manager/ to /media/network/nas01/Manager/
Now before we just entered the path switch before the port switch as shown in previous post.
If I edit this line to add the path as follows : ExecStart=/usr/share/manager-server/ManagerServer -path /media/network/nas01/Manager -port 8080
The following error results.
The Error:
Internal Error
20.9.77
/
SQLite.SQLiteException: database is locked
at SQLite.SQLiteCommand.ExecuteNonQuery()
at SQLite.SQLiteConnection.Execute(String query, Object args)
at SQLite.SQLiteConnection.Commit()
at Manager.ApplicationData.Process(String entityId, Action actions, String user, String description) in C:\projects\manager2\Manager\ApplicationData.cs:line 207
at Manager.ApplicationData.Process(String entityId, Object o, String user, String description) in C:\projects\manager2\Manager\ApplicationData.cs:line 147
at ManagerServer.HttpHandlers.Default.InnerPost() in C:\projects\manager2\ManagerServer\HttpHandlers\Default.cs:line 170
at ManagerServer.HttpHandlers.Template.Post() in C:\projects\manager2\ManagerServer\HttpHandlers\Template.cs:line 37
at ManagerServer.HttpHandlers.HttpHandler.ProcessRequest() in C:\projects\manager2\ManagerServer\HttpHandlers\HttpHandler.cs:line 50
If I remove the path switch and restart Manager all functions as normal again but of course have not achieved the data relocation as desired.
Updated to Ver 20.10.39 and the result is the same.
Just a little hello here I do not understand this Windows File structure going on here as reported by SQLite above.
This C:\projects\manager2\Manager\ApplicationData smells of Windows and we are 100% Linux based Desktops and Servers. Please what is going on as this file structure does not exist in our environment so if SQLite is looking for these locations on the Ubuntu Server host it will fail?
Manager Version 20.10.47
All linux permissions and NAS location are correct. Data transferred all healthy.
Currently all binaries are built on Windows-based build server. The Windows path you see is not relevant to your error.
Even though your permissions are correct, perhaps NAS is obtaining lock on these files. In other words, Manager is unable to write into Sqlite database on your NAS.
I have had another look at this and tested with other devices including a data location on a separate server share. All setup environments report similar locking. Not sure where to look next as the old mono version worked fine in the server data share environment. I also know I am a common denominator in all this.
Is there anyone who has this working successfully on any OS? Currently I am using Linux server version 21.1.4.
Is there a way to check in manager where it is currently looking for data, other than looking at data file time stamps?
This is not something I came across. Cloud edition is hosted on a cluster of Linux servers.
You can navigate to http://localhost:8080/path which will reveal application data folder. Change localhost:8080 for where your Manager Server is actually running at.
Fabulous way to find the data folder. Beautiful reveals //192.168.45.5/shared will test further now.
OK it showed me and confirmed locations as expected. Unfortunately with similar result “locking thing”.
By the way the error only comes up after logging in with correct credentials.
SQLite.SQLiteException: database is locked
at SQLite.SQLiteCommand.ExecuteNonQuery()
at SQLite.SQLiteConnection.Execute(String query, Object args)
at SQLite.SQLiteConnection.Commit()
at Manager.ApplicationData.Process(String entityId, Action actions, String user, String description) in C:\projects\manager\Manager\ApplicationData.cs:line 203
at Manager.ApplicationData.Process(String entityId, Object o, String user, String description) in C:\projects\manager\Manager\ApplicationData.cs:line 145
at ManagerServer.HttpHandlers.Default.InnerPost() in C:\projects\manager\ManagerServer\HttpHandlers\Default.cs:line 153
at ManagerServer.Startup.<>c.<b__1_1>d.MoveNext() in C:\projects\manager\ManagerServer\Startup.cs:line 87
— End of stack trace from previous location —
at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
I am able to relocate data anywhere on the local host no problem but the moment I off load elsewhere it fails.