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

    DiddiZ

    Version: 1.50​
    [​IMG]
    [​IMG]
    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 :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:
    [​IMG]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)

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

    [​IMG]


    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)
    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'.
     
  2. Offline

    Tomskied

    Is chest logging not working? Everything seems to be working but chest logging. When I hit with toolblock, it only tells me about teh actual chest block, not contents.
     
  3. Offline

    DiddiZ

    Too old CB version, use LB 1.30 instead.
    Update CB, it's an error of CB #1137, fixed in #1337

    Enabled chest logging in world config and Spout is properly running?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 18, 2016
  4. Offline

    Tomskied

    Oops, thought i had it figured, but it still isn't working. Everything is working but chest contents logging. It is enabled in my world.yml file, but still not logging :S
     
  5. Offline

    MultipleGermans

    Thanks so much it worked perfectly. Keep up the good work!
     
  6. Offline

    DiddiZ

    And spout server plugin is properly running?
     
  7. Offline

    Tomskied

    I think so, not getting any errors, but how can I check?
    edit: Would I need to stop and start my server instead of just reloading?
     
  8. Offline

    DiddiZ

    Restart is better in most cases, reload sometimes messes up some things.
     
  9. Offline

    Tomskied

    Mm still no luck. Stopped and started and still nothing. Could it be a conflicting plugin?
     
  10. Code:
    13:44:29 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1131-g86b7fa8-b1337jnks (MC: 1.8.1)
    It is 1337
     
  11. Offline

    gamerboy2396

    I'm sorry if this is a really nooby question, but I have no permissions mod on my server, and whenever I type /lb tool or anything like that it says "Usage: /lb help". How do I make it so ops can use LogBlock commands?
     
  12. Offline

    DiddiZ

    Unlikely
    kk, then I need the full stack trace.
    That normally means LB disabled itself, search your server.log for the reason.
     
  13. Okay is fixed :eek: Just one Server restart ;o
     
  14. Offline

    oxbudy

    i must say, this plugin is a essential! i also recommend having chest logging enabled by default, it caused a bit of trouble for me and other people :|. BUT GREAT PLUGIN :DDD
     
    DiddiZ likes this.
  15. Offline

    Ryan Thorn

    Hi,

    Whenever someone joins the server (doesnt matter who it always does it for everyone when they join) a error pops up.

    Here is the error that is outputted (It may be the same thing twice because two people joined at once, this was the log after a server restart, 20 people joining at once lol) (I also replaced IP's and player names with X's for privacy reasons):

    Code:
    2011-10-28 19:09:34 [INFO] XXXXXX [/XX.X.XX.XX:XXXXXXX] logged in with entity id 2249 at ([obsid] -422.4621266518569, 118.00000014901161, 564.8382357904541)
    2011-10-28 19:09:34 [INFO] connect from ip XX.XXX.XXX.XX
    2011-10-28 19:09:35 [INFO] XXXXXX [/XX.X.XX.XX:XXXXXXX] logged in with entity id 2599 at ([obsid] -628.3915253199389, 6.200000047683716, 1150.300000011921)
    2011-10-28 19:09:35 [INFO] connect from ip XX.XXX.XXX.XX
    2011-10-28 19:09:36 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1319825374), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1319825374), firstlogin), ip = '/XX.XXX.XXX.XX' WHERE playerid = 25;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'
    at sun.reflect.GeneratedConstructorAccessor33.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:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    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.Consumer.run(Consumer.java:278)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Unknown Source)
    2011-10-28 19:09:43 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1319825375), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1319825375), firstlogin), ip = '/XX.XXX.XXX.XX' WHERE playerid = 130;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'
    at sun.reflect.GeneratedConstructorAccessor33.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:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    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.Consumer.run(Consumer.java:278)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Unknown Source)
    I hope you know how to solve it because it makes the server lag slightly every time someone joins.

    Sorry if someone has already asked about this error, i've checked the FAQ.

    MrBotox!
     
  16. Offline

    DiddiZ

    Set version in config to 1.30 and restart.

    I really should have added that to the FAQ.
     
  17. Offline

    Ryan Thorn

  18. Offline

    tedmazer

    I suck at installing MYSQL Help please? It says it cannot start the service :( H2 support please?
     
  19. Offline

    Imm0rt41

    dont make it say pass for password when the thing is empty, i dont have a password set up for my mysql, so everytime i try and make it empty, it keeps trying to say the password is pass, so logblock wont work
     
  20. Offline

    DiddiZ

    Set password to an empty string: '' (two single quotes)
    I guess windows? Tried x86 version instead?
     
  21. Offline

    pigLP

    I got these Error:
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1319842632), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1319842632), firstlogin), ip = '/7.22.205.149:52031' WHERE playerid = 1;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'
    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:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    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.Consumer.run(Consumer.java:278)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Unknown Source)

    I dont now how i fix them
     
  22. Offline

    DiddiZ

    Set version in config to '1.30' and restart.
     
  23. Offline

    tedmazer

    it was x86 give me direct link to the one I need please :D
     
  24. Offline

    Willower

    Hi,

    I'm running CB1337 and using LB 1.32 and getting this message which cripples my server:
    Code:
    2011-10-29 01:55:01 [WARNING] [LogBlock] Failed to import queue-1319170109401-0.sql:
    java.sql.BatchUpdateException: You can't specify target table 'lb-players' for update in FROM clause
        at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:102)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:139)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:112)
        at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:52)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:136)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    Any ideas?
     
  25. Offline

    Spudski

    Code:
    22:52:18 [SEVERE] [LogBlock] Error while fetching connection
    java.sql.SQLException: Failed to validate a brand new connection
        at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:76)
        at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:295)
        at de.diddiz.LogBlock.Consumer.run(Consumer.java:252)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:680)
    
    I am getting this never before seen error after updating to craftbukkit 1337. And also, I am an OP and have all permissions on my server though when I type /lb permissions it says I have all permissions except tool and toolblock. I don't know what's wrong, I have tried almost everything I can think of to fix it to no avail.
     
  26. Offline

    DiddiZ

    The 32 bit version:
    http://www.mysql.com/downloads/mysql/
    Try latest dev, changed some things regarding imports.
    Already restarted your MySQL server?

    The tool permissions aren't part of logblock.* due to a bukkit problem with dynamic permissions. You need to give you logblock.tools.tool and logblock.tools.toolblock.
     
  27. Offline

    Kevybevy

    what's MySQL?
     
  28. Offline

    DiddiZ

    What's google? :D
     
  29. Offline

    Spudski

    Okay, thanks I will try that.

    EDIT: Nothing was working on CB 1337 but then I downgraded to 1317 and it is working like a charm! Thanks for the help!

    EDIT2: What's a queue overload? I have a queue size of 17500

    EDIT3: When I reload or start up the server, it hangs up trying to import all of the queue's, which I still don't understand.
     
  30. Offline

    tedmazer

    please man support H2 MYSQL is not working for me at all :l

    Ok so now it works with WAMP but now MYSQL is not letting me do crap. its saying Ive set a password :L

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 18, 2016
  31. Offline

    DiddiZ

    When the MySQL server is slow, some block changes stay in the queue (which is better then lagging the server :D).
    If you use default consumer settings, increase timePerRun und forceToProcess.
    Try latest dev build, imports are processed async there.
    Normally, you set the root pw during installation ...
     

Share This Page