DKIM-Filter: OpenDKIM Filter v2.11.0 delorie.com 46RDZ7N6867982
Authentication-Results: delorie.com;
	dkim=pass (1024-bit key, unprotected) header.d=cygwin.com header.i=@cygwin.com header.a=rsa-sha256 header.s=default header.b=fRt/BV2T
X-Recipient: archive-cygwin AT delorie DOT com
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org 77A5A3858C32
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
	s=default; t=1722087305;
	bh=3DD1ksTScxGJYz/lZ3ehM0ZzIJLlhixJ+kzDFCVAWvk=;
	h=References:In-Reply-To:Date:Subject:To:Cc:List-Id:
	 List-Unsubscribe:List-Archive:List-Post:List-Help:List-Subscribe:
	 From:Reply-To:From;
	b=fRt/BV2TS4bkMTR/e/EB8YhpqTVgseRELH/9KYs4+rgy5Yma8KIwNcVOb00IQnyXF
	 ETxcosQX/86Om16p+1U7DNA1z+PPS8pHMYjIkRzAqXktkRLNmKFnQyUiH8GVJ6A3yf
	 zl/1C/vModwCBll6iDgVqg0UVVL0ObNKYP3wwsE4=
X-Original-To: cygwin AT cygwin DOT com
Delivered-To: cygwin AT cygwin DOT com
DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 26FB23858D34
ARC-Filter: OpenARC Filter v1.0.0 sourceware.org 26FB23858D34
ARC-Seal: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1722087278; cv=none;
 b=PQ7Y/FGzKjfqjMxgZQGwduTMrXprPzmcpf4g/u0OSPGw1D/xclSWefZQEu7L22Vg/ckiR9g/jHiE77b6QkIL8cd+mR0gNNyeFOPdj2wQv9qXJ+Cj8C+D5fkNnvOq7jZx5hO0pcsEzkIrqeBQl4FVq2y8CzIXsXGm5rDSIvg7NWQ=
ARC-Message-Signature: i=1; a=rsa-sha256; d=sourceware.org; s=key;
 t=1722087278; c=relaxed/simple;
 bh=eiCNPtPcues9Y0gc7fsKW7Fufwyb4yJ6km6mmG2QoNM=;
 h=DKIM-Signature:MIME-Version:From:Date:Message-ID:Subject:To;
 b=ry9rB+aqeKtxEevYTHkZhQmDOe7KHcxYrbzcXSgybuATXhkF0g3gvoPgwvO2xOpG7rOUM9Cl0X8IpyYCsX0zQd1oPDxeRTTT4H8EQ35IVgrJNyJAI5K80W0vSvgukOaLm73hKZh7UMV5BfxRLXMk8rtrplo25R8xNoiaSJYTYf4=
ARC-Authentication-Results: i=1; server2.sourceware.org
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20230601; t=1722087274; x=1722692074;
 h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references
 :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
 :reply-to;
 bh=Vka23p3BM1JH1GkZUi6JLxBaXOFU2YVTH1lMN6qGq5o=;
 b=A6jIF/hZFS0fzPFQhY+fhPMRIljyAzPZejGgvexl/Oh4Nx42Glv5c2aQJ3yk8lveXM
 tDG+zp9zySe4uWxt/E94CWDtW357pjHoYi3j89akHQ8wd5ep8qQruFYaHU1WI76W/6zT
 w8YYYhhYLYxPi8U4kSQWMs3AmstwnqJdLKqnC7M99o6i1s/l5QCBM1QLptUxdU5MONr7
 25o28WiKcTJtYFDeoB76u7ehUMTEelkfgSJiMSoMZoGNUMsMGkTus2xmxvJe4BGL9kSY
 7jggCsyGtzbAVpdSzLdoGOL8777qfQPP650AeEab3Oh2SNa+dZLRIW+xrTLsuPbWrnza
 2+KA==
X-Gm-Message-State: AOJu0Yw3nS75KB39B3w/lTmtxhoJiNt0sW9Kzz5J9DnUtNpo7VW5MR9s
 CAsxubJdwC+87vh/mej/iU2OJJ3Tao/zodLp9kvoimh8hF6OFwr9zUdyz+hsgPDT8CFJJuxWhr6
 xQn5ZKC6chdMPfMbg8yhCBCpctG3zyRAe
X-Google-Smtp-Source: AGHT+IFTx5VcTN2WPkfcHs0o3nxILBMsfJ1O6EwuilTZftAR7jybcgxTRfN2E2K33ucxlgJA1DuOqnlbfIuL1OfGCn8=
X-Received: by 2002:a05:6102:3e95:b0:48f:ebf2:14d6 with SMTP id
 ada2fe7eead31-493fa2eaf39mr3561863137.6.1722087274214; Sat, 27 Jul 2024
 06:34:34 -0700 (PDT)
