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

16/08/2011 - DataLog has been massively rewritten and re-released under the new name of HawkEye. You can find HawkEye here:

​

You can upgrade straight from DataLog to HawkEye. See this wiki page: https://github.com/oliverw92/HawkEye/wiki/Importing-from-other-logging-plugins

 

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.

 

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

 

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

 

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.

 

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

 

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.

 

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?

 

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.

 

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

 

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

 

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

 

Please explain me what this means?

Show Spoiler Hide 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 nameataLog 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

 

Have you got a database called minecraft?

 

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.

 

Can you post the contents of your bukkit.yml?

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

 

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?

 

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.

 

@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.

 

Sorry i've had IRL stuff to do.

 

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

 

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

 

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!

##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

 

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

 

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.

 

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

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

 

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.

 

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?

 

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

 

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.

 

I belive this plugin is not made for anti-grief, it is made for logging.