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

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.

Video Tutorial | Commands & Permissions | Configuration | Messages | Translations | Source | Donate!​

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.

 

This seems to work for me with version 2.0 beta4 and bukkit 1000+:

Code:

<?php
// this script is tested with SMF 2.X

/* The format is pretty simple, and always returns exactly 2 lines.

if successful, return this:

YES
forum_name

if not successful, return this:

ERROR
String to return to user describing error

*/

// $localaddr should be the IP your webserver is listening on, if this page isn't being visited by the same IP ($_SERVER['REMOTE_ADDR'])
// then errors are logged and a warning email is sent to the email configured in done() so no one tries to use this to bruteforce
// passwords, you really should just restrict this to only the server accessing it, I only make it accessible over localhost or to
// my home address over SSL only.
$localaddr = "10.0.0.4";
if($_SERVER['REMOTE_ADDR'] != $localaddr && $_SERVER['REMOTE_ADDR'] != gethostbyname('an.allowed.hostname') && $_SERVER['REMOTE_ADDR'] != '8.9.7.3' ) die("Access Denied!");

function writeToFile($message, $fname = 'auth.log', $mode = 'a'){
        $fp = fopen($fname, $mode);
        fwrite($fp, time().': '.$message."\n");
        fclose($fp);
}

function done($msg, $template = "ERROR\n%s"){
        printf($template, $msg);
        global $localaddr;
        if($_SERVER['REMOTE_ADDR'] != $localaddr){
                $result = sprintf(str_replace("\n", ", ", $template), $msg);
                writeToFile("result: ".$result);
                // only if it's a bad pass, text me
                if(strpos($msg, 'assword') === FALSE)
                        exit;
                $to = "YOUR_EMAIL_ADDRESS_IF_REQUIRED";
                $subject = "auth alert";
                $message .= $result."\n";
                $message .= $_SERVER['REMOTE_ADDR']." user: ".$_REQUEST['user'].", field: ".$_REQUEST['field'].", pass length: ".strlen($_REQUEST['pass']);
                $from = "EMAIL_TO_SEND_FROM";
                $headers = "From: $from";
                $sendmail_params = "-f $from -r $from";
                writeToFile("mail sent: ".(mail($to,$subject,$message,$headers, $sendmail_params) ? 'true' : 'false'));
        }
        exit;
}

$user = $_REQUEST['user'];
$pass = $_REQUEST['pass'];
$field = 'cust_'.$_REQUEST['field'];

if($_SERVER['REMOTE_ADDR'] != $localaddr)
        writeToFile($_SERVER['REMOTE_ADDR']." user: $user, field: $field, pass length: ".strlen($pass));

$db_server = 'xxxx';
$db_name = 'smf';
$db_user = 'xxxx';
$db_passwd = 'xxxx';
$db_prefix = 'smf_';

$mysqli = new mysqli($db_server, $db_user, $db_passwd, $db_name);

$stmt = $mysqli->prepare("SELECT `member_name`, `passwd`, `real_name` FROM `smf_members` WHERE `is_activated` = '1' AND `member_name` = '$user'") or done('MySQL Error');
$stmt->bind_param("ss", $user, $field);
$stmt->execute();
// bind result variables
$stmt->bind_result($member_name, $pass_hash, $display_name);
$success = $stmt->fetch();
$stmt->close();
$mysqli->close();

if(!$success)
     done('Name not registered or activated, please register on forum.');

// hash password
$sha_passwd = sha1(strtolower($member_name) . htmlspecialchars_decode($pass));

if($sha_passwd != $pass_hash)
     done('Incorrect Password, make sure you use your forum password.');

done($display_name, "YES\n%s");
?>

