Jump to content

SQL use

Pending 2.0.9

is there a step by step tutorial available for sql so you can group sync permissions?
I have a few servers and have tried to use permissiongroupsync but get errors and support requests are not getting replies then i remembered i saw sqp mentioned on here,   is it possible to create a sql database and then populate it from permissions manager and then sync with other owned serverrs?
i have created a blank database,  just not sure what to do next or if its even possible with permissions manager,  until today i have been using local path,  but how to combine for other servers other than just overwriting that server?
thanks for any help
( still the best fee plugin available! )

 

Share this comment


Link to comment

Hi,
There's no automatic live synchronisation I.E. You can't change a permission/group on one server and automatically see that change on other servers,
but you can export your permissions, or groups, to local data file or SQL, then import that data in on your other server.

It's all handled in the `/perms data` menu in-game.

 


In the case of using local data file you do have to manually move that, like
Server A : Save to local file
copy /data/PermissionsManager.json to Server B
Server B : Load from local file

In the case of using SQL you just make sure both servers are connected with the same credentials (in config file) then
Server A : Save to SQL
Server B : Load from SQL.

If you're new to SQL + Rust plugins I'd probably just go with the data file option because less can go wrong.

When you do your save to local on the first server, I'd recommend taking a backup of that /data/PermissionsManager.json file.
No reason to expect problems but a backup never hurt anyone. 👍

Share this comment


Link to comment

Apologies to the OP, not trying to hijack your thread, but my question is basically the same, but could I clarify something steen?

I am looking to sync some perms across multiple servers. A SQL database is already set up and working, so I can easily add that to each servers config for this plugin. My question is, while saving permissions on one server, does this plugin load permissions automatically and if so when is that done, is it polled to auto update perms at a given time? Does it handle loading perms at all? Thanks.

  • Like 2

Share this comment


Link to comment

Hi @ZEODE
I think I covered it pretty well a few posts back? Go in to the /perms data menu and you'll see the options there.

You have the option to save permissions, or groups, or both, to SQL,
and the option to load the same from SQL.

Nothing about it is automated - You'd have to go in to the /perms data menu and tell it to save, or load.

 

Note if you're loading perms/groups from a backup, it doesn't wipe the server's existing groups + perms clean.
It just creates groups that exist in the backup and grants them the permissions from the backup, and/or grants permissions to players from the backup,

  • Like 1

Share this comment


Link to comment

Thanks for clarifying, I just wasn't sure if it would load/update perms dynamically. Now I realise, thanks.

  • Like 1

Share this comment


Link to comment
1.1m

Downloads

Total number of downloads.

5.7k

Customers

Total customers served.

81.9k

Files Sold

Total number of files sold.

1.6m

Payments Processed

Total payments processed.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.