[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

    Did you restart the server? Did you make sure your forum rank is fixed now that you're unbanned from the forum? Check your group's ID in your ipb_members table.
     
  3. Offline

    dscm

    It's all set correctly :(
     
  4. Offline

    Kalman Olah

    Great to hear :).
     
  5. Offline

    dscm

    No, still not kicking me out >_<
     
  6. Offline

    Kalman Olah

    -You didn't configure the whitelist correctly.
    -Your group isn't blacklisted on the whitelist.
    -You don't belong to a group, so you're not blacklisted.
    -Your group isn't configured correctly.
    One of the above. Make sure you do indeed have your group set. Make sure your forum group ID is indeed the one of the group you're testing(by checking ipb_members). Make sure the whitelist is configured correctly by posting your config.yml here. Make sure you are mentioned in the file /plugins/OKB3/PlayerList.yml.
     
  7. Offline

    dscm

    Well, as you may know on my last posts ... I've shown you the whitelist, the groups.yml and you said they're all set.
    I am mentioned in PlayerList.yml

    Im getting frustrated on this :(
     
  8. Offline

    Kalman Olah

    Try doing /deop <yourname> in the console, and try again.
     
  9. Offline

    Chrisspitz

    Argh, Hello once againnnn
    Ever since I have updated OKB3 my server has been experiencing mega lag spikes when a server connects and basically just lags out, so I had to remove the plugin.
    Yes, it is connecting to an external mysql server and theres nothing I can do about that, but I do have a fast connection with the host I have so I didn't think this would be problem.

    I had to remove the plugin for now to fix the lag, but I miss it very much so lol.
    I have quite a bit of members on my forum about 150 or so if I had to guess so i'm guessing this is what makes the server lag out when the server queries the mysql server it has a big list to search through for the rank.

    I never had this issue until the plugin was updated, and there are no errors in the server log.

    Any suggestions?

    I had an idea but im not sure if it exists..
    Have some sort of script running on on my webserver which copies the mysql database onto the server's mysql database (which I can't put my web database on).. but have the script copy the table to the other database every 5 minutes and then that would make it so the server would just have to query locally when a player joins, maybe reducing the lag?
    Does a script or anything like this exist?
     
  10. Offline

    Kalman Olah

    Could you tell me what the last version was which wasn't causing any lag spikes?
     
  11. Offline

    Chrisspitz

    2.2.0 I believe, because I did have the /fban features and it was doing fine then

    EDIT: Just found a typo in my last post "when a PLAYER* connects"
     
  12. Offline

    Kalman Olah

    I've made no major changes to the code between 2.2.0 - 2.3.0... Did you try deleting PlayerList.yml?
     
  13. Offline

    Chrisspitz

    Hm, and no I haven't. Do you think that would make a difference? I'll try that, but can't really let you know until sometime later (maybe tomorrow). Players on the server at the moment I can't add the plugin back because i'd have to restart the server and they'd whine D:

    I'll let you know though as usual :p
     
  14. Offline

    Kalman Olah

    I have no idea if it'll make a difference. I've not been able to test this plugin on a server with over 2 people, so I can't really check the performance impact it may or may not have on servers with lots of players. I'll look into it, though. I'd suggest you keep it turned off until I can fix it, which should be on monday.
     
  15. Offline

    Chrisspitz

    Alright so I deleted the playerlist and restarted the server with the plugin back on. 2 players on connected was fine, but a third player joined and then there was a big lag spike for like a good 20 seconds

    EDIT: Which isn't bad as the lag spikes I was having before, but still.

    EDIT2: Honestly I love this plugin so much and love your programming so much, and how great your support is I would be willing to just add you as an admin on my server to do whatever you'd like. But it would be hard for you to test, because most of the time we have about 5 players online or more, at the moment there are only 3 though :O
     
  16. Offline

    iBstoneyDave

    I actually don't want to keep it at all, was just waiting for Essentials to remove it in favor of permissions, thanks for your help man.
     
  17. Offline

    Derrick Mehaffy

    Ok I can not for the life of me get the plugin to communicate with my forums site. Yes it supports mysql and php.
    My website hosting company is http://x10hosting.com
    My minecraft server hosting company is http://brohoster.com
    Minecraft server IP: 184.172.7.182
    It will not connect and authorize the phpbb sql database correctly
    *Im not exactly new to messing with phpbb or mysql databases, i just know enough to get by ;)*

    If you need more information I can pm you my skype. Please and thank you. I would really like to get this setup. Also if you do help me getting this setup, I will make a tutorial video for you to add. =)
     
  18. Offline

    Chrisspitz

    I recommend posting your config.yml ~ sensoring out your passwords
    Also posting your config from the web portion ~ sensoring out your passwords

    And your server.log file (because that would show the error)

    Kalman Olah is going to ask for all of these things in order to help you.
     
  19. Offline

    Kalman Olah

    ^These ^
    Post your config.yml, Server log and config.inc.php please :).
     
  20. Offline

    Derrick Mehaffy

    WebCode
    PHP:
    <?php
    //Your mysql host
    $dbhost 'localhost';
    //Your mysql user
    $dbuser 'derrickm_phpbb';
    //Your mysql password
    $dbpass '_______';
    //Your mysql database
    $dbname 'derrickm_phpbb';
    //Your custom password. #####THIS MUST MATCH THE PHP PASSWORD IN CONFIG.PROPERTIES!#####
    $phppass 'michael5592';
    //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_';
    ?>
    Minecraft Code
    Code:
    mode: normal
    mysql-connection-info:
        mysql-host: 69.175.122.178
        mysql-user: derrickm_phpbb
        mysql-password: _____________
        mysql-database-name: derrickm_phpbb
    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: phpbb
        type1:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
        type2:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
            location-of-passgenphp: http://telionmc.co.cc/forums/okb3/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://telionmc.co.cc/forums/okb3/passgen.php
            password-set-in-config-inc-php: michael5592
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '1': Peasant
                '2': Commoner
    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'
    
    Server Log
    Code:
    2011-07-17 21:02:18 [INFO] [OKB3] Attempting to enable OKB3 v2.3.3 by Kalman Olah...
    2011-07-17 21:02:18 [INFO] [OKB3] Initiating auto-update...
    2011-07-17 21:02:18 [INFO] [OKB3] You already have the latest version of OKB3.
    2011-07-17 21:02:18 [INFO] [OKB3] Successfully hooked into permissions plugin.
    2011-07-17 21:02:18 [INFO] [OKB3] Attempting to load configuration file...
    2011-07-17 21:02:18 [INFO] [OKB3] Configuration file successfully loaded.
    2011-07-17 21:02:18 [INFO] [OKB3] Attempting to load PlayerList file...
    2011-07-17 21:02:18 [INFO] [OKB3] PlayerList file successfully loaded.
    2011-07-17 21:02:18 [INFO] [OKB3] Attempting to load BanList file...
    2011-07-17 21:02:18 [INFO] [OKB3] BanList file successfully loaded.
    2011-07-17 21:02:18 [INFO] [OKB3] [DB] Initializing MySQL connection...
    2011-07-17 21:02:18 [SEVERE] [OKB3] SQLException! Access denied for user 'derrickm_phpbb'@'50.22.36.146' (using password: YES)
    2011-07-17 21:02:18 [INFO] [OKB3] [DB] MySQL connection failed!
    2011-07-17 21:02:18 [INFO] [OKB3] Error connecting to MySQL DB, OKB3 is being disabled...
    2011-07-17 21:02:18 [INFO] [OKB3] Attempting to disable OKB3 v2.3.3 by Kalman Olah...
    2011-07-17 21:02:18 [INFO] [OKB3] OKB3 disabled successfully.
    2011-07-17 21:02:18 [INFO] [MobileAdmin] alizarcivire enabled a plugin (OKB3)
    Yes I do know that the ip-address listed in the log is not the same that is listed in my config. As to why that is, you tell me lol. I followed the instructions to the letter. I also went into my cpanel on my hosting company made sure the remote mysql had the correct host for my minecraft server ip address which is 184.172.7.182. We also run logblock which connects to a remote mysql database so its not Brohoster. It has to be me not having the correct ipaddress for x10hosting. How do i get the correct one?
     
  21. Offline

    Kalman Olah

    EDIT: I'm so sorry, I didn't read your post, just checked out the config.yml :p.
    50.22.36.146 is YOUR IP. Give this IP access to your forum's database, and it should work.
     
  22. Offline

    Chrisspitz

    Sensor out your php pass in your webcode source. Lemme read some more maybe I can help
    EDIT: And do what Kalman said :p
     
  23. Offline

    Derrick Mehaffy

    Ah sorry i already edit that part after i copied it. So thats fixed already. Still same error.

    Either of you two have skype so we can talk in real time? I can pm you my skype name.

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

    Kalman Olah

    Go ahead. My skype email is [email protected]
     
  25. Offline

    Derrick Mehaffy

    Sent. Do you use voice or just text?
     
  26. Offline

    Kalman Olah

    Just text, I'm watching a movie and it's 5 am :)
     
  27. Offline

    thernztrom

    Just updated from 1.2.2 to 2.3.3! Worked perfectly fine, just moved over the info from the old config to the new (edit: and put in the new webfiles) :) Build #1000 here.
     
  28. Offline

    Kalman Olah

    Great :). Glad to hear it's working for you

    Seems like Permissions 3.1.6 can port over GroupManager's users.yml and groups.yml files. Also, Essentials 2.5 will include a plugin that maps the old GroupManager commands to the Permissions command, so if it's alright with you, I think I won't add GroupManager support, since the Essentials team also seems to be favouring Permissions right now.
    If you're still set on getting GroupManager support, reply to this post or PM me and I'll still add it.

    Updated to version 2.3.4
    • Various minor performance fixes. These probably won't afffect performance, funnily enough.
    • The /fpromote and /fdemote commands now require custom Permissions nodes to work. Let's say this is your promotion track:

      Code:
      '1': Banned
      '2': Default
      '3': Member
      '4': Builder
      '5': Guardian
      '6': Moderator
      '7': Admin
      '8': Owner
      If someone wants to promote someone to "Builder", he will need the bbb.promote.4 Permissions node. If someone wants to demote someone to "Builder", he will need the bbb.demote.4 Permissions node. If someone wants to promote a Builder all the way to Admin, they'd need the bbb.promote.5, bbb.promote.6, bbb.promote.7, bbb.promote.8 Permissions nodes.
      This does not affect /frank.
    @bocaj812 : Added your suggestion :). I didn't actually test this, so it'd be great if you could tell me if it works :p.

    In the coming days you can expect a couple of improvements, which could include customizable messages, and storing player info in the form of a SQLite DB instead of....a YAML file.

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

    Deadlystrike

    im upgrading from 2.1.3 is there anything that i need to change besides as u stated the permisions for promoting?
     
  30. Offline

    Kalman Olah

    Yeah, remake your config.yml, a bunch of shit was changed/added since 2.1.3
     
  31. Offline

    Deadlystrike

    dues it work on 1000
     

Share This Page