The SQL statement is adjusted and I removed some security (yup.. I couldn't figure out that part )

 

I can't unregister offline users, also I can't register users.
This is what i get when i try to unregister offline users.

Code:

2011-08-19 00:35:19 [SEVERE] null
org.bukkit.command.CommandException: Unhandled exception executing command 'xauth' in plugin xAuth v2.0b4
    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 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.NullPointerException
    at com.cypherx.xauth.xAuthPlayer.getPlayer(xAuthPlayer.java:96)
    at com.cypherx.xauth.commands.xAuthCommand.unregisterCommand(xAuthCommand.java:245)
    at com.cypherx.xauth.commands.xAuthCommand.onCommand(xAuthCommand.java:41)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    ... 12 more

 

What does

Code:

    # If set to true, everyone must register
    forced: true

do?
I don't get who does not have to register... The ones who bought it or what?
Just maybe explain it a BIT better (and add it to the default config).

Thanks and see ya,
NoNe aNd NoNly.

 

Can you put a updated for to have a automatic "logout" when we left the game ?
Thanks You.
(Sorry for the orthogaphe but I am French ...)

 

How to encrypt a pasword from xauths.txt? i really need to know what is this
36925978F8D718684C6C012B804944C13E57502C51B473B9CE200FD7E9E3DC1949D5C85C87404EBAADBD276711F53EF019E9F224001ED760350BC130F7AABD11

 

Version 2.0 beta 4.1 is now available!

• Version 2.0 (Beta 4.1)
  • Setting 'allow-multiple' has been changed to 'account-limit'. A new message replacement variable, {ACCOUNTLIMIT}, has also been added.
  • Fixed NPE when changing the password, logging out, or unregistering an offline player
  • Spaces may now be used in command arguments by using quotes
  • Fixed the ability to use commands while not logged in when used with Spout
  • Overhaul of the strike system including management commands. (See below for more info)

This update includes a much needed overhaul of the 'strike system'. With this new system, individual strikes are persisted in the database rather than in memory allowing them to be more informational and manageable. When an incorrect password is supplied in the /login command, a record of this failed login attempt, called a strike, that includes the exact date and time, IP address of the player attempting to log in, and the players name is inserted into the database. When a specific IP address reaches the configurable strike threshold, they can either be kicked or locked out (configurable) for a period of time (also configurable). There have also been configuration changes related to the strike system:

Removed:

• login.strikes.length

Added:

• login.strikes.strike-length (Length of time, in seconds, that a strike will remain in the database)
• login.strikes.lockout-length (Length of time, in seconds, that a player will remain locked out)

Modified:

• login.strikes.action (Possibly values are now kick and lockout)

Finally, there are new commands to manage strikes:

/xauth strike list [ip] - List all strikes or those linked to the supplied IP address.
/xauth strike clear [ip] - Delete all strikes or those linked to the supplied IP address.

Fixed in this update.

By default, registration is forced, meaning that all players will have to register before they can move, chat, etc. By setting this to false, they will be able to play normally while being able to register as well.

That would be a players password hash.

 

Hi @CypherX

I want to make registration optional - for people who are worried about the security of their username.
# If set to true, everyone must register
forced: false

However, when a new player joins, they still can't move the mouse, talk, walk, do anything at all, until they register.

Is there a way around this?

 

Bah, it's broken. Should be fixed in this build.

 

This new build now no longer prompts an unregistered user to register, however an unregistered user still cannot move

 

Code:

15:44:39 [INFO] [xAuth] Creating file: config.yml
15:44:39 [INFO] [xAuth] Creating file: messages.yml
15:44:39 [INFO] [xAuth] 'Permissions' v3.1.6 support enabled!
15:44:39 [INFO] [xAuth] Connection to database established!
15:44:39 [INFO] [xAuth] Updating database..
15:44:39 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `strikes` 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]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.table.Table.getColumn(Table.java:587)
        at org.h2.command.Parser.parseAlterTable(Parser.java:4699)
        at org.h2.command.Parser.parseAlter(Parser.java:4162)
        at org.h2.command.Parser.parsePrepared(Parser.java:302)
        at org.h2.command.Parser.parse(Parser.java:275)
        at org.h2.command.Parser.parse(Parser.java:247)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.command.Parser.prepareCommand(Parser.java:214)
        at org.h2.engine.Session.prepareLocal(Session.java:426)
        at org.h2.engine.Session.prepareCommand(Session.java:374)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
1)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
        at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:61)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
        at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:885)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:278)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161
)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
15:44:39 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `strikes` 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]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.table.Table.getColumn(Table.java:587)
        at org.h2.command.Parser.parseAlterTable(Parser.java:4699)
        at org.h2.command.Parser.parseAlter(Parser.java:4162)
        at org.h2.command.Parser.parsePrepared(Parser.java:302)
        at org.h2.command.Parser.parse(Parser.java:275)
        at org.h2.command.Parser.parse(Parser.java:247)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.command.Parser.prepareCommand(Parser.java:214)
        at org.h2.engine.Session.prepareLocal(Session.java:426)
        at org.h2.engine.Session.prepareCommand(Session.java:374)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
1)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
        at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:61)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
        at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:885)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:278)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161
)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

Help

 

if i execute following command "/unregister xyz" i get this error code in my log

Code:

org.bukkit.command.CommandException: Unhandled exception executing command 'xauth' in plugin xAuth v2.0b4
    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 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.NullPointerException
    at com.cypherx.xauth.xAuthPlayer.getPlayer(xAuthPlayer.java:96)
    at com.cypherx.xauth.commands.xAuthCommand.unregisterCommand(xAuthCommand.java:245)
    at com.cypherx.xauth.commands.xAuthCommand.onCommand(xAuthCommand.java:41)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)

where is the problem?

 

In this plugin is worldedit commands blocked ?

 

CB 1060
Latest XAuth install, updating from most recent Xauth.
Using mySQL

Code:

