Enable IPv6 in MariaDB in FreeBSD jail


I'm trying to set up a MariaDB 10.2 Server on a FreeBSD 11.2 Jail.

The Server is running and accepts remote connections via IPv4 just fine. According to sockstat, it should also be listening on IPv6:

db# sockstat | grep 3306   
mysql    mysqld     17516 177 tcp46 *:3306                *:*

This is indeed what I was going for, hence my my.cnf:

db# cat my.cnf | grep -vE "^#"
port������������= 3306
socket����������= /tmp/mysql.sock

port������������= 3306
bind-address����= ::
socket����������= /tmp/mysql.sock
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K

server-id�������= 1

innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M
innodb_log_buffer_size = 16M

max_allowed_packet = 16M


key_buffer_size = 8M
sort_buffer_size = 8M


However, when I try to connect to it via IPv6, my request times out:

db# telnet db.local 3306            
Trying fd0b:9867:5eb1::3306...
telnet: connect to address fd0b:9867:5eb1::3306: Operation timed out
telnet: Unable to connect to remote host
db# telnet ::1 3306            
Trying ::1...
telnet: connect to address ::1: Operation timed out
telnet: Unable to connect to remote host

Via IPv4, it doesn't:

db# telnet 3306
Connected to db.burnus.net.
Escape character is '^]'.
5.5.5-10.2.22-MariaDB>8vmB=LG)M'zTti5g)3emysql_native_password^CConnection closed by foreign host.                                          
db# telnet 3306
Connected to localhost.
Escape character is '^]'.
5.5.5-10.2.22-MariaDB?',Jme7}$Wm@70-/FO<~mysql_native_password^CConnection closed by foreign host.

Of course, both addresses are associated with the jail's network interface:

db# ifconfig em0 | grep inet
��������inet netmask 0xffffffff broadcast  
��������inet6 fd0b:9867:5eb1::3306 prefixlen 128

There is no firewall in place.

Removing the bind-address in my.cnf or changing it to the correct IPv6 Address or the hostname does not do the trick either. Do you have any idea, what I might be doing wrong?

asked on Server Fault Mar 21, 2019 by Burnus • edited Mar 22, 2019 by Burnus

1 Answer


Solved it. Naturaly, it came down to a routing error. Everything stated obove was set up correctly, but the host redirected all traffic on port 3306 to the Jail's IPv4 address, which somehow caused the MariaDB service to not trust it anymore.

answered on Server Fault Mar 26, 2019 by Burnus

User contributions licensed under CC BY-SA 3.0