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'.

 

Got 0.12b. It has survived beyond the 10 minutes it took 0.12 to run out of connections
No errors on start-up. Seems to be working great.

Damn those 2 missing lines of code!

Edit: Half an hour now and still going strong. I think it's safe to say it's been fixed! I also haven't had either of the problems that @MrAdam and @Zenergyx3 have had.

 

When I stop my server, the console gets spammed repeatedly with error messages concerning LogBlock. I couldn't close it. In the end I had to exit it by clicking the x. Hopefully my world saved properly.

 

You should set dumbDroppedLog to false. I used backslashes for the path ...

Yeeha

Hm, could I get the error log? Seems like LogBlock tried to save the remaining queue but failed.

 

Code:

[LogBlock Consumer] SQL exception
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '277718' for key 'PRIMARY'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:831)
	at de.diddiz.LogBlock.Consumer.run(Consumer.java:87)
	at java.lang.Thread.run(Unknown Source)
	at de.diddiz.LogBlock.LogBlock.onDisable(LogBlock.java:135)
	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:120)
	at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:528)
	at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:228)
	at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:222)
	at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:83)
	at net.minecraft.server.MinecraftServer.g(MinecraftServer.java:238)
	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:313)
	at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)

Not sure why I am getting this error, anyone have some ideas? MySQL seems to have an issue with two of the same keys or running out of space to put new entries.

 

Huh, MySQL autoincrement doesn't work?
Unique or repetitive occurrence?
The consumer is synchronized, so concurrent threads souldn't be the problem.

 

Nevermind, to anyone else having this problem here is a fix.

Open up your MySQL Database manager in my case Navicat. Navigate to your lb-main database and open it. Once there go to File > Design Table > Find in the row "id" under the column "Length" Adjust the value from 11 to something higher.

What was also interesting is I didn't see an entry for 277718....

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

 

Hm, that worked? Weird.
11 should be the maximun lenght for an int ('-2147483648', the largest number has 11 chars).
And the id should be able to contain up to 2 mrd rows by default. Copared to that, 277718 isn't that much.

Huh?
Hm, maybe the column got messed up somehow, and altering the datatype fixed that.
The errors doesn't make much sense

 

For the last 2 days I have been randomly crashing with Too many open files error... I deducted that I only have about 3 plugins that could cause the problem, and I have been systematically disabling plugins one by one to find it. This is the last plugin I seriously consider to be the culprit. Currently disabled and waiting to see if I get the error again, although having it disabled is really scarey...

 

As far as I know, LB never opens a file.
You could give me the error log, the stack trace is sometimes really informative.

 

The stack trace does not trace to a specific plugin...
This is a snippet of the log, the last error about too many files repeats literally thousands of times, I believe the other errors and failures are just because the threads grind to a halt, so I think they are just secondary failures to the main failure. On average my server was crashing every 2 hours or so, last time it crashed was probably about 4 hours ago. Before I restarted it I took your plugin out. My memory usage of the process is not pegged, there is NO lag on my server, and It has not crashed yet...

Code:

2011-04-10 21:54:17 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
2011-04-10 21:54:19 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
2011-04-10 21:54:21 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
2011-04-10 21:54:24 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
2011-04-10 21:54:25 [INFO] §7[Member]§f §ebigpete24§f§f§7:§f im rite here
2011-04-10 21:54:25 [INFO] [Gastronomic]: Can't create or find plugins/Gastronomic/Gastronomic.users for writing. Error occurred in savedefaults() from savePlayerHunger(). Please report!
2011-04-10 21:54:25 [INFO] [Gastronomic]: Couldn't find Gastronomic.users.
2011-04-10 21:54:25 [SEVERE] net.minecraft.server.MinecraftException: Failed to check session lock, aborting
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.PlayerNBTManager.b(SourceFile:65)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.World.j(World.java:1759)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.World.t(World.java:140)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.World.a(World.java:130)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.World.h(World.java:1401)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:359)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
2011-04-10 21:54:25 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
2011-04-10 21:54:25 [SEVERE] Unexpected exception
net.minecraft.server.MinecraftException: Failed to check session lock, aborting
    at net.minecraft.server.PlayerNBTManager.b(SourceFile:65)
    at net.minecraft.server.World.j(World.java:1759)
    at net.minecraft.server.World.t(World.java:140)
    at net.minecraft.server.World.a(World.java:130)
    at net.minecraft.server.World.h(World.java:1401)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:359)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
