[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.
  1. Offline

    oliverw92

    Vaupell, Pinkpixels, Sleaker and 2 others like this.
  2. Offline

    oliverw92

    JDBC doesn't affect your server - it's just a way of connecting from Java to data sources
     
  3. Offline

    tycoonbob

    Ok, so then the only thing I can really see is that it says the thing about dataid doesnt have a default value. Care to walk me through that using mysql from command line? Or is it in a config file?
     
  4. Offline

    oliverw92

    Run this:

    ALTER TABLE `datalog` MODIFY `dataid` int Default '';
     
  5. Offline

    tycoonbob

    I guess I'm making this to hard? Below is what I got, and I'm not sure what to do from there, but it didn't fix my issue.
    Code:
    mysql> ALTER TABLE 'datalog' MODIFY 'dataid' int Default";
        ">
    
     
  6. Offline

    oliverw92

    Do you have phpMyAdmin access?
     
  7. Offline

    tycoonbob

    I do...and it showed that there were no default for dataid. So I set it to 0, and retried logging into my server. Now the logs show this:

    2011-06-08 19:45:38 [SEVERE] Could not pass event PLAYER_QUIT to DataLog
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[Duplicate entry '0' for key 'PRIMARY']

    Wow, I think I fixed it. I created a new db, and set that up and it is working now! I will run it for a bit and do some testing and let you know how it goes.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
  8. Offline

    oliverw92

    Cool hope it goes ok!
     
  9. Offline

    tycoonbob

    Well tested a few things, and it's all seems to be working like it should. In my server log there is no more errors, and things are pulling up properly on my website, so that's awesome.
    One thing I can note, I could not get it to work with a database named 'minecraft' but it works just fine with a database named 'minecraft1'. Makes no sense, but I guess I can live with that haha.

    Thanks again! (and I will post back later tonight to let you know how it's going)
     
  10. Offline

    Arcen1k

    My website is hosted with zymic.com and it's address is ***.99k.org which is a subset of zymic my minecraft server is hosted on my laptop which also hosts the MySQL server with XAMPP and with the last part I do not know what you quite mean. Anyways I hope that helps a little.
     
  11. Offline

    DJ_Idol

    I'm getting some weird error that is causing my server to time-out:

    Code:
    2011-06-09 00:41:24 [SEVERE] mapping values are not allowed here
     in "<reader>", line 2, column 13:
            username: kunden_61306
                    ^
    
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.scanner.ScannerImpl.fetchValue(ScannerImpl.java:745)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.scanner.ScannerImpl.fetchMoreTokens(ScannerImpl.java:307)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.scanner.ScannerImpl.checkToken(ScannerImpl.java:183)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockMappingKey.produce(ParserImpl.java:564)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:163)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:148)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:228)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:124)
    2011-06-09 00:41:24 [SEVERE]     at org.yaml.snakeyaml.Yaml.load(Yaml.java:264)
    2011-06-09 00:41:24 [SEVERE]     at org.bukkit.util.config.Configuration.load(Configuration.java:74)
    2011-06-09 00:41:24 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:82)
    2011-06-09 00:41:24 [SEVERE]     at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:49)
    2011-06-09 00:41:24 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:130)
    2011-06-09 00:41:24 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    2011-06-09 00:41:24 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-09 00:41:24 [SEVERE] Unexpected exception
    mapping values are not allowed here
     in "<reader>", line 2, column 13:
            username: kunden_61306
                    ^
    
        at org.yaml.snakeyaml.scanner.ScannerImpl.fetchValue(ScannerImpl.java:745)
        at org.yaml.snakeyaml.scanner.ScannerImpl.fetchMoreTokens(ScannerImpl.java:307)
        at org.yaml.snakeyaml.scanner.ScannerImpl.checkToken(ScannerImpl.java:183)
        at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockMappingKey.produce(ParserImpl.java:564)
        at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:163)
        at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:148)
        at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:228)
        at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:160)
        at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122)
        at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105)
        at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:124)
        at org.yaml.snakeyaml.Yaml.load(Yaml.java:264)
        at org.bukkit.util.config.Configuration.load(Configuration.java:74)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:82)
        at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:49)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:130)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-09 00:42:00 [INFO] Read timed out
    
     
  12. Offline

    oliverw92

    Try quoting everything in bukkit.yml . If you are stil having difficulties, paste your bukkit.yml here

    Is your laptop setup with your home router so that it is accessible from outside your home for MySQL access? Your website needs to be able to connect to your home IP which then needs to be port-forwarded (forward port 3306 to your laptop on your router) to your laptop.

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

    neko259

    1. Your interface is very strange. It understands filters in random ways. For example, I can put exact coordinate and it would work. But if I put a radius (even big, like 200 or 1000) and the same exact coordinate - it says it found nothing.
    2. Add player location to in-game search. I don't want to look at my coordinates with F3, write them on a paper and then type. I want to stand on that coordinates and write something like l:current as my position.
     
  14. Offline

    oliverw92

    1. I'll check out why radiuses aren't working - is it both in game and the web interface that do that?
    2. I'll add l:current in and i've already implemented /dl here <radius> for the next version
     
  15. Offline

    neko259

    1. It's only in web chat, in-game commands work fine.
    2. Ok, thanks.
     
  16. Offline

    Tealk

    hi i have a problem that datalog dont log all
    config

    Code:
    version: 1.0.2
    command-filter:
    - /login
    - /restartsrv
    - /register
    log:
        lava-bucket: true
        water-bucket: true
        pvp-death: true
        block-break: true
        open-chest: true
        chat: true
        join: true
        quit: true
        sign-place: true
        block-place: true
        door-interact: false
        command: true
        teleport: true
        flint-steel: true
        lever: true
        button: true
        other: true
    max-lines: 0
    
    if im surch here
    http://78.47.47.178/DataLog/
    eg
    x -115
    z 158
    brake and place
    Range 10

    there only come this
    2011-06-04 12:43:07 BuddhaBeaTz Block Break world -115,17,158 Coal Ore
    2011-06-04 12:43:08 BuddhaBeaTz Block Break world -115,16,158 Coal Ore

    but i (Tealk) have place torches but this didnt log
     
  17. Offline

    oliverw92

    I think there is a bug with searching by a radius in the interface, i'll look into it.
     
  18. Offline

    tombik

    K ničemu, o co ti jde?
     
  19. Offline

    neko259

    Can you please tell me two things:
    1. If I turn on block-break logging, what size will my database have after some months of logging?
    2. Does it have some log rotation? For example, and option to wipe the logs two months old? I don't think such an old logs are useful versus griefers.
     
  20. Offline

    Archelaus

  21. Offline

    oliverw92

    I'm at 11 million logs with everything logging. Plugin has been running for 2 months on the server. That is more than acceptable (2GB database). Note that with the next version of DataLog I am adding events such as leaf decay, explosion logging etc. You will probably want to turn off these if you want to keep your database size to a minimum.

    I am planning to implement a new 'cleanesing' system with the next release. You will be able to configure the maximum age of logs and the plugin will auto remove old logs
     
  22. Offline

    neko259

    Can you implement blocks select for logging? For example, I want to log only glass breaking, or only obsidian placing.
     
  23. Offline

    oliverw92

    I would rather implmenent 'ignore-blocks' where it doesn't log those blocks. Would that be acceptable?
     
  24. Offline

    neko259

    That's the same option but other way :)
     
  25. Offline

    oliverw92

    Yeah - I prefer it that way because it doesn't force everyone to use it
     
  26. Offline

    Shortguy014

    I've setup everything in correspondence to the Wiki but I still receive this error once I any player logons. Note: No errors occur once the server is started, only when someone joins or places a block etc.

    Code:
    18:16:57 [SEVERE] Could not pass event PLAYER_JOIN to DataLog
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[Fiel
    d 'dataid' doesn't have a default value]
            at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(D
    mlBeanPersister.java:116)
            at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(Dm
    lBeanPersister.java:76)
            at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeI
    nsertBean(DefaultPersistExecute.java:91)
            at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(Per
    sistRequestBean.java:527)
            at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue
    (PersistRequestBean.java:557)
            at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(Defaul
    tPersister.java:404)
            at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaIn
    sert(DefaultPersister.java:377)
            at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaRe
    curse(DefaultPersister.java:361)
            at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(D
    efaultPersister.java:308)
            at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultP
    ersister.java:282)
            at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.
    java:1577)
            at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.
    java:1567)
            at uk.co.oliwali.DataLog.DataManager.addEntry(DataManager.java:36)
            at uk.co.oliwali.DataLog.DataManager.addEntry(DataManager.java:29)
            at uk.co.oliwali.DataLog.listeners.DLPlayerListener.onPlayerJoin(DLPlaye
    rListener.java:49)
            at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.ja
    va:243)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.jav
    a:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.j
    ava:310)
            at net.minecraft.server.ServerConfigurationManager.c(ServerConfiguration
    Manager.java:123)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:96)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:33)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:401)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:311)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.sql.SQLException: Field 'dataid' doesn't have a default value
            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.sendCommand(MysqlIO.java:1986)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
    va:2111)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
    :2407)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
    :2325)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
    :2310)
            at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.exec
    uteUpdate(ExtendedPreparedStatement.java:164)
            at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.j
    ava:74)
            at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(Inse
    rtHandler.java:155)
            at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(D
    mlBeanPersister.java:105)
            ... 24 more
    >
     
  27. Offline

    oliverw92

    Delete your DataLog table, then try using this one: http://dl.dropbox.com/u/24279633/DataLog.jar

    Please tell me if it works, i'll release it as a bug patch.
     
  28. Offline

    Techykid3

    This looks awesome, but with a GUI? Even Better!!!!! Keep up the good work!
     
  29. Offline

    oliverw92

    Thanks!

    Quick update on the status of v1.1.0 - pretty much everything is done. There are TONS of new features, including massive speed improvements. I am bug testing now on my server, got a few small issues to iron out first (rollback orders etc) I also need to fix a few bugs with the in-game browser.

    I am looking for people to translate my language file into other languages - i've done a french one myself (it is probably terrible!). If you can help me i would really appreciate it!
     
  30. Offline

    Shortguy014

    This worked thanks!

    EDIT: Now that the plugin works I am absolutely in love!
     
  31. Offline

    oliverw92

    Glad it works for you!
     
Thread Status:
Not open for further replies.

Share This Page