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 :

/authme xauthimport

Permission needed : authme.admin.xauthimport
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 !

You must login to post a comment. Don't have an account? Register to get one!

8 comments

- Reply
- #9
AleksaSRB Feb 22, 2013 at 13:38 UTC - 0 likes
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!
- Reply
- #7
Xephi59 Feb 13, 2013 at 23:26 UTC - 0 likes
Update to 2.7.8 AuthMe changes

My Bukkit Server

BFAK:90728951,aeb99218fe24bda69428470664c6244ae805b870dc3efd67369a80c1ad03a5f2

Xephi59 Jan 25, 2013 at 17:28 UTC - 0 likes

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

- Reply
- #5
nathan433 Jan 19, 2013 at 01:53 UTC - 0 likes
@gertjan206: Go

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:
1. 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:
1. 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 Jan 19, 2013 by nathan433
- Reply
- #4
BennehTServer Nov 05, 2012 at 23:29 UTC - 0 likes
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.
- Reply
- #3
gertjan206 Oct 24, 2012 at 19:43 UTC - 1 like
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
- Reply
- #2
chan1600 May 10, 2012 at 01:13 UTC - 0 likes
From H2 database to Mysql I got the backup.sql , but I can't import it to my database. Any suggestion? thx
- Reply
- #1
Ivanpro Feb 10, 2012 at 18:55 UTC - 0 likes
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 Feb 10, 2012 by Ivanpro

SpHx.it Community. [ITA] IP : server.sphx.it Port : | Bukkit :25565 | Tekkit :25566 | HungerGames :25567 :25568 :25569 :25570 :25571 | SpHxGames :25572 | KillTheKing :25580