Inactive [SEC] xAuth v2.0.10 - Extra Authentication [1.2.5-R1.3+]

Discussion in 'Inactive/Unsupported Plugins' started by CypherX, Mar 15, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    CypherX

    xAuth v2.0.10 - (CraftBukkit build: [1.2.5-R1.3+])
    Download v2.0.10

    lycano is taking over the development of xAuth as I no longer have the time nor the will to continue working on it. Please see the BukkitDev page: http://dev.bukkit.org/server-mods/xauth/

    Thanks to everyone who has showed support for me and xAuth over the past 17 months. It's been 'fun'. If for any reason you need to contact me, stop by my IRC channel (irc.rizon.net #LoveDespite) or toss me a message at http://love-despite.com/forum. Until we meet again, stay gold. Bang.

    ------------------------------------------------------------------​

    xAuth is a plugin designed with a single task in mind: protect a server and its players while running in offline-mode. The basic idea of this protection is allowing players to register an account based on their player name and a supplied password. When a registered player connects to the server, that player will be prompted to authenticate his or herself by logging in. If and only if a valid password is supplied, they will regain full control of their account until their session expires.


    Features
    • Before registering/logging in, players cannot:
      • Chat, execute commands, interact with objects (levers, chests, etc.), move, or pickup items.
      • Break or place blocks
      • Receive or give damage, be targeted (followed) by hostile mobs
    • Inventory and location protection
    • In-depth setting and message configuration
    • Persistent login sessions through server restarts
    • Player name filter and password complexity configuration
    • Kick non-logged in (but registered) players after a configurable amount of time
    • Bukkit Permissions support
    • Kick or temporarily lockout the IP address of a player who fails to log in after a configurable amount of tries
    • Custom, highly secure password hashing
    • H2 and MySQL support
    • Authentication over URL (AuthURL) allows for connection to forum or website databases
    Changelog (click for full changelog)
    • Version 2.0.10
      • [Fixed] Exploit to completely bypass login system.
      • [Fixed] xAuth commands not working with Rcon
      • [Fixed] Exploiting login system to avoid fire & drowning damage.
      • [Fixed] NPE caused by player connecting & disconnecting during same server tick.
      • [Fixed] 'Table "SESSIONS" not found' error when a player uses /logout while session length is set to zero.
      • [Fixed] Exploiting location protection after dieing to return to the spot of death.
    • Version 2.0.9
      • Added several reverse single session configuration options.
      • Fixed registration.forced: false not working.
      • Updated version check and H2 download links.
    xAuth Importer
    xAuth Importer is a tool used to import accounts from previous versions of xAuth as well as other authentication plugins. Click here for more information.
     
  2. Offline

    Worlther

    CB #1060
     
  3. Offline

    XxXLuisXxX

    Hey, i've a huge problem with xAuth, it's connecting to my Database (tables are generated) , and it looks like it's running, but if I try to use any command (like /register mypw), I only get showed the whole syntax: /register <password< [e-mail]. So I can't get it to work.

    My config:
    Show Spoiler

    # How should xAuth store data (Accounts, sessions, etc.)?
    # Possible values: h2, mysql
    datasource: mysql
    # If set to true, xAuth will disable itself if the server is in online-mode
    auto-disable: false
    # If set to true, all required library files will be automatically downloaded
    download-libraries: true
    # When set to true, if a player connects with the same name as someone who is
    # already online, the player connecting will be kicked instead of the online player
    reverse-enforce-single-session: true

    authurl:
    # Send user/pass data to authURL for authentication instead of the database
    # This option disables registration and password changes
    enabled: false
    # The URL to send user/pass data to, look at the example auth.php for an
    # example that works with SMF forums.
    url: http://127.0.0.1/auth.php?field=minecra

    mysql:
    # Location of the MySQL server. Can be either a host name or IP address
    host: localhost
    # Port used by MySQL. Default is 3306
    port: 3306
    # User name used to connect to the MySQL server
    username: *
    # Password used to connect to the MySQL server
    password: *
    # Name of the database that will be used by xAuth
    database: *
    # Names of the tables xAuth will use to store data
    tables:
    account: Xaccounts
    session: Xsessions
    strike: Xstrikes
    location: Xtele_locations
    inventory: Xinventory

    registration:
    # Enable/disable new registrations
    enabled: true
    # If set to true, everyone must register
    forced: true
    # Setting this to true requires a player to enter an email address when they register
    require-email: true
    # If set to true, a valid email address is required
    validate-email: true
    # How many accounts per IP address will be allowed. Set as 0 for unlimited
    account-limit: 0
    # Used with web registrations that require account activation
    activation: true

    login:
    strikes:
    # Amount of times a player can enter an incorrect password before action is taken
    # Set as 0 to disable
    amount: 5
    # What action to take when the strike threshold is reached
    # Possible values: kick, lockout
    action: kick
    # Length of time, in seconds, that a strike will remain in the database
    strike-length: 3600
    # Length of time, in seconds, that a player will remain locked out
    lockout-length: 900

    password:
    # Minimum length a password may be
    min-length: 6
    # Enable/disable password changes
    allow-change: true
    # Require at least one of the character types below that are set to true
    complexity:
    lowercase: false
    uppercase: false
    number: false
    symbol: false

    guest:
    # Amount of time, in seconds, that a player has to log in before they are kicked
    # Set as 0 to disable
    timeout: 300
    # Amount of time, in seconds, between "You must be logged in.." messages
    notify-cooldown: 5
    # Commands that players who are not registered or logged in may execute
    allowed-commands: [register, login, l]
    # Turn on/off location protection
    protect-location: true

    session:
    # Amount of time, in seconds, that a session will remain valid
    length: 3600
    # Verify a player's IP address when resuming a session
    verifyip: true
    # Length of time, in seconds, that a player will have godmode upon logging in
    # set as 0 to disable
    godmode-length: 5

    filter:
    # Minimum length a players name can be
    min-length: 2
    # Characters that may be present in a players name. Use an asterisk (*) to allow all
    allowed: '*'
    # If set to false, players with blank names can connect
    blankname: true

    # INTERNAL USE ONLY! DO NOT TOUCH!
    version: 5


    and my Plugins:
    Show Spoiler


    ChestShop, WorldGuard, AutoMessage, SimpleSign, HeroChat, FalseBookCore, BukkitContrib, BookWorm, PlgWarp, FalseBookBlock, Elevators, MineMail, SimpleHelp, XcraftGate, MobBounty, xAuth, CommandBook, FalseBookIC, RegionMarket, LastLogin, Permissions, PermissionsPlus, WorldEdit, MineBackup, WordRank, MultipleHomes, Trampolin, nSpleef, iConomy, Jail, FalseBookExtra, ModSiren, RedstoneChips, SensorLibrary, MinecartManiaCore, obuVoting, MinecartManiaChestControl, dynmap, Citizens, ClockDisplay, MinecartManiaAdminControls, BasicCircuits, MinecartManiaSignCommands, PermissionsSql, p2Aliases, MinecartManiaStation, NoCheat, ChessCraft


    Does anyone have an idea?
     
  4. Offline

    dog.big

    Hello,
    when user try to conect from banned ip, the error message come up:

    xAuth version: xAuth v2.0 (Beta 4.1)
    CraftBukkit build: 1060
    Description of error/bug: Error when IP-banned player tryes to connect
    Error log: http://pastebin.com/3W6NdjXQ
    Other information: Reproduce: Simply use KiwiAdmin to IP-ban some player, and then wait till ip-banned player try to connect

    Hello,
    another error..

    xAuth version: xAuth v2.0 (Beta 4.1)
    CraftBukkit build: 1060
    Description of error/bug: Error when trying to use commands like /l, /login or /changepw when logged
    Error log: http://pastebin.com/pLYaM0e7
    Other information: Reproduce: Simply log-in a use command /l

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

    tombik

    SuperPerms support would be great.
     
  6. Offline

    CypherX

    @flozza83 - The database file is probably corrupt. You can try using the H2 Recovery Tool to export the database contents into a .sql file then import it into another database. Next time use the error/bug reporting template.

    @Worlther - Caused by using a command without supplying any arguments, fixed in the next update. Next time use the error/bug reporting template.

    @XxXLuisXxX - Are there any errors in the server console when starting the server or attempting to use a command?

    Will be fixed in the next update, although I recommend finding a different plugin for banning. KiwiAdmin seemed extremely buggy when I was using it for testing. EasyBan is a good one.

    That's caused by using a command without supplying any arguments. The error it throws will be fixed in the next update.

    xAuth already supports SuperPerms.
     
  7. Offline

    tombik

    I shouldn't know that because you have Permissions link linked to old Yeti Permission page.
     
  8. Offline

    flozza83

    Hi CypherX

    Thanks for your tip.
    Ok for the template sorry.
    I have got the .sql file from the db file
    But how to use it now ?
    Import to phpmyadmin doesnt working.
    I dont know how this h2 file can be corrupted.. i dont touch it before it dont worked
     
  9. Offline

    Theiago

    xAuth + Spout = Fail
    xAuth + WorldEditCUI = Fail.

    =s
     
  10. Offline

    algiuxas

    Hello there :) I've came with a suggestion.
    Could you add configuration option to change encryption type? I have a big database of users from other plugin that has passwords hashed in plain md5 and migration to xAuth wouldn't be possible in this situation.

    That would be much appreciated :)
     
  11. Offline

    XxXLuisXxX

    I've fixed my issue by my self, thanks anyway ^^.
     
  12. Offline

    flozza83

    I have worldedit and spout, do you think this is why my database became corrupted ?..
     
  13. Offline

    tinez

    hi!

    i got this (CB1060, xauthb4.1 and 4.0 (both throw error))
    plugins:spout, essentials.


    When somebody login:
    xAuth v2.0b4.1
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:352)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
    at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:435)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
    at com.cypherx.xauth.Util.argsToString(Util.java:240)
    at com.cypherx.xauth.Util.fixArgs(Util.java:249)
    at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:25)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    ... 13 more
     
  14. Offline

    The PC Tech Guy

    @CypherX it appears to use the SuperPermsBridge instead of SuperPerms. I'm also getting an SQL error upon startup (even when letting it create a new file):
    Code:
    2011-08-22 09:12:13 [INFO] [xAuth] 'Permissions' v2.7.7 support enabled!
    2011-08-22 09:12:13 [INFO] [xAuth] Connection to database established!
    2011-08-22 09:12:13 [SEVERE] [xAuth] SQL query failure [write] (DELETE FROM `ses
    sions` WHERE NOW() > DATEADD('SECOND', 180, `logintime`))
    org.h2.jdbc.JdbcSQLException: Table "SESSIONS" not found; SQL statement:
    DELETE FROM `sessions` WHERE NOW() > DATEADD('SECOND', 180, `logintime`) [42102-
    153]
    2011-08-22 09:12:13 [SEVERE] [xAuth] SQL query failure [read] (SELECT * FROM `te
    le_locations`)
    org.h2.jdbc.JdbcSQLException: Table "TELE_LOCATIONS" not found; SQL statement:
    SELECT * FROM `tele_locations` [42102-153]
    2011-08-22 09:12:13 [SEVERE] Error occurred while enabling xAuth v2.0b4.1 (Is it
     up to date?): null
    java.lang.NullPointerException
    
    I also have WorldEdit and Spout, but I fail to see how they can be part of the problem...
     
  15. Offline

    ExplosiveBacoN

    EHL OH EHL I downgraded to beta 3.5. It seems to be working much better then the current versions and is more spout friendly.
     
  16. Offline

    CypherX

    xAuth detects if a password is hashed in MD5 and checks and converts it automatically.

    @The PC Tech Guy - The sessions table doesn't exist in the database, which is causing that error. The DBVERSION file needs to be deleted if you want the tables to be re-created.
     
  17. Offline

    Pr0Failure

    Is there anyway to make it so players get force logged out if they disconnect w/out logging out first?
     
  18. Offline

    CypherX

    Set the session length to zero or a low number in the configuration.
     
  19. Offline

    Cystalize

    Is there a way to see who has registered and maybe delete their records for whatever reason? Like lets say someone forgot their password..How can I make it so that he can re-register? Sorry if i missed something on the top :p
     
  20. Offline

    JohnPulse

    I've done that but I still get the following error on every login :(
    Oh boy, I do hope my BD isn't corrupted...
    Code:
    09:39:48 [SEVERE] [xAuth] SQL query failure [write] (DELETE FROM `strikes` WHERE
     `strikeip` = ? AND `playername` = ?)
    org.h2.jdbc.JdbcSQLException: Table "STRIKES" not found; SQL statement:
    DELETE FROM `strikes` WHERE `strikeip` = ? AND `playername` = ? [42102-159]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
            at org.h2.message.DbException.get(DbException.java:169)
            at org.h2.message.DbException.get(DbException.java:146)
            at org.h2.command.Parser.readTableOrView(Parser.java:4747)
            at org.h2.command.Parser.readTableOrView(Parser.java:4725)
            at org.h2.command.Parser.readSimpleTableFilter(Parser.java:704)
            at org.h2.command.Parser.parseDelete(Parser.java:726)
            at org.h2.command.Parser.parsePrepared(Parser.java:336)
            at org.h2.command.Parser.parse(Parser.java:279)
            at org.h2.command.Parser.parse(Parser.java:251)
            at org.h2.command.Parser.prepareCommand(Parser.java:217)
            at org.h2.engine.Session.prepareLocal(Session.java:415)
            at org.h2.engine.Session.prepareCommand(Session.java:364)
            at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1119)
            at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
    1)
            at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
            at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
            at com.cypherx.xauth.database.DbUtil.deleteStrikes(DbUtil.java:150)
            at com.cypherx.xauth.xAuth.login(xAuth.java:349)
            at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:7
    3)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:12
    9)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:3
    52)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.
    java:737)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
    
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    09:39:48 [INFO] [xAuth] <NICKNAME> has logged in
    Regards,
    John
     
  21. Offline

    toon7

    little question the plugin works fine
    but when leave i keep logged in ...
     
  22. Offline

    The PC Tech Guy

    Okay, after doing that it seems that it had trouble creating the table, and it's still using the Permissions Bridge:
    Code:
    2011-08-23 08:04:30 [INFO] [xAuth] 'Permissions' v2.7.7 support enabled!
    2011-08-23 08:04:30 [INFO] [xAuth] Connection to database established!
    2011-08-23 08:04:30 [INFO] [xAuth] Updating database..
    2011-08-23 08:04:30 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `str
    ikes` DROP COLUMN IF EXISTS `host`)
    org.h2.jdbc.JdbcSQLException: Column "IF" not found; SQL statement:
    ALTER TABLE `strikes` DROP COLUMN IF EXISTS `host` [42122-153]
    2011-08-23 08:04:30 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `str
    ikes` DROP COLUMN IF EXISTS `bantime`)
    org.h2.jdbc.JdbcSQLException: Column "IF" not found; SQL statement:
    ALTER TABLE `strikes` DROP COLUMN IF EXISTS `bantime` [42122-153]
    2011-08-23 08:04:30 [INFO] [xAuth] Accounts: 0, Sessions: 0
    2011-08-23 08:04:30 [INFO] [xAuth] v2.0b4.1 Enabled!
    
     
  23. Offline

    Hamad

    Hello, somebody used moderator account somehow, any help?
     
  24. Offline

    Techykid3

    xAuth version: xAuth v2.0 Beta 4.1 CraftBukkit build: #1060 Description of error/bug: When I type a command that belongs to xauth, it says "An internal error has occured" Error log: http://pastebin.com/mY91JR8t Other information:Typed /register or /login
     
  25. Offline

    Aza24

    Would you be able to give CButD a source so I can keep your plugin up to date easily?
    Thanks
     
  26. Offline

    Theiago

    WorldEditCUI dont work with xAuth (WorldEditCUI is a mod to see a area of worldedit. Spout bug the skins
     
  27. Offline

    CypherX

    Looking through the accounts table in the database is the only way to see who has registered. You can unregister people by using the '/xauth unregister <player>' command or change a players password by doing '/xauth changepw <player> <new password>'

    @JohnPulse - The error says that the "STRIKES" table doesn't exist in the database. Make sure that it exists and the configuration is set to the correct name.

    It's called a session. It's a feature.

    @The PC Tech Guy - That error's caused by an outdated H2 library. You can get the latest here. What do you mean it's using the Permissions Bridge? If the Permissions plugin isn't detected it defaults to SuperPerms.

    Stop trying to execute a blank command that requires arguments? This has already been covered multiple times and won't throw an error after the next update.

    I gave them a link months ago but it's still on xAuth v1.2.5 since auto updating to 2.0 will break the configuration.
     
  28. Offline

    Number1Boss

    you might have a slight problem: bigbrother. with it my users have exploited xauth and gained access to passwords. With it you can use the /bb log command to see what has been said and what commands have been issued, therefore allowing people to see the command /login (their password). My users are very mad and many have left my server becasue of this. (not blaming it on you or anything i just hope this doesnt hapen to anyone else) hope you can maybe talk to the devs at big brother and come up with a fix. Except for this great plugin keep up the good work =).
     
  29. Offline

    CypherX

    I recently had a discussion with moparisthebest regarding this issue. A few weeks ago a commit was made to the BigBrother Github repo that introduced censored commands, this included /register, /login, etc. to prevent recording plaintext passwords. We came to the conclusion that this change hasn't been implemented in a release build as of yet. The only option I have on my end would be to hash passwords early in the COMMAND_PREPROCESS event, but any plugin that executes before xAuth could still catch the password in plaintext.
     
  30. Offline

    decebaldecebal

    i get this error when someone logs in
    Code:
    2011-08-24 13:00:38 [SEVERE] [xAuth] SQL query failure [write] (DELETE FROM `strikes` WHERE `strikeip` = ? AND `playername` = ?)
    org.h2.jdbc.JdbcSQLException: Table "STRIKES" not found; SQL statement:
    DELETE FROM `strikes` WHERE `strikeip` = ? AND `playername` = ? [42102-159]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.command.Parser.readTableOrView(Parser.java:4747)
        at org.h2.command.Parser.readTableOrView(Parser.java:4725)
        at org.h2.command.Parser.readSimpleTableFilter(Parser.java:704)
        at org.h2.command.Parser.parseDelete(Parser.java:726)
        at org.h2.command.Parser.parsePrepared(Parser.java:336)
        at org.h2.command.Parser.parse(Parser.java:279)
        at org.h2.command.Parser.parse(Parser.java:251)
        at org.h2.command.Parser.prepareCommand(Parser.java:217)
        at org.h2.engine.Session.prepareLocal(Session.java:415)
        at org.h2.engine.Session.prepareCommand(Session.java:364)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1119)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
        at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
        at com.cypherx.xauth.database.DbUtil.deleteStrikes(DbUtil.java:150)
        at com.cypherx.xauth.xAuth.login(xAuth.java:349)
        at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:73)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:352)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    but they can still log in and it works great though...
     
  31. Offline

    The Wizard

    Code:
    2011-08-23 19:14:33 [SEVERE] Could not pass event PLAYER_LOGIN to xAuth
    java.lang.NullPointerException
            at com.cypherx.xauth.xAuth.isLockedOut(xAuth.java:435)
            at com.cypherx.xauth.listeners.xAuthPlayerListener.onPlayerLogin(xAuthPlayerListener.java:48)
            at org.bukkit.plugin.java.JavaPluginLoader$13.execute(JavaPluginLoader.java:328)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
            at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:184)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:82)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
            at net.minecraft.server.Packet1Login.a(SourceFile:43)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    
    Code:
    [SEVERE] [xAuth] SQL query failure [write] (DELETE FROM `mc_xauth_strike_bans` WHERE `strikeip` = ? AND `playername` = ?)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'strikeip' in 'where clause'
            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.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.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.cypherx.xauth.database.Database.queryWrite(Database.java:90)
            at com.cypherx.xauth.database.DbUtil.deleteStrikes(DbUtil.java:150)
            at com.cypherx.xauth.xAuth.login(xAuth.java:349)
            at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:73)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:352)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    
     
Thread Status:
Not open for further replies.

Share This Page