delorie.com/archives/browse.cgi   search  
Mail Archives: cygwin/2024/07/27/02:50:45

DKIM-Filter: OpenDKIM Filter v2.11.0 delorie.com 46R6ojJb708889
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=yWP8OFce
X-Recipient: archive-cygwin AT delorie DOT com
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org E55203858416
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
s=default; t=1722063043;
bh=Cg9Niaa3589Nx3DwCj0ejAOXtqII9y4MX9r6REQEnzQ=;
h=To:Subject:In-Reply-To:References:Date:List-Id:List-Unsubscribe:
List-Archive:List-Post:List-Help:List-Subscribe:From:Reply-To:
From;
b=yWP8OFceA7UgENRzL/pT5H2rf+96dYxgf8Y6KZ083BoOw5SmBdBnYqOwc09U/ohwd
C0k5mXn+FCg66uO6ysplNguejGJJrL/Ig/26zdd2iCCps+Y7Lthy7538pKh/X2IoZH
andW6SPk7mAnlhqYeAZYfy4uo+8XL1B08PN2X83U=
X-Original-To: cygwin AT cygwin DOT com
Delivered-To: cygwin AT cygwin DOT com
DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 411C03858D34
ARC-Filter: OpenARC Filter v1.0.0 sourceware.org 411C03858D34
ARC-Seal: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1722063023; cv=none;
b=wJRJw0HgHJhl92WzexWLBQZxivH6s4EyTqpvvH1XpVdioryS4fwBWe3TidqFmzQko0VcnqJDcwXhliZ9sRV86x3FU1SQHmwoTbsYxhsClOuBE2WHB7rUsdnBVAhy/klLn7T9U/lUea+ccHWCBxwPG8uCuYJoDM9NoZMTBiKWw94=
ARC-Message-Signature: i=1; a=rsa-sha256; d=sourceware.org; s=key;
t=1722063023; c=relaxed/simple;
bh=WvZyH/K2RYbmPhlD66gtJwH+6ZJK8qN8YN9rW5sFGG8=;
h=DKIM-Signature:From:To:Subject:Date:Message-ID:MIME-Version;
b=okqsgPGfF9ULOtjSWSB0FqmQaiclQDs9Lkl+pZhrmMpKph48T5XARvUc1/DboFscU3VAvFtKrXFFoV+jOtvNHZDI4DhzTAqjs8ovhqLOksRbmH5yGr+sOq6m5eXvFRtZ8rtAfvODgTBbJeGCnELARC5x1tLorr7qVvvu+x6UBc0=
ARC-Authentication-Results: i=1; server2.sourceware.org
To: cygwin AT cygwin DOT 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 AT mail DOT gmail DOT 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
X-purgate-type: clean
X-purgate: clean
X-purgate-size: 1211
X-purgate-ID: 155817::1722063016-D57F8A4B-85C8D131/0/0
X-Spam-Status: No, score=0.0 required=5.0 tests=BAYES_00, DKIM_SIGNED,
DKIM_VALID, DKIM_VALID_AU, DKIM_VALID_EF, RCVD_IN_BARRACUDACENTRAL,
RCVD_IN_DNSWL_LOW, RCVD_IN_MSPIKE_H4, RCVD_IN_MSPIKE_WL, SPF_HELO_NONE,
SPF_PASS, TXREP autolearn=no autolearn_force=no version=3.4.6
X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on
server2.sourceware.org
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-Unsubscribe: <https://cygwin.com/mailman/options/cygwin>,
<mailto:cygwin-request AT cygwin DOT com?subject=unsubscribe>
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: ASSI via Cygwin <cygwin AT cygwin DOT com>
Reply-To: ASSI <Stromeko AT nexgo DOT de>
Errors-To: cygwin-bounces~archive-cygwin=delorie DOT com AT cygwin DOT com
Sender: "Cygwin" <cygwin-bounces~archive-cygwin=delorie DOT com AT cygwin DOT 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

- Raw text -


  webmaster     delorie software   privacy  
  Copyright © 2019   by DJ Delorie     Updated Jul 2019