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

Discussion in 'Inactive/Unsupported Plugins' started by DiddiZ, Feb 15, 2011.

  1. Offline


    Version: 1.50​
    Find and Backroll those Damn Griefers
    LogBlock release are on DevBukkit:

    LogBlock dev builds:

    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

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

    • 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 :D)
    • 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:

    -> 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.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 and
        logblock.toolblock to
    Todo List:

    Permission Nodes:

    Plugins supporting Logblock:
    List (open)

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

    Support the developer (that's me :D):
    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 :D), 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!

    Newyorkdailys Plugin Support Buisness (open)
    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!

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


  3. Offline


    Thats an error report how it should be :D
    But the entry most likely causing that, you did't mention.
    Does your worldTables look like:
     - lb-main
     - lb-nether
  4. Offline


    Thank you, all works fine now:
  5. Offline


    When placing signs, I get:
    [COLOR=rgb(0, 0, 0)][SIZE=12px][FONT=Arial]2011-04-05 13:44:28 [SEVERE] [LogBlock Consumer] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's] [Plot/House] [] []')' at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
    at java.lang.reflect.Constructor.newInstance(
    at com.mysql.jdbc.Util.handleNewInstance(
    at com.mysql.jdbc.Util.getInstance(
    at com.mysql.jdbc.SQLError.createSQLException(
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    at com.mysql.jdbc.MysqlIO.sendCommand(
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
    at com.mysql.jdbc.ConnectionImpl.execSQL(
    at com.mysql.jdbc.ConnectionImpl.execSQL(
    at com.mysql.jdbc.StatementImpl.execute(
    at com.mysql.jdbc.StatementImpl.execute(

    Should I be worried about that? Please "like" my post when you reply so I get notified!
    DiddiZ likes this.
  6. Offline


    but how to rollback creepers esplosion..

    and can u add a rollback command without time online with area and player ?
  7. Offline


    Hm, the syntax looks good.
    Does that happen with all or specific signs?
    Disabling of sign text logging should avoid that error.
    /lb rollback player creeper
    time online?
  8. Offline


    I said in my earlier post that the issue was resolved. My provider was giving me the wrong information...
  9. Offline


    Does this have to use MySQL or can it use SQLite??
  10. Offline


    What happens if someone was to actually try this on the real bedrock .. layers 1-5 ?
  11. Offline


    Huh? It would still work... By right clicking with a bedrock block it will check then remove it (just the one you place.)
  12. Offline

    Chris Lewis

    Pardon me for my ignorance but im trying to understand the syntax for the commands...

    /lb rollback player [name] <time> <minutes|hours|days>
    /lb rollback area [radius] <time> <minutes|hours|days>
    /lb rollback playerarea [name] [radius] <time> <minutes|hours|days>

    /lb rollback selection <time> <minutes|hours|days>

    I must be a noob but i have been trying the following:
    /lb rollback player Broland 10 - this results in asking me to correct the syntax
    /lb rollback player Broland 10m - this results in asking me to correct the syntax
    /lb rollback player Broland time:10 - this results in asking me to correct the syntax
    /lb rollback player Broland time 10 - says rolling back and gives green codes as if it was working but says rollingback by 0 minutes

    This is also prettry much the same for the radius. I guess i am just not figuring it out?
    Maybe its just me but it would be great if we could perhaps use these syntax:
    /lb rollback (Name) (radius) (time) - where time is m,h,d
    which would look like /lb rollback Broland r:10 t:5m
    then if one variable wasn't provided it would defualt to a set thing. I.E if no name it would just do all in that area, no time would defualt to 30m, no r would default to 20...
  13. Offline


    yes a command that rollback player action on specific area without time specified..
  14. Offline


    On b617, just copied and pasted my mySQL url from BigBrother to the lb config, figured it'd work. Guess not :p
    Any additional configs will be supplied if needed.
  15. Offline


    @Chris Lewis
    The syntax is:
    /lb rollbacl player diddiz 5 minutes
    /lb rollback area 20 999 days
    /lb rollback area 5
    The time is optional
    Oh, it's okay. But if LB has problems to access to the mysql connector, and other plugins are using mysql, or sqlite LB for some reason runs amok.
    LB sometime downloads the connector, but isn't abloe to connect to it. In most cases a restart solves the issue. If not, you'll have to post the files in the lib/ folder and the inside the LogBlock.jar.
  16. Offline


    I have a number of plugins running sqlite, but no other ones running mySQL. Also, I didn't clear out the BB tables nor did I convert them. Is that causing the problem?
    VVVVVLib under VVVVVV
  17. Offline


    No, BB tables doesn't matter, and import also isn't required.
    Connector is there, manifest looks good.
    LB is still trying to get a sqlite connection from another plugin.
    Did a restart hava any effect?
  18. Offline


    Nope, restarted a couple of times
    Here is my config for lb
  19. Offline


    Looks also good. So everything is set up properly, but LB can't access to the connector. That's kind of weird. If LB could download the file, I assume LB has rights to access it.
    You could delete the connector.
  20. Offline


    Deleted the connector, restarted a bunch of times, no dice.
  21. Offline

    Chris Lewis

    Ok thanks for the help on the syntax, thats makes things easier.
    My console is outputting this... should i be worried or what do i need to do to make this go away?

  22. Offline


    Found an error!

    You're not escaping queries on sign text! That means someone could create a sign like `; DROP TABLE lb-main;

  23. Offline


    Just tested this by creating a fire and blowing up TNT.
    Seems good. I like the info output.

    But rollback didn't replace a sign or doors that were destroyed. Is that by design? Will it ever log them? Or did something go wrong and it should have?

    I note the server log is full of these lines :-

    [INFO] [LogBlock Consumer] Queue overloaded. Size: 138

    Are they just warnings or is it losing data? Is that potentially where my doors went? Can I increase a queue or setting somewhere to stop this?

    Edit: Further testing. Poured some lava on top of a house. That didn't really end positively. I couldn't get rid of the lava or get the house back as was (with signs and torches etc). Perhaps some manual intervention would have helped, but...

    I guess those excited about the speed would get just as fast speed from bigbrother if it didn't log lava (that being the primary cause of lots of rows) Unfortunately, people grief with lava, so unless there's something I'm missing, it seems to me logging lava flows is a necessary evil for a plugin like this.

    Lastly, please, please, please consider removing the lb- from the front of the table names. It's completely unnecessary (the database name provides a namespace, call your database "lb" and there's your lb.main without needing the ugly - ) Why? Well, it means having to type `` around table names in mysql client.
  24. Offline


    Would you be able to log chat and commands as well? I'd donate even more if you did that!

    EDIT: Just got this error:

  25. Offline

    Chris Lewis

    Noticed a few things or perhaps rather had a few questions
    1- does this work with the new 2.5.5 permissions? because i have permissions negated for the player to be able to see history and yet when they place a block they can see it.
    2- feature request: enable/disable the blocks so we can use things more common. i.e. /lb tool = gives you the tool and saves the place in the inventory slot /lb block would give you the block and saves the inventory slot and when you do /lb none it returns everything back to normal
    3- feature request: the syntax request i made earlier

    Overall i really appreciate this plugin as it basically took the place of a failing BigBrother. I appreciate the work you devs do!
  26. Offline


    Howdy. The url CraftBukkitUpToDate is using is returning an error:
    17:42:24 [INFO] Not able to update LogBlock.jar check if URL correct. If not ask
    the Author to give me the new one
    Just a heads up.
  27. Offline

    Ben Quincy

    any one gona help me set up a database?
  28. Offline


    Just google it.

    The basic steps are

    - Install mysql.
    - Create a user for mysql (don't use root)
    - Create the database (call it what you want)
    - grant privileges on the database you just created to the user you created
    - edit the config.yml of logblock using the user, password and name of the database you've just created. It should be obvious where you put user and password, the name of the database is the last part of this line :-

    url: jdbc:mysql://localhost:3306/db

    So, if your database is called logblock change db to logblock.

    This line also assumes you have mysql running on the same machine "localhost" and default port ":3306" - if that's not the case, change these accordingly.

    If you get stuck, googling the relevant part should find a million or so pages. e.g, if you get stuck creating a user for mysql, google "creating a user in mysql" and you'll get thousands and thousands of pages explaining how to do it. And so on for the other steps. In fact, you'll probably find a few thousand pages describing all the steps together, one at a time - except the last one.

    It's exactly the same doing the steps for this plugin, as it is for anything else that uses mysql that asks you to create a database. The only part that is specific to this plugin is the bit where you edit the config.yml.
  29. Offline


    This is the error i am getting when i start my server :
    00:17:03 [INFO] Locker 1.3.3 is enabled. Loaded 0 blocks.
    00:17:03 [SEVERE] [LogBlock] Can't get a connection
    java.sql.SQLException: Access denied for user 'pizclassy'@'localhost' (using pas
    sword: NO)
            at com.mysql.jdbc.SQLError.createSQLException(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.secureAuth411(
            at com.mysql.jdbc.MysqlIO.doHandshake(
            at com.mysql.jdbc.ConnectionImpl.coreConnect(
            at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
            at com.mysql.jdbc.ConnectionImpl.createNewIO(
            at com.mysql.jdbc.ConnectionImpl.<init>(
            at com.mysql.jdbc.JDBC4Connection.<init>(
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            at com.mysql.jdbc.Util.handleNewInstance(
            at com.mysql.jdbc.ConnectionImpl.getInstance(
            at com.mysql.jdbc.NonRegisteringDriver.connect(
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at bootswithdefer.JDCBPool.ConnectionService.getConnection(ConnectionSer
            at bootswithdefer.JDCBPool.JDCConnectionDriver.connect(JDCConnectionDriv
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at de.diddiz.LogBlock.LogBlock.getConnection(
            at de.diddiz.LogBlock.LogBlock.onEnable(
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(
            at net.minecraft.server.MinecraftServer.e(
            at net.minecraft.server.MinecraftServer.a(
            at net.minecraft.server.MinecraftServer.d(
    00:17:03 [SEVERE] [LogBlock] Exception while enabling
            at de.diddiz.LogBlock.LogBlock.onEnable(
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(
            at net.minecraft.server.MinecraftServer.e(
            at net.minecraft.server.MinecraftServer.a(
            at net.minecraft.server.MinecraftServer.d(
    And here is my config file for Logblock:
    logCreeperExplosionsAs: Creeper
    logLeavesDecayAs: LeavesDecay
    defaultDist: 20
    usePermissions: false
    toolblockRemove: true
    logFire: true
    logFireAs: Fire
    logChestAccess: false
    password: pizclassy
    logSignTexts: false
    version: '0.11'
    username: pizclassy
    logLeavesDecay: false
    driver: com.mysql.jdbc.Driver
    logTNTExplosionsAs: TNT
    toolID: 270
    defaultTime: 30 minutes
    toolblockID: 7
    url: jdbc:mysql://localhost:3306/minecraft
    - lb-main
    keepLogDays: -1
    - 8
    - 9
    - 10
    - 11
    - 51
    logFireballExplosionsAs: Ghast
    - world
    - 46
    - 51
    delay: 6
    logExplosions: true
    And just incase i have Sqlite, Mysql and Mysql connector in the Bin folder. I just moved the mysql into it and am still getting errors. Any ideas for a fix? port is default and i am running on the same machine so i left localhost the same. db is changed to minecraft
  30. Offline


    !!!!!!!!!!! This is a huge issue. I can't run a server with such a huge vulnerability. With BB not updated and LogBlock vulnerable, I'm not able to run my server safely. Can this be fixed quickly?
  31. Offline


    logSignTexts: false

Share This Page