[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

    I tried using your config.yml, with only the mysql connection info altered, and it worked just fine.
    If you're on a linux distro, do a quick chown to make sure you can read from the file.
    I'd also mess around with the way you define a value, as in mysql-host: test.mysql.com - >mysql-host: 'test.mysql.com'
     
  3. Offline

    proudpro

    Now I'm getting this error..
    Code:
    2011-06-25 03:48:09 [INFO] [OKB3] Attempting to enable OKB3 v1.2.1 by K. Olah...
    2011-06-25 03:48:09 [INFO] [OKB3] Successfully hooked into Permissions.
    2011-06-25 03:48:09 [INFO] [OKB3] Attempting to load configuration file...
    2011-06-25 03:48:09 [INFO] [OKB3] Configuration file successfully loaded.
    2011-06-25 03:48:09 [INFO] [OKB3] Attempting to load PlayerList file...
    2011-06-25 03:48:09 [INFO] [OKB3] PlayerList file successfully loaded.
    2011-06-25 03:48:09 [INFO] [OKB3-MYSQL] Initializing MySQL connection...
    2011-06-25 03:48:26 [SEVERE] null
    java.io.IOException: Device not configured
        at java.io.FileInputStream.read(Native Method)
        at jline.Terminal.readCharacter(Terminal.java:99)
        at jline.UnixTerminal.readVirtualKey(UnixTerminal.java:128)
        at jline.ConsoleReader.readVirtualKey(ConsoleReader.java:1453)
        at jline.ConsoleReader.readBinding(ConsoleReader.java:654)
        at jline.ConsoleReader.readLine(ConsoleReader.java:494)
        at net.minecraft.server.ThreadCommandReader.run(ThreadCommandReader.java:32)
     
  4. Offline

    Kalman Olah

    It would appear you are unable to attempt to connect to your MySQL server. This is probably caused by your server host's firewall blocking it.
     
  5. Offline

    NeatMonster

    I've switched to Permissions 3 and I think subgroups became multigroups.
    So, can you add multigroups support?
     
  6. Offline

    Fujikatoma

    Simple Question :
    How did you make the Wbb Password check ?
    because i try to make xAuth Wbb comaptible and now i stock on the password Check because Wbb has a Hash :/
     
  7. Offline

    proudpro

    Hmm... How do I fix this?
     
  8. Offline

    Kalman Olah

    Simple answer:
    This is how you make the Wbb Password hash:
    Code:
    $password = sha1($salt.sha1($salt.sha1($_POST['password'])));
    where $salt is the salt value stored for each user in the database, and $_POST['password'] is the password

    I check them by having my passgen.php generate a WBB hash for a given password(with a salt that's fetched from the MySQL users table for the user) and comparing it to a stored hash.

    Unless you have a dedicated server you host your minecraft server on, you contact your host and tell them that they're blocking you from connecting to an external MySQL database.

    I'm checking out the way different forums store multiple groups as we speak. Once the Essentials team switches over to Permissions 3 with their GroupManager-to-Permissions3 bridge, I will stop supporting GroupManager and add multigroups to Bulletin Board Bridge.

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

    Fujikatoma

    Thanks i hope i can make xAuth Wbb compatible :)
     
  10. Offline

    Kalman Olah

    Tested and working on CD Build 935
     
  11. Offline

    Freakdk

    Hello.
    I'm trying to get this to work - but sadly I get this error error when I join with mc name: freakdk
    And I have registered on the forums with the name freakdk...

    Show Spoiler


    So everything is loading correctly.
    I am using MyBB and my Mysql info is correct.

    This is my config.yml

    Show Spoiler


    I've used the same Mysql database for the Forum aswell.
    I've read all your applies to Chris and tried to sort it out myself - but I just can't..

    Also when I do /bbb sync ingame it gives me:

    "An internal error occourred while attempting to perform this command"

    I've set the group "Admin" and the group "Guest" in the admin cp in the MyBB forum and let Admin have 2 stars, Guest 1... (dunno if that even helps :D)
    This is my Permissions globalusers.yml (3.1.5b)

    Show Spoiler
    groups:
    Guest:
    default: true
    info:
    prefix: '&2'
    suffix: '&f'
    build: false
    rank: 1
    permissions:
    Admin:
    default: false
    info:
    prefix: '&4'
    suffix: '&f'
    build: true
    rank: 2
    permissions:
    - '*'


    Hope you're able to help me!
    - I also run Bukkit 928 and your build for 928.
     
  12. Offline

    Kalman Olah

    Show me your config.inc.php and your FULL config.yml please. You did not show the top.
    EDIT: Please make sure your MySQL user has remote MySQL permissions before showing me any of this =/.
    EDIT: http://eurocraft.hostoi.com/forumtest/passgen.php gives a 404 error. I don't know if you're using normal mode though.
     
  13. Offline

    Freakdk

    1. Yes I want to use old-school mode.
    2. Yes the user has full acces.

    Sorry bout the config.yml :O

    Show Spoiler
     
  14. Offline

    Kalman Olah

    You may want to edit out your password.
     
  15. Offline

    Freakdk

    I dunno why I would be that retarded... It's getting late! :)

    Thanks for telling me.
     
  16. Offline

    Kalman Olah

    It should be usergroup, not usergroups.
    Edit: @Freakdk
     
  17. Offline

    Freakdk

    Thanks, but I still get the same error :'(
     
  18. Offline

    Kalman Olah

    Code:
    mysql-connection-info:
        mysql-host: localhost
        mysql-user: root
        mysql-password: password
        mysql-database-name: dbname
    old-school-mode:
        usertable: mybb_users
        minecraftname-field: username
        rank-field: usergroup
        enable-multiple-tables: false
    EDIT: This works for me... Try mysql-host: 'sql09.freemysql.net' as your mysql host and report back.
    Code:
    mysql-host: 'sql09.freemysql.net'
     
  19. Offline

    Freakdk

    No error when I join the server now - but I still get the error when using /bbb sync

    Show Spoiler

    2011-06-27 01:57:08 [INFO] freakdk [/127.0.0.1:61788] logged in with entity id 114 at ([world] 129.90625, 66.0, -26.78125)
    2011-06-27 01:57:19 [WARNING] [OKB3-MYSQL] Error at SQL Query: Communications link failure

    The last packet successfully received from the server was 10.867 milliseconds ago. The last packet sent successfully to the server was 7 milliseconds ago.
    2011-06-27 01:57:19 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'bbb' in plugin OKB3 v1.3.1
    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:304)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:725)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:691)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:684)
    at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    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:451)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NullPointerException
    at net.genericgaming.kalmanolah.okb3.OKmain.UpdateOldschool(OKmain.java:306)
    at net.genericgaming.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:83)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    ... 12 more

     
  20. Offline

    Kalman Olah

    Delete your config.yml, restart your server, fill in only what you need, leave all other stuff as it is, and try it after restarting once more. Afterwards, give me your results again, and also paste your config.yml, save for the password. :)
     
  21. Offline

    Freakdk

    Okay it's "working"
    though I get kicked for not being whitelisted - Even though I have added myself to the Admin group in the Mybb forum.

    Config
    Show Spoiler

    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: 'sql09.freemysql.net'
    mysql-user:
    mysql-password:
    mysql-database-name: whitelisting
    old-school-mode:
    usertable: mybb_users
    minecraftname-field: username
    rank-field: usergroup
    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: mybb
    ? '###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://yoursite.com/passgen.php
    password-set-in-config-inc-php: 12345pass
    md5:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    phpbb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    smf:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    vbulletin:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    mybb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    xenforo:
    usertable: user_table
    rank-field: rank_field
    username-field: username_field
    password-table: pass_table
    password-field: pass_field
    useridfield-in-usertable: user_id_field
    useridfield-in-passtable: user_id_field
    ipb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    wbb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    kunena:
    usertable: user_table
    rank-table: rank_table
    rank-field: rank_field
    username-field: username_field
    password-field: pass_field
    useridfield-in-usertable: user_id_field
    useridfield-in-rank-table: user_id_field
    groups:
    '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''
    '1': Guest
    '2': Admin
    whitelist:
    enable-whitelist: 'true'
    use-as-blacklist: 'false'
    kick-message: This is the message a user will see if their group isn't whitelisted.
    whitelist-groups:
    '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''
    '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''
    '1': 'true'
    '2': '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: ''


    EDIT: No errors in server cmd
     
  22. Offline

    Kalman Olah

    Your mode is still set to normal.
     
  23. Offline

    Freakdk

    Edited that sorry... (almost 3 am here :rolleyes:)

    Still gives me the kick message though.
     
  24. Offline

    Kalman Olah

    ...
    Paste your config.yml again, restart your server just to make sure, and check your server database. More specifically, check your usergroup for your user in mybb_users.
    EDIT: Tell me what your usergroup is :p
     
  25. Offline

    Freakdk

    This is what it tells my inside the table mybb_users under "usergroup"
    usergroup
    smallint(5) unsigned

    What do you mean by
    Config:

    Show Spoiler
    Show Spoiler
    Show Spoiler
    Show Spoiler

    mode: old-school
    '###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: 'sql09.freemysql.net'
    mysql-user: freakdk
    mysql-password: niclasb
    mysql-database-name: whitelisting
    old-school-mode:
    usertable: mybb_users
    minecraftname-field: username
    rank-field: usergroup
    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: mybb
    ? '###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://yoursite.com/passgen.php
    password-set-in-config-inc-php: 12345pass
    md5:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    phpbb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    smf:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    vbulletin:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    mybb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    xenforo:
    usertable: user_table
    rank-field: rank_field
    username-field: username_field
    password-table: pass_table
    password-field: pass_field
    useridfield-in-usertable: user_id_field
    useridfield-in-passtable: user_id_field
    ipb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    wbb:
    usertable: user_table
    username-field: username_field
    userpassword-field: user_pass_field
    rank-field: rank_field
    kunena:
    usertable: user_table
    rank-table: rank_table
    rank-field: rank_field
    username-field: username_field
    password-field: pass_field
    useridfield-in-usertable: user_id_field
    useridfield-in-rank-table: user_id_field
    groups:
    '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''
    '1': Guest
    '2': Admin
    whitelist:
    enable-whitelist: 'true'
    use-as-blacklist: 'false'
    kick-message: This is the message a user will see if their group isn't whitelisted.
    whitelist-groups:
    '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''
    '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''
    '1': 'true'
    '2': '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: ''
     
  26. Offline

    Kalman Olah

    I mean that you should look inside the table itself, look for YOUR user, and tell me what the value is in the field 'usergroup'. It should be 1 or 2. If it isn't, your groups aren't set up right.
     
  27. Offline

    Freakdk

  28. Offline

    Kalman Olah

    The table mybb_usergroups list the available usergroups that will be assigned to users from your forum, and their IDs. According to that table, 4 = Administrators. Please note that usergroups are not Groups. They're ranks. There's a difference.

    Once you've sorted out your groups and stuff, check out the use-whitelist-as-blacklist option. If it is set to false, groups not specifically mentioned in the config.yml will be kicked. If it is set to true, only groups that are specifically blacklisted in config.yml will be kicked. Groups that aren't mentioned will be allowed to join. :)
     
  29. Offline

    Freakdk

    Oh my god!
    It's working! :D

    1000 [diamond][diamond][diamond] for you @Kalman Olah thank you sooomuch!
    Sorry if I was a bit retarded along the way, I'm not that experienced ;)
     
  30. Offline

    Kalman Olah

    No problem :). Glad it's working for you.
     
  31. Offline

    Robert McKay

    Hello!

    I am having trouble setting up my server with your plugin.

    I am running CB #935, and the forum software is IPBoard 3.1.4

    Here is my config...
    Code:
    mysql-connection-info:
    next part...
    [CODE]    '###Fill in the fields for the forum type that matches your type-of-forum value': ''
        location-of-passgenphp: http://wurld.us/forum/webfiles/passgen.php
        password-set-in-config-inc-php: PASSWORD
    final part...
    Code:
        ipb:
            usertable: wurldus_members
            username-field: members_name
            userpassword-field: members_pass_hash
            rank-field: member_group_id
    Does anything look wrong for IPboard?

    Thanks!
    Robert
     

Share This Page