[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

    /bbb sync <forum username> <forum password>, if you're using normal mode. If it still does not work, post your config.yml :).

    EDIT: Check if your MySQL user has permissions to access data remotely, if the forum is hosted on a different machine from your minecraft server.
     
  3. Offline

    thernztrom

    Yes, the mysql is hosted at www.one.com, and my server is hosted at www.servercraft.co
    But how do I "allow" it todo that? Guess i'll have to go in phpmyadmin again huh? :)
    EDIT: yes im on normal mode
     
  4. Offline

    Kalman Olah

    Go into phpmyadmin, go to "Privileges", and make a new user that's allowed to get data from all hosts. You'll know the option when you see it :).
     
  5. Offline

    thernztrom

    :'( I feel really sad i put effort in tweaking everything all afternnon to now, after contactong my host(one.com), to know that is not possible as thei firewalls block outcoming requests for acessing the databases. :(
    Well well:'(, maybee its possible if i move the mysql server that the forum uses somewhere else, any place to recommend that can host sql-tables with phpmyadmin? Or i guess most of you host it yourselfes eh? xD
     
  6. Offline

    Kalman Olah

    We do indeed host it ourselves :). Sorry to hear about your host =/.

    EDIT: x10hosting.com may allow remote MySQL. I'd ask on their support forum.
     
  7. Offline

    Chrisspitz

    I'm back again.
    I've changed hosts for both my minecraft server and web hosting since then.
    My config files are correct no typos or case sensitive issues. . . Going to passgen.php gives a blank page...
    But when I go to the url
    http://rubikscraft.com/passgen.php?t=6&u=mysqluser&p=mysqlpass&s=myphppass

    I get the same error once again


    In game is the same Internal Error
    Wish I could get this sorted out

    I have tested giving passgen.php full permissions and still the same issue.
    Im confused why it's talking about line 60 of passgen.php
     
  8. Offline

    Kalman Olah

    Either your configuration is wrong, or your MySQL user does not have permissions to select data remotely. Post your config.yml, config.inc.php, and check if your MySQL user has permissions to select data remotely.
     
  9. Offline

    thernztrom

    Ok, I moved my forums to a host that allow remote mysql connections, and I have set my mc-server's ip to a mysql remote connection whitelist.
    I have edited the necessary info (i think), the new domain and mysql settings. Other than that the configs are untouched since yesterdays tries I did.
    But yesterday I got "wrong password" returned to me after using the sync command. But today as I test with the new site I get "an internal error"-message instead. :s
    Any idea what it sound to be this time? :p
    Ill post the (edited) configs here...
    Code:
    mode: normal
    '###The mode the plugin will run in, options are ''normal'' or ''old-school''###': ''
    ? '###In old-school mode, the server does NOT check a username/password! It just gets
        a rank from your forum DB and sets it as your group###'
    : ''
    ? '###If you''re using old-school mode, fill in the section labeled ''old-school-mode''
        If not, fill in the section labeled ''normal-mode'''
    : ''
    mysql-connection-info:
        mysql-host: Mynewwebsite'sip
        mysql-user: forums-mysqlusername
        mysql-password: forums-mysqlpassword
        mysql-database-name: forum-mysqldatabase
    old-school-mode:
        usertable: user_table
        minecraftname-field: mine_user
        rank-field: rank_field
        enable-multiple-tables: false
        '###If enable-multiple-tables is true, fill in the multitable section': ''
        multitable:
            minecraftname-table: mine_table
            useridfield-in-minecraftname-table: user_id_field
            useridfield-in-usertable: user_id_field
    normal-mode:
        type-of-forum: phpbb
        ? '###Current supported forum types md5 for MD5 encryption-based forums,phpbb
            for phpBB3, smf for SMF, vbulletin for vBulletin, mybb for myBB, xenforo for
            XenForo, ipb for IPB, wbb for WBB, kunena for Kunena###'
        : ''
        '###Fill in the fields for the forum type that matches your type-of-forum value': ''
        location-of-passgenphp: http://www.memoryblock.x10.mx/passgen.php
        password-set-in-config-inc-php: samePassAsInMyConfig.inc.php
        phpbb:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
    groups:
        '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''
        '9': Default
        '5': Member
        '6': Member
        '8': VIP
        '4': Donator
        '10': Mod
        '3': Smod
        '7': Admins
        '1': Owner
    whitelist:
        enable-whitelist: 'true'
        use-as-blacklist: 'false'
        kick-message: Apply for whitelist at www.memoryblock.org !
        whitelist-groups:
            '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''
            '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''
            '9': 'false'
            '5': 'true'
            '6': 'true'
            '8': 'true'
            '4': 'true'
            '10': 'true'
            '3': 'true'
            '7': 'true'
            '1': 'true'
    '###If use-as-blacklist is enabled, groups that aren''t specified on the whitelist will count as blacklisted###': ''
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    
    Code:
    <?php
    //Your mysql host
    $dbhost = 'localhost';
    //Your mysql user
    $dbuser = 'forum-mysqlusername';
    //Your mysql password
    $dbpass = 'forum-mysqlpassword';
    //Your mysql database
    $dbname = 'forum-mysqldatabase';
    //Your custom password. #####THIS MUST MATCH THE PHP PASSWORD IN CONFIG.PROPERTIES!#####
    $phppass = 'SamePassAsInMyConfig.yml';
    //The prefix used by your forum tables. Let's say your the table where your usernames are stored in
    // is called 'phpbb_users'...in this case the prefix is 'phpbb_'. set to $sqlprefix = ''; for no prefix.
    $sqlprefix = 'phpbb_ranks';'phpbb_users'
    ?>
     
  10. Offline

    Kalman Olah


    =/....Really?

    Code:
        phpbb:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: user_rank
    Change this in config.yml


    Code:
    $sqlprefix = 'phpbb_';
    Change this in config.inc.php

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

    thernztrom

    Oh, finally :D It works like a charm now. Big thanks to your great support <3 :)
     
  12. Offline

    Kalman Olah

    No problem :)
     
  13. Offline

    thernztrom

    Just a short check :p So now I could wipe the Permissions users file right? As it will create each user and its right settings when they sync. And will it be changed directly after they sync or does a admin have to reload permissions every time someone joins and syncs? :/

    If it needs a manul reload everytime, would'nt it be possible to build in the plugin that the command "/pr reload -all" performs after an sucess sync automaticly. That of course expected that i give everyone the "permissions.reload.all" node? :)

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

    Kalman Olah

    As soon as someone syncs, their permissions and ranks are changed. They may not instantly appear in the user.yml file(in the permissions folder), but it will be applied and working.

    Updated to v1.3.0 :)

    - Fixed the plugin author displaying incorrectly on startup.
    - Fixed the plugin author displaying incorrectly in the "/bbb v, /bbb ver" command.
    - Fixed the /bbb resync command not appearing in the help menu in normal mode.
    - Added the /bbb forceall command. This works like the /bbb force <name> command, but /bbb forceall syncs all online users.
    Permission node: bbb.forceall
    - The "/bbb, /bbb ?, /bbb help" help menu now shows the /bbb force and /bbb forceall commands, should you have the appropriate permissions.
    - Cleaned up the overall code a whole lot. Seriously.
    - Removed the password checks from the whitelisting feature in normal mode. This should make sure a blacklisted player stays blacklisted, even if he should change his forum password.

    EDIT:
    @xREVOLUT1ONZx
    You asked for a command to sync all online players :).

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

    garfield

    hello,

    awesome plugin. but i have two questions:
    we are running wbb on machine 1 and the bukkit server on machine 2

    webfiles/* goes to machine 1, everything is configged correctly.
    OKB3.jar goes to machine 2 and in the config i put mode=wbb

    but i don't know what to put in the wbb section of the config, as machine 2 has no access to mysql-database on machine 1.

    thanks 4 this plugin, and active development!
     
  16. Offline

    Kalman Olah

    If your second machine has no access to your forum's MySQL database on machine 1, this plugin will never work for you. You should check if the MySQL portion of OKB3 can actually connect to machine 1's MySQL server on startup, if you fill in the MySQL connection info. Once you check that, I can help you further :).
     
  17. Offline

    garfield

    we have chosen this setup because we are running a wow-private-server fine for years. we do not want the game-server to be bound to the forums, so if one goes down, the other can stay up.

    so if OKB3 _needs_ an sql connection to the forum, i sadly can't use it in the current state.

    but i have some ideas of my own, so i would like to get the sourcecode to do some improvements of my own.

    i thought about: passgen.php could fetch the rankID by itself, an then posts it back to the plugin like it is done with the pass-hash.
    secound thing i would like to implement is some sort-of caching-layer for the local (from the plugins sight) machine (in my case machine 2), so the plugin can continue to operate even if machine 1 goes away.

    EDIT:
    forget about the caching :D GroupManagers users.yml should be sufficient for this purpose.
    but for passgen.php i really think it should fetch all relevant info and post it back to OKB3
     
  18. Offline

    Kalman Olah

    I'm actually going to remove the passgen.php completely, if I can. I'll PM you.
     
  19. Offline

    NeatMonster

    Only console spamed this time (and only with a lot of successful update messages).
     
  20. Offline

    Kalman Olah

    What do you mean? Screenshots?
     
  21. Offline

    68x

    This is the error I am getting:

    Code:
    <br /> <b>Warning</b>:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in <b>/home/*******/public_html/bbb/passgen.php</b> on line <b>43</b><br />
    
    
    
    This the log:

    Code:
    2011-06-24 00:15:58 [SEVERE] java.io.FileNotFoundException: http://***********.ca/bbb/passgen.php?t=4&u=68x&p=******&s=*******
    2011-06-24 00:15:58 [SEVERE] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-24 00:15:58 [SEVERE] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011-06-24 00:15:58 [SEVERE] 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011-06-24 00:15:58 [SEVERE] 	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2011-06-24 00:15:58 [SEVERE] 	at sun.net.www.protocol.http.HttpURLConnection$6.run(HttpURLConnection.java:1458)
    2011-06-24 00:15:58 [SEVERE] 	at java.security.AccessController.doPrivileged(Native Method)
    2011-06-24 00:15:58 [SEVERE] 	at sun.net.www.protocol.http.HttpURLConnection.getChainedException(HttpURLConnection.java:1452)
    2011-06-24 00:15:58 [SEVERE] 	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1106)
    2011-06-24 00:15:58 [SEVERE] 	at net.genericgaming.kalmanolah.okb3.OKReader.main(OKReader.java:19)
    2011-06-24 00:15:58 [SEVERE] 	at net.genericgaming.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:56)
    2011-06-24 00:15:58 [SEVERE] 	at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-06-24 00:15:58 [SEVERE] 	at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:128)
    2011-06-24 00:15:58 [SEVERE] 	at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:287)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:712)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:678)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:671)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:399)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
    2011-06-24 00:15:58 [SEVERE] 	at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-24 00:15:58 [SEVERE] Caused by: java.io.FileNotFoundException: 
    2011-06-24 00:15:58 [SEVERE] 	at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1401)
    2011-06-24 00:15:58 [SEVERE] 	at sun.net.www.protocol.http.HttpURLConnection.getHeaderField(HttpURLConnection.java:2214)
    2011-06-24 00:15:58 [SEVERE] 	at java.net.URLConnection.getContentType(URLConnection.java:502)
    2011-06-24 00:15:58 [SEVERE] 	at net.genericgaming.kalmanolah.okb3.OKReader.main(OKReader.java:17)
    2011-06-24 00:15:58 [SEVERE] 	... 14 more
    2011-06-24 00:15:58 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'bbb' in plugin OKB3 v1.3.0
    	at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
    	at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:128)
    	at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:287)
    	at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:712)
    	at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:678)
    	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:671)
    	at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    	at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    	at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    	at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:399)
    	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
    	at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NullPointerException
    	at net.genericgaming.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:60)
    	at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    	... 12 more
    
    
     
  22. Offline

    Kalman Olah

    Post your config.inc.php.
    EDIT: post your config.yml too.

    I thought about removing the passgen.php and integrating it into the plugin, but I realized the framework for phpbb hashes is a PHP file...So yeah, it stays.

    Working on CB Build 928

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

    Chrisspitz

    Heres my config.inc.php (mysql server is hosted off my webserver so thats why its localhost, I have allowed remote connections from my own ip and my minecraft servers and it works properly from my ip so it should work properly for my minecraft server as well)
    And heres my config.yml (using old-school I know I have an Authenticate plugin as well)

     
  24. Offline

    Kalman Olah

    And your error is...?

    EDIT: If you're using old-school you can get rid of all the php files. You don't need them in old-school mode.
     
  25. Offline

    Chrisspitz

    It doesn't work, when a user joins the rank doesn't get assigned, and when I try going to http://rubikscraft.com/passgen.php?t=6&u=mysqluser&p=mysqlpass&s=myphppass
    Like you said for someone else to do in earlier posts I get the error:
     
  26. Offline

    Kalman Olah

    You're in old-school mode. All of the php files are useless to you. Have someone use the /bbb sync command and show me the console output when they do so. The error it shows will help me help you :).
     
  27. Offline

    Chrisspitz

    Alright ill do that now. I'm using the host Xenon for my minecraft server, is there a log file that lists the console? I guess i'll find it myself if you dont reply. Or I could download HLSW and get into my server if it lets me :O
     
  28. Offline

    Kalman Olah

    I have no clue. I hosted my minecraft server on my own dedicated server =/.
    EDIT: You know.... It could be that Xenon doesn't allow you to connect to remote MySQL databases...
     
  29. Offline

    Chrisspitz

    AHA!
    Apparently some of my Mysql user info is wrong somehow.
     
  30. Offline

    Kalman Olah

    Try allowing any host to connect to your MySQL database. See if that works. Doublecheck your database name/username/password.
     
  31. Offline

    Chrisspitz

    I dont think I can do that. Just double checked my username password etc. it was all correct no CaSe stuff either so i'm very confused. I can only add ip's allowed to connect : | just connected to test it working through Navicat too. I deleted my config.yml and replaced all the info.. Going stop my server now and restart it and see if its working, i've done this before and it didn't so we will see : | honestly I doubt it. I'll check the logs again as well
     

Share This Page