DataGatherer
A Plugin that hooks into all kind of actions and saves all kind of informations in a sqlite/MySQL database
Gathered Informations
Player
- name
- display
- x
- y
- z
- death
- blocksBroken
- blocksPlaced
- blocksIgnited
- chatlines
- logins
- joins
- quits
- kicks
- teleports
- respawns
- ip
PlayerSession
- start
- end
- reason (current Status/quit reason)
Plugin
- name
- fullname
- version
- website
- description
- author
- enabled
Server
- timestamp
- name
- currentPlayer
- maxPlayer
- version
World
- name
- enviroment
- spawnx
- spawny
- spawnz
System
- timestamp
- maxmemory
- freememory
- totalmemory
- cpus
Configurable Values
databasetype - default sqlite
Defines which database type to use. If 'sqlite' is selected plugins/DataGatherer/datagatherer.sqlite will be used. If 'mysql' is selected you also have to set the Properties 'host', 'database', 'user', 'password'
host
Only needed when databasetype 'mysql' has been selected. The host where te MySQL Database is running
database
Only needed when databasetype 'mysql' has been selected. The database at the given MySQL server
user
Only needed when databasetype 'mysql' has been selected. The user to connect to the given MySQL server
password
Only needed when databasetype 'mysql' has been selected. The password to connect to the given MySQL server
memoryWriteInterval - default 10
Defines the Interval in seconds used for writing Memory Informations to the log. 0 means disabled.
pluginUpdateInterval - default 10
Check interval in seconds for gathering plugin informations. 0 means disabled.
playerUpdateInterval - default 10
Check interval in seconds for gathering player informations. 0 means disabled.
serverUpdateInterval - default 10
Check interval in seconds for gathering world and server informations. 0 means disabled.
memoryUpdateInterval - default 10
Check interval in seconds for gathering system informations. 0 means disabled.
Player blocks broken
Is this an amount or every single block recorded`?
2011-10-12 06:44:52 [SEVERE] [DATAGATHERER] Plugin Insert Exception com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'version' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591) 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 de.tiramon.bukkit.datagatherer.database.DataSource.addPlugin(DataSource.java:244) at de.tiramon.bukkit.datagatherer.DataGatherer.onChange(DataGatherer.java:537) at de.tiramon.bukkit.datagatherer.obj.DGObject.fireChangeEvent(DGObject.java:35) at de.tiramon.bukkit.datagatherer.obj.DGPlugin.setVersion(DGPlugin.java:100) at de.tiramon.bukkit.datagatherer.DataGatherer.updatePlugins(DataGatherer.java:502) at de.tiramon.bukkit.datagatherer.DataGathererThread.run(DataGathererThread.java:58) 2011-10-12 06:44:52 [SEVERE] [DATAGATHERER] Plugin Insert Exception com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'version' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591) 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 de.tiramon.bukkit.datagatherer.database.DataSource.addPlugin(DataSource.java:244) at de.tiramon.bukkit.datagatherer.DataGatherer.onChange(DataGatherer.java:537) at de.tiramon.bukkit.datagatherer.obj.DGObject.fireChangeEvent(DGObject.java:35) at de.tiramon.bukkit.datagatherer.obj.DGPlugin.setEnabled(DGPlugin.java:62) at de.tiramon.bukkit.datagatherer.DataGatherer.updatePlugins(DataGatherer.java:505) at de.tiramon.bukkit.datagatherer.DataGathererThread.run(DataGathererThread.java:58)
Sql fail
03:28:57 [SEVERE] Error occurred while enabling DataGatherer v0.2 (Is it up to date?): de.tiramon.bukkit.datagatherer.database.SqliteConnectionManager cannot be cast to de.tiramon.bukkit.datagatherer.database.MysqlConnectionManager java.lang.ClassCastException: de.tiramon.bukkit.datagatherer.database.SqliteConnectionManager cannot be cast to de.tiramon.bukkit.datagatherer.database.MysqlConnectionManager at de.tiramon.bukkit.datagatherer.DataGatherer.onEnable(DataGatherer.java:240) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:941) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280) at com.bekvon.bukkit.plugman.PlugMan.enablePlugin(PlugMan.java:338) at com.bekvon.bukkit.plugman.PlugMan.reloadPlugin(PlugMan.java:352) at com.bekvon.bukkit.plugman.PlugMan.doCommand(PlugMan.java:133) at com.bekvon.bukkit.plugman.PlugMan.onCommand(PlugMan.java:65) at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40) at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163) at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358) at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:354) at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506) at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374) at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)