[H@M]

Well, My problem is that my server doesn't connect to AMXBANS database when I'm trying to connect it to my website.


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 "*******.fatcowmysql.com" amx_sql_user "amxbans" amx_sql_pass "*********" amx_sql_db "amxbans" amx_sql_table "mysql" amx_sql_type "mysql"

This is the problem that shows in the logs:

[amxbans_core.amxx] [AMXBANS] Index: 10 | [amxbans_core.amxx] [AMXBANS] Index: 8 [amxbans_core.amxx] [AMXBANS] Index: 8 | Name: [amxbans_main.amxx] [AMXBans] Connection failed! [amxbans_main.amxx] [AMXBans] Message: Unknown MySQL server host '*******.fatcowmysql.com' (2) (2005) [amxbans_main.amxx] [AMXBans] Query statement: SELECT `fid`, `reason`, `created`, `length` FROM `amx_flagged` WHERE `player_id` = 'STEAM_ID_LAN' OR `player_ip` = '149.200.184.91' ORDER BY `length` ASC; [AMXBans] Connection failed! [AMXBans] Message: Unknown MySQL server host '*******.fatcowmysql.com' (2) (2005) [amxbans_main.amxx] [AMXBans] Query statement: SELECT COUNT(*) FROM `amx_bans` WHERE ((`player_id` = 'STEAM_ID_LAN' AND `ban_type` = 'S') OR (`player_ip` = '149.200.184.91' AND `ban_type` = 'SI')) AND `expired` = '1';

Btw, the host that I actually use, I'm using it in AMXBANS setup and worked perfectly. Thanks!

[YamiKaitou]

The error message is pretty self explanatory

[H@M]

Originally Posted by YamiKaitou The error message is pretty self explanatory

I used this host for AMXBANS setup in my website.

[YamiKaitou]

Again, the error is right in front of you

[H@M]

I didn't post this thread for someone to say that the error is obvious... I need more explanation and an obvious solution.

[YamiKaitou]

Well, lets start with "What is the correct SQL Hostname/IP?"

[H@M]

Host : 3arabcoolcom.fatcowmysql.com

[YamiKaitou]

Unable to resolve that hostname, hence why it is unknown to MySQL

[H@M]

I put everything correctly and when I tried to check the logs it gives me that error and the Host name was running when I was doing the setup.

[YamiKaitou]

Contact your host as that DNS name does not resolve to an IP