2011-04-10 21:54:39 [SEVERE] java.net.SocketException: Too many open files
2011-04-10 21:54:39 [SEVERE]     at java.net.PlainSocketImpl.socketAccept(Native Method)
2011-04-10 21:54:39 [SEVERE]     at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:358)
2011-04-10 21:54:39 [SEVERE]     at java.net.ServerSocket.implAccept(ServerSocket.java:470)
2011-04-10 21:54:39 [SEVERE]     at java.net.ServerSocket.accept(ServerSocket.java:438)
2011-04-10 21:54:39 [SEVERE]     at net.minecraft.server.NetworkAcceptThread.run(SourceFile:36)

 

I still get this every so often on the console, not sure if its something to worry about.

Code:

:[LogBlock ConnectionPool] Error while fetching connection

Sometime just a couple of lines, sometimes a bit more, no stack trace with any of it.

 

When LogBlock works (and the queue doesn't accumulate) it's only naggig, but not dramatic. The next consumer run will fetch a new connection.

 

Hello, what about to separate "build" and "destroy" logging in config file (like in BB)? Thanks for thinking

 

For what would that be good?

 

I will compare files when I get a chance.

 

Yup, I'll get the error log for you soon.

 

Hi I got a question. I set x,z and playerid to mediumint but still it says within 32767 blocks of you nothing found. Isn't it meant to be higher now? oO

 

Any news on sorting this damn schedule bug out? Its annoying that if I want to view the log or rollback a griefer, I need to stop the server just to get it to write the contents to Database.

At first I thought it was a CPU issue, but now with a 4 core processor on a new server, its still not writing the contents to database until the end :/

I know from reading this thread I'm not the only one. Please look into this one, even if its just a command we can run ingame to cause the buffered log to save.

Cheers

 

Command "/lb world" or "/lb me"?
Well, LB doesn't observe the data types in the db. You have to use "/lb area 999999" or "/lb player name 999999"

Does the issue persist with v0.12b?

 

Ive been using it for over an hour now and it would appear so, unless theres suppose to be a lag between actions happening and being saved. I got a user to place some blocks, ten minutes later there was still no log of it. Shut server down and restarted, log for it magically appeared

Dunno if this is useful:

23:36:38 [INFO] Plugins: CraftBookCircuits, bMobs, OddItem, NoCheat, LWC, WorldGuard, CraftBookMechanisms, mcMMO, CraftBookVehicles, GroupManager, WorldEdit, iConomy, BorderGuard, Help, Permissions, dynmap, MCTelnet, CraftBukkitUpToDate, MagicCarpet, DeathApple, iChat, iConomyChestShop, VoteTime, mcbans, LogBlock, Essentials, AntiGrief, MultiVerse, CraftBookCommon, EssentialsSpawn

 

Hm, the lag is supposed to be not longer than 6 seconds (delay in config).
Just wonder how your delay entry looks like.

 

Just updated to .12b and here is the results and info you requested. (Sanitized)
Previous Version in use [INFO] Logblock v0.11b enabled.
Updated to v0.12b

First Run (Dropped In Jar No Changes)

Show Spoiler Hide Spoiler

Code:

17:38:26 [SEVERE] [LogBlock] SQL exception
java.sql.SQLException: Can't create/write to file 'R:\MC-670\plugins\LogBlock\du
mb\lb-MysticForest-11-03-28-17-38-26.csv' (Errcode: 2)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
        at de.diddiz.LogBlock.ClearLog.run(ClearLog.java:39)
        at java.lang.Thread.run(Unknown Source)

renamed config.yml , ran server for regeneration of config. Changed some settings.
I also compared the files, even with all the rearrangment of config options it looks like only two differences were use permissions, and logfire. Which I thought I was using, and not doing repectively.

OldConfig (I just noticed is says .9e version btw)

Show Spoiler Hide Spoiler

Code:

driver: com.mysql.jdbc.Driver
url: jdbc:mysql://192.168.1.69:3306/minecraft
username: mc
password: password
delay: 6
keepLogDays: 14
defaultDist: 20
defaultTime: 30 minutes
toolID: 270
toolblockID: 7
toolblockRemove: true
logExplosions: false
logFire: true
logSignTexts: false
logChestAccess: true
logLeavesDecay: false
logTNTExplosionsAs: TNT
logCreeperExplosionsAs: Creeper
logFireAs: Fire
logLeavesDecayAs: LeavesDecay
usePermissions: false
worldTables:
- lb-MysticForest
worldNames:
- MysticForest
version: 0.9e
logFireballExplosionsAs: Ghast
dontRollback:
- 46
- 51
replaceAtRollback:
- 8
- 9
- 10
- 11
- 51
dumpDroppedLog: true

New Config

Show Spoiler Hide Spoiler

Code:

logCreeperExplosionsAs: Creeper
logLeavesDecayAs: LeavesDecay
defaultDist: 20
usePermissions: true
toolblockRemove: true
logFire: false
logFireAs: Fire
logChestAccess: true
password: password
logSignTexts: false
version: 0.12b
username: mc
dumpDroppedLog: true
logLeavesDecay: false
driver: com.mysql.jdbc.Driver
logTNTExplosionsAs: TNT
toolID: 270
defaultTime: 30 minutes
toolblockID: 7
url: jdbc:mysql://192.168.1.69:3306/minecraft
worldTables:
- lb-MysticForest
keepLogDays: 14
replaceAtRollback:
- 8
- 9
- 10
- 11
- 51
logFireballExplosionsAs: Ghast
worldNames:
- MysticForest
dontRollback:
- 46
- 51
delay: 6
logExplosions: false

permissions false same error, log fire true same error. Hope this helps. I set dumpDroppedLog:false for now

 

Thanks
You mystify me. I can't imagine any circumstances where the old config leads to an error and the new one doesn't. I compared the config line by line and found usePermissions, logFire and version different. The two first don't do anything related, and version does nothing at all (it's the version, the config file is created under, for later auto updater purposes).
A fixed a few bugs with log dumping today (I was using backslashes ) . Maybe this solves your issue too.