MIME-Version: 1.0
References: <CAOoeT7PUKVhXKkFU7nqv5rNBg-vu2g9rXp+tQoUgf++d4AsWDA AT mail DOT gmail DOT com>
 <8734nvcorf DOT fsf AT Gerda DOT invalid>
In-Reply-To: <8734nvcorf.fsf@Gerda.invalid>
Date: Sat, 27 Jul 2024 09:33:59 -0400
Message-ID: <CAOoeT7MZxhE5uT49n6KSyVgJgXa-GSoKUur1hLWAo==RpH7G_A@mail.gmail.com>
Subject: Re: DBD::mysql not reading host from config file
To: ASSI <Stromeko AT nexgo DOT de>
Cc: cygwin AT cygwin DOT com
X-Spam-Status: No, score=-0.8 required=5.0 tests=BAYES_00, DKIM_SIGNED,
 DKIM_VALID, DKIM_VALID_AU, DKIM_VALID_EF, FREEMAIL_FROM, HTML_MESSAGE,
 RCVD_IN_DNSWL_NONE, SPF_HELO_NONE, SPF_PASS,
 TXREP autolearn=ham autolearn_force=no version=3.4.6
X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on
 server2.sourceware.org
X-Content-Filtered-By: Mailman/MimeDel 2.1.30
X-BeenThere: cygwin AT cygwin DOT com
X-Mailman-Version: 2.1.30
List-Id: General Cygwin discussions and problem reports <cygwin.cygwin.com>
List-Archive: <https://cygwin.com/pipermail/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-request AT cygwin DOT com?subject=help>
List-Subscribe: <https://cygwin.com/mailman/listinfo/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=subscribe>
From: Danny Rice via Cygwin <cygwin AT cygwin DOT com>
Reply-To: danny DOT w DOT rice AT gmail DOT com
Content-Type: text/plain; charset="utf-8"
Sender: "Cygwin" <cygwin-bounces~archive-cygwin=delorie DOT com AT cygwin DOT com>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from base64 to 8bit by delorie.com id 46RDZ7N6867982

>
> it's more likely that the DB itself is the culprit

In what way do you mean? As mentioned, it reads all the option data from
the config file (except host) and connects without issue as long as you
supply host in the dsn. The cygwin command line mysql command reads all the
options, including host, from the config file. The database tested on both
cygwin and linux was the same database. I also did the same tests on two
completely independent hosts/databases.


> examples of this sort of DSN I've seen reverse the two keys

This doesn't change anything.


> versions available in Cygwin, which are almost certainly older than the
> ones on Linux

This has been an issue since at least 2020. The current cygwin DBD::mysql
is version is 4.052. The one I tested on linux is currently 4.046.


On Sat, Jul 27, 2024 at 2:50 AM ASSI via Cygwin <cygwin AT cygwin DOT com> wrote:

> Danny Rice via Cygwin writes:
> > With a dsn like
> >
> > $dsn =
> >
> "dbi:mysql:mysql_ssl=1;mysql_read_default_file=test.cnf;mysql_read_default_group=test_group";
> > $dbh = DBI->connect($dsn);
> >
> > seemingly fails to read the host from [test_group] in test.cnf. Adding a
> > valid host=host_name to the $dsn succeeds in reading the user, password
> etc
> > from test.cnf and the connection succeeds
> >
> > This has been an issue since at least 2020 and I've had to just specify
> the
> > host in the $dsn on cygwin.
>
> I fail to see how this can be caused by DBD::mysql, so it's more likely
> that the DB itself is the culprit (you might want to check if that's a
> known issue with the versions available in Cygwin, whilch are almost
> certainly older than the ones on Linux).  Anyway, I'll just note that
> the examples of this sort of DSN I've seen reverse the two keys:
>
> $dsn = "dbi:mysql:mysql_ssl=1;"
>      . "mysql_read_default_group=test_group;"
>      . "mysql_read_default_file=test.cnf";
>
> so maybe give that a try.
>
>
> Regards,
> Achim.
> --
> +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+
>
> Wavetables for the Terratec KOMPLEXER:
> http://Synth.Stromeko.net/Downloads.html#KomplexerWaves
>
> --
> Problem reports:      https://cygwin.com/problems.html
> FAQ:                  https://cygwin.com/faq/
> Documentation:        https://cygwin.com/docs.html
> Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple
>

-- 
Problem reports:      https://cygwin.com/problems.html
FAQ:                  https://cygwin.com/faq/
Documentation:        https://cygwin.com/docs.html
Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple