[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

    Deses12

    You Misspelled my name. =PPP
     
  3. Offline

    Tealk

    a question any problems if i update from 0.2 to 1.0.2?
     
  4. Offline

    oliverw92

    None at all. It may take a while to update the database though if your database is large - it has to add another column and change a load of xyz values. On my server, the database had around 11 million entries in and I think it took around 20-30 minutes to update

    I'm thinking about implementing rollbacks into DataLog so you don't need to run another plugin like DataLog/BigBrother too. If BigBrother was still being actively developed, not just kept up to date with the latest RB, i wouldn't bother.

    Good idea?

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

    tombik

    I love you guy. Youre awesome! DataLog is really powerfull and extra plugin. It should be featured or something :). It helped me and my server so many times so i have thank u a lot. I've translated it (to czech) a bit, so u can take a look.
     
  6. Offline

    oliverw92

    Glad you like it! You should update to the latest version of the plugin and the web interface - it is much better than the old one.
     
  7. Offline

    hofec

    [in czech] A tohle slouží k čemu tombiku ? jestli se teda můžu zeptat..

    @oliverw92
    i will check this out .. DataLog seems to be powerfull tool, thx :)
     
  8. Offline

    oliverw92

    Awesome :)
     
  9. Offline

    DJ_Idol

    I'd love for you to implement a rollback feature.

    Also...I'm having some problems setting-up the webserver connection, here's my config.php:

    Show Spoiler

    Code:
    <?php
    
        ///////////////////////////////////////////////////
    
        //         DataLog Interface Config File         //
    
        //                 by oliverw92                  //
    
        ///////////////////////////////////////////////////
    
        //     Edit the config array below with your     //
    
        //     details. Make sure all strings are        //
    
        //     escaped. If you can't work this out,      //
    
        //     ask in the thread on bukkit.org.          //
    
        ///////////////////////////////////////////////////
    
        $config = array(
    
                        //Enter your MySQL database information
    
                        //Do not change 'dbTable'
    
                        "dbHost"  => "mysql.xenonservers.com",
    
                        "dbDbase" => "kunden_61306",
    
                        "dbUser"  => "kunden_61306",
    
                        "dbPass"  => "***",
    
                        "dbTable" => "datalog",
    
                        
    
                        //Set this to the password you want people to have to use to access the interface
    
                        //Leave blank for no password
    
                        "password" => "",
    
                        
    
                        //Default radius to search for if user supplies a location
    
                        "radius" => 30,
    
                        
    
                        //Limit the maximum number of results that can be returned. Do not use quotes
    
                        //Set to 0 for no limit
    
                        "maxResults" => 0
    
                        );
    
        
    
        $con = mysql_connect($config["dbHost"], $config["dbUser"], $config["dbPass"]);
    
        if (!$con)
    
            die("Could not connect to MySQL Database!");
    
        if (!mysql_select_db($config["dbDbase"], $con))
    
            die(mysql_error());
    
            
    
        mysql_query("SET NAMES UTF8");
    
            
    
    ?>
    


    All the information is correct, it's the same in my bukkit.yml, and it works on the server, but when I try to use the webserver search, I get this error:

    Code:
    [B]Warning[/B]:  mysql_connect() [[URL='http://watercraftmc.com/datalog/function.mysql-connect']function.mysql-connect[/URL]]: Can't connect to MySQL server on 'mysql.xenonservers.com' (4) in [B]/home/content/07/7876007/html/datalog/config.php[/B] on line [B]63[/B]
     Could not connect to MySQL Database!
    
    Any ideas?
     
  10. Offline

    oliverw92

    Odd - could you paste your bukkit.yml too? How is your minecraft server set up (i.e. where is it hosted etc)
     
  11. Offline

    ssechaud

    I think the download links are still for v1.0.1?
     
  12. Offline

    oliverw92

    My bad, fixed.

    Rollback implementation is done, I'm now adding loads more events that you might want to rollback (explosions, snow form, leaf decay, snow form, block burn etc). Then i need to add in a tool for looking up single blocks.
     
  13. Offline

    DJ_Idol

    Here's my bukkit.yml:

    Code:
    database:
        username: kunden_61306
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: ***
        url: jdbc:mysql://mysql.xenonservers.com:3306/kunden_61306
    settings:
        update-folder: update
    
    And it's hosted with a server hosting company (XenonServers)
     
  14. Offline

    oliverw92

    If its hosted on the same server as the database, could you not use localhost?
     
  15. Offline

    DJ_Idol

    Well, I'm hosting the web files on a separate host (GoDaddy), for use on my website (http://www.watercraftmc.com/datalog), so I thought if I used localhost it would look for the SQL db on watercraftmc.com and not mysql.xenonservers.com?
     
  16. Offline

    Puseidr

    on killing monsters i get always this error code:

    Code:
    [SCHWERWIEGEND]Could not pass event PLAYER_INTERACT to DataLog
    java.lang.NullPointerException
            at uk.co.oliwali.DataLog.listeners.DLPlayerListener.onPlayerInteract(DLPlayerListener.java:74)
            at org.bukkit.plugin.java.JavaPluginLoader$9.execute(JavaPluginLoader.java:299)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
            at org.bukkit.craftbukkit.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:162)
            at org.bukkit.craftbukkit.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:133)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:791)
            at net.minecraft.server.Packet18ArmAnimation.a(SourceFile:35)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:217)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            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)
    
     
  17. Offline

    oliverw92

    My bad, thought you had the webserver on the same thing. It sounds like the database doesn't allow external connections - check with your hosting.

    I'll look into it
     
  18. Offline

    Arcen1k

    I tried setting it up on my web server. I told it which dbHost to connect to (my server laptop with XAMPP) I gave it the user and pass and database and table etc, but I cannot get it to work. Every time I access the file online it tries to connect the MySQL that the web host has and won't connect to my server laptops MySQL etc.
    Here's the error code:
    Code:
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'admin'@'192.168.1.1' (using password: YES) in .....website address..... on line 32 Could not connect to MySQL Database!
    any advice would be much appreciated!
     
  19. Offline

    tycoonbob

    So I'm having issues getting my server to log anything to the SQL db. I am running on a server here at home, running Server 2008 R2 with WAMP. I have two websites hosted on this same server with WAMP, so I know MySQL, PHP, and Apache are set up correctly. Attached are my 3 config files, and the forth is what I'm getting from the server. The db user account has full access to the db, at least I'm pretty sure.

    bukkit.yml
    Show Spoiler

    settings:
    update-folder: update
    database:
    username: tycoonbob
    isolation: SERIALIZABLE
    driver: com.mysql.jdbc.Driver
    password: *****
    url: jdbc:mysql://localhost:3306/minecraft


    config.yml
    Show Spoiler

    max-lines: 0
    log:
    lava-bucket: true
    water-bucket: true
    other: true
    pvp-death: true
    block-break: true
    open-chest: true
    chat: true
    join: true
    quit: true
    sign-place: true
    block-place: true
    door-interact: true
    flint-steel: true
    button: true
    command: true
    teleport: true
    lever: true
    version: 1.0.2
    command-filter:
    - /login
    - /restartsrv
    - /register


    config.php
    Show Spoiler

    <?php
    ///////////////////////////////////////////////////
    // DataLog Interface Config File //
    // by oliverw92 //
    ///////////////////////////////////////////////////
    // Edit the config array below with your //
    // details. Make sure all strings are //
    // escaped. If you can't work this out, //
    // ask in the thread on bukkit.org. //
    ///////////////////////////////////////////////////
    $config = array(
    //Enter your MySQL database information
    //Do not change 'dbTable'
    "dbHost" => "localhost",
    "dbDbase" => "minecraft",
    "dbUser" => "tycoonbob",
    "dbPass" => "*****",
    "dbTable" => "datalog",
    //Set this to the password you want people to have to use to access the interface
    //Leave blank for no password
    "password" => "",
    //Default radius to search for if user supplies a location
    "radius" => 30,
    //Limit the maximum number of results that can be returned. Do not use quotes
    //Set to 0 for no limit
    "maxResults" => 0
    );
    $con = mysql_connect($config["dbHost"], $config["dbUser"], $config["dbPass"]);
    if (!$con)
    die("Could not connect to MySQL Database!");
    if (!mysql_select_db($config["dbDbase"], $con))
    die(mysql_error());
    mysql_query("SET NAMES UTF8");
    ?>


    Error in my Minecraft server logs
    Show Spoiler

    2011-06-07 21:40:47 [INFO] tycoonbob lost connection: disconnect.quitting
    2011-06-07 21:40:47 [INFO] Connection reset
    2011-06-07 21:40:47 [SEVERE] Could not pass event PLAYER_QUIT to DataLog
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[Field 'dataid' doesn't have a default value]
    at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:116)
    at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:76)
    at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:91)
    at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:527)
    at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:557)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:404)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaInsert(DefaultPersister.java:377)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaRecurse(DefaultPersister.java:361)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:308)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.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.onPlayerQuit(DLPlayerListener.java:55)
    at org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:250)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
    at net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:145)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:611)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:222)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    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.java: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.executeUpdate(ExtendedPreparedStatement.java:164)
    at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74)
    at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:155)
    at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
    ... 25 more



    Any idea what's going on? I can't figure it out, and I really want to get this logging to work! From what I can tell, it's not a PHP issue...I first thought it was a permission issue, but I used PHPMyAdmin to give the db user full access to the db...so I don't think that's it. Help?

    Thanks a ton!!
     
  20. Offline

    DJ_Idol

    It's all good, I'll check with my host, thanks :)
     
  21. Offline

    looklee

    Attached Files:

  22. Offline

    oliverw92

    You haven't uploaded all the files to the web server - you need to upload EVERYTHING in the datalog/ folder for the web interface - including index.html, everything else.

    I'm a bit confused about where stuff is hosted. Please tell me:

    Where the database is hosted
    Where the minecraft server is hosted
    Where the web interface is hosted

    Wow that's an odd one! Never seen that before. It could be something to do with your database settings - it could be in some kind of strict mode or something. Has it created the table ok?

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

    tycoonbob

    Lucky me, haha. From what I can tell, it created 1 table "datalog", and inside that table there are 0 records. Under privileges, the my username as well as the global root user, have all been granted "ALL PRIVILEGES"

    Any ideas?
     
  24. Offline

    oliverw92

    Run this query:
    SET sql_mode = '';
     
  25. Offline

    tycoonbob

    Didn't seem to do anything for me. I ran it from phpmyadmin, and from the command line in mysql (which I'm more accustomed to).
     
  26. Offline

    oliverw92

    It's still giving that error? Ok try modifying the field 'dataid' so it has a default value of 0


    I'm going to hold off until next week before i release rollbacks. I am going to completely redo the database system. I realised today how massive inefficient it is - with my current plans, database queries will be (number of entries in database)/(number of different players) times faster. So for my database which has around 11 million entries, searching will be 11,000 times faster :p
     
  27. Offline

    DJ_Idol

  28. Offline

    oliverw92

    Hm i'm actually not sure. Maybe your web hosting doesn't allow outgoing mysql connections?
     
  29. Offline

    tycoonbob

    Not sure what you mean by dataid. I can also say that I created a new database, "minecraft1" instead of "minecraft", and I am still getting errors. I cleared the log file, and restarted my server and below is what I got.

    Show Spoiler

    2011-06-08 18:21:20 [INFO] Starting minecraft server version Beta 1.6.6
    2011-06-08 18:21:20 [INFO] Loading properties
    2011-06-08 18:21:20 [INFO] Starting Minecraft server on *:25565
    2011-06-08 18:21:20 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-766-g3fc0460-b818jnks (MC: 1.6.6)
    2011-06-08 18:21:20 [INFO] Preparing level "TycoonCraft"
    2011-06-08 18:21:20 [INFO] Preparing start region for level 0
    2011-06-08 18:21:21 [INFO] Preparing spawn area: 85%
    2011-06-08 18:21:21 [INFO] Preparing start region for level 1
    2011-06-08 18:21:22 [INFO] Preparing spawn area: 85%
    2011-06-08 18:21:22 [INFO] DataSourcePool [DataLog] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    2011-06-08 18:21:23 [SEVERE] FATAL: DataSourcePool [DataLog] is down!!!
    2011-06-08 18:21:23 [INFO] Reseting DataSourcePool [DataLog] min:2 max:20 free:0 busy:0 waiting:0 highWaterMark:0 waitCount:0 hitCount:0
    2011-06-08 18:21:23 [INFO] Busy Connections:

    2011-06-08 18:21:23 [SEVERE] Could not load 'plugins\DataLog.jar' in folder 'plugins':
    com.avaje.ebeaninternal.server.lib.sql.DataSourceException: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.<init>(DataSourcePool.java:210)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourceManager.getDataSource(DataSourceManager.java:210)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourceGlobalManager.getDataSource(DataSourceGlobalManager.java:63)
    at com.avaje.ebeaninternal.server.core.DefaultServerFactory.getDataSourceFromConfig(DefaultServerFactory.java:427)
    at com.avaje.ebeaninternal.server.core.DefaultServerFactory.setDataSource(DefaultServerFactory.java:388)
    at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:168)
    at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:64)
    at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:78)
    at org.bukkit.plugin.java.JavaPlugin.initialize(JavaPlugin.java:175)
    at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:174)
    at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:194)
    at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:117)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:103)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:232)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:219)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:146)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    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 com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.createUnpooledConnection(DataSourcePool.java:401)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.createConnectionForQueue(DataSourcePool.java:607)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.ensureMinimumConnections(PooledConnectionQueue.java:205)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.initialise(DataSourcePool.java:248)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.<init>(DataSourcePool.java:208)
    ... 17 more
    2011-06-08 18:21:23 [INFO] [MobileAdmin] Loading server stats.
    2011-06-08 18:21:23 [INFO] [MobileAdmin] Loading chat log.
    2011-06-08 18:21:23 [INFO] [MobileAdmin] Loading users.
    2011-06-08 18:21:23 [INFO] [MobileAdmin] Starting server...
    2011-06-08 18:21:23 [INFO] [MobileAdmin] Version 3.0 is enabled!
    2011-06-08 18:21:23 [INFO] [MobileAdmin] Server listening on *:5839
    2011-06-08 18:21:23 [INFO] SimpleSave: Parts of config file are blank, but not null. Possible errors might happen.
    2011-06-08 18:21:23 [INFO] SimpleSave: Parts of config file are blank, but not null. Possible errors might happen.
    2011-06-08 18:21:23 [INFO] SimpleSave: 3.12 Initialized
    2011-06-08 18:21:23 [INFO] Done (0.280s)! For help, type "help" or "?"


    If you notice line 15, it says it can't load the DataLog.jar plugin. I'm getting ready to re-download and try again and see what happens.
     
  30. Offline

    oliverw92

    Details are wrong or permissions aren't right
     
  31. Offline

    tycoonbob

    I sorted that out, I was doing something wrong when I made a change. I have deleted all files and started anew, so I'm going to try that. Maybe has something to do with JDBC? I don't have that set up, as I don't know anything about it.
     
Thread Status:
Not open for further replies.

Share This Page