Проблема с БД AuthMe

HappyIceGriefYT

Premium
Сборщик
Дизайнер
Hosting
Сообщения
294
Решения
4
Столкнулся с проблемой, указал БД в AuthMe однако БД остается без изменений, easydonate пишет "Не удалось подключится к БД". Через phpmyadmin я подключится могу, что делать?

Конфиг 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: '3306'
    # Connect to MySQL database over SSL
    mySQLUseSSL: true
    # 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: Тут UserName
    # Password to connect to the MySQL database
    mySQLPassword: 'Пароль'
    # Driver Name of the MySQL database
    mySQLDriverClassName: com.mysql.jdbc.Driver
    # Database Name, use with converters or as SQLITE database name
    mySQLDatabase: Название БД
    # 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: ''
    # 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
 
Столкнулся с проблемой, указал БД в AuthMe однако БД остается без изменений, easydonate пишет "Не удалось подключится к БД". Через phpmyadmin я подключится могу, что делать?

Конфиг 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: '3306'
    # Connect to MySQL database over SSL
    mySQLUseSSL: true
    # 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: Тут UserName
    # Password to connect to the MySQL database
    mySQLPassword: 'Пароль'
    # Driver Name of the MySQL database
    mySQLDriverClassName: com.mysql.jdbc.Driver
    # Database Name, use with converters or as SQLITE database name
    mySQLDatabase: Название БД
    # 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: ''
    # 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
Порт открыл?
 
Код:
#Minecraft server properties
#Sun Feb 06 17:04:28 MSK 2022
spawn-protection=1
max-tick-time=60000
server-name=Я люблю iPhone
generator-settings=
force-gamemode=false
allow-nether=true
gamemode=0
broadcast-console-to-ops=true
enable-query=false
player-idle-timeout=0
difficulty=3
spawn-monsters=true
broadcast-rcon-to-ops=true
op-permission-level=4
resource-pack-hash=
pvp=true
snooper-enabled=false
level-type=DEFAULT
rcon.ip=Я люблю iPhone
hardcore=false
enable-command-block=false
max-players=35
network-compression-threshold=512
resource-pack-sha1=
max-world-size=29999984
rcon.port=Я люблю iPhone
server-port=25947
debug=false
server-ip=Я люблю iPhone
spawn-npcs=true
allow-flight=true
level-name=world
view-distance=4
server-id=unnamed
resource-pack=
spawn-animals=true
white-list=false
rcon.password=Я люблю iPhone
generate-structures=true
online-mode=false
max-build-height=256
level-seed=
prevent-proxy-connections=false
use-native-transport=false
enable-rcon=true
motd=Hosted by Я люблю iPhone
 
Код:
#Minecraft server properties
#Sun Feb 06 17:04:28 MSK 2022
spawn-protection=1
max-tick-time=60000
server-name=Я люблю iPhone
generator-settings=
force-gamemode=false
allow-nether=true
gamemode=0
broadcast-console-to-ops=true
enable-query=false
player-idle-timeout=0
difficulty=3
spawn-monsters=true
broadcast-rcon-to-ops=true
op-permission-level=4
resource-pack-hash=
pvp=true
snooper-enabled=false
level-type=DEFAULT
rcon.ip=Я люблю iPhone
hardcore=false
enable-command-block=false
max-players=35
network-compression-threshold=512
resource-pack-sha1=
max-world-size=29999984
rcon.port=Я люблю iPhone
server-port=25947
debug=false
server-ip=Я люблю iPhone
spawn-npcs=true
allow-flight=true
level-name=world
view-distance=4
server-id=unnamed
resource-pack=
spawn-animals=true
white-list=false
rcon.password=Я люблю iPhone
generate-structures=true
online-mode=false
max-build-height=256
level-seed=
prevent-proxy-connections=false
use-native-transport=false
enable-rcon=true
motd=Hosted by Я люблю iPhone
rcon-ip оставь пустым если у тебя VDS
 
easydonate пишет "Не удалось подключится к БД"
Это 2 несвязанные фразы.

Скорее всего, хостинг ограничивает возможность подключения к БД.
Попробуй обратиться в тех. поддержку хостинга и попросить разрешить подключение к БД для easydonate.
 
Назад
Сверху Снизу