[INACTIVE][SEC] BigBrother 1.7.1: A Complete Griefer Logging + Rollback Package [531]

When a person gets tolled back is it possible that with the MySql implementation now it checks if someone else has already done something else so for example if I do a full rollback on someone instead of just replaceing it with it's last block it does this
(before)
Other-Non-Griefer Places Wood Block
Griefer Destroys Dirt Block
Non-Griefer Places Dirt Block

then if the griefer gets rolled back it should not change the dirt block unless the other non griefer gets rolled back too.

Can you also add a way to tell ingame when someone built something. Like when you do /bb here it tells you a date and time?

i got an error when joining,
Severe BBrother: Data Insert SQL Exception (cnf) using sqlite or the same but with mysql instead of sqlite depending on what i choose in the settings file

@Queepo:
You need to make sure you have the SQLite dependency (or MySQL if you're using MySQL) in the same directory as Craftbukkit.jar.

Also, I'll have an update with a few new things up in the next few days

thanks for the response and im excited for BBrother's new updates as it has been by far the most useful plugin I have, however I have no experience with MySQL and have no idea how to set it up. Can you point me in the right direction?
Thanks

edit I have the mysql jar file in the plugins directory but still the same error, im obviously not doing this right lol any help would be good thanks.

If you don't have MySQL already set up, I'd recommend just using the SQLite setting. If you have the dependency library; after you load, everything will be automatically set up and ready to go.

Can I use this without SQL?

This needs to be updated, it doesn't woerk due to the missing class "Color" that was renamed in the recent bukkit update.

Please update it!

Can somebody help me with that SQLite ? some video or smt. I really need this plugin, but it shows errors in the console. help?

It's pretty simple. In the BigBrother settings just set use MySQL to false. Make sure you downloaded the SQLite independacy library and put it in the same folder as craftbukkit, then it should work fine. Although, this is broken from the last update.

I'ts not simple because I can't find where I can download it
Well... ned to update this

Uses old Color.class which is now ChatColors.class needs to be updated.

@Racha: The download to the SQLite library is in the OP, just place the .jar in your the folder holding CraftBukkit.jar.

Also, here's the 1.2 update (for the 1.2 MC update). It fixes compatibility with Bukkit as well as a couple other things.
- If BB can't establish a connection with it's database, it saves the data to try to send later.
- Undoing a rollback will update the database, so you can later rollback what you had undone.
- Logging of buttons, door openings, and lever switches!

Because I had to push out the update early, some of the things I wanted in 1.2 aren't in there, but I should have another update later this week with that stuff

Is there something special I need to do to install this on my Linux MC server? I downloaded the files and ran it and got this error:

2011-01-14 15:37:43 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-14 15:37:43 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.

After downloading the MySQL dependency library and putting it with craft_bukkit.jar I get the following error:

2011-01-14 15:48:28 [SEVERE] [BBROTHER]: Data Insert SQL Exception
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at me.taylorkelly.bigbrother.datablock.DataBlockSender.sendBlocksMySQL(DataBlockSender.java:81)
at me.taylorkelly.bigbrother.datablock.DataBlockSender.sendBlocks(DataBlockSender.java:49)
at me.taylorkelly.bigbrother.datablock.DataBlockSender.access$0(DataBlockSender.java:39)
at me.taylorkelly.bigbrother.datablock.DataBlockSender$SendingTask.run(DataBlockSender.java:210)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:310)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:176)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:163)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
at java.net.Socket.connect(Socket.java:546)
at java.net.Socket.connect(Socket.java:495)
at java.net.Socket.<init>(Socket.java:392)
at java.net.Socket.<init>(Socket.java:235)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
... 17 more

seeing this..

