Page 1 of 1
MYSQL server, wierd connection error!
Posted: Thu Dec 27, 2007 6:16 pm
by onion
I configured my mysql server and all that...but when i start my server...it says can't connect to the mysql server...access denied for amxx@localhost to database amx... but my data base in the config file is amxx...not amx...
--- Please enter the following information for support ---
War3ft Version: 3.0
Amxmodx Version: 1.8
Metamod Version: 1.19
Posted: Fri Dec 28, 2007 12:41 pm
by onion
It also says this in the console...
WARNING: UDP_OpenSocket: port: 27015 bind: WSAEADDRINUSE
NET Ports: server 27015, client 27005
Could not get TCP/IP address, TCP/IP disabled
Reason: WSAENOTS
and my meta list says...
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm.dll v1.8.0.3 ini Start ANY
[ 2] MySQL RUN - mysql_amxx.dll v1.8.0.3 pl1 ANY ANY
[ 3] Fun RUN - fun_amxx.dll v1.8.0.3 pl1 ANY ANY
[ 4] Engine RUN - engine_amxx.dll v1.8.0.3 pl1 ANY ANY
[ 5] FakeMeta RUN - fakemeta_amxx.dl v1.8.0.3 pl1 ANY ANY
[ 6] CStrike RUN - cstrike_amxx.dll v1.8.0.3 pl1 ANY ANY
[ 7] CSX RUN - csx_amxx.dll v1.8.0.3 pl1 ANY ANY
[ 8] SQLite RUN - sqlite_amxx.dll v1.8.0.3 pl1 ANY ANY
weird cuz i t says mysql AND sqlite are running... but i disabled sqlite in the modules folder
AND on top of all that, my admin for the server isn't workin ever since i tried to install mysql. . .
Posted: Fri Dec 28, 2007 1:07 pm
by kp_downarrow
"Could not get TCP/IP address, TCP/IP disabled "
Posted: Fri Dec 28, 2007 1:43 pm
by onion
kp_downarrow wrote:"Could not get TCP/IP address, TCP/IP disabled "
and how do i enable it..? and why is my admin not workin anymore
Posted: Fri Dec 28, 2007 2:07 pm
by YamiKaitou
If the server is unable to get the IP address of itself, then it can't connect to anything and nobody can connect to it. I would suggest doing a fresh install of HLDS.
Oh, and wc3ft forces AMXx to load Fun, Engine, Fakemeta, Cstrike, MySQL, and SQLite
Posted: Fri Dec 28, 2007 2:09 pm
by onion
YamiKaitou wrote:If the server is unable to get the IP address of itself, then it can't connect to anything and nobody can connect to it. I would suggest doing a fresh install of HLDS.
Oh, and wc3ft forces AMXx to load Fun, Engine, Fakemeta, Cstrike, MySQL, and SQLite
So ill have to reinstall all of the damn mods..and mysql...great.. lol, okay ill do that
Posted: Fri Dec 28, 2007 2:13 pm
by YamiKaitou
I said HLDS, not MySQL. You can backup all of your mods. I am just telling you to reinstall the base HLDS files
Posted: Fri Dec 28, 2007 2:37 pm
by onion
YamiKaitou wrote:I said HLDS, not MySQL. You can backup all of your mods. I am just telling you to reinstall the base HLDS files
still says
WARNING: UDP_OpenSocket: port: 27015 bind: WSAEADDRINUSE
NET Ports: server 27015, client 27005
Could not get TCP/IP address, TCP/IP disabled
Reason: WSAENOTSOCK
Connecting to 192.168.0.114:27015...
Connection accepted by 192.168.0.114:
I think i could fix that my forwarding my ports of my router though? so the main problem is ... why is my admin not working, and why are my War3ft races not showing up
Posted: Fri Dec 28, 2007 2:55 pm
by YamiKaitou
Try using the users.ini file for your admins and try using SQLite for your wc3ft xp. See if that helps any
Posted: Fri Dec 28, 2007 4:13 pm
by onion
YamiKaitou wrote:Try using the users.ini file for your admins and try using SQLite for your wc3ft xp. See if that helps any
Alright, very nice. SQlite also fixed the problems with the race...however..im still getting the error: WARNING: UDP_OpenSocket: port: 27015 bind: WSAEADDRINUSE
NET Ports: server 27015, client 27005
Could not get TCP/IP address, TCP/IP disabled
Reason: WSAENOTS
But like i said, i think portforwarding will fix that... And the admin is also working now, Ill try to forward the ports and keep you informed. Thanks!
Posted: Fri Dec 28, 2007 4:47 pm
by onion
Hmm, i was wrong, i forwarded the ports on my router... and im still getting that error... any help?
Posted: Fri Dec 28, 2007 8:48 pm
by YamiKaitou
Switch the server port to 27016 instead
Posted: Fri Dec 28, 2007 9:03 pm
by onion
YamiKaitou wrote:Switch the server port to 27016 instead
Okay now my console just says
NET Ports: server 27015, client 27005
Server IP address 192.168.0.136:27015
Connecting to 192.168.0.136:27016...
Connection accepted by 192.168.0.136:27
Does that mean everyone can connect to my server now? All systems go?
Posted: Fri Dec 28, 2007 9:14 pm
by cybergamezone
Post a Public address and we can try.
Posted: Sat Dec 29, 2007 10:05 am
by Senne
192.168.0.136:27 is a typically router network address, so it isnt public to the world = cant connect from outside your home network.
Posted: Sat Dec 29, 2007 11:13 am
by onion
Well what would a Public Address be? gimme some examples please.. And that IP is the static IP i configured through portforward.com.. So will i have to make a different static IP also?
Also, my server console says...
Adding master server 72.165.61.189:27010
Adding master server 72.165.61.190:27010
If it helps.
Posted: Sat Dec 29, 2007 11:54 am
by YamiKaitou
The ip that you give to others is the ip that is displayed at
http://whatismyip.com
Posted: Sat Dec 29, 2007 12:03 pm
by onion
/sigh, when i put that ip in my network configs, then my internet doesn't work
Posted: Sat Dec 29, 2007 1:20 pm
by YamiKaitou
No, that is the IP that you give to others if they want to connect to your server. That IP is your router's IP to the rest of the world
Posted: Sat Dec 29, 2007 1:42 pm
by onion
Ohh, so everyone CAN actually see/connect to the server? or what do i do to make them see the server?
Posted: Sat Dec 29, 2007 2:03 pm
by YamiKaitou
Forward your ports and make sure the server is not setup for LAN.
Posted: Sat Dec 29, 2007 3:23 pm
by onion
YamiKaitou wrote:Forward your ports and make sure the server is not setup for LAN.
when i try to forward the ports for steam for the IP 65.255.65.171, which is the ip on whatismyip.com... it says i have to use a ip within the LAN subnet (192.168.0.0)
Posted: Sat Dec 29, 2007 3:36 pm
by YamiKaitou
The 65.255 IP is the IP you give to others, NOT THE IP OF YOUR SERVER. The IP of your server is the 192.168 IP. The 65.255 IP is the IP of your router. When a client connects to that IP, the router looks at the port the client is connecting to and then forwards the info to the computer that that port is forwarded to. So, you forward to the 192.168 IP and you give out the 65.255 IP.
Posted: Sat Dec 29, 2007 10:30 pm
by onion
Grr... Im really sorry about this, i just dont know anything about any of this. But! your help IS very much appreciated.
I'm not sure how to set the router or server to give out the 65.255 ip?
Posted: Sat Dec 29, 2007 10:55 pm
by YamiKaitou
it is already set that way. If you give people the IP to your server, give them the 65.255 IP. The server itself will say the ip is the 192.168 one, but everyone will connect to the 65.255 ip
Posted: Tue Jan 15, 2008 12:51 pm
by Geesu
rofl i'm glad i just read this thread after yami like answered it
In Summary:
A router has (generally) ONE public address, this address can be viewed by connecting to the router's admin tool or by going to
www.whatismyip.com (must visit site while connected to router). A router has many private addresses which it designates to computers that are connected to it (generally 192.168.x.x 10.0.x.x).
Bam done
methinks