Inactive [INFO/ADMIN] LogBlock v1.54 - Enderdragon Logging! Tree Grow Logging! [1.4.5]

​

​

Version: 1.50​

​

Find and Backroll those Damn Griefers​

LogBlock release are on DevBukkit:
http://dev.bukkit.org/server-mods/logblock/

LogBlock dev builds:
http://ci.kitteh.org/job/LogBlock/

Please read the installation guide

I won't port LogBlock myself to mcAPI. Source code is available, so it shouldn't be to difficult for someone else to do it, also I'm still here. so I can answer questions. If there is more than one willing, that's up to you to handle that.




The reasons I take this step, are the usual: I quit playing Minecraft about 5 months ago and lastly I was struggling to keep up with updates. The developement of Guardian made slow progress, so I fear it won't be ready to fully replace LB in time.


Download latest dev build: Jenkins
View the source code: GitHub

​

Table of contents:

1. Description
2. Features
3. Why to use LogBlock
4. Example command
5. Older versions
6. Change log
7. Todo list / feature requests
8. Permission nodes
9. Plugins supporting this
10. Support the dev
11. How to post error messages
12. Advertizing

Description:

LogBlock logs block changes into a MySQL database. Block changes can be placed or destroyed block, explosions, burned blocks, sign text changes, chest access, leaves decay etc.
It can be used as griefer identification tool, to find out who build a particular building, or even roll back changes by certain players. Other purposes can be e.g: Undoing of forest fires
All additional features are optional, to keep the database as short as possible. All database actions run in their own threads to avoid server lags.
The use of permissions plugin (or any clone) is possible, but not necessary.
Uses Spout for chest logging (but it's fully optional, and there is no need for the client mod at all).

Features:

• Logging for block placing, block braking, fire, explosions, leaves decay, signtexts, lava flow and chest content
• Very mighty commands system, not only allowing to rollback and redo, but also to tp to blockchanges, delete log ingame etc. Full list of commands.
• Many parameters for lookup/rollback/redo/tp/clearlog commands: Block changes of one ore more player, in a specific area, in a world edit selection, specific block types only, block changes older or newer that a specific date, destroyed/created block only, in a different world and combinations of all these parameters. Full list of parameters.
• Rebuilding map after importing a backup (/lb redo)
• Last parameter to use the parameters of the last command
• Quick ingame lookup of block history a wood pickaxe or a bedrock block.
• All commands accessible from console (exept tools )
• Custom queries for tools.
• Different tool modes (lookup, rollback, redo, writelogfile and clearlog)
• Saves block data like wool color, log type, torch adjustment, etc
• Multiworld and multiserver support (some servers sharing the same database)
• BigBrother log import
• Loggable super pickaxe plugin (not to confuse with WorldEdit's super pickaxe)
• API
• Webstats

Why to use LogBlock:

Example commands: (thanks to tha d0ctor, read more about commands here)

/lb rollback player fire since 1d3h – rolls back fire 1 day 3 hours
/lb rollback player fire since 1d3h area 15 – rolls back fire 1 day 3 hours within a radius of 15 blocks

/lb rollback player thad0ctor since 1h - rolls back thad0ctor 1 hour
/lb rollback player thad0ctor since 1d area 5 – rolls back thad0ctor actions for the last day within 5 blocks
/lb rollback area 10 since 1h30m - rolls back all modifications within 10 blocks since the list 1 hours and 30 mins
/lb rollback area 10 before 06.11.2011 - roll back all changes in an area of 1o before June 11th, 2011
/lb rollback player thad0ctor since 05:36:00 - roll back all changes of thad0ctor since 05:36 (server time)


Download, Command, Configuration and Details:
http://diddiz.insane-architects.net/logblock.php

Changelog:
-> Full changelog

• LogBlock v1.50 # 81 (Dez. 13, 2011)
  Works with CraftBukkit 1.0.1-R1
  • Feature: /lb me shows the total block count
  • Feature: Chest logging without spout
  • Feature: Enderdragon logging
  • Feature: Logging for tree and mushroom grow (thanks to MD5 for the api)
  • Fix: Area param works again with default radius
  • Fix: Rollbacks got slowed down a bit to avoid rare server crashes
  • Fix: If mysql username, password or database only consist of unquoted numbers, LB will read them now
  • Config: World configs changed totally, some names changed and all logging options are now in an own section

• LogBlock v1.41 #63 (Nov. 15, 2011)
  Works with CraftBukkit recommended build #1337
  • Fix: Players with spawnTools permission are no longer allowed to spawn all tools.
  • Fix: Added a check to avoid "The permission xy is already defined!" errors

• LogBlock v1.40 #60 (Nov. 09, 2011)
  Works with CraftBukkit recommended build #1337
  • Feature: Custom auto ClearLog
  • Feature: Reduced error spam. Instead of like 40 line of error code, there is now just a warning stating the MySQL con
  • Feature: The queue will now be dumped after 10 tries even when the MySQL server is connected
  • Feature: Custom material names, allows naming custom blocks
  • Feature: LogBlock will now respond to messages when started without MySQL connection
  • Fix: Log import runs now async
  • Fix: Log import errors won't crash the server
  • Fix: Console commands work again
  • Fix: You can now use upper case letter in tool names (I don't know why you even should, but ...)
  • Config: Added clearlog.auto, clearlog.enableAutoClearlog in main config. Added materials.yml. Removed clearlog.keepLogDays
  • Permissions: Added 'logblock.spawnTools'

• LogBlock v1.32 (Oct. 04, 2011)
  Works with CraftBukkit recommended build #1240
  • Feature: Player info logging: firstLogin, lastLogin, onlinetime, ip. No ingame lookup yet.
  • Feature: /lb queuesize to see the current queue size
  • Fix: Door logging logs now also fence gates
  • Fix: Bukkit api break in CB #1191
  • Fix: time restriction works now as intended. Thanks to xrobau
  • Fix: Players with insufficient permissions can't smuggle bedrock from one world to another
  • Config: Added logPlayerInfo

• LogBlock v1.30 (Sep. 22, 2011)
  Works with CraftBukkit recommended build #1185
  • Feature: Chat lookup /lb chat player diddiz search +admin +sucks +dicks (more info)
  • Feature: Door logging
  • Feature: Dynamic tools, define your own tools
  • Feature: Use since and before to define a timespan
  • Feature: Enderman logging
  • Feature: cake logging (who ate it)
  • Config: Added logEndermen, logCakes and logDoors to world config and moved the tool section in main config.
  • Permissions: logblock.tool changed to logblock.tools.tool and
    logblock.toolblock to logblock.tools.toolblock.

Todo List:

https://github.com/LogBlock/LogBlock/issues

Permission Nodes:
https://github.com/LogBlock/LogBlock/wiki/Permissions

Plugins supporting Logblock:

List (open) List (close)

• DropPlugin
• Superpickaxe
• UndroppableDroppables
• PhysicalShop

When you want to appear your plugin here, tell me about

Support the developer (that's me ):
If you want to support me writing plugins or want to thank me for the plugin/support, you can: Suggest features I missed, report bugs (best with fix ), donate via PayPal, flattr my plugins, gift me The Witcher 2 (thanks to newyoukdaily), 2x 1GB DDR1 modules (thanks to HonestFlames), or send me the inner life of a laptop or netbook with a broken display (need it to build a model aircraft, so there is no need for parts like display and keyboard).

​

How to post error messages:


I won't aswer questions to general MySQL setup/installation/what is MySQL (there are lots of good tutorials out there, use google)
Please read the installation guide before asking a question about installation problems.
Please read the FAQ before posting a error report. It may be solved there.
In case of rollback or lookup problems: Type /lb savequeue and try again (when it's fixed then, it was a consumer problem, see FAQ)
When you post error messages, it's important to paste the whole stack trace!

Advertizing:

Newyorkdailys Plugin Support Buisness (open) Newyorkdailys Plugin Support Buisness (close)

Still can't get LogBlock working, or any other plugin? Are you getting errors in your console and cant figure out why? Newyorkdaily offers Basic/Advanced Plugin support.

• General/Advanced troubleshooting: FREE!
• Plugin Installations: 1-2 Plugins - FREE!
• 3 or More Plugins - $2

Click on the link below to connect to him now!
http://wbe001.mibbit.com/?settings=7cb4fd3cdd72754df475fb92a0b65f6c&server=irc.Mibbit.Net&channel=#CBPluginSupport

There is a LogBlock irc channel: #logblock at irc.esper.net.
You can ask me on skype. My name is 'hawky.diddiz'.

 

To my knowledge none of the plugins will modify the data value except for creaturebox. However that still uses 0-14.

I've just broken one of the spawners which triggers creaturebox. No problems in the log.
07-10 22:19:05 spathizilla created mob spawner
07-10 22:18:59 spathizilla destroyed mob spawner

 

One of my users was able to trigger the message by putting a half step on top of a half step, when it forms a full step. I verified this too with a magic carpet and no trails, so that one happens in uncorrupt chunk.
But yesterday a user caused that console message by putting a cloth block in a bad chunk, so maybe we're looking at 2 causes here. I'll keep looking into it, I haven't tested this thoroughly yet.

 

Hm, I accidentally removed setting too large values to 0. Will get next dev build out today

Yeah, double steps are known, but thanks. We're now hunting the third cause (second is flintandsteel).

 

Building giant wooden platform in the sky also triggered unknown actions. The unknown blocks were not in neat rectangle, but instead randomly spread out on the platform.

 

Hm, will check. Wonder what could cause it ...

 

what does this mean i get it all the time

 

@DiddiZ every time my mods try to rollback a player they're told they can't roll back more than 50 blocks. What's the new permission so they can get around that and do full rollbacks as needed?

 

DiddiZ. Please view this document Myself and a team of others have written About forking with a New MCbans project.

https://docs.google.com/document/d/14gnvZat-mTf5WSwGKBdYBJ4DwfDozIwChp8O2KljI1I/edit?hl=en_US

 

No jenkins yet?

 

Seriously the console spam I get is frigging INSANE now, can we at least get a flag to disable this??

09:42:18 [INFO] [LogBlock] Bukkit provided no block type for the block placed by Steppes at world:1338:651315. Please check the conditions this happened under, and report it to Diddiz or Bukkit.
09:42:18 [INFO] [LogBlock] Bukkit provided no block type for the block placed by Steppes at world:1339:651314. Please check the conditions this happened under, and report it to Diddiz or Bukkit.
09:42:18 [INFO] [LogBlock] Bukkit provided no block type for the block placed by Steppes at world:1338:651314. Please check the conditions this happened under, and report it to Diddiz or Bukkit.
09:42:19 [INFO] [LogBlock] Bukkit provided no block type for the block placed by Steppes at world:1339:651313. Please check the conditions this happened under, and report it to Diddiz or Bukkit.

Pages and PAGES of this spam.

 

@DiddiZ : UndroppableDroppables and my DropPlugin supports this plugin. You may want to add those to your list.

 

Check the FAQ, added some values there.

logblock.ignoreRestrictions
Forgot to put it to the wiki

Sounds interesting at first, but have to read it fully.

When I get the time, I'll play around with it a bit. Not sure yet about the gain and wether to use it.

Will get disabled for doublesteps today.

Sure

 

I have to restart the server, check if consumer works. If it does, fine, if it doesn't restart server again and hope now it works. Seems kinda random. (I get same timeout error every time, but sometimes the consumer works just fine, sometimes it doesn't.)

 

@Sh8kezula
The best way to submit the log:
Hook into LogBlock, get the session of the admin who wants to ban, get the queryparams of the last lb command, check wether it contains the player to be banned at all, set the sum mode to blocks, and then, not use the writelogfile function, but write an own command, extending AbstractCommand. See the source of commandshandler for that. That way you get the ResultSet and can do whatever you want with it, there's even no need to store it in a file, you could submit it directly.

Then better disable useBukkitScheduler.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Hmm, something's wrong, I'm unable to get MySQL working again.

Code:

2011-07-11 13:25:12 [INFO] [LogBlock] Version check: Your version is up to date
2011-07-11 13:25:12 [INFO] [LogBlock] Connecting to minecraft@jdbc:mysql://localhost:3306/minecraft...
2011-07-11 13:25:12 [SEVERE] [LogBlock] Error while fetching connection
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.
    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:407)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    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:407)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    at java.sql.DriverManager.getConnection(DriverManager.java:620)
    at java.sql.DriverManager.getConnection(DriverManager.java:200)
    at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:74)
    at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:201)
    at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:69)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:121)
    at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:356)
    at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:281)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:290)
    at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:480)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:465)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