2011-08-19 19:40:23 [INFO] [xAuth] 'Permissions' v3.1.6 support enabled!
2011-08-19 19:40:23 [INFO] [xAuth] Connection to database established!
2011-08-19 19:40:23 [INFO] [xAuth] Updating database..
2011-08-19 19:40:23 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `tele_locations` ADD COLUMN `uid` VARCHAR(36) NOT NULL FIRST)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'uid'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:531)
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.DbUpdate.update(DbUpdate.java:61)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
2011-08-19 19:40:23 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `tele_locations` ADD COLUMN `global` TINYINT(1) NOT NULL DEFAULT 0)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'global'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:531)
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.DbUpdate.update(DbUpdate.java:61)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
2011-08-19 19:40:23 [SEVERE] [xAuth] SQL query failure [write] (UPDATE `tele_locations` SET `uid` = `worldname`)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'worldname' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:531)
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.DbUpdate.update(DbUpdate.java:61)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
2011-08-19 19:40:23 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `tele_locations` DROP COLUMN `worldname`)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'worldname'; check that column/key exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:531)
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.DbUpdate.update(DbUpdate.java:61)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
2011-08-19 19:40:23 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `tele_locations` ADD PRIMARY KEY (`uid`))
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Multiple primary key defined
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:531)
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.DbUpdate.update(DbUpdate.java:61)
at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422) 

 

Strangely enough, it's working correctly for me now. Even on the "broken" build. If you're using the '*' or 'xauth.*' permission node that will cause it since it contains 'xauth.register'.

@SpiFioY - Something's wrong with your database file or you're using an older h2 library file. Try updating to the latest h2 library then open /plugins/xAuth/DBVERSION and change it to 3.

Update to the latest version.

Yes? Read the features list.

@NotYetRated - It's attempting to update your database from an older version although the updates have already been executed. Check your database, if the strike_bans table contains 3 columns (striketime, strikeip, playername) edit the DBVERSION file to say '4' (without the quotes), otherwise edit it to '3'.

 

Hmm, I actually only have 'host' and 'bantime' under the strike_bans table...

 

xAuth version: 2.0 beta 4.1
CraftBukkit build: 1060
Description of error/bug: SQL query failure
Error log: http://pastie.org/pastes/2398983/text?key=jkhyvvx7h3e4elax0jlpua
Other information: Deleted config.yml and updated xAuth.jar. The first batch of errors were on server startup and the next part is when I joined for the first time after updating. We had an existing h2 database. DBVERSION was "4" after the update.
Edit: Should I update from http://www.h2database.com/html/download.html?

 

I get 1 entry in the strike table for each wrong password. This is how it should work? Or at 3 (or what numer you've set) invalid passwords -> 1 entry in the strike table.

 

you don't deserve it

 

Edit DBVERSION to say '3' (no quotes) and start the server. It should update the database to the latest version then.

Yeah, that's how it should be. It inserts one entry for every strike.

 

Hey @CypherX

Seems I had an xauth.register node all along, and that's been my problem. I thought that xauth.register "allowed" someone to register, haha, not forced them =p. Sorry to have caused so much trouble - i'm so stupid =.=
however, I strongly suggest the wiki have a page devoted to the permission nodes and what they do - as it took me a while to find it !

 

02:12:18 [SEVERE] [xAuth] SQL query failure [write] (INSERT INTO `strike_bans` VALUES (?, ?, ?))
org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement:
INSERT INTO `strike_bans` VALUES (?, ?, ?) [21002-153]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.message.DbException.get(DbException.java:133)
at org.h2.command.dml.Insert.prepare(Insert.java:228)
at org.h2.command.Parser.prepare(Parser.java:202)
at org.h2.command.Parser.prepareCommand(Parser.java:214)
at org.h2.engine.Session.prepareLocal(Session.java:426)
at org.h2.engine.Session.prepareCommand(Session.java:374)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
at com.cypherx.xauth.database.DbUtil.insertStrike(DbUtil.java:145)
at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:52)
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:320)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:713)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:677)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:670)
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:85)
at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

 

I still got this problem... I downloaded the last build .....
Look:

Code:

10:52:25 [INFO] [xAuth] 'Permissions' v3.1.6 support enabled!
10:52:27 [INFO] [xAuth] Connection to database established!
10:52:27 [INFO] [xAuth] Updating database..
10:52:27 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `strikes` 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]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.table.Table.getColumn(Table.java:587)
        at org.h2.command.Parser.parseAlterTable(Parser.java:4699)
        at org.h2.command.Parser.parseAlter(Parser.java:4162)
        at org.h2.command.Parser.parsePrepared(Parser.java:302)
        at org.h2.command.Parser.parse(Parser.java:275)
        at org.h2.command.Parser.parse(Parser.java:247)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.command.Parser.prepareCommand(Parser.java:214)
        at org.h2.engine.Session.prepareLocal(Session.java:426)
        at org.h2.engine.Session.prepareCommand(Session.java:374)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
