MYSQL server, wierd connection error!

onion · Post by **onion** » Thu Dec 27, 2007 6:16 pm

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

onion · Post by **onion** » Fri Dec 28, 2007 12:41 pm

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. . .

kp_downarrow · Post by **kp_downarrow** » Fri Dec 28, 2007 1:07 pm

"Could not get TCP/IP address, TCP/IP disabled "

onion · Post by **onion** » Fri Dec 28, 2007 1:43 pm

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

Post by **YamiKaitou** » Fri Dec 28, 2007 2:07 pm

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

onion · Post by **onion** » Fri Dec 28, 2007 2:09 pm

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

Post by **YamiKaitou** » Fri Dec 28, 2007 2:13 pm

I said HLDS, not MySQL. You can backup all of your mods. I am just telling you to reinstall the base HLDS files

onion · Post by **onion** » Fri Dec 28, 2007 2:37 pm

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

Post by **YamiKaitou** » Fri Dec 28, 2007 2:55 pm

Try using the users.ini file for your admins and try using SQLite for your wc3ft xp. See if that helps any

onion · Post by **onion** » Fri Dec 28, 2007 4:13 pm

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!

onion · Post by **onion** » Fri Dec 28, 2007 4:47 pm

Hmm, i was wrong, i forwarded the ports on my router... and im still getting that error... any help?

Post by **YamiKaitou** » Fri Dec 28, 2007 8:48 pm

Switch the server port to 27016 instead

onion · Post by **onion** » Fri Dec 28, 2007 9:03 pm

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?

cybergamezone · Post by **cybergamezone** » Fri Dec 28, 2007 9:14 pm

Post a Public address and we can try.

Senne · Post by **Senne** » Sat Dec 29, 2007 10:05 am

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.

onion · Post by **onion** » Sat Dec 29, 2007 11:13 am

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.

Post by **YamiKaitou** » Sat Dec 29, 2007 11:54 am

The ip that you give to others is the ip that is displayed at http://whatismyip.com

onion · Post by **onion** » Sat Dec 29, 2007 12:03 pm

YamiKaitou wrote:The ip that you give to others is the ip that is displayed at http://whatismyip.com

/sigh, when i put that ip in my network configs, then my internet doesn't work

Post by **YamiKaitou** » Sat Dec 29, 2007 1:20 pm

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

onion · Post by **onion** » Sat Dec 29, 2007 1:42 pm

Ohh, so everyone CAN actually see/connect to the server? or what do i do to make them see the server?

Post by **YamiKaitou** » Sat Dec 29, 2007 2:03 pm

Forward your ports and make sure the server is not setup for LAN.

onion · Post by **onion** » Sat Dec 29, 2007 3:23 pm

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)

Post by **YamiKaitou** » Sat Dec 29, 2007 3:36 pm

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.

onion · Post by **onion** » Sat Dec 29, 2007 10:30 pm

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?

Post by **YamiKaitou** » Sat Dec 29, 2007 10:55 pm

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

Post by **Geesu** » Tue Jan 15, 2008 12:51 pm

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