Caused by: java.net.ConnectException: Connection refused
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
    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:254)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    ... 26 more
2011-07-11 13:25:12 [SEVERE] [LogBlock] Error while loading:
java.lang.NullPointerException
    at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:69)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:121)
    at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:356)
    at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:281)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:290)
    at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:480)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:465)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

I have created a database minecraft, I have created an user minecraft, the config is just fine with correct password but still fails. I tried BigBrother too, but seem to have the same issue. Also, I do have mysql-connector in my lib folder.

EDIT: And my config: http://pastie.org/2195847

 

I'd guess you mysql server is down.
/etc/init.d/mysqld restart

 

It should be up, I can do mysql queries from SSH. I'll try though.

Nope, didn't work. Same error.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

So you had it working before?
Otherwise I'd have guessed it's refusing TCP connections.
So you could try rebooting the server.

 

I did, a full "reboot" from root too. No luck. I did try connecting to another MySQL database hosted somewhere else, it worked, except it was blocking outside MySQL requests, of course. Well, it's this temporary host I'm on anyway, it has some performance issues anyway and will change hosts later on anyway.

 

Getting the same error as above this is the first time i am using this plugin. i am using cb #977
i am coming from bigbrother and that was working fine any ideas?

 

So I guess you're using the same connection data as for BB. Most likely you've typo in your config, like not quoting the pw, or something. You could post the relevant config here.

 

