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
Or
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 !
It's possible convert the xauth h2 db in authme file? I solved by copying manually name:password from backup.sql.. (2000 users) D:
From H2 database to Mysql I got the backup.sql , but I can't import it to my database. Any suggestion? thx
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
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.
@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:
EDIT2: I deleted the line giving the error IGNORECASE but now i get the following error when importing the backup.sql:
Edit these things in the AuthMe.jar -> scripts -> auth_db_to_mysql.pl
Xephi
Update to 2.7.8 AuthMe changes
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!
@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.
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
after importing, do i have to set the passwordHash, to "SHA256" again? Or completely delte the config & let it generate new?
Julia :)
@RaynLegends
@Xephi59
I got same thing happened to him how to fix it? help plz thx :D
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
@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 :)
The Command is actually: /authme xauthimport
At least this one works for me, while the one above does not.
Greetings, DrW
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.