DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 411C03858D34
To: cygwin@cygwin.com
Subject: Re: DBD::mysql not reading host from config file
In-Reply-To: <CAOoeT7PUKVhXKkFU7nqv5rNBg-vu2g9rXp+tQoUgf++d4AsWDA@mail.gmail.com>
 (Danny Rice via Cygwin's message of "Thu, 25 Jul 2024 18:26:14 -0400")
References: <CAOoeT7PUKVhXKkFU7nqv5rNBg-vu2g9rXp+tQoUgf++d4AsWDA@mail.gmail.com>
Date: Sat, 27 Jul 2024 08:50:12 +0200
Message-ID: <8734nvcorf.fsf@Gerda.invalid>
User-Agent: Gnus/5.13 (Gnus v5.13)
MIME-Version: 1.0
Precedence: list
From: ASSI via Cygwin <cygwin@cygwin.com>
Reply-To: ASSI <Stromeko@nexgo.de>
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Errors-To: cygwin-bounces~archive-cygwin=delorie.com@cygwin.com
Sender: "Cygwin" <cygwin-bounces~archive-cygwin=delorie.com@cygwin.com>

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