tables:
- lb-main
- lb-nether
loggedWorlds:
- world
- world_nether
mysql:
port: 3306
host: localhost
password: pass
user: username
database: minecraft
logging:
logBlockCreations: true
logBlockDestroyings: true
logKills: false
logFire: false
logChestAccess: false
logSignTexts: false
hiddenBlocks:
- 0
hiddenPlayers: []
logButtonsAndLevers: false
logLeavesDecay: false
logCreeperExplosionsAsPlayerWhoTriggeredThese: false
logLavaFlow: false
logKillsLevel: PLAYERS
logExplosions: false
clearlog:
dumpDeletedLog: false
keepLogDays: -1
questioner:
askRedos: true
askClearLogs: true
askRollbacks: true
rollback:
replaceAnyway:
- 8
- 9
- 10
- 11
- 51
maxArea: 50
dontRollback:
- 10
- 11
- 46
- 51
maxTime: 2 days
consumer:
delayBetweenRuns: 6
forceToProcessAtLeast: 0
timePerRun: 100
useBukkitScheduler: true
lookup:
toolID: 270
toolQuery: area 0 all sum none limit 15 desc silent
toolblockID: 7
toolBlockQuery: area 0 all sum none limit 15 desc silent
defaultDist: 20
defaultTime: 30 minutes
linesPerPage: 15
linesLimit: 1500
version: '1.20'

 

