serwer nie łączy z amxbansem
Carbon
05.01.2014
Wszystko podłączone jak powinno, wiem bo nie raz już to robiłem.
Tylko, że tym razem pojawił się taki error:
L 01/05/2014 - 15:30:03: Start of error session. L 01/05/2014 - 15:30:03: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20140105.log") L 01/05/2014 - 15:30:03: [MySQL] Invalid info tuple handle: 0 L 01/05/2014 - 15:30:03: [AMXX] Run time error 10 (plugin "amxbans_core.amxx") (native "SQL_Connect") - debug not enabled! L 01/05/2014 - 15:30:03: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
Edited by Carbon, 05.01.2014 15:31.
Carbon
05.01.2014
Nie mogę już edytować tak więc podrzucam nowe logi:
L 01/05/2014 - 15:53:13: Start of error session. L 01/05/2014 - 15:53:13: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20140105.log") L 01/05/2014 - 15:53:13: [MySQL] Invalid info tuple handle: 0 L 01/05/2014 - 15:53:13: [AMXX] Run time error 10 (plugin "amxbans_core.amxx") (native "SQL_Connect") - debug not enabled! L 01/05/2014 - 15:53:13: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes). L 01/05/2014 - 15:53:34: Function is not present (function "check_player") (plugin "amxbans_main.amxx") L 01/05/2014 - 15:53:34: [AMXX] Displaying debug trace (plugin "amxbans_main.amxx") L 01/05/2014 - 15:53:34: [AMXX] Run time error 10: native error (native "set_task") L 01/05/2014 - 15:53:34: [AMXX] [0] amxbans_main_1980379.sma::client_authorized (line 289)
Carbon
13.01.2014
Niestety nadal nic, tak mam ustawione:
amx_sql_host "localhost" amx_sql_user "w301_bany" amx_sql_pass "hasło" amx_sql_db "w301_amxbans" amx_sql_table "admins" amx_sql_type "mysql"
;AMX Mod X plugins ; Admin Base - Always one has to be activated amxbans_core.amxx ; amxbans amxbans_main.amxx debug ; amxbans ;admin.amxx ; admin base (required for any admin-related) admin_sql.amxx ; admin base - SQL version (comment admin.amxx) ; Basic admincmd.amxx ; basic admin console commands adminhelp.amxx ; help command for admin console commands adminslots.amxx ; slot reservation multilingual.amxx ; Multi-Lingual management
Error:
L 01/13/2014 - 15:19:19: Start of error session. L 01/13/2014 - 15:19:19: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20140113.log") L 01/13/2014 - 15:19:19: [MySQL] Invalid info tuple handle: 0 L 01/13/2014 - 15:19:19: [AMXX] Run time error 10 (plugin "amxbans_core.amxx") (native "SQL_Connect") - debug not enabled! L 01/13/2014 - 15:19:19: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
Logi:
L 01/13/2014 - 15:24:58: -------- Mapchange to de_dust2 -------- L 01/13/2014 - 15:24:58: [amxbans_core.amxx] [AMXBans] WARNING: admin_sql.amxx plugin running! Stopped. L 01/13/2014 - 15:24:58: [amxbans_main.amxx] [AMXBans] Connection failed! L 01/13/2014 - 15:24:58: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1 L 01/13/2014 - 15:24:58: [amxbans_main.amxx] [AMXBans] Message: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (2002) L 01/13/2014 - 15:24:58: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '178.19.106.148:27091' L 01/13/2014 - 15:24:59: [amxbans_main.amxx] [AMXBans] Connection failed! L 01/13/2014 - 15:24:59: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5 L 01/13/2014 - 15:24:59: [amxbans_main.amxx] [AMXBans] Message: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (2002) L 01/13/2014 - 15:24:59: [amxbans_main.amxx] [AMXBans] Query statement: L 01/13/2014 - 15:24:59: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
Zabijaka Gryps
13.01.2014
Carbon
13.01.2014
Błędny host. Nie będzie to localhost. Spróbuj wpisać tam adres strony, do której jest ta baza. Pamiętaj też o dodaniu zezwolenia na łączenie z bazą z ip serwera.
Masz racje, gdzieś wyczytałem, że na tej bazie musi pisać "localhost" ale jednak nie, plusik dla Ciebie.
skibos
13.01.2014
tak jak kolega, dodaj zamiast loclhost swoją stronkę na której masz bazę.
Dodaj uprawnienia do bazy z zewnątrz, CPanel, menadżer zdalnego zarządzania Mysql i dodaj tam %
Jeśli nie pokaż plik modules.ini
Musisz mieć tam odblokowane pierwsze 2 moduły czyli mysql oraz sqllite chyba.