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

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



[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!

​

 

Also, I have another use case you might want to modify your database query for. We have an online forum community that does not center on minecraft, but we run a minecraft server for some of our members. The whitelisting policy we are looking to implement is that in order to get on the minecraft server, the user has to add their minecraft username to their forum profile. Forum usernames don't usually match minecraft usernames though. The nice thing about this plugin is that you can specify what column to use for the minecraft username. The problem though is that most of the records in the members table will not have anything set for the minecraft username. Your current query, as of couple nights ago (haven't looked at your source yet today), does not filter out blank usernames. I'm not sure how your plugin handles blank usernames, since I wasn't able to fully test it the other night, but you can easily modify your query so that it will remove blank usernames by doing something like this...

Code:

SELECT <username> FROM <table> WHERE <group> IN(1,2,3) AND <username> != "";

Also, can you make it so we can disable the group check? Maybe if the variable is left blank in the config file, use a slightly stripped down version of the query, and if there is something there, use the current query. The user group feature is nice to have, but our use case doesn't have a need for it, and I'm not a huge fan of having to write out every user group we have in our forum.

Thanks for the work you've done on this!

 

I have given all the info to Albus yet I get this error.

Code:

2011-02-17 02:25:42 [WARNING] [Albus] v2.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.
2011-02-17 02:25:42 [WARNING] [Albus] v2.0 - The following statement failed: SELECT minecraft FROM jos_users WHERE null IN(null)
2011-02-17 02:25:42 [WARNING] [Albus] v2.0 - Statement failed: java.lang.NullPointerException
2011-02-17 02:25:42 [WARNING] [Albus] v2.0 - Failed to load whitelist

I am pretty sure I have filled in all the correct info, and even went as far as forwarding the port 3306 (which was probably unnecessary).

Help.

 

Looks like it is trying to select a field called 'Minecraft' from a table called 'jos_users'. Is that what it is supposed to be doing?

 

The problem is that the plugin can't connect to your database. All the other errors stem from that, because its trying to query something that doesn't exist, thus the NullPointerException. Double check your username and password. Is your minecraft server running on the same machine as MySQL? If not, you may need to modify/add a user account to MySQL, since MySQL filters connections based on username and host. It also looks like you don't have anything set for group-field or allowed-group-ids, which as far as I can tell is required for the plugin to work.

 