I can report the same issue, but not using BB and I am using the Craftbukket that was at Twitter, so that isn't #977.

"Version: git-Bukkit-unknown (MC: 1.7.3)
Plugins: AntiPistonDupe,AutoMessage,BukkitContrib,ChestLock,LogBlockQuestioner,LoginMessage,MinecraftViewer,RaddaChat,TextPlayer,WorldEdit,WorldGuard,LogBlock
Game Type: SMP
Game ID: MINECRAFT"

 

Looks good so far. But put the pw in single quoes.
What does LB says at start up? (the "connecting to ..." message)

Um, that really depends on your MySQL server. (local/remote, granted rights, etc)

I really should write en extended wiki page about

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

hey i have a big problem. logblock logs all block changes but the rollback dont work i make /lb rollback player NAME and then come "searching block changes from player NAME in the last 1515098112 minutes in world - 0 blocks found. rollback aborted" but in the history i can see the changes from this player

 

Log lock logs lock locks %)

 

last 1515098112 minutes? Sounds strange
try: /lb rb player <name> time 5 days

Lol
Fixed

@Juze
Just remembered: Sometimes it only worked when you entered your ip instead of localhost.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Would 127.0.0.1 work?

 

13:25:49 [INFO] [LogBlock] Version check: Your version is up to date
13:25:49 [INFO] [LogBlock] Connecting to username@jdbc:mysql://localhost:3306/mi
necraft...
13:25:51 [SEVERE] [LogBlock] Error while fetching connection
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai
lure

The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
116)

 

Added new wiki page:
https://github.com/DiddiZ/LogBlock/wiki/MySQL-Connection-Problems

I don't know, maybe. Could also be a problem with bind-address (look into your mysql config what's there).

You didn't set the mysql connection data in config.