From owner-freebsd-questions@freebsd.org Fri Jan 29 15:00:59 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 2C139A7280C for ; Fri, 29 Jan 2016 15:00:59 +0000 (UTC) (envelope-from lists@schamschula.com) Received: from homiemail-a1.g.dreamhost.com (homie.mail.dreamhost.com [208.97.132.208]) by mx1.freebsd.org (Postfix) with ESMTP id 1594912E9 for ; Fri, 29 Jan 2016 15:00:58 +0000 (UTC) (envelope-from lists@schamschula.com) Received: from homiemail-a1.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a1.g.dreamhost.com (Postfix) with ESMTP id 5F7E134806F; Fri, 29 Jan 2016 07:00:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=schamschula.com; h= content-type:mime-version:subject:from:in-reply-to:date:cc :message-id:references:to; s=schamschula.com; bh=yYqoFFX6TySJe9X gmtgoOsuVh2Q=; b=VZ81EBtA3sSeAknQYzpKLxgxabVmdkVL8r3fRJXeCTkdVoh dhYnpNaCotVpJOuK1zE7lsAIa3+apD2FEkBShfk8z/t40WAZhmgTg/4XgvCRqNaA e0bwwfLTpat+P0qhsCDqC+95quGlYbP8UleLtQfmC0tIyxeFi5Vd0MQybpF8= 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-a1.g.dreamhost.com (Postfix) with ESMTPSA id 1E8D134806C; Fri, 29 Jan 2016 07:00:56 -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: <56AB7AD6.6060100@ohlste.in> Date: Fri, 29 Jan 2016 09:00:53 -0600 Cc: Matthew Seaman , freebsd-questions@freebsd.org Message-Id: <6339668B-09F1-429B-B061-E5294271F498@schamschula.com> References: <937D197D-F170-4222-A028-572692385DE6@schamschula.com> <56AB601E.2080904@infracaninophile.co.uk> <413CD012-8261-43C6-AE43-D6B8D231C2BC@schamschula.com> <56AB7AD6.6060100@ohlste.in> To: Jim Ohlstein 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 15:00:59 -0000 Jim, Great catch! Currently installing=85 Thanks! On Jan 29, 2016, at 8:44 AM, Jim Ohlstein wrote: >=20 >=20 > On 1/29/16 9:21 AM, Marius Schamschula wrote: >> Matthew, >>=20 >> Thanks. >>=20 >> On Jan 29, 2016, at 6:50 AM, Matthew Seaman = wrote: >>=20 >>> 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 >>>> 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. >>=20 >> Make sense. >>=20 >>>> 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 >>=20 >> 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 >>=20 >> # make install >> =3D=3D=3D> owncloud-8.0.4 cannot install: unknown MySQL version: 57. >> *** Error code 1 >>=20 >> Stop. >=20 > You're using an outdated ports collection as the current owncloud = version is 8.2.2. I'm guessing that's why MySQL 5.7 isn't recognized. = Try upgrading it with portsnap or svn. >=20 >=20 >>=20 >> 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. >>=20 >> 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 >>=20 >> MYSQL_DEFAULT?=3D 5.6 >>=20 >> which is exactly what I=92m trying to avoid=85 >>=20 >> I also checked the owncloud Makefile and saw nothing requiring a = specific version of mysql. >>=20 >>> (There are many other bits of software you can switch default = versions >>> in the same way) >>>=20 >>> Cheers, >>>=20 >>> Matthew >>=20 >>=20 >> TIA, >>=20 >> Marius >> -- >> Marius Schamschula >>=20 >>=20 >>=20 > --=20 > Jim Ohlstein >=20 >=20 > "Never argue with a fool, onlookers may not be able to tell the = difference." - Mark Twain Marius -- Marius Schamschula