SOLVED: Connection Failure when trying to login.

[N-pie]

I am unable to login to any of the accounts (Admin included) on my local machine or on my phone using the Jellyfin app. I can select the server and see the login screen with the account names and images but when I click on one I get the following error:
Connection Failure. We're unable to connect to the selected server right now. Please ensure it is running and try again.

What is strange, however, is that Findroid works fine but only for the account I am currently logged in as. I can play video so the server is running, but I cannot log in as a different account.

I've had a bit of a look at the logs, and I'm no expert but it looks like something is wrong with the user authentication:

Code:

at Jellyfin.Api.Controllers.UserController.AuthenticateUserByName(AuthenticateUserByName request)
   at lambda_method396(Closure, Object)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
[2024-11-22 17:35:24.251 +00:00] [ERR] [19] Jellyfin.Api.Middleware.ExceptionMiddleware: Error processing request. URL "POST" "/Users/authenticatebyname".
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 8: 'attempt to write a readonly database'.
   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText, SqliteParameter[] parameters)

That would explain why the already logged in user on Findroid works but I cannot login elsewhere.

Unfortunately I don't know how to fix this issue. Any advice would be much appreciated.

Thanks

[TheDreadPirate]

Can you share your full jellyfin log via pastebin?

[N-pie]

Can you share your full jellyfin log via pastebin?

Unfortunately the file is too big for pastebin but I have uploaded it to google drive here:
https://drive.google.com/file/d/18bWaZEY...sp=sharing

If you want I can copy out specific smaller segments upon request and put them into a pastebin.

[TheDreadPirate]

Has Jellyfin crashed recently? Or did your disk fill up? The one with Jellyfin's DB? IMO, it looks like the database is corrupt.

[N-pie]

Has Jellyfin crashed recently? Or did your disk fill up? The one with Jellyfin's DB? IMO, it looks like the database is corrupt.

I haven't noticed any crashes, but it's possible it crashed and I missed it as the server auto-restarts weekly. As for space, there is nearly 200GB free on the server so it isn't full.

[TheDreadPirate]

How long has this been happening? If within the last three days (the default log retention), could you share ALL of the available log files?

[N-pie]

How long has this been happening? If within the last three days (the default log retention), could you share ALL of the available log files?

I haven't needed to log in for a bit, so I've only noticed it today but it looks like all the logs are pretty much the same.
I just decided to do a clean re-install and it's all working again.