Сборки серверов

СливПлатные

Сейчас онлайн

  • VALAROSSA
  • fongbe50
  • SyrnikInteractive
  • leperochek
  • Saritomy
  • LaBrava
  • loganbodart_
  • mcdevz
  • kneekick
  • giomiracle123
  • scorgme
  • OderPrince
  • postedex
  • abhazfarhaz
  • anhvuquang0512
  • sadasda

Помощь Помощь по SuperAuth - MySQL, BungeeCord

  • Автор темыsuperfo
  • Дата начала
superfo
Ядро papperspigor 1.12.2. Использую последнею версию SuperAuth

Здравствуйте, хочу подключить MySQL через BungeeCord для Auth, база данных подключается только к BunngeeCord.
Когда пытаюсь подключить его к серверу Auth, но пишет что не удалось подключиться.
Помогите пожалуйста.

Плагин стоит на BungeeCord и Auth

Проверили 200 раз все варианты, проверяли логин пароль, копировали и вставляли... :/ Всё равно не работают.
MySQL полностью работает. bat файлы тоже полностью одинаково работают.

# Should the authentication be enabled?
AuthEnabled: true
# We recommend 'SHA512' for you ;D
HashingMethod: SHA512
# We have DIALOG, GUI and COMMANDS
AuthMethod: GUI
# For the GUI Pin, how long should be the pins? (We recommend between 4 and 6)
PinLength: 4
PasswordLength:
# Min password lenght. We recommend you 8
Min: 5
# Max password lenght. We recommend you from 12 to 16
# (If you set a higher number make sure to add longer timings so users have the time to write their passwords)
Max: 16
Commands:
# The /register command (Yes, you can change it!)
Register: register
# The /login command (Yes, you can change it!)
Login: login
# The /auth command (Yes, you can change it!) <- Only needed if the user can't see the Pin Gui
Auth: auth
Aliases:
# The /register command aliases (Yes, you can change it!)
Register:
- reg
# The /login command aliases (Yes, you can change it!)
Login:
- l
# The /auth command aliases (Yes, you can change it!) <- Only needed if the user can't see the Pin Gui
Auth:
- pin
- code
AntiBots:
# The max time (in seconds) that the user can be in authentication.
MaxTime: 30
Captcha:
# Should the captcha be enabled?
Enabled: true
# The chance that the captcha will be shown (0.0 - 1.0)
Chance: 1.0
# The length of the captcha (We recommend a number between 1 and 10)
Length: 5
# Should the IP be blocked if the user changes it?
BlockIPChanges: true
# Should the VPN be blocked?
VPNBlocker: true
Before:
# The actions that will be executed before the user registers
Register:
- msg:&aHello! Please register yourself
# The actions that will be executed before the user logs in
Login:
- msg:&aHello Again! Please authenticate yourself
After:
# The actions that will be executed after the user registers
Register:
- msg:&aGreat! Now you can play
- cmd:kit nooby
- server:rules
# The actions that will be executed after the user logs in
Login:
- msg:&aGreat! Now you can play
- cmd:kit nooby
- server:lobby
# The commands that can be executed even if the user is not logged in
WhitelistedCommands:
- register
- login
Title:
After:
# The title that will be shown after the user logs in
Login: '&bLogged In!'
# The title that will be shown after the user registers
Register: '&bRegistered In!'
Subtitle:
After:
# The subtitle that will be shown after the user logs in
Login: '&7Now you can play!'
# The subtitle that will be shown after the user registers
Register: '&7Thank you for choosing us!'
Title-Time:
After:
# The timing in ticks that the title will be shown (in;stay;out)
Login: 10;20;10
# The timing in ticks that the title will be shown (in;stay;out)
Register: 10;20;10
# The actions that will be blocked if the user is not logged in
BlockedActions:
- BLOCK_BREAK
- BLOCK_PLACE
- CHAT
- INTERACTION
- CUSTOM_INVENTORY
- DAMAGE
- ITEM_DROP
- ITEM_PICKUP
Auth:
# Period of time in seconds that will be waited before sending again how to login
CommandUsageTimer: 3
# Should the premium players be automatically logged in?
PremiumAutoLogin: true
Sessions:
# Should the sessions be enabled?
Enabled: true
MaxTime: 300

UpdateChecker: true
MySQL: Enabled: true
Host: localhost
Port: '3306'
DataBase: superauth
UserName: superauth
Password: BL_-z!y%t!kH[6(s
UseSSL: true ConnectionUrl: jdbc:mysql://{Host}:{Port}/{Database}?useSSL={UseSSL}

Вот скрин:

1647021858277
 
superfo
Тема закрыта.
Если кто-то столкнулся с такой проблемой и не хочет устанавливать Mariadb, пропишите данные команды в MySQL:

Код:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'some_hard_password';
GRANT USAGE ON *.* TO 'username'@'localhost';
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `database`.* TO 'username'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'username'@'localhost';
 
ВерхНиз