Помогите AuthMe, как импортировать аккаунты?

  • Автор темы Автор темы MineGo
  • Дата начала Дата начала
MineGo

MineGo

Активный участник
Пользователь
Баллы
66
Добрый день, кто может подсказать, как базу данных - authme.db импортировать в name.sql?

Посмотрел куча гайдов и все твердят, что через команду /authme convertflattosql, но в новых версиях данная команда заменена на /authme convert mysqltosql или sqlitetosql (вообщем говоря 2 варианта побывал писать и выскакивали ошибки.) Очень прошу вашей помощи, так как на форуме нечего нормального не нашел.

Ядро: spigot 1.11.2
Плагин: AuthMe-5.4-SNAPSHOT.jar
 
Сортировать по дате Сортировать по голосам
Dymeth сказал(а):
какие команды использовал, и какие ошибки возникали?
Нажмите, чтобы раскрыть...
При использование команды /authme convert mysqltosql, пишет -

Код: 
[11:46:25] [Server thread/INFO]: [AuthMe] Successfully started mysqltosqlite[m
[11:46:25] [Craft Scheduler Thread - 15/INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[11:46:25] [Craft Scheduler Thread - 15/WARN]: [Craft Scheduler Thread - 15] INFO fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [Craft Scheduler Thread - 15] ERROR fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
[11:46:26] [Craft Scheduler Thread - 15/WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:376)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:205)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:448)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:519)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:157)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:164)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.converter.MySqlToSqlite.getSource(MySqlToSqlite.java:29)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.converter.MySqlToSqlite.getSource(MySqlToSqlite.java:15)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.converter.AbstractDataSourceConverter.execute(AbstractDataSourceConverter.java:50)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.command.executable.authme.ConverterCommand$1.run(ConverterCommand.java:59)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:71)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.lang.Thread.run(Thread.java:748)
[11:46:26] [Craft Scheduler Thread - 15/WARN]: Caused by: java.net.ConnectException: Connection refused (Connection refused)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.PlainSocketImpl.socketConnect(Native Method)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.Socket.connect(Socket.java:589)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     ... 32 more
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [AuthMe] Can't initialize the MySQL database: [CommunicationsException]: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [AuthMe] Please check your database settings in the config.yml file!
[11:46:26] [Craft Scheduler Thread - 15/INFO]: [AuthMe] The data source to convert from could not be initialized
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [AuthMe] Could not initialize source: [CommunicationsException]: Communications link failure

И при использование команды /authme convert sqlitetosql, пишет -
Код: 
>authme convert sqlitetosql
[11:50:45 INFO]: [AuthMe] Successfully started sqlitetosql
[11:50:45 INFO]: Please configure your connection to MYSQL and re-run this command
 
Последнее редактирование:
За 0 Против
MineGo сказал(а):
При использование команды /authme convert mysqltosql, пишет -

Код: 
[11:46:25] [Server thread/INFO]: [AuthMe] Successfully started mysqltosqlite[m
[11:46:25] [Craft Scheduler Thread - 15/INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[11:46:25] [Craft Scheduler Thread - 15/WARN]: [Craft Scheduler Thread - 15] INFO fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [Craft Scheduler Thread - 15] ERROR fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
[11:46:26] [Craft Scheduler Thread - 15/WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:112)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:118)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:376)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:205)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:448)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:519)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:157)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:164)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.converter.MySqlToSqlite.getSource(MySqlToSqlite.java:29)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.converter.MySqlToSqlite.getSource(MySqlToSqlite.java:15)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.datasource.converter.AbstractDataSourceConverter.execute(AbstractDataSourceConverter.java:50)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at fr.xephi.authme.command.executable.authme.ConverterCommand$1.run(ConverterCommand.java:59)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:71)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.lang.Thread.run(Thread.java:748)
[11:46:26] [Craft Scheduler Thread - 15/WARN]: Caused by: java.net.ConnectException: Connection refused (Connection refused)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.PlainSocketImpl.socketConnect(Native Method)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at java.net.Socket.connect(Socket.java:589)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
[11:46:26] [Craft Scheduler Thread - 15/WARN]:     ... 32 more
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [AuthMe] Can't initialize the MySQL database: [CommunicationsException]: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [AuthMe] Please check your database settings in the config.yml file!
[11:46:26] [Craft Scheduler Thread - 15/INFO]: [AuthMe] The data source to convert from could not be initialized
[11:46:26] [Craft Scheduler Thread - 15/WARN]: [AuthMe] Could not initialize source: [CommunicationsException]: Communications link failure

И при использование команды /authme convert mysqltosql, пишет -
Код: 
>authme convert sqlitetosql
[11:50:45 INFO]: [AuthMe] Successfully started sqlitetosql
[11:50:45 INFO]: Please configure your connection to MYSQL and re-run this command
Нажмите, чтобы раскрыть...
Опечатка. Ты два раза одну и туже команду написал. У меня такая же проблема, решение не знаю(
 
За 0 Против
Наверно /authme convert sqltomysql, нет?

UPD: Ошибка второй команды, забей её в переводчик и будет тебе ответ
 
За 0 Против

Вложения

  • Скриншот 2017-12-04 15_07_07.png
    Скриншот 2017-12-04 15_07_07.png
    3,9 КБ · Просмотры: 17
За 0 Против
Уже побывал включать mysql в config.yml, там при выполнение команды - /authme convert sqlitetosql, создавало файл с базой который находится в phpmyadmin, а мне нужно чтобы .db конвертировался в .sql
 
За 0 Против
MineGo сказал(а):
Уже побывал включать mysql в config.yml, там при выполнение команды - /authme convert sqlitetosql, создавало файл с базой который находится в phpmyadmin, а мне нужно чтобы .db конвертировался в .sql
Нажмите, чтобы раскрыть...
Так а по другому там никак и не сделаешь.
 
За 0 Против
Для ответа нужно войти/зарегистрироваться
Назад
Верх Низ