[INACTIVE][SEC] BigBrother 1.7.1: A Complete Griefer Logging + Rollback Package [531]

Discussion in 'Inactive/Unsupported Plugins' started by tkelly, Jan 5, 2011.

Thread Status:
Not open for further replies.
Search this thread
Advanced search...
Page 3 of 92
     
  1. Offline

    tkelly

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    BigBrotherv1.7.1
    irc.esper.net #BigBrother
    LATEST 617+-COMPATIBLE SNAPSHOT HERE

    What is BigBrother?
    BigBrother is a powerful weapon in the war against griefers, and this particular tool has the ability to log and rollback every individual change a griefer has done via a large, all-knowing database that logs every action a user has taken. It gives you the utilities to inspect the world around you and determine who made what change, so you can catch the griefer every time. You can go here for more information, but here's a few examples:
    1. Log players' block destruction, placement, chats, commands, and so much more
    2. When chests are destroyed, their contents are logged
    3. Log blocks destroyed by TNT and Creeper Explosions and Fires
    4. Inspect missing blocks, opened chests using a variety of tools
    5. Rollback all changes to exactly as they were
    6. Rollback by player, time, area, and block type

    I want a full list of what it logs.
    Okay. Here it goes:
    Broken blocks, placed blocks, destroyed signs' text, teleportation, changes in chest contents, commands, chats, disconnects, logins (with IP address), opening doors, pushing buttons, lever switches, created signs' text, leaf decay, TNT explosions, Creeper explosions, miscellaneous explosions, the opening of chests, burnt blocks, and lava flow.
    I'll admit, this list is pretty small (only 20 things). But with every update of BB, this list grows to allow you to log or not log anything you could want.

    That's a nice list, but what can I really do with BB?
    I'll give you a few scenarios in which BB can really come to the rescue.
    1. Complete Grief Rollback: A griefer, meanieguy, comes and starts griefing away when your admins are away. And when I say grief, I mean grief. He gets his hands on buckets of lava, TNT, and goes to town. By the time an admin gets back on, meanieguy and half of your town is gone. The admin can quickly and easily identify that meanieguy was the crook using /bb here or the SuperSticks. After that, all he has to do is issue the command: /bb rollback meanieguy, and everything is back to normal. Flows of lava is cleaned up, TNT explosions have been fixed, welcome signs are back with their sometimes-odd text, chests are back with their original contents, and your users are happy
    2. Specific Rollbacks: A couple of your (typically good) server members get a little carried away when making modifications to someone else's building. You don't want to rollback all their changes, but only in a particular area and within a certain period of time. You can just use: /bb rollback tw3dled3 tw3dledum t:1d5h r:20, and that will rollback just their changes, within a 20 block radius and within the past 1 days and 5 hours.
    3. Building Identification: Ever stumble across a building that is either so good or so bad that you have to know whose it was? By using /bb stick 1, you'll get a stick that will let you identify who placed or modifed which blocks. /bb stick 2 will give you a log that will let you inspect "air", water, and lava blocks (basically things that aren't rightclick-able).
    4. Creeper Rollbacks: Creepers are annoying for a two reasons: they kill you and they blow up your stuff. Thankfully, BigBrother can take care of reason 2. If a creeper blocks up the side of your building, you can quickly fix it by using /bb rollback Environment r:5. This will rollback any environmental changes within 5 blocks.
    *With the current version of BigBrother, you may have to do more work to rollback TNT, burnt blocks, and lava. Currently, these are logged as "Environment" (as it's difficult to match these actions up to a specific player). So rolling back meanieguy and Environment with a good time argument will easily take care of this.




    Hm, Okay. Where can I go to get more information?
    You can hop on over to BigBrother's github repository.
    There we have a wiki full of installation, troubleshooting, and command information; the full and bleeding edge source code; and an issue tracker to get your problems solved.

    Video Tutorial

    By Samkio.

    Changelog

    BigBrother v1.7.1
    Released 16 Mar, 2011
    - Built with CB 531.
    - Fix for SQLite problem with (LIMIT)
    - Fix for people using non-permissions plugin
    - Initial table prefix support.

    BigBrother v1.7
    Released 13 Mar, 2011
    - Updated + Compiled for CB 527, Permissions 2.5.3, GroupManager 1.0+
    - Inserts into database are now (optionally) LOW_PRIORITY (thanks GpMidi!)
    - Sanitizes names before sending to DB (helps w/ name hack)
    - Logging of signs changed using the Mass Sign Hack (.eas)
    - Rollback by Tick (greatly reduces lag during rollbacks, customizable # of blocks/tick)
    - Threaded and cleaned up Cleansing (much faster, no lag).
    - Options to restrict # of entries removed each cleansing
    - Cleansing happens on a schedule
    - '/bb version' and '/bb update'. version: tells you the version of BB you're running. update: tells you if there is an update. (These also work in the console: 'bb version' and 'bb update')
    - Complete properties file change: BigBrother.properties + watching.properties -> BigBrother.yml. (it will auto-convert)
    - Fix for broken bed logging
    - Fix for cancelled onEntityExplodes
    - Help support. View organized help w. '/help bb'- Auto-download of libraries is now optional
    - Temporarily turned off threading of /bb here and SuperSticks
    - Leaf Removal + Lava Flow defaulted to off
    - /bb log : Alias for /bb stick 2
    - A few other things...

    BigBrother v1.6.3
    Released 27 Feb, 2011
    - Fix for removal of Bukkit's onPlayerCommand
    - Command-logging fixed!
    - SuperStick threading
    - /bb here threading

    BigBrother v1.6.2
    Released 26 Feb, 2011
    - "Fixed" SQLite problem with database locking during datablock sending.
    - Fixed problem where it gives you sticks instead of proper item
    - Fixed but where Chest Logs end in "-"
    - Modified table schema to allow for longer chest logging.
    - Better error reporting when unable to create connection.
    - Extra Permissions check + better messaging
    - Initial Threading: Less lag when logging blocks and rolling back.

    BigBrother v1.6.1
    Released 23 Feb, 2011
    - "Fixed" SQLite problem with Cleansing
    - Fixed IndexOutOfBoundsException when timeCleanse setting was set to "0s"

    BigBrother v1.6
    Released 23 Feb, 2011
    - Multiworld support! Rolling back by radius will be limited to the world you're in. (All other rollbacks will still be universal)
    - Database cleansing on startup by age or number of records. Look in bigbrother.properties for these settings.
    - Initial On-demand cleansing. Using '/bb cleanse' (bb.admin.cleanse), it will invoke the cleansing under the settings you have. This will be built upon in upcoming updates.
    - Initial Lava Flow logging + rollback. Those ugly lava flows will be quickly removed. (Logs to "Environment" for now)
    - Sign creation text logging. Logs the text of signs when they build (in addition to destroy) signs
    - Performance enhancements from Oni and N3X15 builds
    - Player IP Logging on login (from Oni build) (can be turned off)
    - Better '/bb help'
    - No longer using the long, spammy constructor.
    - Fix for the not logging of broken blocks.

    BigBrother 1.5
    Jan 30 - (CraftBukkit #186)
    - Requires build #183 or higher
    - Logging/Rollback of blocks burnt by fire, initially to player "Environment". (fire = action #19)
    - Rollback confirmation if you're rolling back without a radius or time argument
    - Customize what the stick is (check "stickItem" in BigBrother.properties)
    - "History Log" - /bb stick 2 - Gives you a log to place and gives you the history there.
    - SuperSticks will now supply you with the item they need.
    - More permission separation between info, rollbacks, and watching (check the OP for more info)
    - /bb stats gives you a few basic stats about BB
    - Memory free'ing after sending blocks (thanks to Zenexer for that)
    - Restores optionally restore fire blocks, default false (check restoreFire in BigBrother.properties)

    BigBrother 1.4.3
    Jan 25 - (CraftBukkit #135)
    - All the updates from 1.4.2
    - Different management of connections

    BigBrother 1.4.2 (caused Conn. problems)
    Jan 24 - (CraftBukkit #135)
    - Removed annoying spam!
    - If connection can't be established from the start, BB tells you and shutsdown (rather than keeping on warning)
    - If connection fails in the middle of running the program, it's reset
    - Better handling of problems when saving to the database
    - Handling of data being too long
    - Right-clicking stuff with super stick doesn't interact with them

    BigBrother 1.4.1
    Jan 24 - (CraftBukkit #135)
    - Fixes internal client error with using just /bb

    BigBrother 1.4
    Jan 24 - (CraftBukkit #135)
    - Better connection management for SQLite and MySQL
    - Optional use of INNODB with MySQL
    - Fixes 'y' out of bounds error with MySQL
    - Creating Signs are now logged
    - Moved settings + data into plugins/BigBrother
    - Dependency downloader - Auto-Downloads SQLite and MySQL libraries into lib/ folder (thanks to Hidendra <3)
    - SuperSticks! - Support for many different types of sticks for searching an area
    - 'History Stick' - The first SuperStick, gives detailed history of a block
    - Radius Rollback - Specify the radius around you to rollback (using r: )
    - TNT/Creeper Logging - Log the blocks destroyed by TNT or creepers (for now logged as "Environment")
    - Leaf Decay -Logs leaves that decay so you can roll your trees back (for now logged as "Environment")
    - Flint+Steel logging
    - Opening chests - No chest modification though, the right hooks aren't in place
    - Destroying chests logging and rollback - If someone breaks your chest, roll them back and get all ur stuffs back

    See Older Ones Here...
    tkelly, Jan 5, 2011
    #1
    Mattb4rd, harakiwi, Partylizard and 16 others like this.
    2.  
  2. Offline

    lawina

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Same problem here.

    [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using sqlite.
    [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
    lawina, Jan 15, 2011
    #61
  3. Offline

    Racha

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Full console woth this -
    Code:
    [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:31:36 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:31:40 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:31:40 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:31:44 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:31:44 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:31:47 [INFO] Racha lost connection: disconnect.quitting
2011-01-15 19:31:48 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:31:48 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:31:52 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:31:52 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:31:56 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:31:56 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:32:00 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:32:10 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
2011-01-15 19:32:10 [SEVERE] [BBROTHER]: Data Insert SQL Exception (cnf) using mysql
2011-01-15 19:32:10 [INFO] [BBROTHER]: SQL send failed. Keeping data for later send.
    Racha, Jan 15, 2011
    #62
  4. Offline

    bandit6789

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    I'm using WAMP, works great.

    BTW love this plugin
    bandit6789, Jan 15, 2011
    #63
  5. Offline

    Phanku

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Jan 15, 2011 1:30:23 PM org.bukkit.plugin.SimplePluginManager callEvent
    SEVERE: Could not pass event BLOCK_DAMAGED to BigBrother
    java.lang.NoSuchMethodError: org.bukkit.Block.getTypeID()I
    at me.taylorkelly.bigbrother.datablock.BrokenBlock.<init>(BrokenBlock.java:14)
    at me.taylorkelly.bigbrother.BBBlockListener.onBlockDamaged(BBBlockListener.java:19)
    at org.bukkit.plugin.java.JavaPluginLoader.callEvent(JavaPluginLoader.java:172)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:199)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:329)
    at net.minecraft.server.Packet14BlockDig.a(SourceFile:42)
    at net.minecraft.server.NetworkManager.a(SourceFile:232)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:63)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:261)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:197)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    SET_SLOT for window: 0 index: 37and stack: 5xtile.dirt@0 -- SEND!
    SET_SLOT for window: 0 index: 39and stack: 1xitem.arrow@0 -- SEND!
    SET_SLOT for window: 0 index: 36and stack: 2xitem.bone@0 -- SEND!
    SET_SLOT for window: 0 index: 39and stack: 2xitem.arrow@0 -- SEND!
    Jan 15, 2011 1:30:38 PM org.bukkit.plugin.SimplePluginManager callEvent
    SEVERE: Could not pass event BLOCK_DAMAGED to BigBrother
    java.lang.NoSuchMethodError: org.bukkit.Block.getTypeID()I
    at me.taylorkelly.bigbrother.datablock.BrokenBlock.<init>(BrokenBlock.java:14)
    at me.taylorkelly.bigbrother.BBBlockListener.onBlockDamaged(BBBlockListener.java:19)
    at org.bukkit.plugin.java.JavaPluginLoader.callEvent(JavaPluginLoader.java:172)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:199)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:302)
    at net.minecraft.server.Packet14BlockDig.a(SourceFile:42)
    at net.minecraft.server.NetworkManager.a(SourceFile:232)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:63)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:261)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:197)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    SET_SLOT for window: 0 index: 40and stack: 1xtile.rose@0 -- SEND!
    Jan 15, 2011 1:30:41 PM org.bukkit.plugin.SimplePluginManager callEvent
    SEVERE: Could not pass event BLOCK_DAMAGED to BigBrother
    java.lang.NoSuchMethodError: org.bukkit.Block.getTypeID()I
    at me.taylorkelly.bigbrother.datablock.BrokenBlock.<init>(BrokenBlock.java:14)
    at me.taylorkelly.bigbrother.BBBlockListener.onBlockDamaged(BBBlockListener.java:19)
    at org.bukkit.plugin.java.JavaPluginLoader.callEvent(JavaPluginLoader.java:172)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:199)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:302)
    at net.minecraft.server.Packet14BlockDig.a(SourceFile:42)
    at net.minecraft.server.NetworkManager.a(SourceFile:232)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:63)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:261)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:197)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)

    with build 25.
    Phanku, Jan 15, 2011
    #64
  6. Offline

    tkelly

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    @People having trouble with (cnf) errors: You need the dependency library for SQLite or MySQL (whichever you're using). The downloads are in the OP and you put them in the same directory as CraftBukkit

    @Phanku: I'll be fixing it up for build 25 later tonight.
    tkelly, Jan 15, 2011
    #65
  7. Offline

    fffizzz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    hey, didnt know if you saw this or not, but im getting that error again, but with a different coluymn this time.

    Thanks for your hard work!
    fffizzz, Jan 15, 2011
    #66
  8. Offline

    TheArcher

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    I seem to get this error when I run the server:
    [IMG]
    TheArcher, Jan 15, 2011
    #67
  9. Offline

    bradcland

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    While BigBrother wasn't working, my server was griefed.
    bradcland, Jan 16, 2011
    #68
  10. Offline

    Lim-Dul

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Cool story bro!

    P.S. That's why you don't use software not even released publicly on production servers.
    Lim-Dul, Jan 16, 2011
    #69
  11. Offline

    bradcland

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    There aren't very many options since hMod was dropped.
    bradcland, Jan 16, 2011
    #70
  12. Offline

    Nipper

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Huge memory leak with this. While running due to the all the sql writes it fills up my /tmp folder with .lib files. So in the end my /tmp folder gets filled forcing me to restart the server to clear the /tmp dir. Here is what I mean.


    root@s1 /]# df -hl
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda5 2.0G 1.5G 400M 79% /
    /dev/sda8 198G 3.5G 184G 2% /home
    /dev/sda3 9.7G 2.1G 7.2G 23% /usr
    dev/sda2 9.7G 362M 8.9G 4% /var
    /dev/sda1 99M 32M 62M 34% /boot
    /dev/sda6 996M 944M 0 100% /tmp
    tmpfs 2.0G 0 2.0G 0% /dev/shm
    [root@s1 /]#


    This is my config




    mysqlPass = root #Password for MySQL db (if applicable)
    mysqlUser = root #Username for MySQL db (if applicable)
    MySQL = false #If true, uses MySQL. If false, uses Sqlite
    mysqlDB = jdbc:mysql://localhost:3306/minecraft #DB for MySQL (if applicable)
    autoWatch = true #Automatically start watching players
    defaultSearchRadius = 2 #Default search radius for bbhere and bbfind
    flatFileLogs = true #If true, will also log actions to .logs (one for each player)


    I might try changing over to MySQL later to see if this solves the issue. But this should be addressed.
    Nipper, Jan 16, 2011
    #71
  13. Offline

    Fewmets

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    do you have the sqlite dependence library installed? otherwise it can't write the tmp files to your sqlite database.
    Fewmets, Jan 16, 2011
    #72
  14. Offline

    Equ1n0x

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    will this be updated to 44? This together with Guardian Basically makes griefers a past nuisance
    Equ1n0x, Jan 16, 2011
    #73
  15. Offline

    tkelly

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    1.3.2 Updated to #48+.
    - Fixed for all the changes to Bukkit
    - Fix for ffizz's 'y' problem
    - Only OP's can use commands now.


    @Nipper : I will definitely work on fixing that.
    Could you verify a few things for me:
    - It is BB that's causing it? Like if you disable it, there is no problem, but when it's back on, there is.
    - It only happens when running SQLite?
    tkelly, Jan 16, 2011
    #74
    bradcland likes this.
  16. Offline

    bradcland

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    I love you.
    bradcland, Jan 16, 2011
    #75
  17. Offline

    Jobsti

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Thanks for the update. works with #50.
    Jobsti, Jan 16, 2011
    #76
  18. Offline

    fuzzyslippers

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Hello. I'm running latest everything(scrap,craft,bukkit) as of 12:52 PM EST. Whenever I load BigBrother I get this... From what I can tell, it's a mysql error. I have the mysql and sqlite connectors...
    Code:
    2011-01-16 00:49:17 [SEVERE] [BBROTHER]: Table Check SQL Exception mysql
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 5 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at me.taylorkelly.bigbrother.datablock.BBDataBlock.bbdataTableExists(BBDataBlock.java:96)
    at me.taylorkelly.bigbrother.datablock.BBDataBlock.initialize(BBDataBlock.java:81)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:53)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:133)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:269)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:173)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:41)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:153)
    at net.minecraft.server.MinecraftServer.c(MinecraftServer.java:140)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:104)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:177)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
