> > 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@cygwin.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
