Вы используете устаревший браузер. Этот и другие сайты могут отображаться в нем неправильно. Необходимо обновить браузер или попробовать использовать другой.
РешеноAuthMe связать с Mysql. config перенастраиваю в течении недели но победить не могу
Уважаемые, помогите разобраться с хренью при связке плагина с БД. 2 года назад пытался открыть на хостинге playvds игровой сервер и в тот момент получалось привязать этот плагин. Но сейчас же этот сервис на русском уже закрыт и работает вроде бы как партнер раннего сервиса. По сути тот же интерфейс, но без лаунчера, но не важно...
Проблема при открытии сервера на bukkite, а именно связка базы данных, которые предоставляют в данном сервисе и плагина AuthMe. Все вроде бы как данные ввел правильно. Но в моменте запуска сервера и в попытке подключения к базе данных крашится и отключается (
Вот конфиг
DataSource:
# What type of database do you want to use?
# Valid values: SQLITE, MYSQL, POSTGRESQL
backend: mysql
# Enable the database caching system, should be disabled on bungeecord environments
# or when a website integration is being used.
caching: true
# Database host address
mySQLHost: localhost
# Database port
mySQLPort: '2108'
# Connect to MySQL database over SSL
mySQLUseSSL: false
# Verification of server's certificate.
# We would not recommend to set this option to false.
# Set this option to false at your own risk if and only if you know what you're doing
mySQLCheckServerCertificate: true
# Username to connect to the MySQL database
mySQLUsername: root
# Password to connect to the MySQL database
mySQLPassword: 'PaSsWoRd'
# Database Name, use with converters or as SQLITE database name
mySQLDatabase: mysql
# Table of the database
mySQLTablename: authme
# Column of IDs to sort data
mySQLColumnId: id
# Column for storing or checking players nickname
mySQLColumnName: username
# Column for storing or checking players RealName
mySQLRealName: realname
# Column for storing players passwords
mySQLColumnPassword: password
# Column for storing players passwords salts
mySQLColumnSalt: ''
# Column for storing players emails
mySQLColumnEmail: email
# Column for storing if a player is logged in or not
mySQLColumnLogged: isLogged
# Column for storing if a player has a valid session or not
mySQLColumnHasSession: hasSession
# Column for storing a player's TOTP key (for two-factor authentication)
mySQLtotpKey: totp
# Column for storing the player's last IP
mySQLColumnIp: ip
# Column for storing players lastlogins
mySQLColumnLastLogin: lastlogin
# Column storing the registration date
mySQLColumnRegisterDate: regdate
# Column for storing the IP address at the time of registration
mySQLColumnRegisterIp: regip
# Column for storing player LastLocation - X
mySQLlastlocX: x
# Column for storing player LastLocation - Y
mySQLlastlocY: y
# Column for storing player LastLocation - Z
mySQLlastlocZ: z
# Column for storing player LastLocation - World Name
mySQLlastlocWorld: world
# Column for storing player LastLocation - Yaw
mySQLlastlocYaw: yaw
# Column for storing player LastLocation - Pitch
mySQLlastlocPitch: pitch
# Column for storing players uuids (optional)
mySQLPlayerUUID: ''
Уже не знаю в чем проблема... для root открыт удаленный доступ в настройках... AuthMe 5.6.0. Версия сервера 1.16.4
[10:13:25] [Server thread/INFO]: [AuthMe] Enabling AuthMe v5.6.0-SNAPSHOT-b2440
[10:13:25] [Server thread/INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[10:13:25] [Server thread/WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[10:13:27] [Server thread/WARN]: [Server thread] ERROR fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
[10:13:27] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
[10:13:27] [Server thread/WARN]:
[10:13:27] [Server thread/WARN]: The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[10:13:27] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[10:13:27] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[10:13:27] [Server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[10:13:27] [Server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2187)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[10:13:27] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[10:13:27] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[10:13:27] [Server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[10:13:27] [Server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:167)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:175)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:76)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:67)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:245)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
[10:13:27] [Server thread/WARN]: at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:145)
[10:13:27] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263)
[10:13:27] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:351)
[10:13:27] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:480)
[10:13:27] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugin(CraftServer.java:494)
[10:13:27] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugins(CraftServer.java:408)
[10:13:27] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.MinecraftServer.loadWorld(MinecraftServer.java:435)
[10:13:27] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.DedicatedServer.init(DedicatedServer.java:218)
[10:13:27] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.MinecraftServer.w(MinecraftServer.java:808)
[10:13:27] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.MinecraftServer.lambda$0(MinecraftServer.java:164)
[10:13:27] [Server thread/WARN]: at java.lang.Thread.run(Thread.java:748)
[10:13:27] [Server thread/WARN]: Caused by: java.net.ConnectException: Connection refused (Connection refused)
[10:13:27] [Server thread/WARN]: at java.net.PlainSocketImpl.socketConnect(Native Method)
[10:13:27] [Server thread/WARN]: at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
[10:13:27] [Server thread/WARN]: at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
[10:13:27] [Server thread/WARN]: at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
[10:13:27] [Server thread/WARN]: at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
[10:13:27] [Server thread/WARN]: at java.net.Socket.connect(Socket.java:589)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
[10:13:27] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:299)
[10:13:27] [Server thread/WARN]: ... 42 more
[10:13:27] [Server thread/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.
[10:13:27] [Server thread/WARN]: [AuthMe] Please check your database settings in the config.yml file!
[10:13:27] [Server thread/WARN]: [AuthMe] Could not create data source: [CommunicationsException]: Communications link failure
адрес, порт и пароль вводил тот самый, что написаны в хос-сервисе. База данных работает так как phpMyadmin работает. Пробовал и локальные вариации хоста и порта... нет изменении к сожалению
наконец разобрался. Решил проверить в самой phpMyAdmin в переменных хост и порт... и да. установил те самые значения UseSSL исправил на true и заработало
На данном сайте используются cookie-файлы, чтобы персонализировать контент и сохранить Ваш вход в систему, если Вы зарегистрируетесь.
Продолжая использовать этот сайт, Вы соглашаетесь на использование наших cookie-файлов.
