How do I map an IPv4 connection to IPv6?

FireRaven · 02-07-2012, 08:50 PM

Hi,

I want MySQL (port 3306) to also listen on port 3306 on IPv6 - it currently only listens on IPv4 0.0.0.0:3306.

Can someone tell me the iptables rule for this?

Here is the equivilant for Windows:

Code:

netsh interface portproxy add v6tov4 listenport=3306 connectaddress=127.0.0.1 connectport=3306

larrym82 · 02-10-2012, 11:27 AM

Quote:

Originally Posted by FireRaven

Hi,

I want MySQL (port 3306) to also listen on port 3306 on IPv6 - it currently only listens on IPv4 0.0.0.0:3306.

Can someone tell me the iptables rule for this?

Here is the equivilant for Windows:

Code:

netsh interface portproxy add v6tov4 listenport=3306 connectaddress=127.0.0.1 connectport=3306

Hi,

I'd start here: http://en.wikipedia.org/wiki/IPv6_address

this might work even better: http://docs.oracle.com/javase/1.4.2/...et/ipv6_guide/

Best

FireRaven · 03-30-2012, 06:22 PM

None of that helps.

I'm unsure if I need to set up an internal iptables NAT to do this or can just do simple port forwarding...

WizadNoNext · 03-31-2012, 05:05 AM

Quote:

Originally Posted by FireRaven

None of that helps.

I'm unsure if I need to set up an internal iptables NAT to do this or can just do simple port forwarding...

Answer is no. You cannot do NAT between OSI Layer 3 protocols. You have to setup tunnel to do so.
Look in your config files to find out where are IPs on which it is supposed to listen.
If you have auto-configured IP based on EUI (e.g. MAC), then you are lucky, cause you would always have exactly same IPv6 address, if no try to find interfaces on which it is supposed to listen.
If all of this would fail you have no other choice, but to use sit interface, which would "translate" your IPv6 to IPv4. Do not ask me how to do it this way, as all what I am using sit for is IPv6-in-IPv4 Tunnel provided by hurricane

FireRaven · 03-31-2012, 07:42 AM

I am simply trying to forward TCP port 3306 to another address. It can be done in windows simply with that one command.
I am not sure the exact terminology for but it can be done with a NAT table, just wondering if there is a simpler way without the overhead with NAT.

unSpawn · 03-31-2012, 07:54 AM

Quote:

Originally Posted by FireRaven

I want MySQL (port 3306) to also listen on port 3306 on IPv6 - it currently only listens on IPv4

As per the last comment in bug id 8836:

Quote:

[29 Feb 11:30] Trent Lloyd
MySQL 5.5 and later supports IPv6 fully for client connections, but is currently undocumented.
To configure MySQL 5.5 and later to accept IPv6 connections, use the following configuration option.
bind-address = ::
MySQL 5.1 and earlier cannot accept IPv6 connections in any configuration.

Using iptables rules is not the way. Check your version first.

WizadNoNext · 03-31-2012, 10:39 AM

Quote:

Originally Posted by FireRaven

I am not sure the exact terminology for but it can be done with a NAT table, just wondering if there is a simpler way without the overhead with NAT.

It cannot be done with NAT! I've already stated it! You cannot NAT between OSI Layer 3 protocols! t is NAT (Network Address Translation - this doesn't mean inter-protocol NAT. IPv4 and IPv6 are completely separate protocols! IPv6 isn't on top of IPv4 - it is separate protocol! It is simply imposible to NAT IPv6 into IPv4 or IPv4 into IPv4 protocol. You can setup tunnel, which will do what you want, but it won't be NAT!

squat001 · 04-02-2012, 09:54 AM

Think want you are trying to do is simple redirect traffic from a local IPv6 address to the IPv4 local loopback address?

What your Windows netsh command is doing is reverse proxying the connection from the IPv6 address to the IPv4 or using an IPv6-to-IPv4 Transport Relay Translator (TRT)

First see if your version of MySQL supports IPv6 so to avoid NAT and Proxy config, failing that you could look at NAT64 which is allows a some basic translation between IPv6 and IPv4 but is more global as NATs whole subnets and has no layer 4 controls.