Skip to main content

📝 Admin Notes

Promoting a user to admin​

root@ludus:/opt/ludus# sqlite3 ludus.db
SQLite version 3.40.1 2022-12-28 14:03:47
Enter ".help" for usage hints.
sqlite> UPDATE user_objects set is_admin = 1 WHERE user_id = '<USER ID>';
sqlite> .exit
root@ludus:/opt/ludus# pveum user modify {{ username }}@pam --groups ludus_admins --append

Demoting a user from admin to regular user​

root@ludus:/opt/ludus# sqlite3 ludus.db
SQLite version 3.40.1 2022-12-28 14:03:47
Enter ".help" for usage hints.
sqlite> UPDATE user_objects set is_admin = 0 WHERE user_id = '<USER ID>';
sqlite> .exit
root@ludus:/opt/ludus# pveum user modify {{ username }}@pam --groups ludus_users

Forcing a range out of testing mode​

root@ludus:/opt/ludus# sqlite3 ludus.db
SQLite version 3.40.1 2022-12-28 14:03:47
Enter ".help" for usage hints.
sqlite> UPDATE range_objects set testing_enabled = 0 WHERE range_number = <RANGE NUMBER>;
sqlite> UPDATE range_objects set allowed_domains = '' WHERE range_number = <RANGE NUMBER>;
sqlite> UPDATE range_objects set allowed_ips = '' WHERE range_number = <RANGE NUMBER>;
sqlute> .exit