From owner-freebsd-perl@freebsd.org Mon Apr 5 03:56:39 2021 Return-Path: Delivered-To: freebsd-perl@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id B59285C05E5 for ; Mon, 5 Apr 2021 03:56:39 +0000 (UTC) (envelope-from parv.0zero9@gmail.com) Received: from mail-wm1-x332.google.com (mail-wm1-x332.google.com [IPv6:2a00:1450:4864:20::332]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4FDH066wJsz4v3y for ; Mon, 5 Apr 2021 03:56:38 +0000 (UTC) (envelope-from parv.0zero9@gmail.com) Received: by mail-wm1-x332.google.com with SMTP id g18-20020a7bc4d20000b0290116042cfdd8so1899820wmk.4 for ; Sun, 04 Apr 2021 20:56:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=S1u6doKi/yMoCcsexYibRAyxKepgGPNzov/Ab2FQeF8=; b=DgZj4U9rZw7EbDfarGUmFtJnCLna26k/DTHItBUkHmMuv9bxCFLO2Q3NoO1UArWiWC p8RZWkcGWN8L2gePn8xxmghProOABC/mZaZTvhD8Qxt1XC+hfM5e5CM6INbc0RWsxqvA bKOFh5dfHbzLvyCCbHse7DDrtU7cpn+XCDN5Tw6UnVVmT6zFc5aYPjhQJ6W5zmMtWlQJ s7spk0PhAOwcJf12UIlYjgqrzCFbYE7rGpfYFyb0cdmcwKJrY6fcRhg18B26CvKmSMp/ WrcUUBgJQ1uu41HyW2azY0uqE4a0XJSIvj+KUKAeG0MbC3hH13zg363UagcfrchDfHuF VNCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=S1u6doKi/yMoCcsexYibRAyxKepgGPNzov/Ab2FQeF8=; b=ta1DvxaiewNM9jC46zypkYf0u6M3UoPJEJdF+CYTTehaZZqjQy+Be/desDmrKu/sQw KraZHs36Jt/UH8ISCGjmuu2WBQgHQnv6F9C5w+1kVmOtCy/+nNGdFiRieKUIk4i2z0QW 3ASWhrTXUmrBuKmRqz3a5toLyabhPtsQAOKQtsrunxn+0hNefpHydkdE1B/e1o4JI71h BeRnuBeAqpOG6fmKA6FLyPZ9DqYsXaImBTMFJCXbfkHKlF9jRdujrdo1PlEGiAyq2N3H AtWONNHqXlXK6/g/rRRy3RL3y/WxU5cv8zGPknSZ2lf++4lR/786xOXLUMWs3Hg44Blm eWLA== X-Gm-Message-State: AOAM531VlXtIkpiLGHN/d/ZTc/+FZDZ4l8R+wyuhqHEl7VaRhN6jNtfK hwDbrCzXWnsNCoQAEvREsj8/EZwcci4HfUyCLgA= X-Google-Smtp-Source: ABdhPJyJjL0b4dqDCMnhE+jBxz81yFmjTn8uMF4NrFr5jqDhCtI0ZOvyqW6x6ucrN6GkLPlvaGIoajBEGUxIoIR9ze4= X-Received: by 2002:a1c:2541:: with SMTP id l62mr8887497wml.188.1617594996681; Sun, 04 Apr 2021 20:56:36 -0700 (PDT) MIME-Version: 1.0 References: <61be7557-81de-d087-bc6a-79592b0da76d@gmail.com> <2af104fb-de58-9e47-4b0c-84f61fbec5a8@gmail.com> In-Reply-To: <2af104fb-de58-9e47-4b0c-84f61fbec5a8@gmail.com> From: "parv/freebsd" Date: Sun, 4 Apr 2021 17:55:25 -1000 Message-ID: Subject: Re: FreeBSD Port: databases/p5-DBD-MariaDB To: Iasen Kostov Cc: freebsd-perl@freebsd.org X-Rspamd-Queue-Id: 4FDH066wJsz4v3y X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=DgZj4U9r; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of parv0zero9@gmail.com designates 2a00:1450:4864:20::332 as permitted sender) smtp.mailfrom=parv0zero9@gmail.com X-Spamd-Result: default: False [-3.95 / 15.00]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36:c]; FREEMAIL_FROM(0.00)[gmail.com]; DKIM_TRACE(0.00)[gmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_HAM_SHORT(-0.95)[-0.952]; FREEMAIL_TO(0.00)[gmail.com]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RBL_DBL_DONT_QUERY_IPS(0.00)[2a00:1450:4864:20::332:from]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[freebsd]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; FROM_HAS_DN(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; TAGGED_RCPT(0.00)[]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-perl@freebsd.org]; SPAMHAUS_ZRD(0.00)[2a00:1450:4864:20::332:from:127.0.2.255]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::332:from]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[]; MAILMAN_DEST(0.00)[freebsd-perl] Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.34 X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 05 Apr 2021 03:56:39 -0000 On Sun, Apr 4, 2021 at 4:44 PM Iasen Kostov wrote: Hi Iasen, On 4.4.2021 =D0=B3. 21:12, parv/freebsd wrote: > > On Sun, Apr 4, 2021 at 5:23 AM Iasen Kostov wrote: > > ... > So I had to install p5-DBD-mysql from ports with mariadb client installed >> beforehand. But then when I do 'pkg upgrade' of course a mess ensues. I >> had to remove the packcage from the database by hand which is ugly solut= ion >> to say the least :) >> > > What does actually happen when "mess" happens? > > pkg tries to uninstall mariadb(server/client) and then install mysqlclien= t > (and other packages) which will basically destroy the system setup. > Ok. In that case you could lock a package & various pkg commands would not touch it... % pkg lock ... note that that will also affect the dependent packages. To upgrade or delete later, you can run ... % pkg unlock ... and upgrade or delete as you usually do. So my actual question is how to make 'mytop' (and other similar things) >> from MariaDB work ? >> One way is to just have "p5-DBD-mysql-mysql" and "p5-DBD-mysql-mariadb" = - >> but that looks a 'bit' ugly too. >> > I have no idea what are you referring to with "p5-DBD-mysql-mysql" > & "p5-DBD-mysql-mariadb". > > The names of new packages which can be complied with dependency to mysql > and mariadb so the people wont have to resort to ports. > Thank you for the explanation. - parv ... > > and only the ports is not feasible with small systems like RaspberyPI or >> older / low power systems and will lead to "but in Linux ..." so it is = not >> a solution either. >> >> What would be the best and least ugliest way to make it work ? >> > On 3.4.2021 =D0=B3. 12:19, parv/freebsd wrote: >> >> On Fri, Apr 2, 2021 at 9:58 PM Iasen Kostov wrote: >> >>> I wonder why does the package depends on mysqlclient and not on >>> mariadb ? >> >> >> Yes, should have switched to depend on MariaDB. >> >> That package seems to be useless because it is the same as >>> databases/p5-DBD-mysql. Am I missing something ? >>> >> >> How much do you care for Unicode support & security bug fixes? >> >> ... > https://github.com/gooddata/DBD-MariaDB#readme >> >>