From owner-freebsd-questions@freebsd.org Fri Jan 29 12:50: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 0390EA70D44 for ; Fri, 29 Jan 2016 12:50:59 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 815451B49 for ; Fri, 29 Jan 2016 12:50:58 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from ox-dell39.ox.adestra.com (no-reverse-dns.metronet-uk.com [85.199.232.226] (may be forged)) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.2/8.15.2) with ESMTPSA id u0TCoi6K097755 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO) for ; Fri, 29 Jan 2016 12:50:51 GMT (envelope-from m.seaman@infracaninophile.co.uk) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=infracaninophile.co.uk DKIM-Filter: OpenDKIM Filter v2.10.3 smtp.infracaninophile.co.uk u0TCoi6K097755 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1454071851; bh=7nsVItmXyquhgiDkItgPwUDz78YarU5G5CpyDXg3HzM=; h=Subject:To:References:From:Date:In-Reply-To; z=Subject:=20Re:=20Installing=20owncloud=20downgrades=20mysql57|To: =20freebsd-questions@freebsd.org|References:=20<937D197D-F170-4222 -A028-572692385DE6@schamschula.com>|From:=20Matthew=20Seaman=20|Date:=20Fri,=2029=20Jan=202016=2012 :50:38=20+0000|In-Reply-To:=20<937D197D-F170-4222-A028-572692385DE 6@schamschula.com>; b=EiG9HfmFqQMX+zTU2jCqk5eGCXixdDgpq/TNt7TE+WCLqgnF8B11oVM3c8b42myg2 sZ+hd09K2Zq5wX2GFK7jd8VNGdcAjg+MBI/6uAzdFsoTaxz9LcocNSuIJGBCzyrtkg Ylh6Arx3Or/oa8/bw141hYok0Wy+qOCgBKZp5l80= X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host no-reverse-dns.metronet-uk.com [85.199.232.226] (may be forged) claimed to be ox-dell39.ox.adestra.com Subject: Re: Installing owncloud downgrades mysql57 To: freebsd-questions@freebsd.org References: <937D197D-F170-4222-A028-572692385DE6@schamschula.com> From: Matthew Seaman X-Enigmail-Draft-Status: N1110 Message-ID: <56AB601E.2080904@infracaninophile.co.uk> Date: Fri, 29 Jan 2016 12:50:38 +0000 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:38.0) Gecko/20100101 Thunderbird/38.5.0 MIME-Version: 1.0 In-Reply-To: <937D197D-F170-4222-A028-572692385DE6@schamschula.com> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4PSUKJ8A0o9PFt77nqOpJH73fHtwGW523" X-Virus-Scanned: clamav-milter 0.99 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-1.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lucid-nonsense.infracaninophile.co.uk 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 12:50:59 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --4PSUKJ8A0o9PFt77nqOpJH73fHtwGW523 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 01/29/16 12:14, Marius Schamschula wrote: > I=E2=80=99m new to FreeBSD, but rather familiar to *NIX OSs (20 years o= f > 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 f= ind >=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=E2=80=99m 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. 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. > 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=E2=80=99d 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). 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. 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. 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: https://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports.html To prefer ports to build and link against mysql57, add this to the DEFAULT_VERSIONS variable in /etc/make.conf: DEFAULT_VERSIONS+=3D mysql=3D5.7 (There are many other bits of software you can switch default versions in the same way) Cheers, Matthew --4PSUKJ8A0o9PFt77nqOpJH73fHtwGW523 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIcBAEBCgAGBQJWq2AjAAoJEABRPxDgqeTnkcMP/0F3VL22l3gu1Xsi3V0LaYm3 8FVQDZ04O8RsWYUC7KULU7TLzpnSlHHd0cfaBrSqx8MHUG1Y8u3045RX2a6DOGxZ hZNyLIr8pt+53qXUHiWwDGodH3B/8tSKJD4kEhxtoBopXBQKGJ5dA9HFOxflhFwa aKF01VsO0DfMt8Er+9CocE6x6EDxcltujqG9mC4vX8mPz4w8renetqRTLM4bdceS uidjU18CP6OKcrz+j8G4IVi+D91E7beyIjD7doQGLlub+1EiEQBTD9YH29K2mfZv uFuIXjsVw6jegwlHwcTeyoU7U9x/HvuqutesdkNehXIr9j83sFlQwKuPP3LZRFH5 TZdrvt7qnrosAQyN1WMzvVYfInlguJ8Ns+6WmgQNFH07b4j8cF1zpe2V0QKWgFvW vy03U2SvZFesW2chTGK3nKI5mORvd8HhQADQMnt5CfZakxDiCQgvTHtk9lqPksHs 3soqZC9ktN3PESx9yzxlzKk89k/w2jYiqosb59U2KddRuIpcRcjz7XLe1Ja5hbHT sHoOi9TT5Xr10KKCsYVnsLEcChLWgaw3RMyum7GVDTzkBfqokPMzo5uEcAjV7w6D mLoLWDN9+UK6mU45d/AowJML1YqloewnzZ/AaN0IWjBqb0jHT+xBC7rc9kSdOk4+ eSnpprYiIKwyJrmPVbdw =KQJK -----END PGP SIGNATURE----- --4PSUKJ8A0o9PFt77nqOpJH73fHtwGW523--