(e-mailing ports@ since my previous private reply seems to have
been ignored)

On Fri, 22 Mar 2013 at 21:55:07 -0400, Brad Smith wrote:
> Here is the port and a diff to adjust the tree to move over to
> MariaDB. The only port I haven't touched is xmysql as it doesn't
> build with newer MariaDB or MySQL. It's old unmaintained cruft
> and I'm planning on removing it.
> 
> http://comstyle.com/ports/mariadb/
> 
> If you're a MySQL user or have expressed interest in MariaDB
> please test and provide any feedback regarding testing and/or
> the port.

I'm running with this on amd64 as a drop-in replacement for a
previous mysqld installation with a few databases.

One issue with the port is that its MASTER_SITES is only one host in
.ie.  You should probably add at least the one US mirror:

MASTER_SITES=   
http://ftp.osuosl.org/pub/mariadb/${DISTNAME}/kvm-tarbake-jaunty-x86/ \
                
http://ftp.heanet.ie/mirrors/mariadb/${DISTNAME}/kvm-tarbake-jaunty-x86/

As far as a drop-in replacement for the old MySQL goes, I
uninstalled mysql-server-5.1.68 and installed mariadb-server.  It
started up fine, but in the logs it complained that I needed to run
mysql_upgrade, which I did and seemed to go fine.  That should
probably be in an INSTALL message for those migrating.

Next, mysqld only listened on IPv6, with the default my.cnf
installed from mariadb:

$> netstat -an | grep 3306
tcp6         0      0  *.3306                 *.*                    LISTEN

That seems broken.  My stuff is configured to connect to
127.0.0.1:3306 which was reachable on the previous default for
mysql-server:

$> netstat -an | grep 3306
tcp          0      0  *.3306                 *.*                    LISTEN

If I manually specify "bind-address = 127.0.0.1" in my.cnf, it
works, but the default should probably be inet, if not both inet and
inet6.

Reply via email to