pkgs want to go to mariadb, customer does not....

Sun May 24 14:05:40 UTC 2015

On 21/05/2015 13:45, Willem Jan Withagen wrote:
> On 21/05/2015 12:41, Baptiste Daroussin wrote:
>> On Thu, May 21, 2015 at 12:21:12PM +0200, Willem Jan Withagen wrote:
>>> Hoi,
>>>
>>> In upgrading clamav I run into:
>>> pkg: mariadb53-client-5.3.12_6 conflicts with mysql-client-5.1.67 
>>> (installs files into the same place).  Problematic file: 
>>> /usr/local/bin/mysql
>>>
>>> Which I understand since it seems that nowadays the default DB of choice 
>>> is MariaDB.
>>>
>>> But since that requires a lot of required testing, I'd rather not 
>>> upgrade....
>>>
>>> Now is there any incantation in pkg, pkg.conf, <etc>
>>> to tell pkg that I'd like to stay with mysql-client?
>>>
>> That means one of your ports have switched to mariadb-client there is not yet
>> any provides/requires on mysql/mariadb so one cannot replace another without
>> rebuilding the packages.
>>
>> You will have to find our what is pulling mariadb pkg -o DEBUG_LEVEL=4 might be
>> helpful to figure out can you post it? (same upgrade command with -o
>> DEBUG_LEVEL=4)
> 
> Hi Bapt,
> 
> I was in a hurry, so I went 'portupgrade clamav' which did the job
> without any questions.... So running the debug stuff is not possible in
> the current situation. There is nothing installed that triggers:
> 	pkg info | grep maria
> Perhaps you have other "tools/tricks" to get some more info out of this?
> 
> (upgrade ecause of a security issue)
> As far as I can remember is the upgrade to clamav-0.98.7 the first to
> ask for mariadb-client, on this system.
> And it is against the std freebsd 10 packages repo.
> 
> That said, I remember to have run into other packages that would like
> mariadb stuff. But I'm not sure which ones they were, just hammered over
> it like I did now. But this is a system which has not been polluted with
> my own repo. Just ports building until I recently upgraded the system to
> 10.1, and started using pkg for ports-maintenance.

Another example where mariadb-client comes popping up.
This time in a JAIL on: FreeBSD mailserver.medusa.nl 9.3-STABLE FreeBSD
9.3-STABLE #746 r280326: Sat Mar 21 20:19:07 CET 2015
root at big.medusa.nl:/usr/obj/usr/srcs/src9/src/sys/BIG  amd64

The other problem is that I also get upgraded to perl 5.20, probably
also loosing out on postgrey and amavis that need to be
upgraded/reinstalled as well to get the p5-packages into

Running the upgrade again with -o DEBUG_LEVEL=4 does not show anything
more trouble.... but reinstalls a lot more.
I did tee it into a log-file if you are interested.

--WjW

# pkg upgrade php5
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
pkg: autoconf has a missing dependency: perl
pkg: automake has a missing dependency: perl
pkg: swatch has a missing dependency: perl
pkg: razor-agents has a missing dependency: perl
pkg: pecl-APC has a missing dependency: perl
pkg: help2man has a missing dependency: perl
pkg: intltool has a missing dependency: perl
The following 12 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
        libxcb-1.11
        libX11-1.6.2_2,1
        libXext-1.3.3,1
        libXpm-3.5.11_2
        libXt-1.1.4_2,1
        libXmu-1.1.2_2,1
        xcb-util-0.4.0,1
        xcb-util-renderutil-0.3.9
        libXrender-0.9.8_2

New packages to be INSTALLED:
        mysql51-client: 5.1.73_2
        perl5.18: 5.18.4_14

Installed packages to be UPGRADED:
        php5: 5.4.39 -> 5.4.40

The process will require 39 MiB more space.
15 MiB to be downloaded.

Proceed with this action? [y/N]: y
[mailserver.medusa.nl] Fetching php5-5.4.40.txz: 100%    1 MiB   2.0MB/s
   00:01
