[AmineKyo]

I Have Some MySQL Errors I Can't Solve Them
For The First Its ZP Web STATS Plugin For Zombie Plague

Originally Posted by Console 03/11/2012 - 11:00:03: [zp_web_stats.amxx] [ZP] Stats: SQ Error #1045 - Access denied for user '****_stats'@'89.238.135.176' (using password: YES) 03/11/2012 - 11:00:03: [MySQL] Invalid database handle: 0 03/11/2012 - 11:00:03: [AMXX] Displaying debug trace (plugin "zp_web_stats.amxx") 03/11/2012 - 11:00:03: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery") 03/11/2012 - 11:00:03: [AMXX] [0] sqlx.inc::SQL_QueryAndIgnore (line 345) 03/11/2012 - 11:00:03: [AMXX] [1] zp_web_stats.sma::plugin_cfg (line 287)

Look at the plugin cvars

Originally Posted by zp_web_stats.cfg // Databse settings zp_stats_host "63.247.77.114" zp_stats_db "****_stats" zp_stats_user "****_stats" zp_stats_password "****"

Anything is OK Here (No Password Wrong Or USER ETC...)
And The Second AMXBans

Originally Posted by Console [AMXBans] plugin_cfg: ip 89.238.135.177:27018 / prefix HPBans [AMXBans] Loaded 7 admins from file 03/12/2012 - 19:06:40: [amxbans_main.amxx] [AMXBans] Received DB Info Tuple from amxbans_core: 3 | HPBans Menu item 18 added to Menus Front-End: "Plugin Cvars" from plugin "pluginmenu.amxx" Menu item 19 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx" 03/12/2012 - 19:06:40: [amxbans_core.amxx] Login: "[ H P ]* |YasserCS [~]<7><>" became an admin (account "STEAM_0:1:4***3360") (access "abcdefghijklmnopqrstu") (address "***9") (nick ";YasserCS") (static 0) [AMXBans] The server IP:PORT is: 89.238.135.177:27018 03/12/2012 - 19:06:40: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 89.238.135.177:27018 03/12/2012 - 19:06:40: [amxbans_main.amxx] [AMXBans] Connection failed! 03/12/2012 - 19:06:40: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17 03/12/2012 - 19:06:40: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'vefiedb_bans'@'89.238.135.176' (using password: YES) (1045) 03/12/2012 - 19:06:40: [amxbans_main.amxx] [AMXBans] Query statement: 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Connection failed! 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'vefiedb_bans'@'89.238.135.176' (using password: YES) (1045) 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `HPBans_serverinfo` WHERE address = '89.238.135.177:27018' 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Connection failed! 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'vefiedb_bans'@'89.238.135.176' (using password: YES) (1045) 03/12/2012 - 19:06:41: [amxbans_main.amxx] [AMXBans] Query statement: [AMXBans] No Reasons found [AMXBans] No Reasons found in Database. Static reasons were loaded instead.

SQL.CFG Cvars

Originally Posted by SqL.cfg amx_sql_host "63.247.77.114" amx_sql_user "vefiedb_bans" amx_sql_pass "*****" amx_sql_db "vefiedb_bans" amx_sql_table "HPBans_amxadmins" amx_sql_type "mysql"

Server IP : 89.238.135.177
SQL Host : 63.247.77.114
The Host That Shows Me In Console : 89.238.135.177
And Sorry For The WRONG Name Of Topic :$

[AmineKyo]

But When I Did This In ZP_Web_Stats.CFG

Originally Posted by ZP_Web_Stats.CFG // Databse settings zp_stats_host "**63.247.77.114" zp_stats_db "****_stats" zp_stats_user "****_stats" zp_stats_password "****"

Look What Happened

03/12/2012 - 19:19:05: [zp_web_stats.amxx] [ZP] Stats: SQ Error #2005 - Unknown MySQ server host '**63.247.77.114' (3) 03/12/2012 - 19:19:05: [MySQL] Invalid database handle: 0 03/12/2012 - 19:19:05: [AMXX] Displaying debug trace (plugin "zp_web_stats.amxx") 03/12/2012 - 19:19:05: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery") 03/12/2012 - 19:19:05: [AMXX] [0] sqlx.inc::SQL_QueryAndIgnore (line 345) 03/12/2012 - 19:19:05: [AMXX] [1] zp_web_stats.sma::plugin_cfg (line 287)

Sorry For The Double Post

[8088]

Access denied for user '****_stats'@'89.238.135.176' (using password: YES)

This can mean four things:

1. user ****_stats doesn't have the privilege to connect to MySQL (i.e. does not exist)
2. user ****_stats has the privilege to connect to MySQL, but not from 89.238.135.176
3. the password is incorrect
4. a combination of some or all of the above

Originally Posted by AmineKyo Server IP : 89.238.135.177

Apparently 89.238.135.176 is also your server ip. Make sure that your user is allowed to connect from that host too.

[AmineKyo]

Originally Posted by 8088 This can mean four things: user ****_stats doesn't have the privilege to connect to MySQL (i.e. does not exist) user ****_stats has the privilege to connect to MySQL, but not from 89.238.135.176 the password is incorrect a combination of some or all of the above Apparently 89.238.135.176 is also your server ip. Make sure that your user is allowed to connect from that host too.

The Right Answer is 2
but look at here

Server IP : 89.238.135.177 SQL Host : 63.247.77.114 The Host That Shows Me In Console : 89.238.135.176

[8088]

Like I said, make sure that your MySQL user is allowed to connect from that host too.

[AmineKyo]

Originally Posted by 8088 Like I said, make sure that your MySQL user is allowed to connect from that host too.

I Don't Have that host it doesn't exist i think
but w8
i test it in other Server
look what happened

[AMXBans] The server IP:PORT is: 89.238.135.172:27028 03/12/2012 - 20:14:44: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 89.238.135.172:27028 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Connection failed! 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'vefiedb_bans'@'89.238.135.170' (using password: YES) (1045) 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `HPBans_serverinfo` WHERE address = '89.238.135.172:27028' 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Connection failed! 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'vefiedb_bans'@'89.238.135.170' (using password: YES) (1045) 03/12/2012 - 20:14:45: [amxbans_main.amxx] [AMXBans] Query statement: [AMXBans] No Reasons found [AMXBans] No Reasons found in Database. Static reasons were loaded instead.

This is another server not the same

[8088]

Originally Posted by AmineKyo I Don't Have that host it doesn't exist i think

MySQL disagrees with you.

Maybe setting ip [value] in server.cfg helps controlling your outbound connections. If that won't work, you've two options left: 1) add all possible ips to the appropriate privileges or 2) fix it on OS level.

[AmineKyo]

nothing from that answers had did well,
Thank So Much And I'm Sorry For Disturbing you.

[8088]

You're not disturbing me, but I have no idea what 'nothing from that answers had did well' means.