3 odpowiedzi w tym temacie

[BooG]

Witam otóż występuje mały problem z połączeniem:

L 03/12/2019 - 21:15:57: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'www1246_bans'@'o28.1sk.pl' (using password: YES) (1045)
L 03/12/2019 - 21:15:57: [amxbans_main.amxx] [AMXBans] Raport zapytania: SELECT `bid`, `ban_created`, `ban_length`, `cs_ban_reason`, `admin_nick`, `admin_id`, `admin_ip`, `player_nick`, `player_id`, `player_ip`, `server_name`, `server_ip`, `ban_type` FROM `amx_bans` WHERE ((`player_id` = 'STEAM_1:0:1075209335' AND `ban_type` = 'S') OR (`player_ip` = '83.31.159.178' AND `ban_type`L 03/12/2019 - 21:15:58: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie!
L 03/12/2019 - 21:15:58: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'www1246_bans'@'o28.1sk.pl' (using password: YES) (1045)
L 03/12/2019 - 21:15:58: [amxbans_main.amxx] [AMXBans] Raport zapytania: SELECT COUNT(*) FROM `amx_bans` WHERE ((`player_id` = 'STEAM_0:1:3685455' AND `ban_type` = 'S') OR (`player_ip` = '94.254.168.126' AND `ban_type` = 'SI')) AND `expired` = '1';
L 03/12/2019 - 21:16:07: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie!

Hosting bazy danych mam na net-speak'u 

 sql.cfg

// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host    "188.68.224.15"
amx_sql_user    "www1246_bans"
amx_sql_pass    "*****"
amx_sql_db      "www1246_bans"
amx_sql_table   "ban"
amx_sql_type    "mysql"

W czym może być problem?

[Rivit]

Access denied for user 'www1246_bans'@'o28.1sk.pl'

 

Hasło dobre? user na pewno taki jak ma być? uprawnienia ma ten user?

[BooG]

haslo git user też uprawnienia ma wszystkie

[BooG]

L 03/12/2019 - 21:57:29: Function is not present (function "check_player") (plugin "amxbans_main.amxx")
L 03/12/2019 - 21:57:29: [AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "Gm 1.6")
L 03/12/2019 - 21:57:29: [AMXX] Run time error 10: native error (native "set_task")
L 03/12/2019 - 21:57:29: [AMXX]    [0] amxbans_main.sma::client_authorized (line 289)

L 03/12/2019 - 21:57:31: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie!
L 03/12/2019 - 21:57:31: [amxbans_main.amxx] [AMXBans] Wiadomosc: Host '137.74.4.13' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' (1129)
L 03/12/2019 - 21:57:31: [amxbans_main.amxx] [AMXBans] Raport zapytania: SELECT `fid`, `reason`, `created`, `length` FROM `amx_flagged` WHERE `player_id` = 'STEAM_0:0:16443092' OR `player_ip` = '79.191.65.119' ORDER BY `length` ASC;

Teraz wygląda to tak.

 

/edit przepraszam zapomniałem o tej opcji

[AMXBans] Blad SQL: nie mozna polaczyc: 'Host '137.74.4.13' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts''

Użytkownik BooG edytował ten post 12.03.2019 22:18