MySQL and IPv6

[SNorman]

Hi I'm running an Arma server and am trying to set it up to a web control panel. My current problems

- When I google what my ip is, it's now coming up with an IPv6? How do I switch back to IPV4 or would this not cause me any problems

- My MySQL port is accidentally on 3366 instead of 3306 how can I change this

- My Databse doesn't seem to be allowing any connections into it, I've tried other accounts apart from root. I have 3366 forwarded but could this be because of the IPv6 issue? Or is there a setting I have to change to enable connections into my MySQL Databse 

[Windows7ge]

5 minutes ago, Snorman01 said:

Hi I'm running an Arma server and am trying to set it up to a web control panel. My current problems

- When I google what my ip is, it's no coming up with an IPv6? How do I switch back to IPV4 or would this not cause me any problems

- My MySQL port is accidentally on 3366 instead of 3306 how can I change this

- My Databse doesn't seem to be allowing any connections into it, I've tried other accounts apart from root. I have 3366 forwarded but could this be because of the IPv6 issue? Or is there a setting I have to change to enable connections into my MySQL Databse 

I'm not entirely sure but NAT is suppose to translate IPv6 addresses into IPv4. If your internal network is entirely IPv4 and your public IP is IPv6 you should be able to connect just fine. If Google is only giving you a IPv4 address you should be able to use that just the same. IPv6 has less overhead than IPv4 but performance wise I don't think you would notice a difference.

 

I'm willing to bet you cannot get any incoming connections due to the messed up port number. Unfortunately I cannot instruct you on how to change it but when requesting a connection to the server make sure that:

Whatever protocol(s) you're using is/are enabled on the server

Make sure the routers inbound port matches the port you're using and that the local port matches what's configured on the server.

Make sure you're connecting to your Public IPv4 address

Make sure the router is pointing to the static IPv4 address of the server.

Check your routers firewall settings. Router firewall settings can reject certain protocols such as ones required for online game operation.

 

You mentioned MySQL Database, are you also using this as a file server?

[SNorman]

51 minutes ago, Windows7ge said:

I'm not entirely sure but NAT is suppose to translate IPv6 addresses into IPv4. If your internal network is entirely IPv4 and your public IP is IPv6 you should be able to connect just fine. If Google is only giving you a IPv4 address you should be able to use that just the same. IPv6 has less overhead than IPv4 but performance wise I don't think you would notice a difference.

 

I'm willing to bet you cannot get any incoming connections due to the messed up port number. Unfortunately I cannot instruct you on how to change it but when requesting a connection to the server make sure that:

Whatever protocol(s) you're using is/are enabled on the server

Make sure the routers inbound port matches the port you're using and that the local port matches what's configured on the server.

Make sure you're connecting to your Public IPv4 address

Make sure the router is pointing to the static IPv4 address of the server.

Check your routers firewall settings. Router firewall settings can reject certain protocols such as ones required for online game operation.

 

You mentioned MySQL Database, are you also using this as a file server?

Arma 3 server, I'm trying to setup am web admin panel but it can't connect to my MySQL Databse. So you don't think the IP will be causing the problem? Any idea how I can find out how to change the MySQL port? How do I make sure the ports are enabled? They are forwarded and pointed at the local IP of the server  is there anything else I need to do inside MySQL to allow connections. 

[Windows7ge]

39 minutes ago, Snorman01 said:

Arma 3 server, I'm trying to setup am web admin panel but it can't connect to my MySQL Databse. So you don't think the IP will be causing the problem? Any idea how I can find out how to change the MySQL port? How do I make sure the ports are enabled? They are forwarded and pointed at the local IP of the server  is there anything else I need to do inside MySQL to allow connections. 

This is just a shot in the dark because I've never used MySQL before I don't know how the GUI works. From Shell provided you haven't confugred any user/pass requirments to access Shell try this:

 

To specify a port number explicitly, use the --port or -P option:

shell> mysql --port=3306 --host=localhost

 

To cause the port number to be used, invoke the program in either of these ways:

shell> mysql --port=3306 --host=127.0.0.1

shell> mysql --port=3306 --protocol=TCP

 

See if these change the port number to your desired port.