How to import database from xAuth

Migrate from xAuth to AuthMe

Put xAuth and AuthMe (>2.7.8) in your plugin folder
Configure your new AuthMe database in the config.yml file

DataSource:
    mySQLColumnName: username #Column for User Names
    mySQLTablename: authme # TableName
    mySQLUsername: authme # Username for MySQL connection
    backend: mysql # Available: mysql , sqlite, file
    mySQLColumnLastLogin: lastlogin # Column for lastlogin Timestamp
    mySQLDatabase: authme # Name of the database
    mySQLPort: '3306' # Port
    mySQLColumnIp: ip # Column for ip storage
    mySQLHost: 127.0.0.1 # Your MySQL host for connection
    mySQLColumnPassword: password # Column for password storage
    mySQLPassword: '12345' # Your MySQL database password for connection
    caching: true # For limit too much Request , disable if you do not need
    mySQLlastlocX: x # Last Location Storage X
    mySQLlastlocY : y # Last Location Storage Y
    mySQLlastlocZ : z # Last Location Storage Z
    mySQLColumnEmail: email # Column for email storage
    mySQLColumnId: id #Column for the primary key, change only if you know what you're doing

If you do not want to use MySQL, use SQLite or Flatfile like this :

    backend: sqlite

    backend: file

3. Now set the PasswordHash :

    security:
        minPasswordLength: 4
        unLoggedinGroup: unLoggedinGroup
        passwordHash: XAUTH

4. You're ready , start the server, but do not join ( xAuth + AuthMe .... whose have the /login and /register command ? x) )
5. Use this following command in console , or if you have successfully join , use in game :

/converter xauth

Permission needed : authme.admin.converter
6. Wait for the end of the import
7.Stop the server, remove xAuth and Restart.... Enjoy !

This Method Advantages :

All xAuth database support (H2, SQLite, MySQL )
Import in actual AuthMe database ( do not errase any data but simply add ! )
Choose your AuthMe database support , not only MySQL !

Comments

ivanfromitaly
- Join Date: 9/12/2011
- Posts: 424
- Member Details
#1 ivanfromitaly

View User Profile

Send Message

Posted Feb 10, 2012
It's possible convert the xauth h2 db in authme file? I solved by copying manually name:password from backup.sql.. (2000 users) D:

Last edited by ivanfromitaly: Feb 10, 2012

Rollback Post to Revision RollBack
_ForgeUser8693276
- Join Date: 4/5/2012
- Posts: 3
- Member Details
#2 _ForgeUser8693276

View User Profile

Send Message

Posted May 9, 2012
From H2 database to Mysql I got the backup.sql , but I can't import it to my database. Any suggestion? thx

Rollback Post to Revision RollBack
_ForgeUser7957400
- Join Date: 11/27/2011
- Posts: 30
- Member Details
#3 _ForgeUser7957400

View User Profile

Send Message

Posted Oct 24, 2012
can you please help me with the converting from H2 to MySQL i almost tried everything and it just won't work :S i tried to convert my xAuth H2 file to the Backup.sql file but it has an error everytime it says: Error: Could not find or load main class org.h2.tools.Script

Rollback Post to Revision RollBack
_ForgeUser8693188
- Join Date: 4/5/2012
- Posts: 10
- Member Details
#4 _ForgeUser8693188

View User Profile

Send Message

Posted Nov 5, 2012
Is it possible to decypt passwords? Someone griefed my friend via getting his password on his server using this plugin, and I want to know how so I can prevent it.

Rollback Post to Revision RollBack
_ForgeUser7962766
- Join Date: 11/28/2011
- Posts: 9
- Member Details
#5 _ForgeUser7962766

View User Profile

Send Message

Posted Jan 18, 2013
@gertjan206

