From owner-freebsd-questions@freebsd.org Fri Jan 29 14:21:29 2016 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 77AA3A72C18 for ; Fri, 29 Jan 2016 14:21:29 +0000 (UTC) (envelope-from lists@schamschula.com) Received: from homiemail-a99.g.dreamhost.com (homie.mail.dreamhost.com [208.97.132.208]) by mx1.freebsd.org (Postfix) with ESMTP id 64EAB129C for ; Fri, 29 Jan 2016 14:21:28 +0000 (UTC) (envelope-from lists@schamschula.com) Received: from homiemail-a99.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a99.g.dreamhost.com (Postfix) with ESMTP id 10B61FB0072; Fri, 29 Jan 2016 06:21:28 -0800 (PST) Received: from [10.0.1.75] (173-26-108-176.client.mchsi.com [173.26.108.176]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: lists@schamschula.com) by homiemail-a99.g.dreamhost.com (Postfix) with ESMTPSA id 1955BFB0071; Fri, 29 Jan 2016 06:21:26 -0800 (PST) Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\)) Subject: Re: Installing owncloud downgrades mysql57 From: Marius Schamschula In-Reply-To: <56AB601E.2080904@infracaninophile.co.uk> Date: Fri, 29 Jan 2016 08:21:18 -0600 Cc: freebsd-questions@freebsd.org Message-Id: <413CD012-8261-43C6-AE43-D6B8D231C2BC@schamschula.com> References: <937D197D-F170-4222-A028-572692385DE6@schamschula.com> <56AB601E.2080904@infracaninophile.co.uk> To: Matthew Seaman X-Mailer: Apple Mail (2.1878.6) Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.20 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 29 Jan 2016 14:21:29 -0000 Matthew, Thanks.=20 On Jan 29, 2016, at 6:50 AM, Matthew Seaman = wrote: > On 01/29/16 12:14, Marius Schamschula wrote: >> I=92m new to FreeBSD, but rather familiar to *NIX OSs (20 years of >> various flavors of Linux, IRIX and (Mac) OS X/Darwin). >>=20 >> I'm attempting to install owncloud-8.2.2 under FreeBSD 10.2.> >> I previously have installed mysql57 client and server. To my dismay I = find >>=20 >> Installed packages to be REMOVED: >> mysql57-server-5.7.10_1 >> mysql57-client-5.7.10_1 >>=20 >> to be replaced by=20 >> mysql56-client: 5.6.27 >>=20 >> No mention no replacement of mysql56-server. I=92m not sure how >> owncloud is expected to work w/o a working mysql-server. Never mind >> that there may be backward incompatible changes between mysql56 and >> mysql57. >=20 > That's one of those things: mysql57-client was removed because it > conflicts with mysql56-client, and then mysql57-server was removed > because it depends on mysql57-client. However, once that happens, > there's nothing that depends on mysql56-server to bring it in: your > owncloud application only depends on mysqlXX-client -- which makes = sens > if you think about it: your mysql server could be on an entirely > different machine and then you'ld be annoyed if you were forced to > install mysqlXX-server where it wasn't needed. Make sense. >> It is somewhat unclear to me where in the dependency tree >> mysql56-client: 5.6.27 is specified, i.e. if owncloud or one of its >> dependencies makes this request. >>=20 >> I suppose I could do a mysqldump, and restore into mysql56-server, >> but I really want to be using the current stable branch (as defined >> upstream). >>=20 >> Is there any way to specify which version of mysql to use, i.e. a >> variant? Under MacPorts I=92d use something like >>=20 >> port install owncloud +mysql57 >>=20 >> (if there were such a package - the case insensitive files system >> precludes installing owncloud under OS X). >=20 > This is a well known limitation of binary packages under FreeBSD at = the > moment. Dependencies on exact versions of packages are baked in, = which > means it is particularly hard to use alternate versions of software > systems like python or php or perl and the system provided packages. >=20 > Mysql as a case in point is always going to be harder to substitute in > because here the specific dependency is required because of the > libmysql.so ABI version. >=20 > However, the answer here is to compile your own packages -- = effectively > the same as what you're doing with MacPorts. To do that, look at this > section in the Handbook: >=20 > https://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports.html >=20 > To prefer ports to build and link against mysql57, add this to the > DEFAULT_VERSIONS variable in /etc/make.conf: >=20 > DEFAULT_VERSIONS+=3D mysql=3D5.7 Unfortunately, this didn=92t work for me. After creating (copying from = share/examples) /etc/make.conf and adding DEFAULT_VERSIONS+=3D = mysql=3D5.7 to the file, I cded to /usr/ports/www/owncloud and ran # make install =3D=3D=3D> owncloud-8.0.4 cannot install: unknown MySQL version: 57. *** Error code 1 Stop. This is strange, as mysql57-* are still installed. I then commented out = the DEFAULT_VERSIONS line in /etc/make.conf and got the same result. Is there a master list of the allowed versions of mysql, etc.? A quick = search did not come up with anything other than = https://wiki.freebsd.org/DEFAULT_VERSIONS and Mk/bsd.default-versions.mk = which has MYSQL_DEFAULT?=3D 5.6 which is exactly what I=92m trying to avoid=85 I also checked the owncloud Makefile and saw nothing requiring a = specific version of mysql. > (There are many other bits of software you can switch default versions > in the same way) >=20 > Cheers, >=20 > Matthew TIA, Marius -- Marius Schamschula