@Mhalkyer: Do you have MySQL set up on your server? If so, you have to change the username, password, and database in bigbrother.properties to match what you ned. If not, the easiest thing to do is change mysql=false in bigbrother.properties and use SQLite (you'll need that dependency library if so).

@fffizzzz: I'll get a fix up for that tonight or tomorrow.

You the man, thanks!

Nice plugin but i notice when you rollback damage the greifer keeps any gains.
ie:i pickaxe someones house down,the house gets rebuilt in a rollback but i still have eveything the house was built with. is this a known bug or would it be possible to log the players pack as well and delete the gain also?

Amazing mod. For the MySQL stuff, I found downloading the newest jdbc driver from MySQL helped.

Would it be possible to remove (or toggle) the debug code from line 82 of DataBlockSender? I refer specifically to the entry that posts "test" to the log file on each update. On a busy server it fills up the log pretty quick. A debug option for that would rock in general, though.

@jolt76: Well, I would think that if you caught the griefer you'd just ban him I don't really plan to add a inventory cleaner to it, there will probably be other plugins that'll do this.

@atomicben: Yea, I realized that I left that in there. I've removed it in the next version that also fixes the problem that fffizzzz was having; I'm currently testing that out before I release it.

@tkelly *hero* thanks kindly! We're stoked by the volume of blocks our crew has been pushing (130k events in a few hours)! Busy little bees, and the server is just purring away. We haven't touched much from the roll back stuff, I'm not sure we will, but given any bug reports we find, we'll be sure to post.

Wow, with that many events, I definitely need to know how rollbacks and scalability goes for you.

Also, here's the update that fixes that "test" spamming, the problem fffizzzz pointed out, as well as adds configuration for the number of seconds in the intervals when it sends info to the database (defaulted and recommended 4). It's called sendData in bigbrother.properties.

Let me know if you have any problems with the update because it's updating the SQL table (and in the case of SQLite, making backups and copies). So there is room for error.

"BigBrother.properties"

Where is this file? It's not in the .zip.

Is there any reason I can't use WAMP for MySQL?

It'll be generated by BB on startup in a folder called "BigBrother".
I'll probably start including it in the zips, but here's the defaults:

Code:

mysqlPass = root   #Password for MySQL db (if applicable)
MySQL = true   #If true, uses MySQL. If false, uses Sqlite
mysqlUser = root   #Username for MySQL db (if applicable)
mysqlDB = jdbc:mysql://localhost:3306/minecraft   #DB for MySQL (if applicable)
autoWatch = true   #Automatically start watching players
sendDelay = 4   #Delay to batch send updates to database (4-5 recommended)
defaultSearchRadius = 2   #Default search radius for bbhere and bbfind
flatFileLogs = true   #If true, will also log actions to .logs (one for each player)

I'm not familiar with WAMP, I see no reason why it wouldn't work if it's just packaging MySQL in there.

2011-01-14 23:53:40 [INFO] [BBROTHER] Updating table for 1.3
2011-01-14 23:53:44 [INFO] BigBrother 1.3 initialized


Lookin' good so far.
--- merged: Jan 15, 2011 7:04 AM ---
CHEST
CHEST
CHEST
CHEST
CHEST
WORKBENCH
CHEST
CHEST
CHEST
CHEST
CHEST
CHEST

Still some output like that; but that's fine.

Logging wise, and I'm generalizing my statement, is there a plan or any ideas on how to get mods to realign good information to the server.log as how many of the hMods did? I don't mean to de-rail your thread by the question, if I have missed an article or posting elsewhere I humbly apologise, and would appreciate being pointed in the right direction.

You must've ninja'd me to the download, cause I snuck in an non-update (same dl-link as 1.3) that removes that. So if you redownload 1.3, it'll fix that CHEST spamming.

And I'm not sure what you're asking about the logging, so let me know if I'm talking about the wrong thing: It's really up to the plugin maker to log good information, but posts like yours help keep them in check (ie. random debug spammings that they forgot). So definitely recommend things to plugins that you think could log better info.

How do you limit commands to certain people?


EDIT: Also, when entering a command I get the output 3-4 times.

1.3.1 Updated for new constructor.

Shoie13: No way to limit commands right now, but I'm planning (in the next update) to limit all BB commands to OP's

Code:

2011-01-15 13:37:50 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using s

How to stop this spam? - Also ingame commands does not work for me.

me again
now its a diff column..

Code:

2011-01-15 08:45:31 [SEVERE] [BBROTHER]: Data Insert SQL Exception
java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'y' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
        at me.taylorkelly.bigbrother.datablock.DataBlockSender.sendBlocksMySQL(DataBlockSender.java:97)
        at me.taylorkelly.bigbrother.datablock.DataBlockSender.sendBlocks(DataBlockSender.java:49)
        at me.taylorkelly.bigbrother.datablock.DataBlockSender.access$0(DataBlockSender.java:39)
        at me.taylorkelly.bigbrother.datablock.DataBlockSender$SendingTask.run(DataBlockSender.java:209)
        at java.util.TimerThread.mainLoop(Timer.java:555)
        at java.util.TimerThread.run(Timer.java:505)
2011-01-15 08:45:31 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.