Hi all,
I'm running a server for a week long online camp and I would like to grant all the students ability to fly and then add some other privs as we stress test the server. I have read through several discussions about needing to modify auth.txt after changing default_privs in the configuration file. Unfortunately I launched this server with auth.sqlite and do not know how to modify it and do not see any discussion on how to do so. I have about 85 users and I don't want to go through each using /grant <player> fly. Is there a batch procedure to achieve this?
Any help on this matter is greatly appreciated!
auth.sqlite and /auth_reload
- Festus1965
- Member
- Posts: 4181
- Joined: Sun Jan 03, 2016 11:58
- GitHub: Festus1965
- In-game: Festus1965 Thomas Thailand Explorer
- Location: Thailand ChiangMai
- Contact:
Re: auth.sqlite and /auth_reload
I guess the 85 times
/grant gamer fly noclip fast
is faster then wait for a help here,
but a sql could do it.
OR, you change the default settings, delete the auth, and let everyone login (first) time again, same name - should get there same builds, positions ,,, but the full privs
fly noclip and fly
as when you use also key auto-forward,
and let the gamer fly straight north from south pol, every gamer on own lane, about 200 nodes distance
they can let it go without interact,
and I am sure this mapgen from 80 people will be the hell for mapgen, maybe crash server
if later you do the same lines again after they are generated, the lag depends then only of reloading (mean need fast M.2 SSD) ...
have fun
more then 3 of this flying explorers are already quit a problem even on my fast hardware.
/grant gamer fly noclip fast
is faster then wait for a help here,
but a sql could do it.
OR, you change the default settings, delete the auth, and let everyone login (first) time again, same name - should get there same builds, positions ,,, but the full privs
fly noclip and fly
as when you use also key auto-forward,
and let the gamer fly straight north from south pol, every gamer on own lane, about 200 nodes distance
they can let it go without interact,
and I am sure this mapgen from 80 people will be the hell for mapgen, maybe crash server
if later you do the same lines again after they are generated, the lag depends then only of reloading (mean need fast M.2 SSD) ...
have fun
more then 3 of this flying explorers are already quit a problem even on my fast hardware.
Human has no future (climate change)
If urgend, you find me in Roblox (as CNXThomas)
If urgend, you find me in Roblox (as CNXThomas)
Re: auth.sqlite and /auth_reload
Even if you up the emerge threads? Cause isn't that the whole idea? If you got something like a 6 or 8 cores processor you can dedicate a fair number of threads just for mapgen?Festus1965 wrote: ↑Thu Jun 24, 2021 04:18and I am sure this mapgen from 80 people will be the hell for mapgen, maybe crash server
more then 3 of this flying explorers are already quit a problem even on my fast hardware.
- Festus1965
- Member
- Posts: 4181
- Joined: Sun Jan 03, 2016 11:58
- GitHub: Festus1965
- In-game: Festus1965 Thomas Thailand Explorer
- Location: Thailand ChiangMai
- Contact:
Re: auth.sqlite and /auth_reload
I can and do, I can 8 Threads, but as I have my terminal with also htop always open on my upper left side you can maybe use 2 mapgen threads for each 1 about 3.4 GHz virtual CPU, or 4 each real CPU ... there is always a limit.
MapGen goes easy over 50% of one of my threads, so at 16 mapgen active gamer I also will have problems from CPU time, ... but I am sure the lag is so high that that might not be possible ... guessing 4 to 8 mapgen gamer will freeze the game
Human has no future (climate change)
If urgend, you find me in Roblox (as CNXThomas)
If urgend, you find me in Roblox (as CNXThomas)
Re: auth.sqlite and /auth_reload
Festus1965 wrote: ↑Fri Jul 02, 2021 23:45there is always a limit.
MapGen goes easy over 50% of one of my threads, so at 16 mapgen active gamer I also will have problems from CPU time, ... but I am sure the lag is so high that that might not be possible ... guessing 4 to 8 mapgen gamer will freeze the game
Correct, that why you need to find a balance between cores' counts and core's performance. AMD Ryzen is known for good yields in this department, where you can up the cores' count while still getting quality single threads. Until you get to the ThreadRipper/Eypc range. Cause those have "too many" cores to be able to clock too high.
Re: auth.sqlite and /auth_reload
Maybe your camp is over but here you go, this works on a Linux system and you need to install the sqlite3 package that brings the sqlite3 command line program so I am assuming you know how to use the command line and that you have a Linux system available.wrraarr wrote: ↑Thu Jun 24, 2021 00:37Hi all,
I'm running a server for a week long online camp and I would like to grant all the students ability to fly and then add some other privs as we stress test the server. I have read through several discussions about needing to modify auth.txt after changing default_privs in the configuration file. Unfortunately I launched this server with auth.sqlite and do not know how to modify it and do not see any discussion on how to do so. I have about 85 users and I don't want to go through each using /grant <player> fly. Is there a batch procedure to achieve this?
Any help on this matter is greatly appreciated!
Copy this bash script code into a file and name it as you wish, make sure to make it executable with chmod:
Code: Select all
#! /bin/bash
players=$(expr $(sqlite3 auth.sqlite ".dump auth" | wc -l) - 4)
for id in {1..${players}}
do
cat sql_cmd | sed "s/id/$id/" | sqlite3 auth.sqlite
mv auth.sqlite.tmp auth.sqlite
done
Code: Select all
INSERT INTO user_privileges VALUES (id, "fly");
.save auth.sqlite.tmp
.quit
Done
Another way of doing this could be just enabling creative or if the player accounts are not yet created you could add fly to the default_privs setting on the configuration file of the server.
- Festus1965
- Member
- Posts: 4181
- Joined: Sun Jan 03, 2016 11:58
- GitHub: Festus1965
- In-game: Festus1965 Thomas Thailand Explorer
- Location: Thailand ChiangMai
- Contact:
Re: auth.sqlite and /auth_reload
You didn't get the point ... every CPU has somewhere earlier or later a limit.Mineminer wrote: ↑Sat Jul 03, 2021 00:25Correct, that why you need to find a balance between cores' counts and core's performance. AMD Ryzen is known for good yields in this department, where you can up the cores' count while still getting quality single threads. Until you get to the ThreadRipper/Eypc range. Cause those have "too many" cores to be able to clock too high.
And this discussion is also so far useless as most servers even have just 10-15 gamer... most don't need to have better CPU ... and further can't pay it, and just for 5 hours of 24 there might be the need of it.
Give me 20.000.000.000 US$ then I might order a Quantum ?? and a view good payed programmers to port mt to there ... haha
and even there we will face a limit some day ...
Human has no future (climate change)
If urgend, you find me in Roblox (as CNXThomas)
If urgend, you find me in Roblox (as CNXThomas)
- Linuxdirk
- Member
- Posts: 3216
- Joined: Wed Sep 17, 2014 11:21
- In-game: Linuxdirk
- Location: Germany
- Contact:
Re: auth.sqlite and /auth_reload
You could add a mod that grants every joining player the permissions you like. This won't do it directly in the database for all users at once, but using the Minetest API for all users when they join.
Who is online
Users browsing this forum: Google [Bot] and 5 guests