I was just installing MariaDB on a new machine and ran into this again
that I hit in 2014..
----- Forwarded message from Stuart Henderson <st...@openbsd.org> -----
Hmm, looks like default config is to bind to :: (v6 only) and it
inherits old mysql behaviour of not being able to bind to multiple
sockets.
I wonder if we should change config to "bind-address 0.0.0.0" (or
maybe even 127.0.0.1) in default config ...
----- End forwarded message -----
Any OKs for either this or 'bind-address = 0.0.0.0' in default config?
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/mariadb/Makefile,v
retrieving revision 1.37
diff -u -p -r1.37 Makefile
--- Makefile 28 Dec 2015 08:49:25 -0000 1.37
+++ Makefile 11 Feb 2016 20:17:37 -0000
@@ -16,6 +16,7 @@ DISTNAME= mariadb-${VERSION}
PKGNAME-main= mariadb-client-${VERSION}
PKGNAME-server= mariadb-server-${VERSION}
PKGNAME-tests= mariadb-tests-${VERSION}
+REVISION-server= 0
EPOCH= 1
CATEGORIES= databases
MASTER_SITES= http://mariadb.mirror.iweb.com//${DISTNAME}/source/ \
Index: patches/patch-support-files_my-huge_cnf_sh
===================================================================
RCS file: patches/patch-support-files_my-huge_cnf_sh
diff -N patches/patch-support-files_my-huge_cnf_sh
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ patches/patch-support-files_my-huge_cnf_sh 11 Feb 2016 20:17:37 -0000
@@ -0,0 +1,11 @@
+$OpenBSD$
+--- support-files/my-huge.cnf.sh.orig Thu Feb 11 20:15:36 2016
++++ support-files/my-huge.cnf.sh Thu Feb 11 20:16:49 2016
+@@ -27,6 +27,7 @@ socket = @MYSQL_UNIX_ADDR@
+ [mysqld]
+ port = @MYSQL_TCP_PORT@
+ socket = @MYSQL_UNIX_ADDR@
++bind-address = 127.0.0.1
+ skip-external-locking
+ key_buffer_size = 384M
+ max_allowed_packet = 1M
Index: patches/patch-support-files_my-innodb-heavy-4G_cnf_sh
===================================================================
RCS file: patches/patch-support-files_my-innodb-heavy-4G_cnf_sh
diff -N patches/patch-support-files_my-innodb-heavy-4G_cnf_sh
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ patches/patch-support-files_my-innodb-heavy-4G_cnf_sh 11 Feb 2016
20:17:37 -0000
@@ -0,0 +1,11 @@
+$OpenBSD$
+--- support-files/my-innodb-heavy-4G.cnf.sh.orig Thu Feb 11 20:15:36 2016
++++ support-files/my-innodb-heavy-4G.cnf.sh Thu Feb 11 20:16:18 2016
+@@ -46,6 +46,7 @@ socket = @MYSQL_UNIX_ADDR@
+ # generic configuration options
+ port = @MYSQL_TCP_PORT@
+ socket = @MYSQL_UNIX_ADDR@
++bind-address = 127.0.0.1
+
+ # back_log is the number of connections the operating system can keep in
+ # the listen queue, before the MariaDB connection manager thread has
Index: patches/patch-support-files_my-large_cnf_sh
===================================================================
RCS file: patches/patch-support-files_my-large_cnf_sh
diff -N patches/patch-support-files_my-large_cnf_sh
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ patches/patch-support-files_my-large_cnf_sh 11 Feb 2016 20:17:37 -0000
@@ -0,0 +1,11 @@
+$OpenBSD$
+--- support-files/my-large.cnf.sh.orig Thu Feb 11 20:15:36 2016
++++ support-files/my-large.cnf.sh Thu Feb 11 20:16:20 2016
+@@ -27,6 +27,7 @@ socket = @MYSQL_UNIX_ADDR@
+ [mysqld]
+ port = @MYSQL_TCP_PORT@
+ socket = @MYSQL_UNIX_ADDR@
++bind-address = 127.0.0.1
+ skip-external-locking
+ key_buffer_size = 256M
+ max_allowed_packet = 1M
Index: patches/patch-support-files_my-medium_cnf_sh
===================================================================
RCS file: patches/patch-support-files_my-medium_cnf_sh
diff -N patches/patch-support-files_my-medium_cnf_sh
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ patches/patch-support-files_my-medium_cnf_sh 11 Feb 2016 20:17:37
-0000
@@ -0,0 +1,11 @@
+$OpenBSD$
+--- support-files/my-medium.cnf.sh.orig Thu Feb 11 20:15:36 2016
++++ support-files/my-medium.cnf.sh Thu Feb 11 20:16:23 2016
+@@ -28,6 +28,7 @@ socket = @MYSQL_UNIX_ADDR@
+ [mysqld]
+ port = @MYSQL_TCP_PORT@
+ socket = @MYSQL_UNIX_ADDR@
++bind-address = 127.0.0.1
+ skip-external-locking
+ key_buffer_size = 16M
+ max_allowed_packet = 1M
Index: patches/patch-support-files_my-small_cnf_sh
===================================================================
RCS file: patches/patch-support-files_my-small_cnf_sh
diff -N patches/patch-support-files_my-small_cnf_sh
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ patches/patch-support-files_my-small_cnf_sh 11 Feb 2016 20:17:37 -0000
@@ -0,0 +1,11 @@
+$OpenBSD$
+--- support-files/my-small.cnf.sh.orig Thu Feb 11 20:15:36 2016
++++ support-files/my-small.cnf.sh Thu Feb 11 20:16:35 2016
+@@ -26,6 +26,7 @@ socket = @MYSQL_UNIX_ADDR@
+ [mysqld]
+ port = @MYSQL_TCP_PORT@
+ socket = @MYSQL_UNIX_ADDR@
++bind-address = 127.0.0.1
+ skip-external-locking
+ key_buffer_size = 16K
+ max_allowed_packet = 1M
