Raised This Month: $ Target: $400
 0% 

Amx bans mysql error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
MaXs
Member
Join Date: Jan 2017
Old 01-18-2017 , 13:06   Amx bans mysql error
Reply With Quote #1

I set everything right, added server in mysql, edited sql.cfg but:
[amxbans_main.amxx] [AMXBans] Connection failed!
L 01/18/2017 - 20:02:29: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17
L 01/18/2017 - 20:02:29: [amxbans_main.amxx] [AMXBans] Message: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 (2013

Sql.cfg :

amx_sql_host "185.80.128.32"
amx_sql_user "frags_banas"
amx_sql_pass "PASSWORD HIDDEN"
amx_sql_db "frags_banas"
amx_sql_table "amx"
amx_sql_type "mysql"
amx_sql_timeout "60"
MaXs is offline
ko22009
New Member
Join Date: Jan 2017
Old 01-19-2017 , 17:05   Re: Amx bans mysql error
Reply With Quote #2

You have problem with query.
Send your chunk of code of query.
Did you check connection with mysql?
Set in front of this plugin in plugins.ini, debug. For example: amxbans_main.amxx debug;
And you get result stack of trace.
ko22009 is offline
D3XT3R
AlliedModders Donor
Join Date: Nov 2016
Location: Lithuania, Bomb A (Kauna
Old 01-27-2017 , 14:15   Re: Amx bans mysql error
Reply With Quote #3

Try use this
Quote:
// SQL configuration file
// File location: /addons/amxmodx/configs/sql.cfg

//Skopiuj tekst i wklej do pliku sql.cfg - folder addons/amxmodx/configs/

//Plik wygenerowany na stronie mybans.eu


amx_sql_host ""
amx_sql_user ""
amx_sql_pass ""
amx_sql_db ""
amx_sql_table "amx"
amx_sql_type "mysql"
and you should give yours vps permission host from ur domain of amxbans
__________________
D3XT3R is offline
Send a message via Skype™ to D3XT3R
MaXs
Member
Join Date: Jan 2017
Old 01-29-2017 , 12:31   Re: Amx bans mysql error
Reply With Quote #4

i fixed myself like week ago but thanks.
MaXs is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 20:42.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode