Help with mysql (error log included)

hansenxu · **Author**

well i have a ultimate war3 server, and the xp wont save, i think its because of mysql.
here is the error message from log
then it repeats the last line of error ALLLL over
can someone tell me how to configure my files to make saving work?

L 10/19/2004 - 22:26:09: [uwc3.amxx] UWC3 SQL :: Loading Configuration File...
L 10/19/2004 - 22:26:09: [uwc3.amxx] UWC3 SQL :: Configuration File Loaded [OK]
L 10/19/2004 - 22:26:10: [uwc3.amxx] UWC3 SQL :: Config Report: host=(127.0.0.1) user=() pass=(*) db=(uwc3)
L 10/19/2004 - 22:26:10: [MySQL] SQL Error: Could not connect (plugin "czero\addons\amxmodx\plugins\uwc3.amxx" line 871)
L 10/19/2004 - 22:26:10: [uwc3.amxx] UWC3 SQL :: Connect Error [ ]

hansenxu · 10-19-2004 , 22:55

by the way, here are what i have in SQL.CFG

Quote:

amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "amx"
amx_sql_table "admins"

this is what i have in UWC3_sql.cfg

Quote:

UW_sql_host "127.0.0.1"
UW_sql_user ""
UW_sql_pass ""
UW_sql_db "uwc3"

BAILOPAN · 10-19-2004 , 22:55

o_O weird error report, what version of amxx

hansenxu · 10-19-2004 , 22:57

amxmodx-0.20-RC6.zip

hansenxu · 10-20-2004 , 18:43

ok i changed some stuff, here is the new stats

ERROR LOG

Quote:

L 10/20/2004 - 18:20:17: [uwc3.amxx] UWC3 SQL :: Loading Configuration File...
L 10/20/2004 - 18:20:17: [uwc3.amxx] UWC3 SQL :: Configuration File Loaded [OK]
L 10/20/2004 - 18:20:18: [uwc3.amxx] UWC3 SQL :: Config Report: host=(64.228.129.22

user=(root) pass=(*) db=(uwc3)
L 10/20/2004 - 18:20

9: [MySQL] DB Connection failed(2003): Can't connect to MySQL server on '64.228.129.228' (10060)
L 10/20/2004 - 18:20

9: [uwc3.amxx] UWC3 SQL :: Connect Error [ Can't connect to MySQL server on '64.228.129.228' (10060) ]

hansenxu · 10-20-2004 , 18:44

sql.cfg

Quote:

amx_sql_host "64.228.129.228"
amx_sql_user "root"
amx_sql_pass "root2"
amx_sql_db "amx"
amx_sql_table "admins"

uwc3_sql.cfg

Quote:

UW_sql_host "64.228.129.228"
UW_sql_user "root"
UW_sql_pass "root2"
UW_sql_db "uwc3"

Its an ultimate warcraft 3 mod, the exp wont save, thats the problem im having.

i have no idea what sql is by the way, or or to config it, is there a help site for it???

kingpin · 10-20-2004 , 19:38

I honestly hope they are fake passwords/usernames, and I have had similar problem while tryign to connect but have had no time to fix that yet or take a deeper look at it.

Realitive_Context · 12-10-2004 , 20:57

i know what your doing wrong i had the same problenm but it was a simple simple fix. I added youto my msn list so if youll put me on allow ill walk you threw it

BigBaller · 12-10-2004 , 22:21

read the date of the posts, then read hte date of your posts.

come on man dont bump old shit.

Kamikaze · 12-11-2004 , 03:32

DTR! DTR! DTR!

Dead Topic Revivor, I used that abbrevation a lot in my own forums.