[INACTIVE] [ADMN] Albus v4.0 Final - Use forum grouping to control whitelist via MySQL [953]

Discussion in 'Inactive/Unsupported Plugins' started by Ant59, Feb 1, 2011.

  1. Offline

    Ant59

    Want to rank players with GroupManager/Permissions using your forum system instead? Use Warrant!

    [​IMG]

    [DistrictMine] Albus v4.0
    Whitelisting via forum grouping

    Albus is a whitelist plugin that allows admins to whitelist their servers, by grouping members in their forum. The Bukkit server will ask the forum's database - whenever someone logs in - whether their username in the forum has a group id that is allowed to join the server.

    This is especially good for subscription servers, where SMF subscriptions are used. It will completely automate the whitelist function for your minecraft server.

    Download JAR: http://dl.dropbox.com/u/29840218/Albus.jar
    Download MySQL Connector: http://dl.dropbox.com/u/29840218/mysql.jar
    View Source: https://github.com/Ant59/Albus

    Installation
    1. Place Albus.jar in your plugins directory
    2. Place mysql.jar (the mysql java connector) into the root of your bukkit server, in the same folder as craftbukkit.jar
    [SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5][SIZE=5]Configuration[/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE][/SIZE]


    All configuration settings can be found in the auto-generated properties file, found in plugins/Albus/Albus.properties​

    Properties and explanations

    kick-message - Message to display to players not on whitelist when they try to login​
    kick-message-registered - Message to display to players not in a whitelisted but registered on the forum. Making this blank will turn off this functionality, saving memory by not memorising all registered forum members.​
    mysql-host - The MySQL server IP or URL​
    mysql-port - Port of MySQL server (3306 by default)​
    mysql-db - Database to find member data​
    mysql-table - The table used for member data​
    mysql-user - Name of MySQL User​
    mysql-pass - Password for MySQL user​
    username-field - The field that your forum engine stores the user's minecraft player name​
    group-field - The field that your forum engine stores the group ids of users​
    allowed-group-ids - The group ids to which a user must belong to be allowed in​
    reload-period - Not yet used. In a future version, you may change the period of time between auto database checks from 5 minutes to any length.​

    I took my own time to make this plugin and distribute it and would really appreciate a small donation if you find it useful :) Thank you!

    [​IMG]
     
    nogoodwithnames, WolwX and Niemand like this.
  2. Offline

    Ant59

    Yes, that does sound like a nice idea. I have been planning permissions integration too, but I'm waiting for Bukkit native permissions to be released before going any further with that.

    Lol I'm glad it works for you now :D
     
  3. Offline

    brafenschlug

    Code:
    2011-03-19 01:19:50 [INFO] [Albus] v3.0 - Trying to load whitelist and settings...
    2011-03-19 01:19:50 [INFO] [Albus] v3.0 - Running database connection...
    2011-03-19 01:19:50 [INFO] com.mysql.jdbc.StatementImpl@43ccc48b
    2011-03-19 01:19:50 [INFO] [Albus] v3.0 - Whitelist Loaded
    2011-03-19 01:24:50 [INFO] [Albus] v3.0 - Trying to load whitelist and settings...
    2011-03-19 01:24:50 [INFO] [Albus] v3.0 - Running database connection...
    2011-03-19 01:24:50 [INFO] com.mysql.jdbc.StatementImpl@7ca2a618
    2011-03-19 01:24:50 [INFO] [Albus] v3.0 - Whitelist Loaded
    2011-03-19 01:29:50 [INFO] [Albus] v3.0 - Trying to load whitelist and settings...
    2011-03-19 01:29:50 [INFO] [Albus] v3.0 - Running database connection...
    2011-03-19 01:29:50 [INFO] com.mysql.jdbc.StatementImpl@44d10c4e
    2011-03-19 01:29:50 [INFO] [Albus] v3.0 - Whitelist Loaded
    2011-03-19 01:34:50 [INFO] [Albus] v3.0 - Trying to load whitelist and settings...
    2011-03-19 01:34:50 [INFO] [Albus] v3.0 - Running database connection...
    2011-03-19 01:34:50 [INFO] com.mysql.jdbc.StatementImpl@23426966
    2011-03-19 01:34:50 [INFO] [Albus] v3.0 - Whitelist Loaded
    2011-03-19 01:39:50 [INFO] [Albus] v3.0 - Trying to load whitelist and settings...
    2011-03-19 01:39:50 [INFO] [Albus] v3.0 - Running database connection...
    2011-03-19 01:39:50 [INFO] com.mysql.jdbc.StatementImpl@68743a3
    2011-03-19 01:39:50 [INFO] [Albus] v3.0 - Whitelist Loaded
    Would it be possible to set these to only one message? Maybe if one could choose which output you'll get in the albus proterties, logging=[none:standard:all] or something, where none is no messages in the log, standard is showing "Whitelist Loaded" only and all is like my logfile above.

    What do you think?
     
  4. Offline

    mooztik

    ok, wait & see :)
     
  5. Offline

    Nathan C

    Anyone managed to get this working with Mybb?

    If so let me know.
     
  6. Offline

    saladin1980

    Yes i am also curious as if this is working myBB as i just moved my whole database to be allowed to be connected to with this but if this is not working with it then i don't see all that work i did :) LOL want to make this so i can have the server in offline mode:)
     
  7. Offline

    seriosbrad

    It has been working fine on my MyBB 1.6 board basically since Albus was released.

    Here are my settings for MyBB.

    Code:
    group-field=usergroup
    kick-message=Sign up to BaronsOfBullshit.com to play\!
    mysql-port=3306
    mysql-db=MYSQL-DATABASENAME
    mysql-user=MYSQL-USERNAME
    username-field=username
    mysql-pass=MYSQL-PASSWORD
    mysql-table=mybb_users
    allowed-group-ids=2,3,4,8,10,11,13,15,17,19,20,22,24
    kick-message-registered=You are registered, but Banned\!
    mysql-host=MYSQL-HOSTNAME
     
  8. Offline

    saladin1980

    Now the key is does this still work with the latest update? 1.4 or CB 610+? if it is then this would be SOOO great:)

    And thnx for above i will use it if it works with the latest CB:)


    BTW tested and still works:) so this is a CB612 thing as well:)
     
  9. Offline

    moose517

    AFAIK its working with CB617, as i didn't have issues logging in, and when i stopped the server it said it was stopping as well. But i have other rogue plugins that i'm trying to sort out ATM to find bad ones.
     
  10. Offline

    Mr_Mellow

    does this still work? or is there something else i can use?
     
  11. Offline

    Tfs Halo

    Team plasma avatar ftw :D :D :D :D :D!!!
     
    Ant59 likes this.
  12. Offline

    Plague

    considered inactive
     
  13. Offline

    Zottelchen

    please dont be inactive! we need the plugin... can someone update it please?
     
  14. Offline

    Ant59

    If you really need it, then yes, I will update it :) I was thinking of actually getting it working again sometime tbh :) I wanted to add some extra functionality of shifting GroupManager groups in sync with forum groups :) Time to load up Eclipse and get back to some Java! :p

    Plugin Updated!

    No new features this release. However, everything is updated to work with CB #766 :)

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

    Ant59

    New plugin finished! You can now use the same format to control players' GroupManager rank on the server, according to their forum group!

    Try Warrant! http://forums.bukkit.org/threads/18175/
     
  16. Offline

    nimmis

    You have a bug in the code

    In Albus.java on line 156
    the line

    kickMessageRegistered = propConfig.getProperty(PROP_KICKMESSAGE);

    should read

    kickMessageRegistered = propConfig.getProperty(PROP_KICKMESSAGE_REGISTERED);

    so you get correct kick message when registred but not whitelisted

    Another fault in preventing registred but not whitelisted users to be detected is

    In Albus.java on line 179
    the line

    if (kickMessageRegistered == "") {

    should read

    if (kickMessageRegistered != "") {

    After these 2 changes registred but not whitelisted works with correct response message

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

    Phantom Index

    Says 4., but the download is 3.0 :/
     
  18. Offline

    Adrenaline

    hmm.. whos test it at WBB? (Woltlab burning board) :| really need for wbb3 :d
     
  19. Offline

    Kaikz

    Is it possible to make it read from the MySQL on player join, if they are in it, add the player to a flatfile whitelist, and reload that, thus letting the player in? I already have a large flatfile whitelist and I would rather not make all my users register to play again.
     
  20. Offline

    olimoli123

    Hey there, would you update this please? :]

    If you update, ill donate :D, just the delay function would be great

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

    Niemand

    Code:
    2011-08-25 14:30:44 [WARNING] [Albus] v3.0 - MySQL connection failed: java.sql.SQLException: null,  message from server: "Host 'serverip' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
    2011-08-25 14:30:44 [WARNING] [Albus] v3.0 - The following statement failed: SELECT username FROM mybb_users WHERE usergroup IN(4,6,9,2,8) AND username != ""
    2011-08-25 14:30:44 [WARNING] [Albus] v3.0 - Statement failed: java.lang.NullPointerException
    2011-08-25 14:30:44 [WARNING] [Albus] v3.0 - Failed to load whitelist
    sorry to troll but: what is this shit? it suddenly showed up, none of my ppl can connect to the server anymore...
     
  22. Offline

    ShaDooM

    "this shit" means:
    Host 'serverip' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
     
  23. Offline

    Niemand

    i solved that problem.

    but! is there any alternative plugin for albus, that works with CB1317? :(
     
  24. Offline

    Ant59

  25. Offline

    Aza24

    Heres an error I am getting. BTW this is my first time using MySQL so any help would be appreciated.

    Code:
    13:27:19 [WARNING] [Albus] v3.0 - MySQL connection failed: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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.
    13:27:19 [WARNING] [Albus] v3.0 - The following statement failed: SELECT user_login FROM wp_users WHERE whitelist IN(1) AND user_login != ""
    13:27:19 [WARNING] [Albus] v3.0 - Statement failed: java.lang.NullPointerException
    13:27:19 [WARNING] [Albus] v3.0 - Failed to load whitelist
    Do you need to open a port for this to work?
     
  26. Offline

    radie1230

    Code:
    28.11 20:16:26 [Server] WARNING [Albus] v3.0 - Statement failed: java.lang.NullPointerException
    28.11 20:16:26 [Server] WARNING [Albus] v3.0 - The following statement failed: SELECT username FROM xf_user WHERE user_state IN(valid) AND username != ""
    28.11 20:16:26 [Server] INFO The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    28.11 20:16:26 [Server] WARNING [Albus] v3.0 - MySQL connection failed: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    My error code ^^^ descending order from latest to oldest.

    I am 100% sure that the mysql connection information is correct. It just cannot seem to connect to my database before it is even given the chance to query. Please help.

    This seems to be the same problem as Aza24 above me.
     
  27. Offline

    Daniel Akkanen

    Worked perfect with bukkit build #1576
     
  28. Offline

    gjosse

    Hello
    I am getting a problem connecting to the database...
    I am sure that the username and pass are correct but i get that it can't connect?
    Code:
    3:33:27 [WARNING] [Albus] v3.0 - MySQL connection failed: com.mysql.jdbc.except
    ions.jdbc4.CommunicationsException: Communications link failure
    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
    23:33:27 [WARNING] [Albus] v3.0 - The following statement failed: SELECT user_lo
    gin FROM wp_users WHERE whitelist IN(1) AND user_login != ""
    23:33:27 [WARNING] [Albus] v3.0 - Statement failed: java.lang.NullPointerExcepti
    on
    23:33:27 [WARNING] [Albus] v3.0 - Failed to load whitelist
    Whats wrong???
     
  29. Offline

    vxldigitz

    ok i am haveing major issuies with this plug in i have every thing set up right but i keep getting this code

    2012-01-12 21:51:27 [WARNING] [Albus] v3.0 - MySQL connection failed: java.sql.SQLException: Access denied for user 'user'@'localhost' (using password: YES)
    2012-01-12 21:51:27 [WARNING] [Albus] v3.0 - The following statement failed: SELECT user_login FROM wp_users WHERE whitelist IN(1) AND user_login != ""
    2012-01-12 21:51:27 [WARNING] [Albus] v3.0 - Statement failed: java.lang.NullPointerException


    please some one help me i need this plugin on my website. if it cant be fix are there any other plugins like this one?
     
  30. Offline

    EHAndrew

    Are we possibly going to see this updated for R5?

    I know this thing is old, but we love it on our server please don't let us down :)
     
  31. Offline

    jodom1979

    I'm so so excited for this plugin to work. I don't really know whats involved, but I would love to see this working. Nothing else like this exists. Gladly donate! Thanks for the hard work!

    Oh yea..... Here is what I get. Let me know if you need anything else!

    Code:
    2012-03-03 10:00:35 [SEVERE] Could not load 'plugins\Albus.jar' in folder 'plugins'
    Caused by: java.lang.NoClassDefFoundError: org/bukkit/event/player/PlayerListener
    Caused by: java.lang.ClassNotFoundException: org.bukkit.event.player.PlayerListener
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 8, 2016

Share This Page