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: (Danny Rice via Cygwin's message of "Thu, 25 Jul 2024 18:26:14 -0400") References: 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 Precedence: list List-Id: General Cygwin discussions and problem reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , From: ASSI via Cygwin Reply-To: ASSI Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Errors-To: cygwin-bounces~archive-cygwin=delorie DOT com AT cygwin DOT com Sender: "Cygwin" 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