Closed AzureDoom closed 6 months ago
Heyo, eeyup, I can reproduce this. I already have a suspicion where this is coming from, but need to check some things first.
The Path to the SQLite database, or rather the setting of the URL during boot, when no property was found, seems to be broken.
Great! I will keep an eye out for the next release!
I just started up now, but I still can't access it via my browser. https://gist.github.com/AzureDoom/acb1da47b8060a508c9244993ea2567d
Looks to be an SQL issue?
That's...very strange.
The property is set correctly
Set database path to: jdbc:sqlite:/root/ServerPackCreator/serverpackcreator.db
yet the webservice complains
2023-12-11T00:00:00,439 WARN [scheduling-1] (SqlExceptionHelper.java:137) - SQL Error: 1, SQLState: null
2023-12-11T00:00:00,440 ERROR [scheduling-1] (SqlExceptionHelper.java:142) - [SQLITE_ERROR] SQL error or missing database (no such table: server_pack_model)
Unless you've tried that already, could you delete the file at /root/ServerPackCreator/serverpackcreator.db
and try running ServerPackCreator again?
Just did that now, and same error. 1 important thing I do notice however, it's a 0 KB sized file
Hmm alright. Completely wiping the ServerPackCreator folder gives what looks to be no errors at startup (https://gist.github.com/AzureDoom/7bc92710f870c214f0f6936c262b185c) but still a 0KB file and I can't access the web panel, as it's giving
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
This problem can sometimes be caused by disabling or refusing to accept cookies.
but I do notice with Chrome I'm getting
redirected you too many times.
[Try deleting your cookies](https://support.google.com/chrome?p=rl_error&hl=en-US).
ERR_TOO_MANY_REDIRECTS
Hm, very strange. I had that exprience with older versions which didn't have the web-resources embedded in them. Are you using the JAR, or the dpkg-instalation?
.jar file itself, should I try the package version?
It shouldn't matter, really. The package points to a JAR, too. Only difference is that it ships its own JDK tailored to the needs of SPC. I assume this is the same machine affected by #484 ?
Correct
Whilst 5.1.6 now at least contains the web-resources to render the frontend, there seems to be more broken than I thought. I'm afraid this will take some time, sorry.
I need to rewrite the queueing system as a whole. While I am at it, I will remove the SQLite implementation and move to PostgreSQL, which was planned for milestone 6.
The queue system broke down because of version incompatibilities of Spring Boot and Artemis. SQLite also seems to throw a fit.
Just to give you heads up, you will require a PostgreSQL container/host if you still want to use the webservice.
That's alright! PostgreSQL isn't that hard to setup so I don't mind the extra step!
Small update: I am making progress towards the fix, or rather the general improvement of the webservice. However, I've run into a performance issue with PostgreSQL. It takes ages to store and retrieve the file BLOBS, so I need to find a solution here.
Ideally I'd like to store uploaded modpacks and generated server packs in the database, so data can easily be moved to another host by just moving the database. I'll probably end up writing some sort of FileSystemCache to store the files at, too. Only when the file is not found in the cache will it be retrieved from the database. Not sure yet.
Heyo AzureDoom,
the webservice fix, as well as general improvements, are coming along nicely.
The backend is almost done. Whilst I am at it, I'd like to know whether the following JSON would be considered helpful by you, and possibly BisectHosting, or whether you'd like it to include additional information etc. etc.
Feel free to DM me on Discord if you'd rather not disclose that here on GitHub.
Also, sha256
is a SHA256 hash of the uploaded modpack, and for the generated server pack respectively. Is this something you are interested in and if so, would you like to see any other hashes added?
Another question: Is a list of files in the modpack and/or server pack of interest to you?
/api/v2/modpacks/all
https://gist.github.com/Griefed/49fec8ff8bf7cd3f5999bf5e2bfdd918
What happened?
After doing the help command (as per #484) to get to the webserver startup, it's failing to start with
URL must start with
jdbc``What did you expect to happen?
Webserver would startup
Version
5.1.3
Relevant log output
Anything else you would like to add?
No response
If you are using the webservice, in which browers did you encounter this bug?
Firefox
Code of Conduct