[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

    Thanks it shouldn't affect anything it is just a warning

    Worked it out! Look at the errors - the last lot are being caused by LWC, not my plugin. Look throuhg them a bit more and you can see that it says 'too many connections'. This means that the MySQL database has run out of connections. There are three things that could cause this:
    1. Your database has too few connections set in its configuration. It is 100 by default which should be plenty, however if you are using web hosting for the database it might be limited.
    2. LWC has really bad connection management and does not close its MySQL connections.
    3. There is something else other than minecraft stuff that is accessing the database and not closing its connections.

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

    Αρρεν

    Can you make it possible to logging in UTF-8 (not in Latin1) because server.log have normal russian letters but not in database. :(
    // I changed font.txt in my server.jar to have russian alphabet

    *** doesn't matter anyway I repaired connection default codepage with this

    on MySQL server a changed/added this in my.cnf
    Code:
    [client]
    default-character-set = utf8
    
    [mysqld]
    default-character-set = utf8
    
    [mysql]
    default-character-set = utf8
    
     
  4. Offline

    cholo71796

    Perhaps Brohoster puts a lower-than-default limit on connections, who knows
     
  5. Offline

    oliverw92

    Seems you solved it - DataLog will log whatever is compatible with minecraft and MySQL - it doesn't care whether it is Latin1 or UTF-8

    You can test this. Get a completely fresh server and first use datalog. If it gives you that error still then it is an issue with Brohoster and how many connections bukkit uses on it. If you don't, install LWC. If you then get that error, LWC isn't managing connections right.
     
  6. Offline

    cholo71796

    I would if people weren't playing on my server. :D
     
  7. Offline

    Αρρεν

    Solved just UTF-8 from Linux, but CP1251 from Windows users I cant read, it looks like this "ãẽũõ" and other…
    So have disabled it :(
    Waiting until Notch will made full international support.
     
  8. Offline

    oliverw92

    Run up a test server. You should never be testing plugins live on your main server anyway.

    Is there anything I can do to fix that or not? Where does it show up wrong?
     
  9. Offline

    Αρρεν

    Maybe try to detect encoding (if CP1251) and convert it to UTF-8, and store it into database, I like your plugin for chat logging into MySQL, but if someone from Windows tried to chat, I will receive bullshit in my database. That's crap!
    // I know that linux users (and mac) chatting in UTF-8 encoding, but windows only in CP1251.
     
  10. Offline

    oliverw92

    Ok so the text shows up fine in minecraft itself, but when it is put into the database it comes up in gibberish?
     
  11. Offline

    cholo71796

    We're talking about things specific to Brohoster. I can't run a Brohoster test server...
     
  12. Offline

    oliverw92

    Can you download your server setup and run it on your local machine to see if you get the same issues?
     
  13. Offline

    ruben

    Please explain me what this means?
    Show Spoiler
    23:51:47 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-681-
    g0f8abd2-b709jnks (MC: 1.5_02)
    23:51:47 [INFO] Preparing level "world"
    23:51:47 [INFO] Preparing start region
    23:51:48 [INFO] Preparing spawn area: 73%
    23:51:48 [SEVERE] ebean.properties not found
    23:51:49 [INFO] DataSourcePool [DataLog] autoCommit[false] transIsolation[SERIAL
    IZABLE] min[2] max[20]
    23:51:49 [INFO] DatabasePlatform name:DataLog platform:mysql
    23:51:49 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.Plugi
    nClassLoader]
    23:51:50 [INFO] Entities enhanced[0] subclassed[1]
    23:51:50 [INFO] LWC Loading shared objects
    23:51:50 [INFO] LWC Native library: plugins/LWC/lib/native/Windows/x86/sqlit
    ejdbc.dll
    23:51:50 [INFO] [Permissions] (Phoenix) was Initialized.
    23:51:50 [INFO] ControllerBlock: 1.18 by Hell_Fire
    23:51:53 [INFO] ControllerBlock: Using IRON_BLOCK (42) as ControllerBlock, loade
    d 0 disallowed types from config
    23:51:53 [INFO] [Albus] v3.0 - Trying to load whitelist and settings...
    23:51:53 [INFO] [Albus] v3.0 - Running database connection...
    23:51:53 [INFO] [Albus] v3.0 - Enabled!
    23:51:53 [INFO] ControllerBlock: Enabling full redstone check
    23:51:53 [INFO] ControllerBlock: Events registered
    23:51:53 [INFO] CopyCat 0.2 Enabled
    23:51:53 [INFO] [DataLog] Installing database due to first time usage
    23:51:53 [WARNING] Column name [date] is a suspected SQL reserved word for prope
    rty uk.co.oliwali.DataLog.DataEntry.date
    23:51:53 [INFO] runScript
    23:51:53 [INFO] executing 1 of 1 create table datalog ( dataid
    integer auto_increment not null...
    23:51:53 [SEVERE] Error: Error executing stmt[create table datalog ( dataid
    integer auto_increment not null, date varcha
    r(255) not null, player varchar(255) not null, action
    integer not null, world varchar(255) not null, x
    double not null, y double not n
    ull, z double not null, data varcha
    r(255), constraint pk_datalog primary key (dataid)) ] error[Table 'minecraft.dat
    alog' doesn't exist] loading DataLog v0.2 (Is it up to date?)
    javax.persistence.PersistenceException: Error: Error executing stmt[create table
    datalog ( dataid integer auto_increment not null, date
    varchar(255) not null, player varchar(255) no
    t null, action integer not null, world va
    rchar(255) not null, x double not null, y
    double not null, z double not null, data
    varchar(255), constraint pk_datalog primary key (dataid)) ] erro
    r[Table 'minecraft.datalog' doesn't exist]
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerato
    r.java:233)
    at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:253)
    at uk.co.oliwali.DataLog.DataLog.setupDatabase(DataLog.java:71)
    at uk.co.oliwali.DataLog.DataLog.onEnable(DataLog.java:52)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:584)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:218)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: java.lang.RuntimeException: Error executing stmt[create table datalog
    ( dataid integer auto_increment not null, date
    varchar(255) not null, player varchar(255) not null,
    action integer not null, world varchar(25
    5) not null, x double not null, y
    double not null, z double not null, data
    varchar(255), constraint pk_datalog primary key (dataid)) ] error[Table
    'minecraft.datalog' doesn't exist]
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGener
    ator.java:281)
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGene
    rator.java:246)
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerato
    r.java:224)
    ... 13 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'min
    ecraft.datalog' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
    rce)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.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.execute(PreparedStatement.java:1362)

    at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.exec
    ute(ExtendedPreparedStatement.java:136)
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGener
    ator.java:272)
    ... 15 more
     
  14. Offline

    oliverw92

    Have you got a database called minecraft?
     
  15. Offline

    ruben

    Yes. My database is called minecraft, it is on localhost, other plugins can work with this database. My forum can work with the mySQL server. So, I think it is plugin related.
     
  16. Offline

    oliverw92

    Can you post the contents of your bukkit.yml?

    Also can you check if there is a table called datalog in the minecraft database?
     
  17. Offline

    maetthew

    My bukkit.yml currently has some SQLLite configuration. How would I go about to change this to MySQL? Sureley I can't just change the SQLLite conf to the MySQL conf. Wouldn't this screw up things?
     
  18. Offline

    oliverw92

    Do you have plugins that already use the bukkit.yml database stuff? If you do, all you need to do is import the data they have stored in their .db files into your mysql database, then change bukkit.yml to use mysql.
     
  19. Offline

    KiloWhiskey

    @oliverw92 Hey, it's been about 2 weeks since I last bugged you, so can we PLEASE get a time based search and multiple player search? Also, please make x and z only use 2 decimals or less again. There's really no need for it to go out to 12. Thanks, I still love the plugin.
     
  20. Offline

    oliverw92

    Sorry i've had IRL stuff to do.
     
  21. Offline

    SirPole

    Hi, does your plugin work also with Bukkit 740? I hope so...
     
  22. Offline

    KiloWhiskey

    Works perfectly all the way up through the new RB 766.
     
  23. Offline

    Nato

    Works amazingly great and has no issues so far. It took a few restarts of my http server and the minecraft server to get it going but since then its been working fine. I'm really looking forward to the BB integration cause that wood be great.

    Is there any way that in the future to add a system where we can exclude a column from appearing. When i want to know when people log in, there really isnt any need for their coords.
    But not to take it away from just some sections. To be able to have like an options check list where we check what columns to exclude. Please give response! IT WOULD BE FREAKING AMAZING IF YOU COULD! :D

    ##EDIT##
    Wait i got an error

    Whenever i try to select:
    -Water Bucket
    -Open Chest
    -Door Interact

    I get this error repeated along the screen

    Code:
    Notice: Undefined offset: 1 in C:\Apache2.2\htdocs\pArchives\H4XCraft_DataLog\searchDB.php on line 82
     
  24. Offline

    Trevor_

    Could use an update, getting tons of read timed out errors from just this plugin.
     
  25. Offline

    Jumla

    Hm, i am getting an error.

    It is hosted on a mysql database stored on the web hosting plan.

    Heres my server.log: http://pastebin.com/PNmin4Ni

    Heres My Bukkit.yml: http://pastebin.com/JAz6zR9H

    The web interface works fine, but the server isn't connecting up to it.

    If it helps, i am using Xenon Servers, and they have a firewall, so if i need a port opened, i need to ask them.
     
  26. Offline

    KiloWhiskey

    driver: org.sqlite.JDBC
    should be
    driver: com.mysql.jdbc.Driver

    You can't use sqlite for DataLog. Give that a shot.
     
  27. Offline

    greycap

    Is it possible to use/mod this addon to use the logs created by LogBlock?
    I already have every action on my server logged by it and it would be pointless to log everything twice.
     
  28. Offline

    Jumla

    Close, but no cigar.

    Updated Server.log: http://pastebin.com/ydtT9Cdg

    Updated Bukkit.yml: http://pastebin.com/h3h9DFZs

    The webspace were datalog is installed: http://epiclight.org/datalog

    Once again, i believe the firewall might be blocking it from connecting to database. What port needs to be unblocked?
     
  29. Offline

    KiloWhiskey

    I connect to mine on 3306. That's default for mysql... This is my exact config.
    Code:
    database:t
        username: usernamehere
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: passwordhere
        url: jdbc:mysql://localhost:3306/minecraft
    settings:
        update-folder: update
     
  30. Offline

    OlDrunk

    Having some issues with your plugin not loggin data, one player on my server was griefing and DataLog only logged chat nothing else the player has done ( still caught via chat) , seems to have a lot of data gaps as well and the date is always two weeks behind the server clock , won't log TNT , only logs dirt, cobblestone and couple of other basic things or is this a future update to log all data other wise you should maybe state that this plugin doesn't logs a few things right now.
     
  31. Offline

    Jumla

    I belive this plugin is not made for anti-grief, it is made for logging.
     
Thread Status:
Not open for further replies.

Share This Page