I get the same error :( Did you ever work it out?

Edit: I got around that error doing the conversion via the H2 console in the web browser.

The next error was when importing the backup.sql file into a sql database. I got:

1193 - Unknown system variable 'IGNORECASE'

EDIT2: I deleted the line giving the error IGNORECASE but now i get the following error when importing the backup.sql:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS SA SALT 'baa8980520ece73e' HASH 'bb16cea394579d8bc03afc9e493592002' at line 1
Last edited by _ForgeUser7962766: Jan 19, 2013

Rollback Post to Revision RollBack

Xephi59

Location: Lille
Join Date: 8/10/2012
Posts: 794
Member Details

#6 Posted Jan 25, 2013

Edit these things in the AuthMe.jar -> scripts -> auth_db_to_mysql.pl

##############################
# EDIT THESE CONFIG SETTINGS #
##############################

my $host = "localhost";
my $database = "authme";
my $username = "authme";
my $password = "password";
my $auth_file = "/opt/craftbukkit/plugins/auths.db";

Xephi

Xephi59
- Location: Lille
- Join Date: 8/10/2012
- Posts: 794
- Member Details
#7 Xephi59

View User Profile

Send Message

Posted Feb 13, 2013
Update to 2.7.8 AuthMe changes

Rollback Post to Revision RollBack
_ForgeUser10444678
- Join Date: 1/24/2013
- Posts: 6
- Member Details
#9 _ForgeUser10444678

View User Profile

Send Message

Posted Feb 22, 2013
Okay, i have a question for the plugin maker or someone who know how to do it... Yesterday i change my webhost and i buy new one, how can i move authme sql from 1st host to second host cus if i dont move it players must register again and someone will register like some other person, i hope you understand me. HELP PLS!

Rollback Post to Revision RollBack
_ForgeUser9890464
- Join Date: 10/29/2012
- Posts: 4
- Member Details
#10 _ForgeUser9890464

View User Profile

Send Message

Posted May 30, 2013
@AleksaSRB

Well, the easiest option would be to ask your current host to download the database and give it to you (if you don't have access to it yourself). If that's not possible, you could just run the new server while using the old database (change the host and port it gets the DB from) if the MySQL server isn't secured (such as SSH) until your host can give you it.

Rollback Post to Revision RollBack
_ForgeUser9886664
- Join Date: 10/28/2012
- Posts: 59
- Member Details
#11 _ForgeUser9886664

View User Profile

Send Message

Posted May 31, 2013
Getting this error...

2013-05-31 20:17:21 [WARNING] Unexpected exception while parsing console command "authme xauthimport" org.bukkit.command.CommandException: Unhandled exception executing command 'authme' in plugin AuthMe v2.7.16 at org.bukkit.command.PluginCommand.execute(PluginCommand.java:46) at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:189) at org.bukkit.craftbukkit.v1_5_R3.CraftServer.dispatchCommand(CraftServer.java:523) at org.bukkit.craftbukkit.v1_5_R3.CraftServer.dispatchServerCommand(CraftServer.java:512) at net.minecraft.server.v1_5_R3.DedicatedServer.an(DedicatedServer.java:262) at net.minecraft.server.v1_5_R3.DedicatedServer.r(DedicatedServer.java:227) at net.minecraft.server.v1_5_R3.MinecraftServer.q(MinecraftServer.java:477) at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:410) at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573) Caused by: java.lang.NoClassDefFoundError: com/cypherx/xauth/xAuth at uk.org.whoami.authme.converter.xAuthToFlat.getXAuthPlayers(xAuthToFlat.java:86) at uk.org.whoami.authme.converter.xAuthToFlat.convert(xAuthToFlat.java:43) at uk.org.whoami.authme.commands.AdminCommand.onCommand(AdminCommand.java:291) at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) ... 8 more Caused by: java.lang.ClassNotFoundException: com.cypherx.xauth.xAuth at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at org.bukkit.plugin.java.PluginClassLoader.findClass0(PluginClassLoader.java:80) at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:53) at java.lang.ClassLoader.loadClass(ClassLoader.java:423) at java.lang.ClassLoader.loadClass(ClassLoader.java:356) ... 12 more

Rollback Post to Revision RollBack
Forge_User_02764350
- Join Date: 2/6/2012
- Posts: 269
- Member Details
#12 Forge_User_02764350

View User Profile

Send Message

Posted Jun 9, 2013
after importing, do i have to set the passwordHash, to "SHA256" again? Or completely delte the config & let it generate new?

Julia :)

Last edited by Forge_User_02764350: Jun 11, 2013

Rollback Post to Revision RollBack
_ForgeUser8885421
- Join Date: 5/13/2012
- Posts: 5
- Member Details
#13 _ForgeUser8885421