Wrote the command. "/lb savelog" will be added in next release.
Anyway, post your delay config entry.

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

 

is there a way to get red of this? didnt have it back in CB#556
011-04-12 04:40:31 [INFO] [LogBlock] Waiting for consumer ...
2011-04-12 04:40:31 [INFO] [LogBlock] Remaining queue size: 11203
2011-04-12 04:40:31 [INFO] [LogBlock Consumer] Queue overloaded. Size: 11203
2011-04-12 04:40:45 [INFO] [LogBlock Consumer] Queue overloaded. Size: 255
2011-04-12 04:40:45 [INFO] [LogBlock] Remaining queue size: 78

 

Ouch, seems like you have the same issue with the cunsumer. Damn bukkit scheduler, have to figure out, why it doesn't work. I suppose you don't really want to get rif of that, since LB is saving the log that's still in the queue before shutdown (and loosing the unsaved log).

 

umm, ok ill let u worry about it them XD

 

Uhm for some reason your plugin defaulted to putting - in the table names, making it an invalid MySQL table name and I cannot do anything to it.

 

Use backticks to escape: `lb-main`

 

Sorry to be a pain, but I hope you fix the Consumer issue soon. My server at some points has a queue accumulated with over 100,000 records at times and takes a ridiculous amount of time to process most of it

 

Released v0.12c
Hopefully fixed consumer and dump issues.