[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

    Cosmic Break

    15:09:58 [SEVERE] Exception in thread "Thread-36"
    15:09:58 [SEVERE] java.lang.NullPointerException
    15:09:58 [SEVERE] at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery
    (DatabaseHandler.java:74)
    15:09:58 [SEVERE] at com.alta189.sqlLibrary.MySQL.mysqlCore.sqlQuery(mysql
    Core.java:52)
    15:09:58 [SEVERE] at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:81)

    15:09:58 [SEVERE] at java.lang.Thread.run(Unknown Source)

    15:10:36 [WARNING] Task of 'OKB3' generated an exception
    java.lang.NullPointerException
    at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler
    .java:74)
    at com.alta189.sqlLibrary.MySQL.mysqlCore.sqlQuery(mysqlCore.java:52)
    at me.kalmanolah.okb3.OKDatabase$1.run(OKDatabase.java:25)
    at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(C
    raftScheduler.java:137)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:428)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

    15:11:59 [SEVERE] Exception in thread "Thread-548"
    15:11:59 [SEVERE] java.lang.NullPointerException
    15:11:59 [SEVERE] at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery
    (DatabaseHandler.java:74)
    15:11:59 [SEVERE] at com.alta189.sqlLibrary.MySQL.mysqlCore.sqlQuery(mysql
    Core.java:52)
    15:11:59 [SEVERE] at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:81)

    15:11:59 [SEVERE] at java.lang.Thread.run(Unknown Source)

    this does support myBB

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

    Kalman Olah

    Your config.yml is configured incorrectly. Post it here, and I'll let you know what's wrong.
     
  4. Offline

    Cosmic Break

    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: XXX
        mysql-user: XXX
        mysql-password: XXX
        mysql-database-name: XXX
    old-school-mode:
        usertable: XXX
        minecraftname-field: fid4
        rank-field: usergroup
        enable-multiple-tables: 'true'
        multitable:
            secondtable: XXX
            useridfield-in-secondtable: XXX
            useridfield-in-usertable: XXX
    normal-mode:
        forum: mybb
        type1:
            usertable: mybb_users
            username-field: username
            userpassword-field: password
            rank-field: usergroup
        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'
        normal:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
        nether:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
        skylands:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
        freebuild:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
    whitelist:
        enable-whitelist: 'true'
        global:
            use-as-blacklist: 'true'
            kick-message: Your Group is BANNED.
            groups:
                '7': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '7'
        unbanned-forum-user-rank-id: '2'
        ban-message: You are banned on this server.
    promotion-tracks:
        '1': '2'
        '2': '3'
        '3': '4'
    forum-ranks:
        Admin: '4'
        Registered: '2'
        Mod: '3'
    misc:
        mysql-ping-interval: '10'
    
     
  5. Offline

    Kalman Olah

    Since you're running it in old-school mode, mind removing the XXXs there?
     
  6. Offline

    Cosmic Break

    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: XXX
        mysql-user: XXX
        mysql-password: XXX
        mysql-database-name: XXX
    old-school-mode:
        usertable: mybb_users
        minecraftname-field: fid4
        rank-field: usergroup
        enable-multiple-tables: 'true'
        multitable:
            secondtable: mybb_userfields
            useridfield-in-secondtable: ufid
            useridfield-in-usertable: uid
    normal-mode:
        forum: mybb
        type1:
            usertable: mybb_users
            username-field: username
            userpassword-field: password
            rank-field: usergroup
        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'
        normal:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
        nether:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
        skylands:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
        freebuild:
            groups:
                '1': Guest
                '2': Member
                '3': Mod
                '4': Admin
                '5': Guest
                '6': Mod
                '7': Guest
                '8': Owner
                '9': VIP
    whitelist:
        enable-whitelist: 'true'
        global:
            use-as-blacklist: 'true'
            kick-message: Your Group is BANNED.
            groups:
                '7': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '7'
        unbanned-forum-user-rank-id: '2'
        ban-message: You are banned on this server.
    promotion-tracks:
        '1': '2'
        '2': '3'
        '3': '4'
    forum-ranks:
        Admin: '4'
        Registered: '2'
        Mod: '3'
    misc:
        mysql-ping-interval: '10'
    
     
  7. Offline

    patey

    only one question for me now- where is minecraftname-field?
     
  8. Offline

    Kalman Olah

    It's wherever minecraft names are stored in your MySQL database. This could be the username field, or a custom profile field, hence why it's customizable.

    ARe you sure it wasn't an issue with your MySQL server? Did the errors appear in the order you pasted them?
     
  9. Offline

    Cosmic Break

    they did, the only thing removed was ingame chat about it not working when people logged in or switched worlds.
     
  10. Offline

    Kalman Olah

    Can't find anything wrong with it. It's either your mysql config.yml configuration, or your mysql server was restarting. I can't verify either of those.
     
  11. Offline

    patey

    how do i add this custom field on my forum?
     
  12. Offline

    Kalman Olah

    PHPBB Admin Control Panel, Users tab. I don't know the specifics, so don't ask me.
     
  13. Offline

    patey

    well before i asked that i did create a custom profile field but this gets added in a different table

    *edit* this is also the only custom field i can find to add
    *edit*i use phpbb3
     
  14. Offline

    Kalman Olah

    Hence why you use the value "enable-multiple-tables" to enable multiple tables.
     
  15. Offline

    patey

    kk,thx for the help, i gotta figure the forum p;art out on my own but the plugin works perfectly :D
     
  16. Offline

    LibertasMens

    I get this every time it starts. I didn't used to.
    Code:
    2011-08-18 23:08:25 [SEVERE] [OKB3] SQLException! Access denied for user '########'@'#######.device.mst.edu' (using password: YES)
    2011-08-18 23:08:25 [INFO] [OKB3] [DB] MySQL connection failed!
    2011-08-18 23:08:25 [INFO] [OKB3] [DB] Loading database...
    2011-08-18 23:08:25 [INFO] [OKB3] Error connecting to MySQL DB, OKB3 is being disabled...
    2011-08-18 23:08:25 [INFO] [OKB3] Attempting to disable OKB3...
    2011-08-18 23:08:25 [INFO] [OKB3] [DB] SQLite connection closed.
    2011-08-18 23:08:25 [INFO] [OKB3] Terminating worker threads...
    2011-08-18 23:08:25 [INFO] [OKB3] OKB3 disabled successfully.
    2011-08-18 23:09:26 [INFO] [OnlinePlayers v1.0.1] Enabled Successfully.
    
     
  17. Offline

    Kalman Olah

    It can't connect to your MYSQL server. Info may be incorrect, there may be a firewall, your MySQL user may not have remote access, etc...
     
  18. Offline

    SynMonger

    Does anyone have an example of the config.yml setup for normal mode using XenForo?

    The passwords aren't stored in the same table as the username, and it's giving me fits.

    Edit: Found the problem. I was using the wrong column from the xf_user_authenticate table. Should be the 'data' column.
     
  19. Offline

    Sayshal

    Does this work with SMF?
     
  20. Offline

    Kalman Olah

    yes
     
  21. Offline

    Sayshal

    I'm a bit confused as to what this does, does this make it so new members have to join the forums to be able to do certain things? Like a whitelist?
     
  22. Offline

    Cosmic Break

    how do i stop this from happening?

    16:53:54 [WARNING] [OKB3] Error at SQL Query: No operations allowed after connec
    tion closed.Connection was implicitly closed by the driver.
     
  23. Offline

    thernztrom

    So as Permissions 3.0 is inactive and discontiued im looking into other permissions solutions.
    Most users are migrating over to PermissionsEx, is that something OKB3 supports?
    Already saw that OKB3 didnt support permissionsbukkit..
    Or is it all gonna bee dead with PE3 away :(
     
  24. Offline

    microskies

    Hey, I've been getting this error after trying to /sync for the first time (I had to re-configure the whole plugin because I had messed up some things):

    Code:
    2011-08-21 17:03:25 [WARNING] [OKB3] Error at SQL Query: Communications link failure
    
    The last packet successfully received from the server was 34,720 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
    2011-08-21 17:03:25 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'sync' in plugin OKB3 v2.5.17
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:352)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
        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:89)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:436)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NullPointerException
        at me.kalmanolah.okb3.OKmain.UpdateNormal(OKmain.java:574)
        at me.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:101)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 13 more

    Nevermind, I was using the wrong IP for my database :/
     
  25. Offline

    ronk22

    Hi,

    I've spent hours to find a bug in the normal mode :
    For $phppass, don't affect password with the sign "#" at the end or you'll have a bug like "[OKB3] xxx's rank update failed."

    Thanks for this plugins, now it works well ! :)
     
  26. Offline

    buengese

    I get this error
    Code:
    19:22:46 [SCHWERWIEGEND] Could not load 'plugins/OKB3.jar' in folder 'plugins':
    while parsing a block mapping
     in "<reader>", line 48, column 9:
                groups:
                ^
    expected <block end>, but found BlockMappingStart
     in "<reader>", line 50, column 12:
                   '11': CoAdmin
                   ^
    
            at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockMappingKey.produce(ParserImpl.java:576)
            at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:163)
            at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:148)
            at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:228)
            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
            at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:230)
            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
            at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:230)
            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
            at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122)
            at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105)
            at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:124)
            at org.yaml.snakeyaml.Yaml.load(Yaml.java:264)
            at org.bukkit.util.config.Configuration.load(Configuration.java:82)
            at org.bukkit.plugin.java.JavaPlugin.initialize(JavaPlugin.java:157)
            at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:175)
            at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:207)
            at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:130)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:128)
            at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:97)
            at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:51)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:132)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Code:
    mode: normal
    mysql-connection-info:
        mysql-host: reich-der-welten.de
        mysql-user: *********
        mysql-password: ******
        mysql-database-name: reichder_2
    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: mybb
        type1:
            usertable: mybb_users
            username-field: username
            userpassword-field: password
            rank-field: usergroup
        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: 'false'
        default:
            groups:
                '4': Admin
               '11': CoAdmin
                '6': Moderator
               '10': VIP
                '9': Donator
               '12': Builder
                '8': Spieler
        exampleworld1:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
        exampleworld2:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
    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'
    misc:
        mysql-ping-interval: '30'
     
  27. Offline

    Cosmic Break

    are you considering permissionsbukkit/superperms support in the future?
     
  28. Offline

    Kalman Olah

    As soon as a group changing API is added.
    Code:
    world-groups:
    
        enable-multiworld-groups: 'false'
    
        default:
    
            groups:
    
                '4': Admin
    
              '11': CoAdmin
    
               '6': Moderator
    
              '10': VIP
    
               '9': Donator
    
              '12': Builder
    
               '8': Spieler
    Make sure that the groups are aligned. no extra spaces.
     
  29. Offline

    brandon079

    First off this plugin has been awesome to automate the registration process on our server. There is however one thing that is a bit bothersome and has more to do with our sites SQL table design than your plugin.

    Our default group is citizen. Upon completion of the registration process they become a citizen. We use the multitable option. The problem is, in order for a user to become a citizen they not only have to register but also have to post to the forum. This confuses new users quite a bit and I would rather not have to make them do this step. The reason that they have to post to the forum is that the forum component of our site doesn't add the user to the table until they have created at least 1 post. So until they have posted on the forum they have no rank.

    Would it be possible to add an option to the config that would assign a user to a certain group if the username appears in one table but the associated ID isn't in the table with the rank? Basically it would be a group that have registered but still have a null rank.

    Please let me know if this is something you could implement (or already have) or if I am not explaining the issue very well. ~Thanks
     
  30. Offline

    ExplosiveBacoN

    Does this support PEX?
     
  31. Offline

    Kalman Olah

    Yes, it does.
    If you tell them to register with their minecraft usernames, you could use old-school mode. It would eliminate the need to /sync, and it would fix your current issue with them having to post to gain access.
     

Share This Page