SQL Problem

Ask questions about errors and problems related to the amxbans project.
The more details you give, the better answer you will receive, READ the sticky topics before posting!

Be sure to post in the right sub forum: Bugs and Security
Post Reply
M3DHaT
Posts: 3
Joined: 25 Feb 2020, 21:33
Contact:

SQL Problem

Post by M3DHaT »

L 03/07/2020 - 08:25:35: [amxbans_core.amxx] [AMXBans] WARNING: amxbans_core.amxx should be the fist entry in your plugins.ini!

L 03/07/2020 - 08:25:35: [amxbans_core.amxx] [AMXBans] WARNING: amxbans_main.amxx should be the second entry in your plugins.ini!

[AMXBans] SQL error: can't connect: 'Access denied for user 'zcsltcom_medhata'@'193.70.36.126' (using password: YES)'

[AMXBans] Loaded 9 admins from file

[AMXBans] SQL error: can't connect: 'Access denied for user 'zcsltcom_medhata'@'193.70.36.126' (using password: YES)'

L 03/07/2020 - 08:25:36: [MySQL] Invalid handle: 0

L 03/07/2020 - 08:25:36: [AMXX] Displaying debug trace (plugin "amxbans_main.amxx")

L 03/07/2020 - 08:25:36: [AMXX] Run time error 10: native error (native "SQL_FreeHandle")

L 03/07/2020 - 08:25:36: [AMXX] [0] amxbans_main.sma::sql_init (line 183)

Menu item 17 added to Menus Front-End: "Plugin Cvars" from plugin "pluginmenu.amxx"

Menu item 18 added to Menus Front-End: "Plugin Commands" from plugin "pluginmenu.amxx"

L 03/07/2020 - 08:25:37: [amxbans_main.amxx] [AMXBans] Connection failed!

L 03/07/2020 - 08:25:37: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17

L 03/07/2020 - 08:25:37: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'zcsltcom_medhata'@'193.70.36.126' (using password: YES) (1045)

L 03/07/2020 - 08:25:37: [amxbans_main.amxx] [AMXBans] Query statement:

L 03/07/2020 - 08:25:38: [amxbans_main.amxx] [AMXBans] Connection failed!

L 03/07/2020 - 08:25:38: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17

L 03/07/2020 - 08:25:38: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'zcsltcom_medhata'@'193.70.36.126' (using password: YES) (1045)

L 03/07/2020 - 08:25:38: [amxbans_main.amxx] [AMXBans] Query statement:

Could not establish connection to Steam servers.


How i can fix this problem please told me
thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: SQL Problem

Post by thescaryguy »

First, you need to make amxbans_core.amxx and amxbans_main.amxx the first and second lines in your plugins.ini file, as it says in the error:
L 03/07/2020 - 08:25:35: [amxbans_core.amxx] [AMXBans] WARNING: amxbans_core.amxx should be the fist entry in your plugins.ini!
L 03/07/2020 - 08:25:35: [amxbans_core.amxx] [AMXBans] WARNING: amxbans_main.amxx should be the second entry in your plugins.ini!
Like this:
; AMX Mod X plugins

; Admin Base - Always one has to be activated
amxbans_core.amxx
amxbans_main.amxx
Another problem is:
[AMXBans] SQL error: can't connect: 'Access denied for user 'zcsltcom_medhata'@'193.70.36.126' (using password: YES)'
Check your config for host, username, password, and database. Is your amxbans on the same server as the game server?

TRY THIS:
Try entering "mysqladmin flush-hosts" via PuTTy.
Also check if you have added your server IP via Direct Admin to the Amxbans database Access Hosts.
I put flush-hosts into HLSW's console.
Post Reply