Caused by: java.net.ConnectException: Connection refused
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
    at java.net.Socket.connect(Socket.java:529)
    at java.net.Socket.connect(Socket.java:478)
    at java.net.Socket.<init>(Socket.java:375)
    at java.net.Socket.<init>(Socket.java:218)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
    ... 23 more
2011-01-16 00:49:17 [INFO] [BBROTHER]: Generating bbdata table
2011-01-16 00:49:17 [SEVERE] [BBROTHER]: Create Table SQL Exception mysql
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at me.taylorkelly.bigbrother.datablock.BBDataBlock.createBBDataTable(BBDataBlock.java:131)
    at me.taylorkelly.bigbrother.datablock.BBDataBlock.initialize(BBDataBlock.java:83)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:53)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:133)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:269)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:173)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:41)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:153)
    at net.minecraft.server.MinecraftServer.c(MinecraftServer.java:140)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:104)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:177)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
Caused by: java.net.ConnectException: Connection refused
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432)
    at java.net.Socket.connect(Socket.java:529)
    at java.net.Socket.connect(Socket.java:478)
    at java.net.Socket.<init>(Socket.java:375)
    --- merged: Jan 16, 2011 5:54 AM ---
    at java.net.Socket.<init>(Socket.java:218)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
    ... 23 more
    2011-01-16 00:49:17 [INFO] [BBROTHER] Updating table for 1.3
    2011-01-16 00:49:17 [SEVERE] [BBROTHER]: Update Table 1.3 Fail mysql
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    Last packet sent to the server was 0 ms ago.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at me.taylorkelly.bigbrother.fixes.Fix13.updateTable(Fix13.java:55)
    at me.taylorkelly.bigbrother.fixes.Fix13.apply(Fix13.java:39)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:56)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:133)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:269)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:173)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:41)
    fuzzyslippers, Jan 16, 2011
    #77
  19. Offline

    ScytheX10

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    BB is not inserting new data into the mysql db. i just loaded up the new version, no errors, but /bb here or /bb rollback acts as if no changes were made. It's like data isn't being put in the database.

    Confirmed: It's not inserting anything into the database. For me, anyway.
    ScytheX10, Jan 16, 2011
    #78
  20. Offline

    fuzzyslippers

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Sorry i couldnt fit the entire error msg. I'll make a txt file
    fuzzyslippers, Jan 16, 2011
    #79
  21. Offline

    Fewmets

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    @fuzzyslippers do you have an SQL server set up? if so link to your server in the config file. otherwise change use-mysql to false and it will use SQLite which doesn't require a database server
    Fewmets, Jan 16, 2011
    #80
    fuzzyslippers likes this.
  22. Offline

    tkelly

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    That error happens if you try to use MySQL without MySQL running.
    If you don't know if it is, chances are that it's not :p And if it's not I'd recommend using SQLite instead.
    Just go to BigBrother.properties in the BigBrother/ directory and change "use-mysql = false"
    tkelly, Jan 16, 2011
    #81
    fuzzyslippers likes this.
  23. Offline

    fuzzyslippers

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Thank you!
    fuzzyslippers, Jan 16, 2011
    #82
  24. Offline

    bradcland

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    I'm getting the same thing, /bb here isn't showing changes.
    bradcland, Jan 16, 2011
    #83
  25. Offline

    Nipper

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    I'm running a older version like build #19. Later tonight once everyone has gone to bed I will test it and tell you.
    Nipper, Jan 16, 2011
    #84
  26. Offline

    tkelly

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    @ScytheX10, bradcland: I'll check this out and try to get an update up soon.

    Edit: Redownload 1.3.2 (same zip), this has been fixed :) Sorry about that.
    tkelly, Jan 16, 2011
    #85
  27. Offline

    stolen_insanity

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    I have reinstalled the plugin and I'm getting the same problem.
    bb is logging all the users and their actions but the commands aren't working e.g. /bb here or /bb rollback
    stolen_insanity, Jan 16, 2011
    #86
  28. Offline

    tkelly

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    In the latest version you need to be an 'OP' to be able to use any of the commands. This is using the built-in Notch groups. (You can op yourself through the console).

    After Bukkit releases its permission system, BB will be using that.
    tkelly, Jan 16, 2011
    #87
  29. Offline

    arthoz

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    Awesome, thanks for plugin and OP-change =)
    arthoz, Jan 16, 2011
    #88
  30. Offline

    stolen_insanity

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)
    added ops
    Commands work :D thanks alot
    stolen_insanity, Jan 16, 2011
    #89
  31. Offline

    Nipper

    dev.bukkit.org profile:
    CFUSERNAME
    My Plugins (CFCOUNT)

    Just updated my server to newest 61bukket. It happens. I still see some things that are using sqlite. Like MyHome but not filling up so fast. I did disable BB to see if it was the cause and it was. It seems like the sqlite jar is and might be the cause of this. It does not seem to remove its temp files from the /tmp dir like it should. But once I restart Bukkit it self it all gose poof.

    I will try switching to MySQL to see if it helps.

    Update: I was correct it is the SQLite dependency library That was causing the issue. Once I switched to the MySQL no more full /tmp. So might want to look in to getting it fixed. Not for sure if you made the SQLite part but might report it to them. The MyWarp uses the same thing and every time someone sets warp it makes a .lib in the /tmp dir of the size of 415kb and does not delete it self. But unlike big brother it does not write 10+times in under a minute to the /tmp dir so it wont fill up as fast.
    Nipper, Jan 16, 2011
    #90
Page 3 of 92
Thread Status:
Not open for further replies.

Share This Page