[ADMN/WEB] OKB3 - Bulletin Board Bridge - Now on BukkitDev! [1337]

Discussion in 'Inactive/Unsupported Plugins' started by Kalman Olah, Jun 2, 2011.

  1. Offline

    Kalman Olah

  2. Offline

    Kalman Olah

    Code:
        default:
                '2': default
                '14': Iron
                '15': Gold
                '16': Diamond
                '7': Moderator
                '6': Admin
                '13': Owner
    should be
    Code:
        default:
            '2': default
            '14': Iron
            '15': Gold
            '16': Diamond
            '7': Moderator
            '6': Admin
            '13': Owner
    You also didn't fill in "normal".

    @Waffletastic I need your full config with correct indenting. Use CODE tags. Also startup log.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
    McEvan likes this.
  3. Offline

    Waffletastic

    Well it just says connecting to mysql database in the startup and it works, and hold on ill get the config

    Code:
    general:
      mode: secure
      enable-whitelist: 'false'
      enable-nickname-syncing: 'false'
      enable-synced-banning: 'true'
      enable-promotion-track: 'true'
      enable-rank-changing: 'true'
      enable-post-count-rewarding: 'false'
      enable-anonymous-stat-tracking: 'true'
    modes:
      normal:
        user-table: user_table
        minecraft-login-name-field: minecraft_name
        rank-id-field: rank_group_field
        multitable:
          enable-multiple-tables: 'false'
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
      secure:
        forum: ipb
        type1:
          user-table: wafflesipboard_members
          username-field: name
          password-field: members_pass_hash
          rank-id-field: member_group_id
        type2:
          user-table: user_table
          username-field: username_field
          password-field: password_field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://yoursite.com/passgen.php
          password-set-in-config-inc-php: 12345pass
        type3:
          user-table: user_table
          rank-id-field: rank_group_field
          username-field: username_field
          password-field: password_field
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
        type4:
          user-table: user_table
          username-field: username_field
          password-field: password-field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://yoursite.com/passgen.php
          password-set-in-config-inc-php: 12345pass
    mysql-connection:
      mysql-host: wafflesipboard.db.8435687.hostedresource.com
      mysql-user: wafflesipboard
      mysql-password:*********
      mysql-database-name: wafflesipboard
    group-mapping:
      default:
        '1': ExampleGroup1
        '2': ExampleGroup2
      worlds:
        NoobWorld:
          '3': Default
    extras:
      whitelist:
        kick-message: This is the message a user will see if their group isn't whitelisted.
        use-as-blacklist: 'false'
        groups:
          '1': 'true'
          '2': 'false'
      nickname-syncing:
        nickname-field-in-usertable: nickname_field_user_table
      synced-banning:
        banned-user-forum-rank-id: '0'
        unbanned-user-forum-rank-id: '10'
        ban-message: This is the message a user will see if they are banned.
      promotion-track:
        track: 6|4|68|123|10
      rank-changing:
        identifiers:
          '1': NickNameforRank1
          '7': NickNameforAnotherRank
      post-count-rewarding:
        post-count-field-in-user-table: post-count-field-user-table
        currency-reward-per-post: '40'
    
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  4. Offline

    Kalman Olah

    That looks like it should work. If it doesn't, please make sure that your MySQL user has remote SELECT, UPDATE permissions.
     
  5. Offline

    Waffletastic

    How would I go about checking that?
     
  6. Offline

    Kalman Olah

    Your host's cPanel should have an option that lets you configure remote MySQL permissions.
    It could also be that your forum host does not allow remote MySQL. In that case, you're pretty much doomed.
     
  7. Offline

    Waffletastic

    I have phpmyadmin, is it somewhere in there?
     
  8. Offline

    Kalman Olah

    There could be a privileges tab where you can see all MySQL users. Make a new user there, and be sure to let him have access from ALL hosts, and to check the SELECT and UPDATE checkboxes.
     
  9. Offline

    Waffletastic

    Unfortunately, I can't find anything on permissions.

    How do I input my table names and fields? do they need _s with the mysql database name before them or something?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  10. Offline

    Kalman Olah

    What do you mean? You mean what table names you should put into the config? The full ones, exactly as they're listed in phpmyadmin.
     
  11. Offline

    Waffletastic

    Alright, so if it just lists the usertable as members, I don't put wafflesipboard_ before it?
     
  12. Offline

    Kalman Olah

    Exactly.
     
  13. Offline

    Waffletastic

    Do you have a skype, or teamspeak, so we could work this out? :)

    Oh and would the password field be members_pass_hash? Because it does not directly show me everyones password

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  14. Offline

    Kalman Olah

    Yeah, that's the one. It's an encrypted password.

    Code:
        type1:
          user-table: members
          username-field: name
          password-field: members_pass_hash
          rank-id-field: member_group_id
    That should work. If it doesn't, you have an issue somewhere else.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  15. Offline

    Waffletastic

    I have a feeling that my issue doesn't have to do with the config though, because it connects to mysql just fine, it's just that when I put in the plugin, the server stops responding.
     
  16. Offline

    Kalman Olah

    Strange. I went ahead and tested the plugin with a test setup for IPB, and it's working fine for me.
    My config:
    Code:
    general:
      mode: secure
      enable-whitelist: 'false'
      enable-nickname-syncing: 'false'
      enable-synced-banning: 'false'
      enable-promotion-track: 'false'
      enable-rank-changing: 'false'
      enable-post-count-rewarding: 'false'
      enable-anonymous-stat-tracking: 'true'
    modes:
      normal:
        user-table: mybb_users
        minecraft-login-name-field: username
        rank-id-field: usergroup
        multitable:
          enable-multiple-tables: 'false'
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
      secure:
        forum: ipb
        type1:
          user-table: dermembers
          username-field: name
          password-field: members_pass_hash
          rank-id-field: member_group_id
        type2:
          user-table: user_table
          username-field: username_field
          password-field: password_field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://yoursite.com/passgen.php
          password-set-in-config-inc-php: 12345pass
        type3:
          user-table: user_table
          rank-id-field: rank_group_field
          username-field: username_field
          password-field: password_field
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
        type4:
          user-table: user_table
          username-field: username_field
          password-field: password-field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://yoursite.com/passgen.php
          password-set-in-config-inc-php: 12345pass
    mysql-connection:
      mysql-host: **********************
      mysql-user: *********************
      mysql-password: **********************
      mysql-database-name: ******************
    group-mapping:
      default:
        '1': Admin
        '2': Moderator
      worlds:
        exampleworld1:
          '1': ExampleGroup1
          '2': ExampleGroup2
    extras:
      whitelist:
        kick-message: This is the message a user will see if their group isn't whitelisted.
        use-as-blacklist: 'false'
        groups:
          '1': 'true'
          '2': 'false'
      nickname-syncing:
        nickname-field-in-usertable: nickname_field_user_table
      synced-banning:
        banned-user-forum-rank-id: '0'
        unbanned-user-forum-rank-id: '10'
        ban-message: This is the message a user will see if they are banned.
      promotion-track:
        track: 6|4|68|123|10
      rank-changing:
        identifiers:
          '1': NickNameforRank1
          '7': NickNameforAnotherRank
      post-count-rewarding:
        post-count-field-in-user-table: post-count-field-user-table
        currency-reward-per-post: '40'
     
  17. Offline

    Waffletastic

    It appears that I can't edit the mysql user priveleges with godaddy.... sigh.

    And that's probably the issue, thanks for helping though. Might just have to switch where my mysql server is located.

    I guess I'll be changing where the mysql database is located.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  18. Offline

    McEvan

    Im confused what did you change ? Not sure if iam configuring this completely wrong or...

    general:
    mode: normal
    enable-whitelist: 'true'
    enable-nickname-syncing: 'false'
    enable-synced-banning: 'true'
    enable-promotion-track: 'false'
    enable-rank-changing: 'true'
    enable-post-count-rewarding: 'false'
    enable-anonymous-stat-tracking: 'true'
    modes:
    normal:
    user-table: vbulletin_users
    minecraft-login-name-field: minecraft_username
    rank-id-field: usergroup
    multitable:
    enable-multiple-tables: 'false'
    second-table: second_table
    user-id-field-in-user-table: user_id_field_user_table
    user-id-field-in-second-table: user_id_field_second_table
     
  19. Offline

    Kalman Olah

    I changed the indenting: How many spaces are on each lines, no tabs, etc...
     
  20. Offline

    NukemD

    I'm wanting to get this plugin to work on my server, but I'm using an older version of IPB (2.3.6) that stores the password hashes and salts in different tables and columns. I don't plan on upgrading IPB due to the high cost of a new license for 3.x, and porting the theme would be an extreme pain, so I was wondering if you could add some backwards compatibility.

    The plugin currently seems to think that everything is stored in ibf_members, but on IPB 2.3.6 (and probably most of the 2.x branch), the hashes and salts are stored in the table ibf_members_converge with the column names of converge_pass_hash and converge_pass_salt (instead of members_pass_hash and salt). Everything else though like member name is stored in ibf_members though.
     
  21. Offline

    Waffletastic

    Hey, since I can't get the privileges working, is it possible you could make a version of this that just looks into the mysql database to see if a user is registered, then promotes them based on that? That would be sooooo useful for me.
     
  22. Offline

    Kalman Olah

    That osuld also require remote SELECT privileges.
     
  23. Offline

    Waffletastic

    Wait wait wait, I just realised that it can't be that it can't edit the DB because I run IPB on the same mysql server, and it can edit it just fine, and create new tables and all kinds of things... I wonder why it freezes then.. Do you have a skype or ts3?

    Getting this error on 1317:

    17:53:34 [INFO] [NoCheat] version [2.1] is enabled.
    17:53:34 [INFO] [OKB3] Attempting to enable OKB3 v3.1.5 by Kalman Olah...
    17:53:34 [INFO] [OKB3] Initiating auto-update...
    17:53:34 [INFO] [OKB3] You already have the latest version of OKB3.
    17:53:34 [SEVERE] Error occurred while enabling OKB3 v3.1.5 (Is it up to date?):
    null
    java.lang.NullPointerException
    at me.kalmanolah.okb3.OKConfig.loadkeys(OKConfig.java:156)
    at me.kalmanolah.okb3.OKConfig.configCheck(OKConfig.java:33)
    at me.kalmanolah.okb3.OKConfig.<init>(OKConfig.java:18)
    at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:123)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:170)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:957)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:280)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
    at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154
    )
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:297)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:284)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:152)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    And on 1330 it just freezes.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  24. Offline

    Kalman Olah

    I already told you. You need 1330+ for it to work, and 1330+ works for literally everyone but you.
     
  25. Offline

    Vl4dmir

    Hey, is it possible to pull users from two different databases?
     
  26. Offline

    AlexBrahhh

    does anyone know a good website/forum thing where i could post my server
     
  27. Offline

    Kalman Olah

    No.
     
  28. Offline

    xXKebobXx

    Hey, jsut got this plugin working(took me about 4 hours becuase i needed to manually get my MYSQL hostname, and then finally figure out that i needed to add the serverhost of my mc server access remotely to the MySqL) but i finally got it. But i was wondering why this is happening when people join..

    Code:
    2011-10-15 16:34:01 [INFO] [OKB3] [SYNC] xXKebobXx's ranks successfully updated.
    2011-10-15 16:34:01 [WARNING] [OKB3] Error at SQL Query: Unknown column 'nickname_field_user_table' in 'field list'
    2011-10-15 16:34:01 [SEVERE] Exception in thread "Thread-24124"
    2011-10-15 16:34:01 [SEVERE] java.lang.NullPointerException
    2011-10-15 16:34:01 [SEVERE] at me.kalmanolah.okb3.OKFunctions.updateNick(OKFunctions.java:78)
    2011-10-15 16:34:01 [SEVERE] at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:124)
    2011-10-15 16:34:01 [SEVERE] at java.lang.Thread.run(Thread.java:722)



    I have nickname sync turned to false. and the part below that I have no idea what is going on. One more error..


    Code:
    2011-10-15 16:47:49 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'fsyncall' in plugin OKB3 v3.1.2
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:42)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    Caused by: java.lang.NullPointerException
        at me.kalmanolah.okb3.OKFunctions.updateNick(OKFunctions.java:78)
        at me.kalmanolah.okb3.OKFunctions.updateSecure(OKFunctions.java:233)
        at me.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:222)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        ... 12 more
    2011-10-15 16:47:52 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2011-10-15 16:47:55 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2011-10-15 16:47:58 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2011-10-15 16:48:00 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2011-10-15 16:48:02 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?


    So this happens when i do anytype of thing that will require a sync to the website and server. The server also is lagging horribly as you can see when this happens, which is odd because it is very rare that my server lags.

    I dont mean to be a pain but there one more thing. I was wondering why when epople signup on the website it dosnt automatically rank them up ingame. they need to sync themselves to the website every single time. I was wondering if this is supposed to be happening or if it is a feature that is needed to be put in to this plugin as it would be very great to have. Thanks
    Also im on bukkit RB 1240
     
  29. Offline

    Kalman Olah

    After a sync, usernames and encrypted passwords are stored, so sync happen automatically after that. Post your full config.yml please :).
     
  30. Offline

    Donny

    Code:
    2011-10-16 16:23:43 [INFO] [OKB3] Attempting to enable OKB3 v3.1.5 by Kalman Olah...
    2011-10-16 16:23:43 [INFO] [OKB3] Initiating auto-update...
    2011-10-16 16:23:44 [INFO] [OKB3] You already have the latest version of OKB3.
    2011-10-16 16:23:44 [SEVERE] Error occurred while enabling OKB3 v3.1.5 (Is it up to date?): null
    java.lang.NullPointerException
        at me.kalmanolah.okb3.OKConfig.readStringList(OKConfig.java:66)
        at me.kalmanolah.okb3.OKConfig.loadkeys(OKConfig.java:219)
        at me.kalmanolah.okb3.OKConfig.configCheck(OKConfig.java:33)
        at me.kalmanolah.okb3.OKConfig.<init>(OKConfig.java:18)
        at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:123)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:170)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:297)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:152)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    Using Pex version: 1.15
    CB: 1318


    I upgraded from OKB3 3.1.2, do I need to generate another config file?

    I see, need 1330+, nvm thank you.
     
  31. Offline

    Kalman Olah

    :)
     

Share This Page