View User Profile

Send Message

Posted Jul 26, 2013
@RaynLegends

@Xephi59

I got same thing happened to him how to fix it? help plz thx :D

Rollback Post to Revision RollBack
_ForgeUser6892583
- Join Date: 5/25/2011
- Posts: 1
- Member Details
#14 _ForgeUser6892583

View User Profile

Send Message

Posted Aug 10, 2013
10.08 14:43:01 [Server] INFO ... 8 more 10.08 14:43:01 [Server] INFO at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) 10.08 14:43:01 [Server] INFO at uk.org.whoami.authme.commands.AdminCommand.onCommand(AdminCommand.java:291) 10.08 14:43:01 [Server] INFO at uk.org.whoami.authme.converter.xAuthToFlat.convert(xAuthToFlat.java:43) 10.08 14:43:01 [Server] INFO at uk.org.whoami.authme.converter.xAuthToFlat.getXAuthPlayers(xAuthToFlat.java:86) 10.08 14:43:01 [Server] INFO Caused by: java.lang.NoSuchMethodError: com.cypherx.xauth.xAuth.getPlugin()Lcom/cypherx/xauth/xAuth; 10.08 14:43:01 [Server] INFO at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573) 10.08 14:43:01 [Server] INFO at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:410) 10.08 14:43:01 [Server] INFO at net.minecraft.server.v1_5_R3.MinecraftServer.q(MinecraftServer.java:477) 10.08 14:43:01 [Server] INFO at net.minecraft.server.v1_5_R3.DedicatedServer.r(DedicatedServer.java:227) 10.08 14:43:01 [Server] INFO at net.minecraft.server.v1_5_R3.DedicatedServer.an(DedicatedServer.java:262) 10.08 14:43:01 [Server] INFO at org.bukkit.craftbukkit.v1_5_R3.CraftServer.dispatchServerCommand(CraftServer.java:512) 10.08 14:43:01 [Server] INFO at org.bukkit.craftbukkit.v1_5_R3.CraftServer.dispatchCommand(CraftServer.java:523) 10.08 14:43:01 [Server] INFO at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:189) 10.08 14:43:01 [Server] INFO at org.bukkit.command.PluginCommand.execute(PluginCommand.java:46) 10.08 14:43:01 [Server] INFO org.bukkit.command.CommandException: Unhandled exception executing command 'authme' in plugin AuthMe v2.9 10.08 14:43:01 [Server] WARNING Unexpected exception while parsing console command "authme xauthimport"

am getting this error how do i fix this! plz help! ASAP!

i get this when importing from xauth

Rollback Post to Revision RollBack
_ForgeUser7479931
- Join Date: 9/1/2011
- Posts: 515
- Member Details
#15 _ForgeUser7479931

View User Profile

Send Message

Posted Aug 15, 2013
@o0Julia0o

For me wok without problems... had cca 7k accounts 1n 15 seconda. But shall we change it to "SHA256" or not. It is really bit confusing.

Thank you :)

Rollback Post to Revision RollBack
_ForgeUser12768479
- Join Date: 12/7/2013
- Posts: 6
- Member Details
#16 _ForgeUser12768479

View User Profile

Send Message

Posted Sep 2, 2014
The Command is actually: /authme xauthimport

At least this one works for me, while the one above does not.

Greetings, DrW

Rollback Post to Revision RollBack
_ForgeUser7892921
- Join Date: 11/17/2011
- Posts: 46
- Member Details
#17 _ForgeUser7892921

View User Profile

Send Message

Posted Jan 12, 2015
I seem to have hit a snag, I can't get /authme xauthimport to do anything other than tell me that it's propper use is /authme blah blah blah

And /converter xauth doesn't do anything, I have everything set up as is in the step by step guide above however nothing actually works.

Would like to know if there's a way for me to convert the databases manually instead of using the plugins in case this won't work at all.

EDIT: It looks like 3.5 removed the import command completely 3.4 works perfectly for 1.8 Spigot and I can still import database.

Last edited by _ForgeUser7892921: Jan 12, 2015

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

AuthMe Reloaded

Bukkit Plugins

Pages

Table of Contents

Migrate from xAuth to AuthMe

/converter xauth