MySQL over IPv6??

TinyTunnel_Tom

I cannot for gods sake get MySQL to work over IPv6 please can some MySQL god help me.

And yes @rm_ did rape me into IPv6

Hassan

I laughed way too hard at this post

TinyTunnel_Tom

@Hassan said:
I laughed way too hard at this post

Dont blame ya. Would laugh harder if you could see me swearing

desperand

very interesting. Looking for information too.

William

That should help:

http://dev.mysql.com/doc/refman/5.5/en/ipv6-support.html

TinyTunnel_Tom

All that is in order @William

Tried telnetting and got a connection refused

msg7086

MySQL works with IPv6. Check your firewall / iptables?

Also try VPN over IPv6.

TinyTunnel_Tom

@msg7086 said:
MySQL works with IPv6. Check your firewall / iptables?

Also try VPN over IPv6.
@Jack said:
ip6tables?

Can you give me a command to try. Not really familiar with ip6tables

wych

@TinyTunnel_Tom if testing just

service ip6tables stop

, try it and if it works then add the command to whitelist the port for MySQL.

Is MySQL listening on IPv6?

TinyTunnel_Tom

root@sql1:~# service ip6tables stop
ip6tables: unrecognized service
root@sql1:~#

@wych

wych

@TinyTunnel_Tom said:

root@sql1:~# service ip6tables stop
ip6tables: unrecognized service
root@sql1:~#

wych

What Distro?

TinyTunnel_Tom

@wych said:
What Distro?

Debian7

wych

@TinyTunnel_Tom said:
Debian7

Does

ip6tables -vL

show anything?

Try

sudo /etc/init.d/ip6tables-persistent stop

...

TinyTunnel_Tom

@wych said:
Try

sudo /etc/init.d/ip6tables-persistent stop

...

root@sql1:/etc# ip6tables -vL
Chain INPUT (policy ACCEPT 1632 packets, 951K bytes)
 pkts bytes target     prot opt in     out     source               destination 

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination 

Chain OUTPUT (policy ACCEPT 1036 packets, 126K bytes)
 pkts bytes target     prot opt in     out     source               destination 
root@sql1:/etc# #

root@sql1:/etc# /etc/init.d/ip6tables-persistent stop
-bash: /etc/init.d/ip6tables-persistent: No such file or directory
root@sql1:/etc#

TinyTunnel_Tom

Anyone else?

Makenai

What did you try to telnet? Public IPv6 or local?

Try

telnet ::1 3306

If it works blame the firewall

Is it even listening to IPv6?

sudo netstat -lntp --inet6

TinyTunnel_Tom

@Makenai said:
What did you try to telnet? Public IPv6 or local?

Try

telnet ::1 3306

If it works blame the firewall

Is it even listening to IPv6?

sudo netstat -lntp --inet6

root@sql1:/etc# telnet ::1 3306
Trying ::1...
telnet: Unable to connect to remote host: Connection refused
root@sql1:/etc#

root@sql1:/etc# netstat -lntp --inet6
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp6       0      0 :::53                   :::*                    LISTEN      8919/named
tcp6       0      0 :::22                   :::*                    LISTEN      25434/sshd
tcp6       0      0 ::1:953                 :::*                    LISTEN      8919/named
root@sql1:/etc#

Makenai

It is not even listening to ipv6 connections. There is an issue with Mysql IPv6 configuration.

TinyTunnel_Tom

@Makenai said:
It is not even listening to ipv6 connections. There is an issue with Mysql IPv6 configuration.

I just realised. Any ideas how to allow it to listen to MySQL IPv6

Makenai

Add

bind-address=::

to your mysql configuration (Normally /etc/my.cnf)

This will make it listen to all IPv4 and IPv6 interfaces

After that restart mysqld

/etc/init.d/mysqld restart

TinyTunnel_Tom

@Makenai said:
Add

bind-address=::

to your mysql configuration (Normally /etc/my.cnf)

This will make it listen to all IPv4 and IPv6 interfaces

After that restart mysqld

/etc/init.d/mysqld restart

Makenai said: bind-address=::

THANK YOU IT works now

@mpkossen do the honours of closing this for me

mpkossen

@TinyTunnel_Tom said:
mpkossen do the honours of closing this for me

Done. :-)