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

    DiddiZ

    Can't really track it down, as there not really can't be a null.
    Does this happen always or just when reloading?
     
  3. Offline

    Spathizilla

    While I can modify them, I'm not sure if any new ones will not still be up there in the thousands. Plus any existing blocks placed will stop working correctly (and also not work with LB :().

    Plus, the spout guys are saying they're planning for around 60k custom block compatability so its most definitely going to use more than 1 byte (and probably break your implementation)
     
  4. Offline

    Raycrash

    on server start ;)
     
  5. Offline

    Valdifer

    I got an error connection
    Code:
    2011-11-16 17:56:45 [INFO] Starting minecraft server version Beta 1.8.1
    2011-11-16 17:56:45 [INFO] Loading properties
    2011-11-16 17:56:45 [INFO] Starting Minecraft server on *:25565
    2011-11-16 17:56:45 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
    2011-11-16 17:56:45 [WARNING] The server will make no attempt to authenticate usernames. Beware.
    2011-11-16 17:56:45 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
    2011-11-16 17:56:45 [WARNING] To change this, set "online-mode" to "true" in the server.settings file.
    2011-11-16 17:56:45 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1131-g86b7fa8-b1337jnks (MC: 1.8.1)
    2011-11-16 17:56:45 [SEVERE] Could not load 'plugins\NoLaggChunks.jar' in folder 'plugins': Spout
    org.bukkit.plugin.UnknownDependencyException: Spout
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:135)
        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-11-16 17:56:45 [INFO] MLog clients using java 1.4+ standard logging.
    2011-11-16 17:56:45 [INFO] [Catacombs] version 0.8 is loaded
    2011-11-16 17:56:45 [INFO] [LogBlock] Version check: Your version is up to date
    2011-11-16 17:56:45 [INFO] [LogBlock] Connecting to root@jdbc:mysql://localhost:3306/minecraft...
    2011-11-16 17:56:45 [SEVERE] [LogBlock] Error while fetching connection:
    java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
        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.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:259)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:76)
        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)
    2011-11-16 17:56:45 [INFO] Preparing level "yars"
    2011-11-16 17:56:45 [INFO] Default game type: 0
    2011-11-16 17:56:45 [INFO] Preparing start region for level 0 (Seed: -2548602007347809568)
    2011-11-16 17:56:46 [INFO] Preparing start region for level 1 (Seed: 9092670251152645405)
    2011-11-16 17:56:46 [INFO] Preparing spawn area: 81%
    2011-11-16 17:56:47 [INFO] [AuthMe] MySQL driver loaded
    2011-11-16 17:56:47 [INFO] [AuthMe] Connection pool ready
    2011-11-16 17:56:47 [INFO] [AuthMe] MySQL Setup finished
    2011-11-16 17:56:47 [INFO] [AuthMe] Authme 2.5 enabled
    2011-11-16 17:56:47 [INFO] Log version 0.8: Loaded.
    2011-11-16 17:56:47 [INFO] Log version 0.8: Events initialised successfully.
    2011-11-16 17:56:47 [INFO] Log version 0.8: Data loaded successfully.
    2011-11-16 17:56:47 [INFO] Log version 0.8: Loaded properties file.
    2011-11-16 17:56:47 [INFO] Loaded Essentials build 2.6.4 by: Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans, Xeology, KHobbits
    2011-11-16 17:56:47 [INFO] Essentials: Using config based permissions. Enable superperms in config.
    2011-11-16 17:56:47 [INFO] Loaded EssentialsChat build 2.6.4 by: essentials team
    2011-11-16 17:56:47 [INFO] Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
    2011-11-16 17:56:47 [INFO] Loaded EssentialsProtect build 2.6.4 by: essentials team
    2011-11-16 17:56:47 [INFO] Loaded EssentialsSpawn build 2.6.4 by: essentials team
    2011-11-16 17:56:47 [INFO] LogBlockQuestioner v0.02 enabled
    2011-11-16 17:56:47 [INFO] [MyWorlds] Using build-in 'Bukkit SuperPerms' as permissions plugin!
    2011-11-16 17:56:47 [INFO] [MyWorlds] Loading or creating world: 'mundo_nether' using seed 0
    2011-11-16 17:56:47 [INFO] Preparing start region for level 2 (Seed: -1733955896)
    2011-11-16 17:56:47 [INFO] [MyWorlds] Loading or creating world: 'mundo' using seed 0
    2011-11-16 17:56:47 [INFO] Preparing start region for level 3 (Seed: 2127618073)
    2011-11-16 17:56:48 [INFO] [MyWorlds] Loading or creating world: 'world_nether' using seed 0
    2011-11-16 17:56:48 [INFO] Preparing start region for level 4 (Seed: -8256222484530202836)
    2011-11-16 17:56:48 [INFO] [MyWorlds] Loading or creating world: 'world' using seed 0
    2011-11-16 17:56:48 [INFO] Preparing start region for level 5 (Seed: -8256222484530202836)
    2011-11-16 17:56:49 [INFO] [MyWorlds] Successfully bound variable to region file cache.
    2011-11-16 17:56:49 [INFO] [MyWorlds] File references to unloaded worlds will be cleared!
    2011-11-16 17:56:49 [INFO] [MyWorlds] version 1.29 is enabled!
    2011-11-16 17:56:49 [INFO] PermissionsBukkit v1.1 is now enabled
    2011-11-16 17:56:49 [INFO] Essentials: Using PermissionsBukkit based permissions.
    2011-11-16 17:56:49 [INFO] [Residence] Successfully linked with Essentials Economy!
    2011-11-16 17:56:49 [INFO] [Residence] Loaded...
    2011-11-16 17:56:49 [INFO] [Residence] Enabled! Version 2.4.2 by bekvon
    2011-11-16 17:56:49 [INFO] WorldEdit 4.7 enabled.
    2011-11-16 17:56:49 [INFO] WorldEdit: Using the Bukkit Permissions API.
    2011-11-16 17:56:49 [INFO] [Catacombs] Looking for Permissions plugin
    2011-11-16 17:56:49 [INFO] [Catacombs] Permission system not detected, defaulting to OP
    2011-11-16 17:56:49 [INFO] [Catacombs] Preferred payment method [any] not found, using first found.
    2011-11-16 17:56:49 [INFO] [Catacombs] Payment method found (Essentials version: 2.2)
    2011-11-16 17:56:49 [INFO] [Factions v1.6.1] === ENABLE START ===
    2011-11-16 17:56:49 [INFO] [Factions v1.6.1] No permission plugin detected. Defaulting to native bukkit permissions.
    2011-11-16 17:56:50 [INFO] [Factions v1.6.1] Loading board from disk
    2011-11-16 17:56:50 [INFO] [Factions v1.6.1] Found and will integrate chat with EssentialsChat v2.6.4
    2011-11-16 17:56:50 [INFO] [Factions v1.6.1] Economy integration is disabled, and the plugin "Register" is not installed.
    2011-11-16 17:56:50 [INFO] [Factions v1.6.1] === ENABLE DONE (Took 102ms) ===
    2011-11-16 17:56:50 [INFO] [mcMMO] Using Bukkit Permissions.
    2011-11-16 17:56:50 [INFO] Loading Config File...
    2011-11-16 17:56:50 [INFO] mcMMO version 1.1.17 is enabled!
    2011-11-16 17:56:51 [INFO] [NoLagg] Auto-save field bound to 'u'!
    2011-11-16 17:56:51 [INFO] NoLagg version 1.48 is enabled!
    2011-11-16 17:56:51 [INFO] Server permissions file permissions.yml is empty, ignoring it
    2011-11-16 17:56:51 [INFO] Done (0,520s)! For help, type "help" or "?"
    2011-11-16 17:56:51 [INFO] New max size: 484
    2011-11-16 17:56:51 [INFO] New max size: 784
    
    My config file is this:

    Code:
    mysql:
      user: root
      port: 3306
      password: test
      host: localhost
      database: minecraft2
    where is the problem?

    Grettings
     
  6. Offline

    DiddiZ

    I see ... that makes it a bit difficult to me.
    Which CB version? There is a known error in CB 1396+ I still need to fix.
    It's likely containing numbers or special chars and so have to be surrounded by single quotes like
    password: '123'
     
    Valdifer likes this.
  7. Offline

    Valdifer

    Yeah!!!

    Thx man :D
     
    DiddiZ likes this.
  8. Offline

    biblelucas

    When you said what to do, i did erased the config.yml in logblock and resatrted. It still has the same problem.
     
  9. Offline

    Raycrash

    Nope using 1337
     
  10. Offline

    VoidFusion

    @biblelucas In your general config file there is a section called loggedWorlds:, it means that world named World isn't logged, as the default world is spelled with a lowercase w instead of a W. But, in this case where the code would look like

    loggedWorlds:
    - world
    - world-nether

    , you would simply put it like this

    loggedWorlds:
    - world
    - world-nether
    - World

    if that still doesn't work, rename your World to something different as 2 worlds named 'world' and 'World' can cause problems.

    EDIT: Do NOT copy and paste the loggedWorlds: section i put there, as the forum wont allow me to space it 4 times.
     
    DiddiZ likes this.
  11. Offline

    biblelucas

    OMG THANKS ALOT THUMBS UP THAT WAS THE PROBLEM ALL ALONG~!!!!~!~!~!~
     
  12. Offline

    DiddiZ

    Strange. There can't really be a null.
    You could reinstall LB (no need t drop the table) or give me the error log after a restart.
     
  13. Offline

    Jaminb2030

    Is there a way to get LB to use a flat file?
     
  14. Offline

    DiddiZ

    No, not at all. Too much data.
     
  15. Offline

    H_J_446

    just one question

    does this roll back tree griefing?
     
  16. Offline

    DiddiZ

    As soon as @md_5 's tree grow event get pulled to bukkit
     
  17. Offline

    latexink

    Thanks for the reply.. great plugin.
     
    DiddiZ likes this.
  18. Offline

    javoris767

    Im getting lots o errors

     
  19. Offline

    md_5

    Dammit 1.9!
     
  20. Offline

    Tomskied

    When using /lb lookup, with any parameters or even on its own it causes the server to restart, i have no idea why. It rollsback just fine.
     
  21. Offline

    TheBeast808

    Why isn't there a simple form of the roll back command?
    I'm used to bigbrother where we could just type /bb rollback ___. When I type /lb rollback player ___ it searches the default radius and time. To me, this seems inconvenient. If I set the default radius and time really high, to get all the block changes that player made, it seems kind of "dirty". It is searching for all entries that are within X blocks and since X, when it seems much more efficient to select all regardless of distance or time.
    Am I just missing out on some feature of LB, or is there no way to rollback a player completely regardless of time, distance, or world?
     
  22. Offline

    DiddiZ

    Set version in config to '1.30' and restart.
    Example command please.
    Any error log in console?
    First, you need logblock.ignoreRestrictions permission, but I guess you already have that.
    Then:
    /lb rb player <name> time 0
    0 disables the time check
     
  23. Offline

    Spathizilla

    Code:
    SpoutBlock testblock = ((SpoutBlock)world.getBlockAt(x,y,z));
    String blockname = null;
    if(testblock.isCustomBlock()) {
      blockname = testblock.getName();
    }
    
    This way you *might* not have to get people to define the custom block names for Spout blocks. Since Spout uses flint as the item inhand and stone/glass as placed block depending on transparency, it would require people to define the custom block names twice at least. Two sets of names because one set for items stored in chests as flint and the other for the placed block as stone/glass

    I've been digging through the spout api for a better way to get a full list of custom blocks and their metadata though. That is the first viable method I've found for getting the name.
     
  24. Offline

    DiddiZ

    Hm, then I'd need to know at least one location of each block to get the name ...
     
  25. Offline

    Spathizilla

    Well the code works nicely for placing blocks.

    You could build your own db of them on first placement. This way you're using a Logblock database of metadata rather than Spout's. The metadata for a placed block will remain the same for in the chest too. However depends whether you want to go this route.

    On break is more of a problem though since the block is already broken. I think you could still do it a similar way if you can get the metadata for the broken block you could simulate the block in code and check on Spout.

    I'm not sure Spout will provide a full list of blocks/metadata for all custom blocks. I couldnt find a way to do it in the API. I might ask Afforess to add a method to get a full list of Spout custom items/blocks.
     
  26. Offline

    Zork766

    Hi, and thank you for that usefull plugin.
    I used it for two month with an external database, and all works fine until 4 days ago.
    With no reason, i got a connection error. I've check my database, trying to do it with a new one, but nothing work.
    I'm becoming mad, i don't know how to find the problem.

    Running CraftBukkit #1337
    LogBlock v1.41 #63
    Spout dev build 529
    PEX 1.16

    Here is my problem:
    Code:
    2011-11-17 16:02:02 [INFO] Starting minecraft server version Beta 1.8.1
    2011-11-17 16:02:02 [INFO] Loading properties
    2011-11-17 16:02:02 [INFO] Starting Minecraft server on *:25565
    2011-11-17 16:02:02 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1131-g86b7fa8-b1337jnks (MC: 1.8.1)
    2011-11-17 16:02:03 [INFO] DataSourcePool [MinecartManiaCore] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    2011-11-17 16:02:03 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    2011-11-17 16:02:03 [INFO] Entities enhanced[0] subclassed[2]
    2011-11-17 16:02:03 [INFO] DataSourcePool [MinecartManiaSignCommands] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    2011-11-17 16:02:03 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    2011-11-17 16:02:04 [INFO] Entities enhanced[0] subclassed[2]
    2011-11-17 16:02:04 [INFO] Starting Minequery server on *:25566
    2011-11-17 16:02:04 [INFO] [PermissionsEx] sql backend registered!
    2011-11-17 16:02:04 [INFO] [PermissionsEx] file backend registered!
    2011-11-17 16:02:04 [INFO] [PermissionsEx] PermissionEx plugin initialized.
    2011-11-17 16:02:04 [INFO] [WorldModes 2.4] initialized
    2011-11-17 16:02:04 [INFO] [PermissionsEx] p2compat backend registered!
    2011-11-17 16:02:04 [INFO] [PermissionsCompat] Compatibility Layer Initalized!
    2011-11-17 16:02:05 [INFO] MusicCraft Loading...
    2011-11-17 16:02:05 [INFO] [PermissionsEx] Initializing file backend
    2011-11-17 16:02:06 [INFO] [LogBlock] Version check: Your version is up to date
    2011-11-17 16:02:06 [INFO] [LogBlock] Connecting to Zork766@jdbc:mysql://database.damstux.fr:3306/logblockcc...
    2011-11-17 16:02:27 [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:259)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:76)
        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)
    Caused by: java.net.ConnectException: Connection timed out: connect
        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.AbstractPlainSocketImpl.connect(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
    
    Complete log file here.

    And here is my LB config file:
    Code:
    tools:
      tool:
        defaultEnabled: true
        mode: LOOKUP
        aliases:
        - t
        params: area 0 all sum none limit 15 desc silent
        leftClickBehavior: NONE
        item: 270
        rightClickBehavior: TOOL
        permissionDefault: 'TRUE'
      toolblock:
        params: area 0 all sum none limit 15 desc silent
        permissionDefault: 'TRUE'
        rightClickBehavior: BLOCK
        item: 7
        mode: LOOKUP
        defaultEnabled: true
        aliases:
        - tb
        leftClickBehavior: TOOL
    mysql:
      user: Zork766
      port: 3306
      password: '**********'
      host: database.damstux.fr
      database: logblockcc
    logging:
      hiddenBlocks:
      - 0
      logCreeperExplosionsAsPlayerWhoTriggeredThese: false
      logPlayerInfo: true
      hiddenPlayers: []
      logKillsLevel: PLAYERS
    consumer:
      timePerRun: 200
      useBukkitScheduler: true
      forceToProcessAtLeast: 20
      delayBetweenRuns: 6
    lookup:
      linesLimit: 1500
      defaultTime: 30 minutes
      defaultDist: 20
      linesPerPage: 15
    questioner:
      askClearLogs: true
      banPermission: mcbans.ban.local
      askRollbacks: true
      askRedos: true
      askClearLogAfterRollback: true
      askRollbackAfterBan: false
    updater:
      checkVersion: true
      installSpout: true
    loggedWorlds:
    - world
    - world_nether
    clearlog:
      enableAutoClearLog: false
      auto:
      - world "world" before 365 days all
      - world "world" player lavaflow waterflow leavesdecay before 7 days all
      - world world_nether before 365 days all
      - world world_nether player lavaflow before 7 days all
      dumpDeletedLog: false
    rollback:
      replaceAnyway:
      - 8
      - 9
      - 10
      - 11
      - 51
      maxArea: 50
      dontRollback:
      - 10
      - 11
      - 46
      - 51
      maxTime: 2 days
    version: '1.41'
    
    PLEASE, can anyone have an idea, or can help me to fix this ******* problem?
    It's really important for me...
     
  27. Offline

    DiddiZ

    Latter would be my preferred way.

    Hm, as I still need to implement a config option to set the datatype of x and z columns to MEDIUMINT/INT, Iit might make sense to also add option or the type/data columns.

    If you don't change anything, it likely either the domain/ip of the database changed, or the MySQL server now refuses remote connections. Maybe also the firewall on your MC server.

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

    latexink

    How often does the automatic clearing of the log run? I have it enabled, but it is not working... I have CreeperHeal and I want to clear Creepers after they heal... so I have it set to clear after 1m all.. but it's not working. There is no documentation that I can find about the differences in autoclear params from query params.. this is the block in the config.yml:

    I would expect that to clear all entries for Creeper only... and the other stuff of course, but how can I make this work?

    I've tried things like:

    - world "LatexWorld" player Creeper before 1m all

    But.. syntax? Does this only work when I /lb clearlog?
     
  29. Offline

    Zork766

    Thanks for your answer, sure it is not a LogBlock issue, because when i try to use Hawkeye instead, same problems.
    I've check my firewall, also try to disable it, that is not the problem. Remote connections are ok.
    So exuses me if that is not the right place, but if anyone have an idea...
    Which settings should i use to try to have the Logblock database store on my server, with Windows 7 and Wamp?
     
  30. Offline

    DiddiZ

    The auto clearlog runs on every server restart/reload.

    - world "LatexWorld" player Creeper all
    Will remove every change done by a creeper

    - world "LatexWorld" player Creeper before 1m all
    Will remove every change done by a creeper that are older than one minute.

    The syntax is the same as in /lb clearlog, except that you can't use params like sel or area.

    host: localhost
    port should be 3306
    database you might have to create first
    user and password like you've set

    SQL commands to create database and user:
    Code:
    CREATE DATABASE minecraft;
    GRANT ALL ON minecraft.* TO 'logblock'@'localhost' IDENTIFIED BY 'password';
    replace password with an actual password, but keep the singlequotes

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

    latexink

    Awesome... thanks for the reply. I'd maybe add a blurb in the wiki on when this runs. Or maybe allow a scheduling of it for people who don't like to reload their servers a lot. Once again, fantastic plugin ... I love being able to rollback selections and customize parameters for searching and rolling back... everything works fantastically and improves on every release.. Kudos.

    On a side note, do you think that LB could be made to import/export a database somehow? I'd like to be able to migrate a server/db without having to muck about with mysql tables/dbs... I know it's a lot of data, but maybe a full dump/export to a local file and them reimport that file to the db if it's local/moved to the other machine? I'm self-taught about this MySQL stuff and it would make it a lot easier when moving a server around...
     
    DiddiZ likes this.

Share This Page