Solved PermissionsEx with MySql

Discussion in 'Spigot Plugin Help' started by dangerORclose, Jun 6, 2016.

?

DID THIS TUTORIAL WORKED AND HELPED YOU?

  1. Yes, Great

    1 vote(s)
    100.0%

  2. No, Bad

    0 vote(s)
    0.0%

  3. No, Other

    0 vote(s)
    0.0%
Thread Status:
Not open for further replies.
Page 1 of 2
  1. dangerORclose

    dangerORclose

    SOLVED - https://www.spigotmc.org/threads/permissionsex-with-mysql.153404/page-2#post-1644002

    Hello,
    I need help setting up PermissionsEx for MySql.
    I did try allready but it dienst synchronisate.
    What is want: every server other permissions (if possible), but same groups. So i do only need to promotie then on 1 server and it Will make then same rank on each server.
    Please do not post links to pex Wiki or bukkit or some Else. These dienst work, and are not like i want them to work as explained above.
    Thanks for all that helps me with this.

    dangerORclose
     
    #1 dangerORclose, Jun 6, 2016
    Last edited: Jun 11, 2016
  3. MiniDigger

    MiniDigger
    Supporter

    after decrypting what you wrote I think I know what you want:
    you can't to sync the groups a member has but not the permissions the group has.
    I am afraid that this is not possible. you can sync everything or nothing.
     
    #2 MiniDigger, Jun 6, 2016
  5. dangerORclose

    dangerORclose

    And how do i make it then sync it all?
     
    #3 dangerORclose, Jun 6, 2016
  7. MiniDigger

    MiniDigger
    Supporter

    #4 MiniDigger, Jun 6, 2016
  9. JustMaffie

    JustMaffie

    Ohh thx, now i know how pex mysql works, i was looking for it for a LONG LONG time
     
    #5 JustMaffie, Jun 6, 2016
  11. MiniDigger

    MiniDigger
    Supporter

    wow, you know that google is a thing, do you?
     
    #6 MiniDigger, Jun 6, 2016
  13. JustMaffie

    JustMaffie

    Ofc i know that, but i tried to fix it, but it didnt work, but now i know
     
    #7 JustMaffie, Jun 6, 2016
  15. dangerORclose

    dangerORclose

    Like i said, please do not redirect me to the wiki, this doenst work, and there is no explaination.
    This is my config.yml, and it doenst work.
    Also i have no idea what to do with these aliasses and what they really are meaned for.

    Code (Text):
    multiserver:
      use-netevents: true
    permissions:
      backend: sql
      backends:
        sql:
          uri: mysql://*****/*****
          user: *****
          password: *****
          aliases:
              permissions: hub_permissions
              permissions_inheritance: hub_inheritance
              permissions_entity: hub_entity
      debug: false
      allowOps: true
      user-add-groups-last: false
      log-players: false
      createUserRecords: false
      informplayers:
        changes: true
      basedir: plugins/PermissionsEx
    basedir: plugins/PermissionsEx
    updater: true
    alwaysUpdate: false
     
    #8 dangerORclose, Jun 6, 2016
  17. MiniDigger

    MiniDigger
    Supporter

    expain: doesn't work.
    about the aliases, you can leave them alone if you want to. They allow you to rename the tables pex is going to use.
     
    #9 MiniDigger, Jun 6, 2016
  19. dangerORclose

    dangerORclose

    Hi,
    The permissions and groups are now syncing.
    But how can i make it so when user1 is in server1 group Owner that user 2 automaticly becomes group Owner on server 2?
     
    #10 dangerORclose, Jun 6, 2016
  21. PasiiHelper

    PasiiHelper

    Config from Pex:

    Code (Text):
    permissions:
        backend: sql
        backends:
            sql:
                uri: mysql://localhost/databasename
                user: username
                password: password
     
    #11 PasiiHelper, Jun 6, 2016
  23. UElitez

    UElitez

    Once all of your servers are set up to use the same backend (sql), then just set the following command to run every minute or so on each server: /pex reload
    Something like this should work: http://dev.bukkit.org/bukkit-plugins/consolescheduler-reloaded/
     
    #12 UElitez, Jun 6, 2016
  25. dangerORclose

    dangerORclose

    Thanks, but that did not solved what i asked.
    Also i will set that up in multicraft as a task.

    My question was how that i can make it so when i set user1 in server 1 to group admin that he will be in group admin in server1, BUT ALSO in server2, server3, etc.
     
    #13 dangerORclose, Jun 6, 2016
  27. UElitez

    UElitez

    The user will have this rank across all servers as long as they all use the same permissions backend and the pex reload command is run on them.
     
    #14 UElitez, Jun 6, 2016
  29. ShakerLP

    ShakerLP

    I also have the problem with the same error
     
    #15 ShakerLP, Jun 6, 2016
  31. dangerORclose

    dangerORclose

    This doenst work for me.
    I see when i do /pex groups on the 2e server that the group is also there in the groups list. After i did pex reload.
    But when i add me to Test on hub then i do /pex reload I go to the 2e server i do also /pex reload, But then am i still on the default rank.
    I tested with it, and all that worls is that when i create a group the group is on all servers, when i add a perm it it also on all servers, But when i set the group to a user, then doenst it work. Im then test in the server where i added myself to it, and not on the 2e server, also not after /pex reload
     
    #16 dangerORclose, Jun 6, 2016
  33. Ammino

    Ammino

    Once you have configured your backend to sql with all the details, you need to type /pex backend sql in-game.
     
    #17 Ammino, Jun 6, 2016
  35. Ammino

    Ammino

    I don't see why any of that is even necessary? You don't know what you're talking about as you leave out crucial info.
     
    #18 Ammino, Jun 6, 2016
  37. UElitez

    UElitez

    As he already had the backend set to sql in the config, I assumed he had done this for all his servers, hence why I didn't tell him to do it again.
     
    #19 UElitez, Jun 6, 2016
  39. dangerORclose

    dangerORclose

    Yes, same config on all my servers.
     
    #20 dangerORclose, Jun 6, 2016
Page 1 of 2
Thread Status:
Not open for further replies.