From owner-freebsd-perl@freebsd.org Mon Apr 5 02:44: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 1BF785BEE55 for ; Mon, 5 Apr 2021 02:44:39 +0000 (UTC) (envelope-from iasen.kostov@gmail.com) Received: from mail-ed1-x531.google.com (mail-ed1-x531.google.com [IPv6:2a00:1450:4864:20::531]) (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 4FDFP20B75z4qrw for ; Mon, 5 Apr 2021 02:44:37 +0000 (UTC) (envelope-from iasen.kostov@gmail.com) Received: by mail-ed1-x531.google.com with SMTP id w18so11199296edc.0 for ; Sun, 04 Apr 2021 19:44:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language; bh=t719eDcpMfsWED7YwqiTbv2H1RlBKrzOiu6NEvGBHGQ=; b=jdyWwqKN+I81i/6xu8LbP9mhds2dOFgTqzk7JFC0coIhKr0ivbXZK+HkYGY5qk+ULQ lW89wwm5jXt/TC59acOOkaSqhl+T7RQvzcjp2j3/8tDBW1GW8cjzGFt31Z+EnwEVuU38 10f0ByBbl9UyZnFsRLrWZZMJfUXwFy6Vlf1vD19hClIdWG8Q9gjUPr3YU5Jqn4qQCY0h XLS77NetA579l8p1ohlGMga9MakgoHb+DKnp56m125sHH6Ax3+qCfXec6RFPBIToE65p mlNeBGZU4t58qjwXjE4xjfiecb9W0eRBercx/jdWmbpAEOQxSpKNH4U/COd8fUoRm/r1 02Mg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=t719eDcpMfsWED7YwqiTbv2H1RlBKrzOiu6NEvGBHGQ=; b=HOsNZypTAB6oS2vKLMclGm4MXfRXBcwcQ27pk2jiGZczQYDmRV8E/ZyshHBz6NnW9c gkK4OnDmFBUmFCsSEF5UqK8FXwXl3zexDUeVHVQdLDCnHHbMxFnlfUcZA3bqkBOJlO5h UYfICHwmj7ryiE16mt0FMNns+CYE4jqqnpjxsjtbSBKu0KqAbOIxZDJyRigkfyCJecVR KPIG6hdckTMZ2+W6y36qtUoVKPr4AmbzwfOKdqTUyMVcmpeeCrJh5AgFJVr+tRlAlasq 6OiW06FebI7t/WO/gYTw40+PDMKUZkVoGwreucTdxnc8Al/0nme+Qp966Z9uOxgY6p9F 3PGA== X-Gm-Message-State: AOAM530Iax79qfTa66oEPQxAp8aof7/1in+02B59C/qb3YThsIQugTWQ sL23tnNDHPIPaIrmxXIF/LJYE008TI5SuQ== X-Google-Smtp-Source: ABdhPJysFN+r2ZZyaUt/fuyetLOnbnBNrRwkP/EnCMxE+MOOyR6xWWq3ze3Rlyjhd4rgBQtVqXpuSw== X-Received: by 2002:a05:6402:3550:: with SMTP id f16mr28571350edd.134.1617590676600; Sun, 04 Apr 2021 19:44:36 -0700 (PDT) Received: from [10.0.0.2] (178-169-129-121.sf.ddns.bulsat.com. [178.169.129.121]) by smtp.gmail.com with ESMTPSA id gg5sm2805751ejb.93.2021.04.04.19.44.35 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 04 Apr 2021 19:44:36 -0700 (PDT) Subject: Re: FreeBSD Port: databases/p5-DBD-MariaDB To: parv/freebsd Cc: freebsd-perl@freebsd.org References: <61be7557-81de-d087-bc6a-79592b0da76d@gmail.com> From: Iasen Kostov Message-ID: <2af104fb-de58-9e47-4b0c-84f61fbec5a8@gmail.com> Date: Mon, 5 Apr 2021 05:44:37 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.9.0 MIME-Version: 1.0 In-Reply-To: Content-Language: en-US X-Rspamd-Queue-Id: 4FDFP20B75z4qrw X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=jdyWwqKN; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of iasenkostov@gmail.com designates 2a00:1450:4864:20::531 as permitted sender) smtp.mailfrom=iasenkostov@gmail.com X-Spamd-Result: default: False [-4.00 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36:c]; FREEMAIL_FROM(0.00)[gmail.com]; RCVD_COUNT_THREE(0.00)[3]; DKIM_TRACE(0.00)[gmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_HAM_SHORT(-1.00)[-0.997]; FREEMAIL_TO(0.00)[gmail.com]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; MID_RHS_MATCH_FROM(0.00)[]; TAGGED_FROM(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ARC_NA(0.00)[]; RBL_DBL_DONT_QUERY_IPS(0.00)[2a00:1450:4864:20::531:from]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; FROM_HAS_DN(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; TAGGED_RCPT(0.00)[freebsd]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-perl@freebsd.org]; SPAMHAUS_ZRD(0.00)[2a00:1450:4864:20::531:from:127.0.2.255]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::531:from]; RCVD_TLS_ALL(0.00)[]; MAILMAN_DEST(0.00)[freebsd-perl] X-Mailman-Approved-At: Mon, 05 Apr 2021 07:14:37 +0000 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 02:44:39 -0000 On 4.4.2021 г. 21:12, parv/freebsd wrote: > On Sun, Apr 4, 2021 at 5:23 AM Iasen Kostov > wrote: > > Hi Iasen, > > Please keep the mailing lists as recipients. I do not want to > engage in unsolicited private conversation. > Sorry, my mistake. > > I basically needed it for 'mytop' from MariaDB, but it turned out > mytop doesn't even work with p5-DBD-MariaDB. > > > I have not interacted with MariaDB or mytop with either driver. So I > cannot > help with usage of DBD::MariaDB. > > 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 solution to say the least :) > > > What does actually happen when "mess" happens? pkg tries to uninstall mariadb(server/client) and then install mysqlclient (and other packages) which will basically destroy the system setup. > > 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. > > Forcing people to use the ports > > > You are more than free to install Perl software via cpan or cpanm. > Who is forcing you? > Will that work on FreeBSD  ?  I never used it (never had success) in my 20+ years of using FreeBSD. I gave up probably 15 years ago. > > 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 г. 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? >> >> See ... >> >> https://github.com/gooddata/DBD-MariaDB#readme >> >