Войти или зарегистрироваться
  • Вы находитесь в сообществе Rubukkit. Мы - администраторы серверов Minecraft, разрабатываем собственные плагины и переводим на различные языки плагины наших коллег из других стран.

Помогите Подключаю AuthMe к MariaDB

Метки:
Теги Теги
authme reloaded authmebungee mysql

Marry

Участник
Пользователь
Баллы
36
Имя в Minecraft
Marriana
Ubuntu 18.04
Создала базу данных AuthMe в MariaDB.
Создала пользователя AuthMeUser.
Выдала все права на использование базы командой grant all privileges on AuthMe to 'AuthMeUser'@'localhost';
Отредактировала config.yml плагина AuthMe.
DataSource:
# What type of database do you want to use?
# Valid values: SQLITE, MYSQL, POSTGRESQL
backend: MariaDB
# 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: 127.0.0.1
# Database port
mySQLPort: '3306'
# Connect to MySQL database over SSL
mySQLUseSSL: true
# Username to connect to the MySQL database
mySQLUsername: AuthMeUser
# Password to connect to the MySQL database
mySQLPassword: 'тут точно правильный пароль из консоли'
# Database Name, use with converters or as SQLITE database name
mySQLDatabase: AuthMe
# 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
# Overrides the size of the DB Connection Pool, default = 10
poolSize: 10
# The maximum lifetime of a connection in the pool, default = 1800 seconds
# You should set this at least 30 seconds less than mysql server wait_timeout
maxLifetime: 1800
ExternalBoardOptions:
# Column for storing players groups
mySQLColumnGroup: ''
# -1 means disabled. If you want that only activated players
# can log into your server, you can set here the group number
# of unactivated users, needed for some forum/CMS support
nonActivedUserGroup: -1
# Other MySQL columns where we need to put the username (case-sensitive)
mySQLOtherUsernameColumns: []
# How much log2 rounds needed in BCrypt (do not change if you do not know what it does)
bCryptLog2Round: 10
# phpBB table prefix defined during the phpBB installation process
phpbbTablePrefix: phpbb_
# phpBB activated group ID; 2 is the default registered group defined by phpBB
phpbbActivatedGroupId: 2
# IP Board table prefix defined during the IP Board installation process
IPBTablePrefix: ipb_
# IP Board default group ID; 3 is the default registered group defined by IP Board
IPBActivatedGroupId: 3
# Xenforo table prefix defined during the Xenforo installation process
XFTablePrefix: xf_
# XenForo default group ID; 2 is the default registered group defined by Xenforo
XFActivatedGroupId: 2
# Wordpress prefix defined during WordPress installation
wordpressTablePrefix: wp_

При запуске сервера Auth вылетает такая штука:
[21:37:32 INFO]: [AuthMe] Enabling AuthMe v5.5.1-SNAPSHOT-b2192
[21:37:33 INFO]: [AuthMe] SQLite Setup finished
[21:37:33 INFO]: [AuthMe] No supported permissions system found! Permissions are disabled!
[21:37:33 WARN]: [AuthMe] WARNING! The protectInventory feature requires ProtocolLib! Disabling it...
[21:37:33 INFO]: [AuthMe] Development builds are available on our jenkins, thanks to FastVM.io
[21:37:33 INFO]: [AuthMe] Do you want a good vps for your game server? Look at our sponsor FastVM.io leader as virtual server provider!
[21:37:33 INFO]: [AuthMe] AuthMe 5.5.1-SNAPSHOT build n.2192 correctly enabled!

Ввожу show tables for AuthMe - таблиц, говорит, нет. AuthMe на законтачился. Вопрос - что я делаю не так?
 
Где ты увидела в списке Valid values "MariaDB" ? Укажи MYSQL и должно заработать
все отлично, только теперь он ваще стопается)))
[SPOILER = консолька]

[22:12:17 WARN]: [AuthMe] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
[22:12:17 INFO]: [AuthMe] Waiting for 0 tasks to finish
[22:12:17 INFO]: [AuthMe] AuthMe 5.5.1-SNAPSHOT-b2192 disabled!
[22:12:17 INFO]: [IPWhitelist] Enabling IPWhitelist v1.7
[22:12:17 INFO]: [AuthServer] Enabling AuthServer v1.0
[22:12:17 INFO]: AuthServer включен
[22:12:17 INFO]: [HolographicDisplays] Enabling HolographicDisplays v2.3.2
[22:12:17 INFO]: [ViaVersion] Enabling ViaVersion v2.0.0-SNAPSHOT
[22:12:17 INFO]: Server permissions file permissions.yml is empty, ignoring it
[22:12:17 INFO]: Done (4.866s)! For help, type "help" or "?"
[22:12:17 INFO]: Stopping server
[22:12:17 INFO]: [ViaVersion] Disabling ViaVersion v2.0.0-SNAPSHOT
[22:12:17 INFO]: [ViaVersion] ViaVersion is disabling, if this is a reload and you experience issues consider rebooting.
[22:12:17 INFO]: [ProtocolSupport] Disabling ProtocolSupport v4.29-dev
[22:12:17 INFO]: [HolographicDisplays] Disabling HolographicDisplays v2.3.2
[22:12:17 INFO]: [AuthServer] Disabling AuthServer v1.0
[22:12:17 INFO]: AuthServer выключен
[22:12:17 INFO]: [IPWhitelist] Disabling IPWhitelist v1.7
[22:12:17 INFO]: Saving players
[22:12:17 INFO]: Saving worlds
[22:12:17 INFO]: Saving chunks for level 'world'/overworld
[22:12:17 INFO]: Saving chunks for level 'world_nether'/the_nether
[22:12:17 INFO]: Saving chunks for level 'world_the_end'/the_end
[/SPOILER]
 
И ни одной таблички в бдшке AuthMe не появилось((
 
THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
он же тебе прям пишет в лоб, что сервер выключается исходя из настроек конфига.

нужно:
Код:
# AuthMe will automatically disable and the server won't be protected!
stopServer: false
 
THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
он же тебе прям пишет в лоб, что сервер выключается исходя из настроек конфига.

нужно:
Код:
# AuthMe will automatically disable and the server won't be protected!
stopServer: false
Спасибо большое. Я бы сама не дошла до такого)) но теперь почему-то у меня при входе на сервер авторизации не выводится ничего в чат, и даже когда ввожу /register выскакивает какая-то ошибка.
 

Вложения:

  • 2022-02-02_01.32.22.png
    2022-02-02_01.32.22.png
    Размер файла
    97,9 КБ
    Просмотров
    7
чо блэт. это почему?
[SPOILER = не пускают юзера. консоль]

[AuthMe] Can't initialize the MySQL database: [SQLException]: Access denied for user 'AuthMeUser'@'localhost' (using password: YES)
[22:43:09 WARN]: [AuthMe] Please check your database settings in the config.yml file!
[22:43:09 WARN]: [AuthMe] Could not create data source: [SQLException]: Access denied for user 'AuthMeUser'@'localhost' (using password: YES)
[22:43:09 WARN]: [AuthMe] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[22:43:09 INFO]: [AuthMe] Waiting for 0 tasks to finish
[22:43:09 INFO]: [AuthMe] AuthMe 5.5.1-SNAPSHOT-b2192 disabled!
[/SPOILER]
 
Проблема решена. Просто на этом о****@хyительном сайте ошибка в команде, поэтому я не разобралась как выдать права))
upload_2022-2-2_2-57-20.png
 

Поделиться этой страницей

Назад
Верх