From owner-freebsd-questions@freebsd.org Fri Jan 29 14:44:42 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 880ADA722C0 for ; Fri, 29 Jan 2016 14:44:42 +0000 (UTC) (envelope-from jim@ohlste.in) Received: from mail-qk0-x235.google.com (mail-qk0-x235.google.com [IPv6:2607:f8b0:400d:c09::235]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4A7C81D14 for ; Fri, 29 Jan 2016 14:44:41 +0000 (UTC) (envelope-from jim@ohlste.in) Received: by mail-qk0-x235.google.com with SMTP id s68so24832709qkh.3 for ; Fri, 29 Jan 2016 06:44:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ohlste-in.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-type:content-transfer-encoding; bh=tFcCMNz4u107lpISXqS90bNeMtAHv/v6dnuXtVTWqL8=; b=1Wh200uXP1bH6FoQDc77Lf7UFkTViXt5d2azvdMw9iHilEeYgf+IXw3pp4sdnNRt8h vip7S8NDb79QqNdmsD914X5EK9lr8URIrOWvU9qUpAq6+v4kUD4iwuS5lR+HRKnJe4sf jUPw8tWfSMCnK60zTShCLtF5KibRLpqHV3Ny73CHmtQNebH2Ig1zBWSc2kDPUGewpjut UfNlxUvhUZpr724vXwvNG+b9UbJBffqHMYzaiDOVXIh2LtkYmKgLE9TkThWy32yt+P4+ R/a2hCK4+YTITOVE9/2CXOJQj4EnpHlyvoDq2DpSu3H+vbbHLhgjO8Cj7gr/Y0V3M4xJ FLqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-type :content-transfer-encoding; bh=tFcCMNz4u107lpISXqS90bNeMtAHv/v6dnuXtVTWqL8=; b=bkX1WQuFFoiLBLw7y5SSpr0FA90nMUswcgRM/YfBQifB490/MOw+KF2GJpy4PVkqXJ 7CEZE8iCYAKWCU5Ofe+ezRDYBfcv0BUSecxxWliI3vRk6m33c2ExaSxE836e6VEU5uom poRxl4Flk8EaQqvM0VpJt/9nLAXTtcLhMs/LjgD9cfwc+aUdH8CZmuqzsoeLTWF31dXe GfLnfXvnMYwdI5kM3Lf17AJ1Q/q7VGQfc78K++fc3dlJqFJlI4ts8urmmhKWqiIMepAi v0B2IMY04xoVV3gax4NBmIAq0z6o3iU8MYSH3FVm9uae5Vs0GouM8FQWcTKse10faquj X2Ww== X-Gm-Message-State: AG10YOR2ehQp+SXzj8mclxACNdzBa6BMInoL9tR1zWcWa67ctnMjuP7NAir9Fwk/bZQv4A== X-Received: by 10.55.23.9 with SMTP id i9mr11172251qkh.7.1454078680867; Fri, 29 Jan 2016 06:44:40 -0800 (PST) Received: from [192.168.1.18] (pool-96-249-243-37.nrflva.fios.verizon.net. [96.249.243.37]) by smtp.googlemail.com with ESMTPSA id v187sm6745372qhb.27.2016.01.29.06.44.39 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 29 Jan 2016 06:44:40 -0800 (PST) Subject: Re: Installing owncloud downgrades mysql57 To: Marius Schamschula , Matthew Seaman References: <937D197D-F170-4222-A028-572692385DE6@schamschula.com> <56AB601E.2080904@infracaninophile.co.uk> <413CD012-8261-43C6-AE43-D6B8D231C2BC@schamschula.com> Cc: freebsd-questions@freebsd.org From: Jim Ohlstein Message-ID: <56AB7AD6.6060100@ohlste.in> Date: Fri, 29 Jan 2016 09:44:38 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: <413CD012-8261-43C6-AE43-D6B8D231C2BC@schamschula.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit 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:44:42 -0000 On 1/29/16 9:21 AM, Marius Schamschula wrote: > Matthew, > > Thanks. > > On Jan 29, 2016, at 6:50 AM, Matthew Seaman wrote: > >> On 01/29/16 12:14, Marius Schamschula wrote: >>> I’m new to FreeBSD, but rather familiar to *NIX OSs (20 years of >>> various flavors of Linux, IRIX and (Mac) OS X/Darwin). >>> >>> 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 >>> >>> Installed packages to be REMOVED: >>> mysql57-server-5.7.10_1 >>> mysql57-client-5.7.10_1 >>> >>> to be replaced by >>> mysql56-client: 5.6.27 >>> >>> No mention no replacement of mysql56-server. I’m 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. > > 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. >>> >>> 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). >>> >>> Is there any way to specify which version of mysql to use, i.e. a >>> variant? Under MacPorts I’d use something like >>> >>> port install owncloud +mysql57 >>> >>> (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+= mysql=5.7 > > Unfortunately, this didn’t work for me. After creating (copying from share/examples) /etc/make.conf and adding DEFAULT_VERSIONS+= mysql=5.7 to the file, I cded to /usr/ports/www/owncloud and ran > > # make install > ===> owncloud-8.0.4 cannot install: unknown MySQL version: 57. > *** Error code 1 > > Stop. 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. > > 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?= 5.6 > > which is exactly what I’m trying to avoid… > > 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) >> >> Cheers, >> >> Matthew > > > TIA, > > Marius > -- > Marius Schamschula > > > -- Jim Ohlstein "Never argue with a fool, onlookers may not be able to tell the difference." - Mark Twain