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

    gltepel

    Does LogBlock set up the database in the MySQL server by itself, or do I have to do it manually? If I have to do it manually, any advice on setting one up on a web server? (what program I can use to connect etc., I'm completely new to MySQL)
     
  3. Offline

    shaggy2010

    I tried to enable the logging of lever use due to peoples water/piston CropFarms been "premature griefed" sometimes.
    Now I'm getting this error.
     
  4. Offline

    DiddiZ

    Logblock will create the tables, but the database has to be created manually:
    CREATE DATABASE minecraft;

    Helpful programms arew phpMyAdmin and MySQL workbench

    There has to be a second error message before.

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

    STiChad

    I had to set mine up manually.
    I would suggest WampServer, gotta be the best MySQL server.
    Follow a tutorial on the set up and its pretty easy to set up a new database after that.
    If you need help I can help you, its really simple.
     
  6. Offline

    shaggy2010

    your right, my logs didnt steam that far back, there was a missing space between value and answer, I'm sorry. Thanks very much again! working great now.
     
    DiddiZ likes this.
  7. Offline

    leetgamer

    This isn't so much an error, but I'm curious as to what it is. It gets spammed for dozens of lines, than just stops for awhile, to resume at a later time.

    Code:
    11.10 15:15:27 [Server] INFO [LogBlock Consumer] Queue overloaded. Size: 1159
    11.10 15:15:25 [Server] INFO [LogBlock Consumer] Queue overloaded. Size: 1164
    11.10 15:15:24 [Server] INFO [LogBlock Consumer] Queue overloaded. Size: 1170
     
  8. Offline

    Clepto

    I'm getting this error when I start it. I have sql set up and a database, and have given logblock the sql info in the config. I'm on CB 1317, and when I try to do any logblock commands it just says "Usage: /lb help"

    Code:
    15:22:58 [SEVERE] Error occurred while enabling LogBlock v1.30 (Is it up to date?): null
    java.lang.NullPointerException
            at de.diddiz.LogBlock.LogBlock.onEnable(LogBlock.java:145)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:170)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:297)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:284)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:152)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    
     
  9. Offline

    DiddiZ

    -> https://github.com/DiddiZ/LogBlock/wiki/FAQ
    Search for the first error message, there is the cause, this is the second.
     
  10. Offline

    Devin14

    The host IP that my server host gave me for the MySQL is a website that I would put into the url bar at the top of the page to follow. Wouldn't it be that as the host?

    Should I just post what the server says when it starts? How do I do the code box thing so it doesn't take up a ton of space?

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

    DiddiZ

    Code:
    [code]error log[/ code]
     
  12. Offline

    Devin14

    This is what it says when it starts.
    Code:
    error log
    2011-10-10 04:00:23 [INFO] Starting minecraft server version Beta 1.8.1
    2011-10-10 04:00:23 [INFO] Loading properties
    2011-10-10 04:00:23 [INFO] Starting Minecraft server on 109.70.149.207:30765
    2011-10-10 04:00:25 [INFO] Connection reset
    2011-10-10 04:00:25 [INFO] Connection reset
    2011-10-10 04:00:25 [INFO] Connection reset
    2011-10-10 04:00:27 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1112-g54a13b2-b1240jnks (MC: 1.8.1)
    2011-10-10 04:00:32 [INFO] [PermissionsEx] sql backend registered!
    2011-10-10 04:00:32 [INFO] [PermissionsEx] file backend registered!
    2011-10-10 04:00:32 [INFO] [PermissionsEx] PermissionEx plugin initialized.
    2011-10-10 04:00:32 [INFO] [PermissionsEx] p2compat backend registered!
    2011-10-10 04:00:32 [INFO] [PermissionsCompat] Compatibility Layer Initalized!
    2011-10-10 04:00:33 [INFO] LWC: Loading shared objects
    2011-10-10 04:00:33 [INFO] LWC: Protection cache: 0/10000
    2011-10-10 04:00:33 [INFO] LWC: Native library: plugins/LWC/lib/native/Windows/amd64/sqlitejdbc.dll
    2011-10-10 04:00:33 [INFO] MLog clients using java 1.4+ standard logging.
    2011-10-10 04:00:33 [INFO] [PermissionsEx] Initializing file backend
    2011-10-10 04:00:39 [INFO] [LogBlock] Version check: Your version is up to date
    2011-10-10 04:00:39 [INFO] [LogBlock] Connecting to 2056@jdbc:mysql://mysqleu1.fragnet.net:3306/minecraft...
    2011-10-10 04:00:41 [SEVERE] [LogBlock] Error while fetching connection
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user '2056'@'%' to database 'minecraft'
    	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.checkErrorPacket(MysqlIO.java:931)
    	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    	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(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.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    	at java.sql.DriverManager.getConnection(Unknown Source)
    	at java.sql.DriverManager.getConnection(Unknown Source)
    	at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:72)
    	at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:295)
    	at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)
    	at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
    	at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:104)
    	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)
    2011-10-10 04:00:41 [SEVERE] [LogBlock] Error while loading:
    java.lang.NullPointerException
    	at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)
    	at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
    	at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:104)
    	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)
     
  13. Offline

    Anthony45654

    LogBlock Version: 1.32
    CB Build: 1240


    When I try reloading my server, I get this error code:
    Code:
    2011-10-11 19:50:28 [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(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.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(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.ConnectionImpl.getInstance(ConnectionImpl.java:378)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:72)
        at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:295)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:414)
        at org.bukkit.Bukkit.reload(Bukkit.java:182)
        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:354)
        at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
        ... 28 more
    2011-10-11 19:50:28 [SEVERE] [LogBlock] Error while loading:
    java.lang.NullPointerException
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:414)
        at org.bukkit.Bukkit.reload(Bukkit.java:182)
        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:354)
        at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    And then near the end of the reload, I get this error code:
    Code:
    2011-10-11 19:50:48 [SEVERE] Error occurred while disabling LogBlock v1.32 (Is it up to date?): null
    java.lang.NullPointerException
        at de.diddiz.LogBlock.LogBlock.onDisable(LogBlock.java:258)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:128)
        at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:962)
        at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:296)
        at de.diddiz.LogBlock.LogBlock.onEnable(LogBlock.java:132)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:941)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:174)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:157)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:416)
        at org.bukkit.Bukkit.reload(Bukkit.java:182)
        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:354)
        at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    
    Please help!
     
  14. Offline

    NEREVAR117

    I honestly don't understand this MySQL stuff, and it's preventing me from using this plugin. I rent out a dedicated server, and would like to have this on said server. How would I setup my MySQL settings?
     
  15. Offline

    XRayted

    Hello DiddiZ,

    Was out for a bit as my house burned down and lost everything, but trying to get the server back on track. There are some griefers active and have to be quick to set it back up again.

    Do you happen to know what this is? No idea if that is related though:

    "
    03:47 AM [INFO] [CustomDifficulty] Found the following 1 difficulties:
    default.
    03:47 AM [WARNING] [CustomDifficulty] Couldn't hook into Permissions!
    03:47 AM [WARNING] [CustomDifficulty] Couldn't hook into Register!
    03:47 AM [WARNING] [CustomDifficulty] Spawning will not be activated for world waterworld. World's difficulty is invalid and ignoring is disabled.
    03:47 AM [WARNING] [CustomDifficulty] Spawning will not be activated for world waterworld_nether. World's difficulty is invalid and ignoring is disabled.
    "
     
  16. Uhm, im not sure if this has been said before, but the last two times i rolled someone back using logblock, half of the players in my server's minecraft clients crashed, with a blueish whitish screen. Task manager needed to FC the game :\?

    Any ideas or causes? I only say this because its happened twice in a row now...
     
  17. Offline

    JTPROG

    I get the same exact error as he does. It just happened randomly after my computer restarted. Any ideas?
     
  18. Offline

    gltepel

    I'm using DotBlock to host my webserver, and they claim they've set up MySQL on it, but when I try to connect using MySQL Workbench it says I'm not allowed to connect to this MySQL server, so I'm not even sure if MySQL is working right now.
     
  19. Offline

    City Builder

    Getting this error on startup, any help appreciated.
    Code:
    2011-10-12 00:46:47 [SEVERE] Could not load 'plugins/LogBlockQuestioner.jar' in folder 'plugins':
    java.util.zip.ZipException: invalid END header (bad central directory offset)
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:62)
        at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:215)
        at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:136)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:136)
        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)
    2011-10-12 00:46:47 [SEVERE] Could not load 'plugins/Spout.jar' in folder 'plugins':
    java.util.zip.ZipException: invalid END header (bad central directory offset)
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:62)
        at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:215)
        at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:136)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:136)
        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)
    2011-10-12 00:46:47 [SEVERE] Could not load 'plugins/LogBlock.jar' in folder 'plugins':
    java.util.zip.ZipException: invalid END header (bad central directory offset)
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:62)
        at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:215)
        at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:136)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:136)
        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)
     
  20. Offline

    Greylocke

    The first error looks a lot like the SQL connection was closed before LogBlock shut down. That happened to me once during a system halt where the KILL signal was sent out and processes started shutting down as quickly as they could, but not in the proper order.

    The second error looks like what I saw after a recent craftbukkit update. Try CB 1323 and Spout 449. Worked for me.
     
  21. does lb-main is still used ? because this table is no more created on mysql (but the plugin work) and webstats ask for so is no showing players stats.
     
  22. Offline

    STiChad

    Hmm, well I've never used MySQL outside of WampServer and a few PHP hosting sites.
    Only suggestion I can give is to try WampServer out.
     
  23. Offline

    pSy

    Since i updated to 1.32 and Bukkit 1317, i'm getting this. Every few minutes at the console. But ingame, it seems to work fine. All data is still there.


    Code:
    2011-10-12 11:30:03 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1318411797), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1318411797), firstlogin), ip = '/95.118.250.148:49801' WHERE playerid = 3;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'
        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:525)
        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(Thread.java:722)
     
  24. Offline

    JagerPrime

    I really just can't get it to log tnt explosions for rollback. What exactly am I doing wrong here?

    Code:
    loggedWorlds:
    - world
    - world_nether
    - TempServer
    - TempServer_nether
    clearlog:
        dumpDeletedLog: false
        keepLogDays: -1
    updater:
        checkVersion: true
        installSpout: true
    tools:
        tool:
            permissionDefault: 'TRUE'
            item: 270
            leftClickBehavior: NONE
            params: area 0 all sum none limit 15 desc silent
            rightClickBehavior: TOOL
            aliases:
            - t
            defaultEnabled: true
            mode: LOOKUP
        toolblock:
            permissionDefault: 'TRUE'
            item: 7
            leftClickBehavior: TOOL
            params: area 0 all sum none limit 15 desc silent
            rightClickBehavior: BLOCK
            aliases:
            - tb
            defaultEnabled: true
            mode: LOOKUP
    questioner:
        askClearLogAfterRollback: true
        banPermission: mcbans.ban.local
        askRedos: true
        askRollbackAfterBan: false
        askClearLogs: true
        askRollbacks: true
    logging:
        hiddenPlayers: []
        hiddenBlocks:
        - 0
        logCreeperExplosionsAsPlayerWhoTriggeredThese: false
        logKillsLevel: PLAYERS
        logPlayerInfo: true
    rollback:
        replaceAnyway:
        - 8
        - 9
        - 10
        - 11
        - 51
        maxArea: 50
        dontRollback:
        - 10
        - 11
        - 51
        maxTime: 2 days
    consumer:
        delayBetweenRuns: 6
        forceToProcessAtLeast: 20
        timePerRun: 200
        useBukkitScheduler: true
    lookup:
        defaultDist: 20
        defaultTime: 30 minutes
        linesLimit: 1500
        linesPerPage: 15
    version: '1.32'
    mysql:
        port: NOPE
        host: NOPE
        user: NOPE
        password: NOPE
        database: NOPE
    
    Code:
    logBlockCreations: true
    logBlockDestroyings: true
    logCakes: false
    logKills: false
    logDoors: false
    logFire: true
    logSnowFade: false
    table: lb-world
    logChestAccess: false
    logSignTexts: true
    logWaterFlow: false
    logChat: false
    logSnowForm: false
    logButtonsAndLevers: false
    logLeavesDecay: false
    logEndermen: false
    logLavaFlow: false
    logExplosions: true
    
     
  25. Offline

    DiddiZ

    Did you grant all privileges?
    GRANT ALL ON minecraft TO '2056'@'%';

    If that's a managed MySQL server, ask your hoster about remote access.
    Looks like your MySQL server went down
    -> http://dev.mysql.com/doc/refman/5.5/en/installing.html
    I guess you better ask there:
    http://forums.bukkit.org/threads/20135
    Can you provide steps to reproduce this?
    Yeah, MySQL server not running, put it in autostart.
    Not allowed means it runs in most cases, otherwise it would be connection timeout/connection refused
    Corrupted jar. Redownload it and upload in binary mode.
    Idk how your tables are called. Have a look at the world config files, if there is lb-main mentioned as table somewhere, it's needed, otherwise not.
    Autoupdater fail. Set version in config to 1.30 and restart.
    The config looks fine. Did you check with toolblock whether the log is there?
     
  26. Offline

    Anthony45654

    What is MySQL? I see it all the time in threads and plugin topics but I never really knew what it meant. Is it complicated to use and handle?
     
  27. Offline

    City Builder

    Thank you, for some reason I must have set transfers to ASCII FTP'ing something else. Transfering them in binary fixed the problem.

    Much appreciated.
     
  28. Offline

    losdamianos

    http://tinyurl.com/c8cybm
     
  29. Offline

    Synful0ne

    Code:
    2011-10-12 18:22:00 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1318429316), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1318429316), firstlogin), ip = '/88.153.43.126:62649' WHERE playerid = 53;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'
        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.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(Thread.java:636)
    Been having this issue. it seems like a column is missing
    any ideas on how to fix this?
     
  30. Offline

    DiddiZ

    Set version in config to 1.30 and restart
     
  31. Code:
    mysql:
        port: 3306
        host: localhost
        password: pass
        user: username
        database: minecraft
    Plugin can not connect to database with these settings.
    Code:
    2011-10-12 17:25:35 [INFO] [LogBlock] Version check: Your version is up to date
    2011-10-12 17:25:35 [INFO] [LogBlock] Connecting to username@jdbc:mysql://localhost:3306/minecraft...
    2011-10-12 17:25:37 [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(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.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(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.ConnectionImpl.getInstance(ConnectionImpl.java:378)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:72)
        at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:295)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:104)
        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)
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
        ... 23 more
    2011-10-12 17:25:37 [SEVERE] [LogBlock] Error while loading:
    java.lang.NullPointerException
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:78)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:104)
        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)
    Are my settings wrong or there're problems with MySQL at my side?
     

Share This Page