[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

    LibertasMens

    K, wasn't totally sure. :)

    That's what I was askin' about earlier. It's currently using varchars. Should I try tinyint or int?
     
  3. Offline

    Kalman Olah

    This shouldn't matter. I suppose if you're using promote/demote it should be INT, but for regular syncs it only fetches the number, so it should work.
     
  4. Offline

    LibertasMens

    Hmmm. And this is the exact error I was getting with Warrant.
     
  5. Offline

    Deadlystrike

    CB: 1000
    OKB 2.5.7
    Code:
    15:04:37 [INFO] [OKB3] Attempting to enable OKB3 v2.5.7 by Kalman Olah...
    15:04:37 [INFO] [OKB3] Initiating auto-update...
    15:04:37 [INFO] [OKB3] You already have the latest version of OKB3.
    15:04:37 [INFO] [OKB3] Hooked into permissions plugin.
    15:04:37 [INFO] [OKB3] Attempting to load configuration file...
    15:04:37 [INFO] [OKB3] Configuration file successfully loaded.
    15:04:37 [INFO] [OKB3] [DB] Initializing MySQL connection...
    15:04:37 [SEVERE] Error occurred while enabling OKB3 v2.5.7 (Is it up to date?):
     null
    java.lang.NumberFormatException: null
            at java.lang.Integer.parseInt(Unknown Source)
            at java.lang.Integer.parseInt(Unknown Source)
            at me.kalmanolah.okb3.OKDatabase.initialize(OKDatabase.java:34)
            at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:161)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:878)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:272)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146
    )
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    15:04:37 [INFO] over9000homes is ready.
    15:04:37 [INFO] [PersonalChest] version 0.7 loading...
    15:04:37 [INFO] [PersonalChest] version 0.7 is enabled with permissions!
    15:04:37 [INFO] [RainBucket]: V0.5 is enabled without permissions!
    15:04:37 [INFO] [ScheduledAnnouncer] Connected to Permissions.
    15:04:37 [INFO] ScheduledAnnouncer v1.6.3 is enabled!
    
    15:04:37 [INFO] SimpleGodMode is enabled now.
    15:04:37 [INFO] TNTWarner version 1.1 is enabled!
    15:04:37 [INFO] TravelPortals version 1.5 is enabled!
    15:04:37 [INFO] WheatHeal Enabled
    15:04:37 [INFO] WirelessRedstone: WirelessRedstone version 1.1 alpha is loading.
    ..
    15:04:37 [INFO] WirelessRedstone: Detected Permissions version 3.1.6
    15:04:37 [INFO] WirelessRedstone: Registering Events...
    15:04:37 [INFO] WirelessRedstone version 1.1 alpha is enabled!
    15:04:37 [INFO] WorldEdit 4.6 enabled.
    15:04:37 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin
     for permissions.
    15:04:38 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugi
    n for permissions.
    15:04:38 [INFO] WorldGuard: (world) Single session is enforced.
    15:04:38 [INFO] WorldGuard: (world) TNT ignition is PERMITTED.
    15:04:38 [INFO] WorldGuard: (world) Lighters are blocked.
     
  6. Offline

    Kalman Olah

    Config.yml.
     
  7. Offline

    Deadlystrike

    Code:
    mode: normal
    mysql-connection-info:
        mysql-host: www.gamingmadeeasy.com:3306
        mysql-user: gaming17_ranks
        mysql-password: *****
        mysql-database-name: gaming17_ipb
    old-school-mode:
        usertable: user_table
        minecraftname-field: mine_user
        rank-field: rank_field
        enable-multiple-tables: 'false'
        multitable:
            secondtable: mine_table
            useridfield-in-secondtable: user_id_field
            useridfield-in-usertable: user_id_field
    normal-mode:
        forum: ipb
        type1:
            usertable: members
            username-field: name
            userpassword-field: members_pass_hash
            rank-field: member_group_id
        type2:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
        type3:
            usertable: user_table
            rank-field: rank_field
            username-field: username_field
            password-field: pass_field
            secondtable: second_table
            useridfield-in-usertable: user_id_field
            useridfield-in-secondtable: user_id_field
        type4:
            usertable: user_table
            username-field: username
            password-field: mine_user
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
    world-groups:
        enable-multiworld-groups: 'true'
        world:
            groups:
                '2': Guest
                '3': Member
                '4': Administrator
                '6': Moderator
                '7': Developer
                '8': Premium
        flatlands:
            groups:
                '2': Guest
                '3': Member
                '4': Administrator
                '6': Moderator
                '7': Developer
                '8': Premium
        world_nether:
            groups:
                '2': Guest
                '3': Member
                '4': Administrator
                '6': Moderator
                '7': Developer
                '8': Premium
        world_skylands:
            groups:
                '2': Guest
                '3': Member
                '4': Administrator
                '6': Moderator
                '7': Developer
                '8': Premium
    whitelist:
        enable-whitelist: 'false'
        global:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: This is the message a player will see if they get banned.
    promotion-tracks:
        '1': '3'
        '2': '5'
        '3': '16'
    forum-ranks:
        Admin: '1'
        Registered: '0'
        Moderator: '2'
    
     
  8. Offline

    LibertasMens

    My server's suggestion is:
    PHP:
    SELECT FROM  `minecraft_usersWHERE  `toon` =  'LibertasMens'
    Is that pretty much what your plugin queries?

    :D I figured it out!!!!!! For some reason, somewhere along the line, one of the programs didn't like the word "group". Changed it to "rank", works now!!!

    EDIT: Except for the fact that it's not actually changing any ranks. :) lol
    It's definitely connecting tho, and it says
    Code:
    OKB3] [BRIDGE] LibertasMens's ranks synced.
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
  9. Offline

    Kalman Olah

    If it's saying this:
    Code:
    OKB3] [BRIDGE] LibertasMens's ranks synced.
    It means it sent Permissions the command to change LibertasMens' rank to the one matching the rank ID in the config.yml. Some possible issues could be:
    -You don't have a groups.yml in the plugins/Permissions/<worldname>/ folder.
    - You don't have a Permissions group mapped to the RANK ID in config.yml.
    - You are using MySQL storage for Permissions, which doesn't work with OKB3 for some reason.
    Please make sure that the group mapped to the rank ID of your user(LibertasMens) actually exists in the groups.yml of the world he's in. These names are case sensitive.
    If it still doesn't work, post your config.yml, the groups.yml from your plugins/Permissions/<worldname> folder, the users.yml from your plugins/Permissions/<worldname> folder, and a screencap of the "rank" field for user LibertasMens in PHPMyAdmin or something. This can be done through PM. Sorry about all of the info I'm asking of you, but I've recently discovered that people tend to leave out critical details because they think them unimportant.

    Add this to the bottom of your config.yml:
    Code:
    misc:
        mysql-ping-interval: '20'
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
  10. Offline

    LibertasMens

    Alright, all problems solved. Lovin' the plugin!!
     
  11. Offline

    Kalman Olah

    Awesome :).

    Version 2.5.8

    • Fixed a bug that caused OKB3 to break if you were using the Permissions support thingy with PermissionsEx. Thanks to @Asphodan .
    • Drank a bottle of Coke regular. It was good.

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

    WNxRev

    This plugin has really taken off since day one. I like how you keep updating it and haven't abandoned it. Good work, keep it up. :)
     
  13. Offline

    Kalman Olah

    Thanks bro, I do my best to help any of my plugin users out, both by supporting and updating. When I have the time :p.
     
  14. Offline

    Deadlystrike

    So apperently my webhost is kinda sucky when it comes to remote sql:( i thank you for your ping feature but would it be possible to make it so that IF
    it loosed connection "closed by driver"
    1: it wont spam console "ps its not crashing any more thanks!!!!"
    2: upon the next time your plugin would normaly sync somone or is being forced to sync it will quickly try to re establish connection as it would upon loadup?

    Thanks man sorry for the sucky webhost

    PS: i am chatting with my webhost support atm if u need me to findout somthing i can
    Edit: webhost said i shouldnt be geting disconected if we are pinging like that they are looking into it!
    Still if you would consider that backup system incase of drop i would apprecate it
     
  15. Offline

    Kalman Olah

    You can tell them that, by default, the following SQL query is executed every twenty seconds, to keep the connection alive:
    PHP:
    "SELECT 1 FROM DUAL"
    I'll look into it when I add customizable messages tomorrow :).
     
  16. Offline

    bocaj812

    Have you had the chance to take a look at permissionsbukkit yet?
     
  17. Offline

    Kalman Olah

    Completely forgot about that, sorry. I'll take a look at it tomorrow, though. Hoping it won't be too much of a pain to add support.
     
  18. Offline

    bocaj812

    Shouldn't be pretty similar setup, and syntax however groups and users are contained within the same file, but I don't think okb3 would be affected by that...
     
  19. Offline

    darkcloud784

    Code:
    2011-07-27 08:22:29 [INFO] [OKB3] Attempting to enable OKB3 v2.5.8 by Kalman Olah...
    2011-07-27 08:22:29 [INFO] [OKB3] Initiating auto-update...
    2011-07-27 08:22:30 [INFO] [OKB3] You already have the latest version of OKB3.
    2011-07-27 08:22:30 [INFO] [OKB3] Hooked into permissions plugin.
    2011-07-27 08:22:30 [INFO] [OKB3] Attempting to load configuration file...
    2011-07-27 08:22:30 [INFO] [OKB3] Configuration file successfully loaded.
    2011-07-27 08:22:30 [INFO] [OKB3] [DB] Initializing MySQL connection...
    2011-07-27 08:22:30 [SEVERE] Error occurred while enabling OKB3 v2.5.8 (Is it up to date?): null
    java.lang.NumberFormatException: null
        at java.lang.Integer.parseInt(Integer.java:443)
        at java.lang.Integer.parseInt(Integer.java:514)
        at me.kalmanolah.okb3.OKDatabase.initialize(OKDatabase.java:34)
        at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:163)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:878)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:272)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    My config is
    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: 69.162.112.59
        mysql-user: *******
        mysql-password: *******
        mysql-database-name: thehissi_forums
    old-school-mode:
        usertable: phpbb_users
        minecraftname-field: pf_minecraft_name
        rank-field: group_id
        enable-multiple-tables: 'true'
        multitable:
            secondtable: phpbb_profile_fields_data
            useridfield-in-secondtable: user_id
            useridfield-in-usertable: user_id
    normal-mode:
        forum: phpbb
        type1:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
        type2:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php: &&&&
        type3:
            usertable: phpbb_users
            rank-field: group_id
            username-field: username
            password-field: user_password
            secondtable: phpbb_profile_fields_data
            useridfield-in-usertable: user_id
            useridfield-in-secondtable: user_id
        type4:
            usertable: php_users
            username-field: username
            password-field: mine_user
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php: &&&&&&
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '2': Builder
                '7': Builder
                '4': Moderator
                '5': Admins
    whitelist:
        enable-whitelist: 'false'
        global:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: Your banned from the forums, what makes you think we wouldn't do the same on the server?
    promotion-tracks:
        '2': Builder
        '7': Builder
        '4': Moderator
        '5': Admins
    forum-ranks: ''
    forum-ranks:
        Admins: '5'
        Registered: '2'
        Moderator: '4'
    
    Error didnt start until recently.
     
  20. Offline

    Kalman Olah

    Add this to the bottom:
    Code:
    misc:
        mysql-ping-interval: 20
     
  21. Offline

    transient

    Since updating the plugin, it's been losing the connection to the SQL server rather frequently. I have the default mysql-ping-interval of 20. Any ideas?

    Thanks!

    Code:
    2011-07-27 07:38:09 [WARNING] [OKB3] Error at SQL Query: Communications link failure
    The last packet successfully received from the server was 158,769 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
     
  22. Offline

    Kalman Olah

    Try lowering the ping interval.
     
  23. Offline

    SynMonger

    Is the source available? This looks like a great plugin, but I'm looking to have it manage the users and groups through McMyAdmin's API instead of directly editing the Permissions config files.
     
  24. Offline

    darkcloud784

    I did that and now I get
    Code:
    2011-07-27 20:45:49 [INFO] [OKB3] Attempting to enable OKB3 v2.5.8 by Kalman Olah...
    2011-07-27 20:45:49 [INFO] [OKB3] Initiating auto-update...
    2011-07-27 20:45:49 [INFO] [OKB3] You already have the latest version of OKB3.
    2011-07-27 20:45:49 [INFO] [OKB3] Hooked into permissions plugin.
    2011-07-27 20:45:49 [INFO] [OKB3] Attempting to load configuration file...
    2011-07-27 20:45:49 [INFO] [OKB3] Configuration file successfully loaded.
    2011-07-27 20:45:49 [INFO] [OKB3] [DB] Initializing MySQL connection...
    2011-07-27 20:45:49 [SEVERE] [OKB3] SQLException! Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-07-27 20:45:49 [INFO] [OKB3] [DB] MySQL connection failed!
    2011-07-27 20:45:49 [INFO] [OKB3] [DB] Loading database...
    2011-07-27 20:45:49 [INFO] [OKB3] Error connecting to MySQL DB, OKB3 is being disabled...
    2011-07-27 20:45:49 [INFO] [OKB3] Attempting to disable OKB3...
    2011-07-27 20:45:49 [INFO] [OKB3] [DB] SQLite connection closed.
    2011-07-27 20:45:49 [INFO] [OKB3] Terminating worker threads...
    2011-07-27 20:45:49 [INFO] [OKB3] OKB3 disabled successfully.
     
  25. Offline

    Kalman Olah

    @darkcloud784 : Your MySQL user doesn't appear to have remote access to your MySQL database. You need to give him access, either through cPanel or through PHPMyAdmin.
     
  26. Offline

    philulrich

    I'm having trouble trying to figure out how to configure this plugin for XenForo, can you help me out please?
     
  27. Offline

    Kalman Olah

    If you post your config.yml.
     
  28. Offline

    philulrich

    Like literally, I have no clue with what to do with the different types. Do I have to fill all of them in or just one?
     
  29. Offline

    Kalman Olah

    The read the OP and check out the example config.yml

    Version 2.5.9

    • Added a new Permissions node: bbb.hide. This hide your join messages from other players.

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

    bocaj812

    Nice little feature :)
     
  31. Offline

    Boon Pek

    Without any form of permissions plugin, this plugin disables itself and outputs this error. I'd be nice if this plugin could... gracefully disable itself :p

    Code:
    2011-07-28 21:40:13 [INFO] Starting minecraft server version Beta 1.7.3
    2011-07-28 21:40:13 [INFO] Loading properties
    2011-07-28 21:40:13 [INFO] Starting Minecraft server on *:25575
    2011-07-28 21:40:13 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-945-g73697a4-b1000jnks (MC: 1.7.3)
    2011-07-28 21:40:14 [INFO] Preparing level "world"
    2011-07-28 21:40:14 [INFO] Preparing start region for level 0 (Seed: -1898028617362346958)
    2011-07-28 21:40:14 [INFO] [OKB3] Attempting to enable OKB3 v2.5.9 by Kalman Olah...
    2011-07-28 21:40:14 [INFO] [OKB3] Initiating auto-update...
    2011-07-28 21:40:15 [INFO] [OKB3] You already have the latest version of OKB3.
    2011-07-28 21:40:15 [INFO] [OKB3] Permissions plugin not found, shutting down...
    2011-07-28 21:40:15 [INFO] [OKB3] Attempting to disable OKB3...
    2011-07-28 21:40:15 [SEVERE] Error occurred while disabling OKB3 v2.5.9 (Is it up to date?): null
    java.lang.NullPointerException
        at me.kalmanolah.okb3.OKBanDB.disable(OKBanDB.java:54)
        at me.kalmanolah.okb3.OKmain.onDisable(OKmain.java:1059)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:128)
        at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:899)
        at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:288)
        at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:145)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:878)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:272)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-07-28 21:40:15 [INFO] Server permissions file permissions.yml is empty, ignoring it
    2011-07-28 21:40:15 [INFO] Done (0.104s)! For help, type "help" or "?"
    
     

Share This Page