Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links


Shells Virtual Desktop
BMail.ag - Secure Email Service
Server.net
CPLicense.net
VPS Server
Buy VPN
Vultr
VMs for AI
HostDare
HostDare
ReliableSite White-Label Dedicated Hosting for Resellers
InterServer VPS
BMail.ag - Secure Email Service
Best VPN
High-Performance Bare Metal Server Solutions
Karvl.com
Server Mania Cloud Hosting
DataWagon Hosting
AlphaVPS Hosting
Evoxt.com
Clouvider
VPS Hosting with NVMe
Residential IPs in the US & 4G Mobile Proxies in EU & US with Unlimited Bandwidth
ReliableSite White-Label Dedicated Hosting for Resellers
Rabisu - Hosting Solutions
Shells Virtual Desktop

Categories

In this Discussion

Home › Help
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

MySQL over IPv6??

TinyTunnel_TomTinyTunnel_Tom Member
in Help

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

Comments

  • HassanHassan Member, Patron Provider

    I laughed way too hard at this post

  • TinyTunnel_TomTinyTunnel_Tom Member

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

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

  • desperanddesperand Member

    very interesting. Looking for information too.

  • WilliamWilliam Member

    That should help:

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

  • TinyTunnel_TomTinyTunnel_Tom Member

    All that is in order @William

    Tried telnetting and got a connection refused

  • msg7086msg7086 Member

    MySQL works with IPv6. Check your firewall / iptables?

    Also try VPN over IPv6.

  • TinyTunnel_TomTinyTunnel_Tom Member

    @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

  • wychwych Member
    edited January 2015

    @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_TomTinyTunnel_Tom Member
    edited January 2015 
    root@sql1:~# service ip6tables stop
ip6tables: unrecognized service
root@sql1:~#

    @wych

  • wychwych Member

    @TinyTunnel_Tom said:

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

    wych

    What Distro?

  • TinyTunnel_TomTinyTunnel_Tom Member

    @wych said:
    What Distro?

    Debian7

  • wychwych Member

    @TinyTunnel_Tom said:
    Debian7

    Does

    ip6tables -vL

    show anything?

    Try

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

    ...

  • TinyTunnel_TomTinyTunnel_Tom Member

    @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_TomTinyTunnel_Tom Member

    Anyone else?

  • MakenaiMakenai Member
    edited January 2015

    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_TomTinyTunnel_Tom Member

    @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#
  • MakenaiMakenai Member
    edited January 2015

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

  • TinyTunnel_TomTinyTunnel_Tom Member

    @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

  • MakenaiMakenai Member
    edited January 2015

    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_TomTinyTunnel_Tom Member

    @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 :D IT works now :D

    @mpkossen do the honours of closing this for me :)

  • mpkossenmpkossen Member

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

    Done. :-)

    Thanked by 1TinyTunnel_Tom
This discussion has been closed.