1)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
        at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:61)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
        at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:885)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:278)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161
)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
10:52:27 [SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `strikes` 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]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.table.Table.getColumn(Table.java:587)
        at org.h2.command.Parser.parseAlterTable(Parser.java:4699)
        at org.h2.command.Parser.parseAlter(Parser.java:4162)
        at org.h2.command.Parser.parsePrepared(Parser.java:302)
        at org.h2.command.Parser.parse(Parser.java:275)
        at org.h2.command.Parser.parse(Parser.java:247)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.command.Parser.prepareCommand(Parser.java:214)
        at org.h2.engine.Session.prepareLocal(Session.java:426)
        at org.h2.engine.Session.prepareCommand(Session.java:374)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
1)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
        at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:61)
        at com.cypherx.xauth.database.DbUpdate.update(DbUpdate.java:39)
        at com.cypherx.xauth.xAuth.onEnable(xAuth.java:98)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:885)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:278)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161
)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
10:52:27 [INFO] [xAuth] Accounts: 10, Sessions: 0
10:52:27 [INFO] [xAuth] v2.0b4.1 Enabled!

Look the last line.. OMG

 

Hey Guy,
since the new update i get following error, followed in a server crash!

Code:

2011-08-20 11:53:45 [SEVERE] [xAuth] SQL query failure [write] (INSERT INTO `strike_bans` VALUES (?, ?, ?))
org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement:
INSERT INTO `strike_bans` VALUES (?, ?, ?) [21002-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.get(DbException.java:144)
    at org.h2.message.DbException.get(DbException.java:133)
    at org.h2.command.dml.Insert.prepare(Insert.java:228)
    at org.h2.command.Parser.prepare(Parser.java:202)
    at org.h2.command.Parser.prepareCommand(Parser.java:214)
    at org.h2.engine.Session.prepareLocal(Session.java:426)
    at org.h2.engine.Session.prepareCommand(Session.java:374)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
    at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
    at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
    at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
    at com.cypherx.xauth.database.DbUtil.insertStrike(DbUtil.java:145)
    at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:52)
    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)

Code:

2011-08-20 12:50:08 [SEVERE] [xAuth] SQL query failure [write] (INSERT INTO `strike_bans` VALUES (?, ?, ?))
org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement:
INSERT INTO `strike_bans` VALUES (?, ?, ?) [21002-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.get(DbException.java:144)
    at org.h2.message.DbException.get(DbException.java:133)
    at org.h2.command.dml.Insert.prepare(Insert.java:228)
    at org.h2.command.Parser.prepare(Parser.java:202)
    at org.h2.command.Parser.prepareCommand(Parser.java:214)
    at org.h2.engine.Session.prepareLocal(Session.java:426)
    at org.h2.engine.Session.prepareCommand(Session.java:374)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
    at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
    at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
    at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
    at com.cypherx.xauth.database.DbUtil.insertStrike(DbUtil.java:145)
    at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:52)
    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 org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:436)
    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)

 

Hi CypherX!

I need help from you quickly because this plugin is hardly important for a non-online server.
I get an error this desactivate the plugin at starting of server:

Can you tell me why it do that??

CB1060
xAuth 2.0 b4.1

 

Read what it says- "can't connect to database H2"

Have you tried using MySql?

 

Not tried.that worked before now with H2 db.
but i have so much entries. how to convert ?

 

@NotYetRated @ExplosiveBacoN @SpiFioY @SilencShadoW

If you are experiencing either of these two errors:

Code:

[SEVERE] [xAuth] SQL query failure [write] (ALTER TABLE `strikes` 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]

Code:

[SEVERE] [xAuth] SQL query failure [write] (INSERT INTO `strike_bans` VALUES (?, ?, ?)) org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement: INSERT INTO `strike_bans` VALUES (?, ?, ?) [21002-153]

1. Browse to <server root>/lib/
2. Delete h2.jar
3. Download the latest H2 Database Engine
4. Place it in <server root>/lib/
5. Browse to <server root>/plugins/xAuth/
6. Open DBVERSION with Notepad
7. Edit the number to say '3' (without the quotes)
8. Save DBVERSION and start the server

 

Love this plugin, have been using it since the start and I have integrated into my server's website for creating accounts and logins now that it runs on MYSQL. Keep up the great work!

 

Have you got a solution for me cypher ? please
It seems is a broken file inscription. The plugin can't start with my xAuth.h2.db, but if i remove it, it creates a new file and its working. But i can't erase all these accounts.
I ask you one of these things:
- a solution to convert all datas of the db to mysql
- or how to edit the xAuth.h2.db file, to transfer datas of my old into the new created by the plugin.

 

Updated to 4.1 and players can't log in anymore..
Log: http://pastebin.com/19eL6PCm