Question: Add Additional Admin about opengist

[Aetherinox]

I don't know what is going on, but I found the opengist.db file, and it is almost impossible to edit. Docker is shut down just so the file wasn't in-use by chance.

Tried opening in DB Lite browser, and all it says is "unable to open database". Even set the file ownership to root as a last ditch measure to ensure security wasn't a problem, and it refuses to open. Which is how I normally edit the DBs, guess I'll try sqlite3

Yeah, sqlite3 doesn't work either. It complains about it being a read-only database, despite the permissions being set to ridiuclous levels.

I chmod 0755 to the entire folder with the DB, and then it complains that it just can't open the database.

Edit: I got it, but it was a royal pain. After I set the permissions and chown the entire folder to the user, it would not let me edit it using terminal's sqlite3, however, I could then go back into the DB Lite browser and make the changes that way. Makes no sense, but that was the most pain in the rear process I've ever had with a database. Not sure what is up with it. Never seen that before.

[Aetherinox]

lol, saw your reaction. No worries, I managed to get the admin added, my system for some reason just made it a god awful pain. I know it's not your fault.

Just something to do with however it's set up, and sqlite3.

A setting later might be great. I'd hate to do that again, but I know you're busy with stuff. I'm just happy the other issue with literal newlines being fixed.

[thomiceli]

Yeah this would be a good addition, for now it's simply UPDATE users SET is_admin = 1 WHERE id = ? in sqlite

[Aetherinox]

Ah, you mean manually editing the opengist .db file using sqlite. I assume opengist would need to be shut down and restarted before and after the edit.

Yeah, a feature like that would be awesome.

[thomiceli]

It doesn't need to be restarted actually

[thomiceli]

Actually i tried to open the database on a Windows machine (running WSL) and it was locked aswell, I will investigate but it's prob a library issue.
No issues on unix

[Aetherinox]

That's weird, I had the opposite. Windows worked right out of box, Linux was locked as read-only. I wanted to use sqlite3 through command-line since it's easier to just run a command, but the only way I could get it to work was downloading the appimage for the SQLite Database manager.