Do you have any plans to support other forum installations? (Vbulletin, perhaps?

 

ATM what's the whitelist reload period ?

 

I can't find any mybb_userProfiles table in the MyBB documentation: http://wiki.mybb.com/index.php/Database_Tables
--- merged: Feb 17, 2011 10:12 AM ---

The current reload period is every 5 minutes, or when /albus reload is used
--- merged: Feb 17, 2011 10:13 AM ---

Ok, I have added an empty field check for you Plugin UPDATED!

 

This doesn't really fit in here but does anyone know a phpbb paypal ipn mod/hack?
Like you pay 1€ via paypal, and you get moved into another group in phpbb. I tried some but none of them work on the latest version of phpbb.
I'm asking because that phpbb mod would fit perfectly with this plugin or wouldn't it? ^^

 

Ah, I said the wrong groups. It seems to be mybb_users that stores groups and mybb_userfields that stores custom fields.

 

SMF is the best forum engine to use for subscription based groups, which is what this plugin was originally designed for.

Would it not be easier for users to user their minecraft username as their forum username? Then allow them to change their display name on the forum (idk if this is possible through MyBB).

 

@ShaDooM: Not wanting to steal this thread, but check the latest version of my Whitelist in my sig(the plugin Albus was based on once). It works now with every database engine and every table layout, as you have to specify the sql querys by yourself.

However, I agree with Ant59, SMF is a great system and this plugin makes it easy to use, you should consider using that instead of phpbb

 

Oh I see how it is Silence, I build on your plugin, and you go and add my functionality to yours, eh? Haha jokes. It's entirely up to server admins to chose what they want to run. Albus is just easier to configure, and more stripped down

 

Nah, SQL was on roadmap, before you forked it

And yes, its exactly like you said: Whitelist SQL sets flexibilty over simplicity and honestly I would use yours when I would like to use SMF as auth source, so good work

 

Thanks Silence This is my first plugin, so I'm glad it turned out ok. Cheers for the awesome work on Whitelist since in the end I did pinch some of your code

 

vBulletin® v3.8.2
Craftbukkit Build #304-349 (Verified on these builds)

vBulletin Setup:

Groups (Default):

8 = Banned Users
7 = Moderator
6 = Administrator
5 = Super Moderator
4 = Users Awaiting Moderation
3 = Users Awaiting E-mail Confirmation
2 = Users
1 = Unregistered / Not Logged In

Code:

mysql-port=3306
mysql-host=localhost
mysql-db=
mysql-user=
mysql-pass=
mysql-table=user
group-field=usergroupid
username-field=username
kick-message=You are not on the whitelist\!
allowed-group-ids=7,6,5,2

Just set mysql-db mysql-user & mysql-pass and should work off the bat with all registered users.


Testing with removed userclass 6

Code:

2011-02-17 22:59:36 [INFO] [Albus] v2.0 - Running database connection...
com.mysql.jdbc.StatementImpl@1abcc03
2011-02-17 22:59:37 [INFO] [Albus] v2.0 - Whitelist Loaded
138 recipes
2011-02-17 23:00:20 [INFO] [Albus] v2.0 - Direct1221 tried to join and was kicked.
2011-02-17 23:00:20 [INFO] Disconnecting Direct1221 [/**.***.***.***:1755]: You are not on the whitelist!

Testing with userclass 6 added

Code:

2011-02-17 23:00:43 [INFO] [Albus] v2.0 - Running database connection...
com.mysql.jdbc.StatementImpl@7f5580
2011-02-17 23:00:44 [INFO] [Albus] v2.0 - Whitelist Loaded
138 recipes
2011-02-17 23:00:48 [INFO] [Albus] v2.0 - Direct1221 tried to join and was allowed.
2011-02-17 23:00:48 [INFO] Direct1221 [/**.***.***.***:1758] logged in with entity id 7
Player count: 1
2011-02-17 23:00:54 [INFO] Direct1221 lost connection: disconnect.quitting

 

It may be easier to make their forum names their minecraft names, but I already have over 50 people registered. Thanks for the support so far, may use this on the future if I ever restart everything.

 

what forum are you using? I can try to see what i can work out for you for minecraft names.

 

I am using MyBB forums, with custom user fields for minecraft names.

 

Okay well set your custom field in your database to the field required for the minecraft names. If need be, I will completely write something to allow the user field to be used with ease.

 

please update the download link!
https://github.com/downloads/Ant59/Albus/Albus.jar
is DOWN!

What version of SMF do we need?

 

This is the version I am running (I believe it is just 2.0):
http://files.odinseye.org/Albus.jar

Also, it does not matter which version of the forum software you are running, as long as you get the database info correct.

 

http://38.99.170.107/downloads/albus/Albus.jar - Albus v2.1
http://38.99.170.107/downloads/albus/mysql.jar - MySQL Connector

 

is it possible to add people ingame to the whitelist such as "/whitelist add PLAYERNAME" ?
If not, will it be implemented?

 

Great stuff..

Implemented my craftbukkit with vbulletin just fine..
CHEERS!!!

 

This plugin is fantastic. I would absolutely love if somehow when we /ban in-game it will put the user on the forum in a specified banned group as well.

 

this plugin is useless without password confirmation

 

Download links fixed!! Sorry for the inactivity and neglecting to update them.

You don't make any sense :S

 

for example - I can login into your server with any of your forum members usernames, isn`t?

 

Go ahead. But you don't know their minecraft passwords :S

 

If the server is in offline-mode you can use Anjosecurity.
http://forums.bukkit.org/threads/se...r-registration-326-353.4497/page-3#post-72951

The cracked launcher doesn't need any password, this is why I guess he is asking. You should buy the game.

Anyway nice plugin I'm looking forward to try it.