From owner-freebsd-ports@freebsd.org Wed Apr 19 11:45:59 2017 Return-Path: Delivered-To: freebsd-ports@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 AD2C7D3C54B for ; Wed, 19 Apr 2017 11:45:59 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 98ACD2B for ; Wed, 19 Apr 2017 11:45:59 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: by mailman.ysv.freebsd.org (Postfix) id 951D6D3C547; Wed, 19 Apr 2017 11:45:59 +0000 (UTC) Delivered-To: ports@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 94C17D3C546 for ; Wed, 19 Apr 2017 11:45:59 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 5A31D29 for ; Wed, 19 Apr 2017 11:45:58 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id C5ED028436; Wed, 19 Apr 2017 13:45:55 +0200 (CEST) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id D2B5D2842B; Wed, 19 Apr 2017 13:45:54 +0200 (CEST) Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files To: scratch65535@att.net Cc: freebsd-ports References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <58F74DF2.4000208@quip.cz> Date: Wed, 19 Apr 2017 13:45:54 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 Apr 2017 11:45:59 -0000 scratch65535@att.net wrote on 2017/04/19 12:45: > [Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman > <000.fbsd@quip.cz> wrote: > >> Miroslav Lachman wrote on 2017/03/31 15:31: >>> I don't know if it was "pkg" fault or mariadb101-server and >>> mariadb101-client conflict. >>> >>> I did standard "pkg upgrade" and at the end I have half files of >>> mariadb101-client missing: >>> >>> # pkg check -Ba >>> Checking all packages: ... >>> pkg: fstat() failed for(/usr/local/bin/msql2mysql): No such file or >>> directory >>> pkg: fstat() failed for(/usr/local/bin/mysql_find_rows): No such file or >>> directory [...] >>> pkg: fstat() failed for(/usr/local/man/man1/mysqlimport.1.gz): No such >>> file or directory >>> pkg: fstat() failed for(/usr/local/man/man1/mysqlshow.1.gz): No such >>> file or directory >>> pkg: fstat() failed for(/usr/local/man/man1/mysqlslap.1.gz): No such >>> file or directory >>> Checking all packages.......... done >>> >>> >>> I think this is the root cause >>> >>> Checking integrity... done (2 conflicting) >>> - mariadb101-server-10.1.22 conflicts with mariadb101-client-10.1.21 >>> on /usr/local/share/mysql/maria_add_gis_sp.sql [...] > > I couldn't tell you whether you're the only one (probably not!) > but I did a pkg upgrade on everything yesterday to recover from > pkg's quarterly version skew, and mariadb *seems* to be all there > and working correctly. I haven't done any work yet this morning, > so I'm keeping my fingers crossed. Do you use MariaDB version 10.1? MariaDB server is running without problems, only some "mysql client" libraries are missing, but if you use only PHP to connect to "mysql server" then you will not notice any problem, because PHP uses internal mysql client. So first time I overlooked this issue because MariaDB was running fine and webserver was on separate machine - PHP website was still running. Can you check this? ls -l /usr/local/lib/mysql/libmysqlclient_r.so.18 I see "ls: /usr/local/lib/mysql/libmysqlclient_r.so.18: No such file or directory" on each upgraded server until i run *pkg upgrade -f mariadb101-client* Miroslav Lachman