[mailserver.medusa.nl] Fetching mysql51-client-5.1.73_2.txz: 100%  632
KiB 647.1kB/s    00:01
[mailserver.medusa.nl] Fetching perl5.18-5.18.4_14.txz: 100%   13 MiB
13.9MB/s    00:01
Checking integrity... done (2 conflicting)
Checking integrity... done (0 conflicting)
Conflicts with the existing packages have been found.
One more solver iteration is needed to resolve them.
The following 14 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
        libXpm-3.5.11_2
        libXmu-1.1.2_2,1
        libXext-1.3.3,1
        libXt-1.1.4_2,1
        xcb-util-renderutil-0.3.9
        libXrender-0.9.8_2
        libX11-1.6.2_2,1
        xcb-util-0.4.0,1
        libxcb-1.11

New packages to be INSTALLED:
        perl5: 5.20.2_4
        mariadb53-client: 5.3.12_6
        perl5.18: 5.18.4_14

Installed packages to be UPGRADED:
        php5: 5.4.39 -> 5.4.40

The process will require 96 MiB more space.
14 MiB to be downloaded.

Proceed with this action? [y/N]: y
[mailserver.medusa.nl] Fetching perl5-5.20.2_4.txz: 100%   13 MiB
13.7MB/s    00:01
[mailserver.medusa.nl] Fetching mariadb53-client-5.3.12_6.txz: 100%    1
MiB   1.4MB/s    00:01
[mailserver.medusa.nl] [1/14] Deinstalling libXpm-3.5.11_2...
[mailserver.medusa.nl] [1/14] Deleting files for libXpm-3.5.11_2: 100%
[mailserver.medusa.nl] [2/14] Deinstalling libXmu-1.1.2_2,1...
[mailserver.medusa.nl] [2/14] Deleting files for libXmu-1.1.2_2,1: 100%
[mailserver.medusa.nl] [3/14] Deinstalling libXext-1.3.3,1...
[mailserver.medusa.nl] [3/14] Deleting files for libXext-1.3.3,1: 100%
[mailserver.medusa.nl] [4/14] Deinstalling libXt-1.1.4_2,1...
[mailserver.medusa.nl] [4/14] Deleting files for libXt-1.1.4_2,1: 100%
[mailserver.medusa.nl] [5/14] Deinstalling xcb-util-renderutil-0.3.9...
[mailserver.medusa.nl] [5/14] Deleting files for
xcb-util-renderutil-0.3.9: 100%
[mailserver.medusa.nl] [6/14] Deinstalling libXrender-0.9.8_2...
[mailserver.medusa.nl] [6/14] Deleting files for libXrender-0.9.8_2: 100%
[mailserver.medusa.nl] [7/14] Deinstalling libX11-1.6.2_2,1...
[mailserver.medusa.nl] [7/14] Deleting files for libX11-1.6.2_2,1: 100%
[mailserver.medusa.nl] [8/14] Deinstalling xcb-util-0.4.0,1...
[mailserver.medusa.nl] [8/14] Deleting files for xcb-util-0.4.0,1: 100%
[mailserver.medusa.nl] [9/14] Deinstalling libxcb-1.11...
[mailserver.medusa.nl] [9/14] Deleting files for libxcb-1.11: 100%
[mailserver.medusa.nl] [10/14] Deinstalling perl5-5.18.4_11...
[mailserver.medusa.nl] [10/14] Deleting files for perl5-5.18.4_11: 100%
rm: /usr/bin/perl: Read-only file system
[mailserver.medusa.nl] [11/14] Installing perl5-5.20.2_4...
[mailserver.medusa.nl] [11/14] Extracting perl5-5.20.2_4: 100%
[mailserver.medusa.nl] [12/14] Upgrading php5 from 5.4.39 to 5.4.40...
[mailserver.medusa.nl] [12/14] Extracting php5-5.4.40: 100%
[mailserver.medusa.nl] [13/14] Installing mariadb53-client-5.3.12_6...
pkg: mariadb53-client-5.3.12_6 conflicts with mysql-client-5.1.68
(installs files into the same place).  Problematic file:
/usr/local/bin/mysql