Is there a method to make a user account an admin from the host level?

[adamsewell]

I have a memos instance that is running on Proxmox in a container. I noticed today that my user is not an admin and it is the only user other than the demo account on the instance. Is there a way I can promote my user to an admin? Maybe by the sqlite db?

Thanks for any help!

[oslavq]

As far as I know, memos does not have a CLI with which you can modify users from the host

I just tried updating the sqlite database and setting a default user role to HOST and it totally worked, although I strongly advise you to back your database up before you do anything. I am assuming that you have some basic linux shell knowledge, I can explain further if you need to, just let me know. So, here is how to do this:

1. Make sure to stop the memos container
2. Install sqlite3 package on your system to manage the sqlite database: apt install sqlite3 if you are running a Debian-based distribution
3. cd ~/.memos to cd into your memos data directory (it is the directory used in the container installation guide)
4. sqlite3 memos_prod.db
5. .backup memos_backup.db;
6. SELECT * FROM user;
7. You should get an output like 1|1234|1234|NORMAL|test|ADMIN||test|longhash|| or multiple rows like this, find the line with your username (in the example above, username is test) and note the first number which is the ID of your user in the database (in the example above, ID for user test is 1)
   8. UPDATE user SET role='HOST' WHERE id=<user_id>;, instead of <user_id> you should put the number you got in the previous step, so the command will look like this: UPDATE user SET role='HOST' WHERE id=1;. Do not forget the semicolon in the end of the statement
8. Press Ctrl + D to exit sqlite shell
9. Start your memos container

Let me know if this helps

[adamsewell]

That helped a lot. Thank you very much!