[INACTIVE][ADMN/SEC/WEB] DataLog - replaced by HawkEye [1000]

Discussion in 'Inactive/Unsupported Plugins' started by oliverw92, Apr 15, 2011.

Thread Status:
Not open for further replies.
Page 21 of 24
  1. Offline

    oliverw92

    oliverw92, Apr 15, 2011
    #1
    Vaupell, Pinkpixels, Sleaker and 2 others like this.
  2. Offline

    oliverw92

    Hmmm. Interesting. Well it still seems to be considerably less than before. I'm happy to release the next version with those stats. Got one more bug to fix before then.
     
    oliverw92, Jul 19, 2011
    #601
  3. Offline

    Justin The Cynical

    Ok, so do you still want the stats for tonight when I get back home from the office?
     
    Justin The Cynical, Jul 19, 2011
    #602
  4. Offline

    oliverw92

    Yeah that would be good thanks :)
     
    oliverw92, Jul 19, 2011
    #603
  5. Offline

    Justin The Cynical

    Umm...

    Code:
    mysql> SHOW PROCESSLIST;

+-------+-------------+--------------------------+-------------+---------+------+-------+------------------+
| Id    | User        | Host                     | db          | Command | Time | State | Info             |
+-------+-------------+--------------------------+-------------+---------+------+-------+------------------+
| 35448 | mc-log-user | $SERVER        :40423    | minecraft   | Sleep   |  292 |       | NULL             |
| 35963 | mc-log-user | $SERVER        :55776    | minecraft   | Sleep   |  292 |       | NULL             |
| 36286 | mc-log-user | $SERVER        :50532    | minecraft   | Sleep   |  292 |       | NULL             |
| 36612 | mc-log-user | $SERVER        :39195    | minecraft   | Sleep   |  292 |       | NULL             |
| 36947 | mc-log-user | $SERVER        :54913    | minecraft   | Sleep   |  292 |       | NULL             |
| 37281 | mc-log-user | $SERVER        :58807    | minecraft   | Sleep   |  292 |       | NULL             |
| 37616 | mc-log-user | $SERVER        :47911    | minecraft   | Sleep   |  292 |       | NULL             |
| 41496 | mc-log-user | $SERVER        :51364    | minecraft   | Sleep   |  292 |       | NULL             |
| 41624 | mc-log-user | $SERVER        :59500    | minecraft   | Sleep   |  296 |       | NULL             |
| 41705 | mc-log-user | $SERVER        :42615    | minecraft   | Sleep   |   14 |       | NULL             |
| 41708 | mc-log-user | $SERVER        :42616    | minecraft   | Sleep   |  271 |       | NULL             |
| 41789 | mc-log-user | $SERVER        :45092    | minecraft   | Sleep   |  292 |       | NULL             |
| 41868 | mc-log-user | $SERVER        :45725    | minecraft   | Sleep   |   14 |       | NULL             |
| 41869 | mc-log-user | $SERVER        :45726    | minecraft   | Sleep   |  271 |       | NULL             |
| 41949 | mc-log-user | $SERVER        :59187    | minecraft   | Sleep   |  292 |       | NULL             |
| 42034 | mc-log-user | $SERVER        :35131    | minecraft   | Sleep   |   14 |       | NULL             |
| 42035 | mc-log-user | $SERVER        :35132    | minecraft   | Sleep   |  271 |       | NULL             |
| 42077 | mc-log-user | $SERVER        :42905    | minecraft   | Sleep   |  296 |       | NULL             |
| 42119 | mc-log-user | $SERVER        :45985    | minecraft   | Sleep   |  292 |       | NULL             |
| 42199 | mc-log-user | $SERVER        :44483    | minecraft   | Sleep   |   14 |       | NULL             |
| 42200 | mc-log-user | $SERVER        :44484    | minecraft   | Sleep   |  271 |       | NULL             |
| 42282 | mc-log-user | $SERVER        :43434    | minecraft   | Sleep   |  292 |       | NULL             |
| 42367 | mc-log-user | $SERVER        :52005    | minecraft   | Sleep   |   14 |       | NULL             |
| 42369 | mc-log-user | $SERVER        :52006    | minecraft   | Sleep   |  271 |       | NULL             |
| 42414 | mc-log-user | $SERVER        :53019    | minecraft   | Sleep   |  296 |       | NULL             |
| 42456 | mc-log-user | $SERVER        :39008    | minecraft   | Sleep   |  292 |       | NULL             |
| 42538 | mc-log-user | $SERVER        :57456    | minecraft   | Sleep   |   14 |       | NULL             |
| 42542 | mc-log-user | $SERVER        :57457    | minecraft   | Sleep   |  271 |       | NULL             |
| 42627 | mc-log-user | $SERVER        :60775    | minecraft   | Sleep   |  292 |       | NULL             |
| 42708 | mc-log-user | $SERVER        :47059    | minecraft   | Sleep   |   14 |       | NULL             |
| 42709 | mc-log-user | $SERVER        :47060    | minecraft   | Sleep   |  271 |       | NULL             |
| 42753 | mc-log-user | $SERVER        :49750    | minecraft   | Sleep   |  296 |       | NULL             |
| 42793 | mc-log-user | $SERVER        :46438    | minecraft   | Sleep   |  292 |       | NULL             |
| 42874 | mc-log-user | $SERVER        :45960    | minecraft   | Sleep   |   14 |       | NULL             |
| 42875 | mc-log-user | $SERVER        :45961    | minecraft   | Sleep   |  271 |       | NULL             |
| 43032 | mc-log-user | $SERVER        :60780    | minecraft   | Sleep   |   14 |       | NULL             |
| 43033 | mc-log-user | $SERVER        :60781    | minecraft   | Sleep   |  271 |       | NULL             |
| 43074 | mc-log-user | $SERVER        :44397    | minecraft   | Sleep   |  296 |       | NULL             |
| 43202 | mc-log-user | $SERVER        :39615    | minecraft   | Sleep   |   14 |       | NULL             |
| 43203 | mc-log-user | $SERVER        :39616    | minecraft   | Sleep   |  271 |       | NULL             |
| 43241 | mc-log-user | $SERVER        :39685    | minecraft   | Sleep   |  296 |       | NULL             |
| 43362 | mc-log-user | $SERVER        :34972    | minecraft   | Sleep   |   14 |       | NULL             |
| 43365 | mc-log-user | $SERVER        :34973    | minecraft   | Sleep   |  271 |       | NULL             |
| 43524 | mc-log-user | $SERVER        :41398    | minecraft   | Sleep   |   14 |       | NULL             |
| 43525 | mc-log-user | $SERVER        :41399    | minecraft   | Sleep   |  271 |       | NULL             |
| 43694 | mc-log-user | $SERVER        :52520    | minecraft   | Sleep   |   14 |       | NULL             |
| 43697 | mc-log-user | $SERVER        :52521    | minecraft   | Sleep   |  271 |       | NULL             |
| 43736 | mc-log-user | $SERVER        :34083    | minecraft   | Sleep   |  296 |       | NULL             |
| 43854 | mc-log-user | $SERVER        :39483    | minecraft   | Sleep   |   14 |       | NULL             |
| 43855 | mc-log-user | $SERVER        :39484    | minecraft   | Sleep   |  271 |       | NULL             |
| 44014 | mc-log-user | $SERVER        :56547    | minecraft   | Sleep   |   14 |       | NULL             |
| 44015 | mc-log-user | $SERVER        :56548    | minecraft   | Sleep   |  271 |       | NULL             |
| 53566 | mc-log-user | $SERVER        :60333    | minecraft   | Sleep   |   25 |       | NULL             |
+-------+-------------+--------------------------+-------------+---------+------+-------+------------------+
    Fortunately, I can absorb the extra connections. :p
     
    Justin The Cynical, Jul 19, 2011
    #604
  6. Offline

    jasvecht

    The staff of my server loves this plugin, it's web interface is great. The only thing we really miss from it is chest-content rollbacks, something I recall BigBrother used to offer but we don't use anymore (as it's heavy, buggy and not as easy to use).

    Any chance you will (ever) incorporate chests completely?
     
    jasvecht, Jul 20, 2011
    #605
  7. Offline

    oliverw92

    Bah

    BigBrother never supported chest content rollbacks AFAIK. LogBlock does. I will at some point, but the hooks aren't build into bukkit yet so it would require me to depend on BukkitContrib.
     
    oliverw92, Jul 20, 2011
    #606
  8. Offline

    jasvecht

    I think it does, not entirely sure, i'll check up with it
     
    jasvecht, Jul 20, 2011
    #607
  9. Offline

    chuiby

    Is it protected against injections?
    I.e: If i type /SELECT * FROM dl_players WHERE player_id='0' in the chat, would it log it and censor the quotes and html chars?
     
    chuiby, Jul 20, 2011
    #608
  10. Offline

    oliverw92

    Yes, it is 100% protected - it uses prepared statements
     
    oliverw92, Jul 20, 2011
    #609
  11. Offline

    Justin The Cynical

    And here are the stats for tonight:
    Code:
    mysql> SHOW PROCESSLIST;
+-------+-------------+--------------------------+-------------+----------------+------+--------------------+------------------+
| Id    | User        | Host                     | db          | Command        | Time | State              | Info             |
+-------+-------------+--------------------------+-------------+----------------+------+--------------------+------------------+
| 35448 | mc-log-user |$SERVER        :40423    | minecraft   | Sleep          |  215 |                    | NULL             |
| 35963 | mc-log-user |$SERVER        :55776    | minecraft   | Sleep          |  215 |                    | NULL             |
| 36286 | mc-log-user |$SERVER        :50532    | minecraft   | Sleep          |  215 |                    | NULL             |
| 36612 | mc-log-user |$SERVER        :39195    | minecraft   | Sleep          |  215 |                    | NULL             |
| 36947 | mc-log-user |$SERVER        :54913    | minecraft   | Sleep          |  215 |                    | NULL             |
| 37281 | mc-log-user |$SERVER        :58807    | minecraft   | Sleep          |  215 |                    | NULL             |
| 37616 | mc-log-user |$SERVER        :47911    | minecraft   | Sleep          |  215 |                    | NULL             |
| 41496 | mc-log-user |$SERVER        :51364    | minecraft   | Sleep          |  215 |                    | NULL             |
| 41624 | mc-log-user |$SERVER        :59500    | minecraft   | Sleep          |  219 |                    | NULL             |
| 41705 | mc-log-user |$SERVER        :42615    | minecraft   | Sleep          |  237 |                    | NULL             |
| 41708 | mc-log-user |$SERVER        :42616    | minecraft   | Sleep          |  194 |                    | NULL             |
| 41789 | mc-log-user |$SERVER        :45092    | minecraft   | Sleep          |  215 |                    | NULL             |
| 41868 | mc-log-user |$SERVER        :45725    | minecraft   | Sleep          |  237 |                    | NULL             |
| 41869 | mc-log-user |$SERVER        :45726    | minecraft   | Sleep          |  194 |                    | NULL             |
| 41949 | mc-log-user |$SERVER        :59187    | minecraft   | Sleep          |  215 |                    | NULL             |
| 42034 | mc-log-user |$SERVER        :35131    | minecraft   | Sleep          |  237 |                    | NULL             |
| 42035 | mc-log-user |$SERVER        :35132    | minecraft   | Sleep          |  194 |                    | NULL             |
| 42077 | mc-log-user |$SERVER        :42905    | minecraft   | Sleep          |  219 |                    | NULL             |
| 42119 | mc-log-user |$SERVER        :45985    | minecraft   | Sleep          |  215 |                    | NULL             |
| 42199 | mc-log-user |$SERVER        :44483    | minecraft   | Sleep          |  237 |                    | NULL             |
| 42200 | mc-log-user |$SERVER        :44484    | minecraft   | Sleep          |  194 |                    | NULL             |
| 42282 | mc-log-user |$SERVER        :43434    | minecraft   | Sleep          |  215 |                    | NULL             |
| 42367 | mc-log-user |$SERVER        :52005    | minecraft   | Sleep          |  237 |                    | NULL             |
| 42369 | mc-log-user |$SERVER        :52006    | minecraft   | Sleep          |  194 |                    | NULL             |
| 42414 | mc-log-user |$SERVER        :53019    | minecraft   | Sleep          |  219 |                    | NULL             |
| 42456 | mc-log-user |$SERVER        :39008    | minecraft   | Sleep          |  215 |                    | NULL             |
| 42538 | mc-log-user |$SERVER        :57456    | minecraft   | Sleep          |  237 |                    | NULL             |
| 42542 | mc-log-user |$SERVER        :57457    | minecraft   | Sleep          |  194 |                    | NULL             |
| 42627 | mc-log-user |$SERVER        :60775    | minecraft   | Sleep          |  215 |                    | NULL             |
| 42708 | mc-log-user |$SERVER        :47059    | minecraft   | Sleep          |  237 |                    | NULL             |
| 42709 | mc-log-user |$SERVER        :47060    | minecraft   | Sleep          |  194 |                    | NULL             |
| 42753 | mc-log-user |$SERVER        :49750    | minecraft   | Sleep          |  219 |                    | NULL             |
| 42793 | mc-log-user |$SERVER        :46438    | minecraft   | Sleep          |  215 |                    | NULL             |
| 42874 | mc-log-user |$SERVER        :45960    | minecraft   | Sleep          |  237 |                    | NULL             |
| 42875 | mc-log-user |$SERVER        :45961    | minecraft   | Sleep          |  194 |                    | NULL             |
| 43032 | mc-log-user |$SERVER        :60780    | minecraft   | Sleep          |  237 |                    | NULL             |
| 43033 | mc-log-user |$SERVER        :60781    | minecraft   | Sleep          |  194 |                    | NULL             |
| 43074 | mc-log-user |$SERVER        :44397    | minecraft   | Sleep          |  219 |                    | NULL             |
| 43202 | mc-log-user |$SERVER        :39615    | minecraft   | Sleep          |  237 |                    | NULL             |
| 43203 | mc-log-user |$SERVER        :39616    | minecraft   | Sleep          |  194 |                    | NULL             |
| 43241 | mc-log-user |$SERVER        :39685    | minecraft   | Sleep          |  219 |                    | NULL             |
| 43362 | mc-log-user |$SERVER        :34972    | minecraft   | Sleep          |  237 |                    | NULL             |
| 43365 | mc-log-user |$SERVER        :34973    | minecraft   | Sleep          |  194 |                    | NULL             |
| 43524 | mc-log-user |$SERVER        :41398    | minecraft   | Sleep          |  237 |                    | NULL             |
| 43525 | mc-log-user |$SERVER        :41399    | minecraft   | Sleep          |  194 |                    | NULL             |
| 43694 | mc-log-user |$SERVER        :52520    | minecraft   | Sleep          |  237 |                    | NULL             |
| 43697 | mc-log-user |$SERVER        :52521    | minecraft   | Sleep          |  194 |                    | NULL             |
| 43736 | mc-log-user |$SERVER        :34083    | minecraft   | Sleep          |  219 |                    | NULL             |
| 43854 | mc-log-user |$SERVER        :39483    | minecraft   | Sleep          |  237 |                    | NULL             |
| 43855 | mc-log-user |$SERVER        :39484    | minecraft   | Sleep          |  194 |                    | NULL             |
| 44014 | mc-log-user |$SERVER        :56547    | minecraft   | Sleep          |  237 |                    | NULL             |
| 44015 | mc-log-user |$SERVER        :56548    | minecraft   | Sleep          |  194 |                    | NULL             |
| 53566 | mc-log-user |$SERVER        :60333    | minecraft   | Sleep          |  248 |                    | NULL             |
| 53648 | mc-log-user |$SERVER        :59930    | minecraft   | Sleep          |  248 |                    | NULL             |
| 53649 | mc-log-user |$SERVER        :59932    | minecraft   | Sleep          |  219 |                    | NULL             |
| 53835 | mc-log-user |$SERVER        :40740    | minecraft   | Sleep          |  219 |                    | NULL             |
| 53964 | mc-log-user |$SERVER        :47815    | minecraft   | Sleep          |  248 |                    | NULL             |
| 54045 | mc-log-user |$SERVER        :47035    | minecraft   | Sleep          |  219 |                    | NULL             |
| 54127 | mc-log-user |$SERVER        :40268    | minecraft   | Sleep          |  248 |                    | NULL             |
| 54213 | mc-log-user |$SERVER        :38191    | minecraft   | Sleep          |  219 |                    | NULL             |
| 54298 | mc-log-user |$SERVER        :40436    | minecraft   | Sleep          |  248 |                    | NULL             |
| 54385 | mc-log-user |$SERVER        :50909    | minecraft   | Sleep          |  219 |                    | NULL             |
| 54468 | mc-log-user |$SERVER        :43737    | minecraft   | Sleep          |  248 |                    | NULL             |
| 54551 | mc-log-user |$SERVER        :52274    | minecraft   | Sleep          |  219 |                    | NULL             |
| 54631 | mc-log-user |$SERVER        :55586    | minecraft   | Sleep          |  248 |                    | NULL             |
| 54717 | mc-log-user |$SERVER        :47479    | minecraft   | Sleep          |  219 |                    | NULL             |
| 54796 | mc-log-user |$SERVER        :43997    | minecraft   | Sleep          |  248 |                    | NULL             |
| 54883 | mc-log-user |$SERVER        :48578    | minecraft   | Sleep          |  219 |                    | NULL             |
| 54967 | mc-log-user |$SERVER        :41470    | minecraft   | Sleep          |  248 |                    | NULL             |
| 55139 | mc-log-user |$SERVER        :54740    | minecraft   | Sleep          |  248 |                    | NULL             |
| 55305 | mc-log-user |$SERVER        :41234    | minecraft   | Sleep          |  248 |                    | NULL             |
| 55472 | mc-log-user |$SERVER        :40066    | minecraft   | Sleep          |  248 |                    | NULL             |
| 55561 | mc-log-user |$SERVER        :57802    | minecraft   | Sleep          |  248 |                    | NULL             |
| 55646 | mc-log-user |$SERVER        :37948    | minecraft   | Sleep          |  248 |                    | NULL             |
| 55807 | mc-log-user |$SERVER        :43310    | minecraft   | Sleep          |  248 |                    | NULL             |
+-------+-------------+--------------------------+-------------+----------------+------+--------------------+------------------+
    I'll keep posting them until you say otherwise. :)
     
    Justin The Cynical, Jul 21, 2011
    #610
  12. Offline

    oliverw92

    No need to keep posting now :p It's obvious I didn't fix the issue lol
     
    oliverw92, Jul 21, 2011
    #611
  13. Offline

    Sleaker

    ok so there is some serious bad logic in here. What is happening right now is that datalog is logging every event no matter what because the events are set on priority.low. DataLog's logging MUST be in Priority.Monitor otherwise there is no way to determine that it is logging for sure what is actually taking place. This also means that any form of block protection may need to happen in a seperate helper plugin (unless you can register more than 1 event handler of each type). Because you need to monitor the actual outcome of the event and log appropriately NOT do event cancellation during the log process.
    On top of this, the method call for addEntry is ambiguously returning a boolean which if successful cancels the event? The logic does not flow from this one, if you want to check an action to cancel it logically it should not ever happen in a log action..

    Records should never be added to the database on a cancelled event - right now they are always being added regardless of other plugin cancellations.
     
    Sleaker, Jul 21, 2011
    #612
  14. Offline

    oliverw92

    I have fixed that in the most recent version - discovered that issue during testing recently.
     
    oliverw92, Jul 21, 2011
    #613
  15. Offline

    Sleaker

    most recent version doesn't have any kind of a fix like that, and neither does the github? So have you just not released it?
     
    Sleaker, Jul 21, 2011
    #614
  16. Offline

    oliverw92

    SOrry I meant, the version I am soon to release
     
    oliverw92, Jul 21, 2011
    #615
  17. Offline

    DJ_Idol

    DJ_Idol, Jul 22, 2011
    #616
  18. Offline

    oliverw92

    It looks perfectly fine to me. What browser are you using?
     
    oliverw92, Jul 22, 2011
    #617
  19. Offline

    DJ_Idol

    Hm...wierd. I'm on Firefox, and for me it's all jumbled and overlayed
     
    DJ_Idol, Jul 22, 2011
    #618
  20. Offline

    oliverw92

    Do you have javascript enabled? Try deleting the entire web interface, redownloading it and reuploading it to your web server.
     
    oliverw92, Jul 22, 2011
    #619
  21. Offline

    h0us3cat

    What permissions do i need for /dl here <radius>
     
    h0us3cat, Jul 25, 2011
    #620
  22. Offline

    heifinator

    Im having an issue where whenever I rollback more than about 500 entries it crashes the server

    8gb ram, RB1000, newest datalog

    Any insight? Thanks!
     
    heifinator, Jul 25, 2011
    #621
  23. Offline

    oliverw92

    datalog.search

    I am currently looking into this. I can't work out what is going wrong.
     
    oliverw92, Jul 26, 2011
    #622
  24. Offline

    h0us3cat

    This gives me a error
    Code:
    18:55:03 [SEVERE] [DataLog] Error executing MySQL query: com.mysql.jdbc.exceptio
ns.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax to
 use near ') AND (x BETWEEN 147.8125 AND 157.8125) AND (y BETWEEN 71.0 AND 81.0)
 AND (z BET' at line 1
    People with permissions '*' can do /dl here <> without errors.
     
    h0us3cat, Jul 26, 2011
    #623
  25. Offline

    oliverw92

    Interesting... I will look into it.
     
    oliverw92, Jul 26, 2011
    #624
  26. Offline

    RG_PankO

    @oliverw92 can it rollback entire nickname already?
     
    RG_PankO, Jul 26, 2011
    #625
  27. Offline

    oliverw92

    @RG_Pank In the next version yes. I am very busy at the moment and do not have developer time
     
    oliverw92, Jul 26, 2011
    #626
  28. Offline

    TheShadow777

    hm /dl rollback r:20 works fine but /dl rollback p:name works not (tells me no changes) !? :confused:
     
    TheShadow777, Jul 26, 2011
    #627
  29. Offline

    oliverw92

    As I have said just a few posts up, that is being addressed in the next version
     
    oliverw92, Jul 26, 2011
    #628
  30. Offline

    Forge_User_45935876

    This is probably caused by most recent CB:

    Deprecated method.

    Code:
    2011-07-28 07:53:25 [SEVERE] Error occurred while enabling DataLog v1.3.0 (Is it up to date?): SNOW_FORM
java.lang.NoSuchFieldError: SNOW_FORM
        at uk.co.oliwali.DataLog.DataLog.onEnable(DataLog.java:95)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:878)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
     
    Forge_User_45935876, Jul 28, 2011
    #629
  31. Offline

    oliverw92

    Thanks, fixing it now

    Ok I have worked out why large rollbacks are crashing servers. It will take some time to fix though, so I will be releasing v1.3.1 in a minute.

    @Sleaker @Joy @TheShadow777 @RG_PankO @h0us3cat @GhostlyDonut

    Version v1.3.1
    • Fixed rolling back entire player failin
    • Implemented separate listeners for 'control' events
    • Swapped from deprecated SNOW_FORM event to BLOCK_FORM event
    No need to update the interface.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
    oliverw92, Jul 28, 2011
    #630
Page 21 of 24
Thread Status:
Not open for further replies.

Share This Page