DBD::mysql and Windows
[email protected] (Daniël van Eeden) Fri, 04 Apr 2025 10:09:49 +0200
| Newsgroups | perl.dbi.dev |
|---|---|
| Message-ID | <[email protected]> |
--=_c8eac02b32cabef84e08e9ed955b1b9e Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8; format=flowed Hi All, In the last few years I've been trying a few times to get the latest versions of DBD::mysql fully working on Microsoft Windows, however it now looks like Ive hit a dead end. DBD::mysql requires MySQL 8.0 (released in 2018) or newer. Strawberry Perl was shipping with a libmysqlclient from MySQL 5.7 (which is now EOL). Newer versions don't seem to include a libmysqlclient at all. When combining a recent version of Strawberry Perl with a MySQL downloaded from mysql.com things work until you try to use SSL/TLS as both MySQL and Perl include OpenSSL, but with different versions. I think DBD::mysql would work fine on Windows if both Perl and MySQL are compiled with the same compiler and OpenSSL version. But compiling from source isn't common on Windows and it looks like MySQL on Windows might not support compiling with GCC. While I haven't tested this, I think WSL (Windows Subsystem for Linux) might be an alternative for running MySQL and Perl on a Windows machine. But as I don't use Windows myself I don't know if this is an acceptable workaround. More info on this: - https://github.com/perl5-dbi/DBD-mysql/pull/384#issuecomment-2548585132 For anyone with the right permissions on github.com/perl5-dbi, I think it would be good to disable/remove appveyor for DBD-mysql as that now always results in failing checks for PRs and there isn't any short (or medium) term fix for this. I anyone has a good suggestion about how to move forward, please let me know. Daniël --=_c8eac02b32cabef84e08e9ed955b1b9e Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=UTF-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset= =3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Tahoma,Aria= l,Helvetica,sans-serif'> <p>Hi All,</p> <p><br /></p> <p>In the last few years I've been trying a few times to get the latest ver= sions of DBD::mysql fully working on Microsoft Windows, however it now look= s like Ive hit a dead end.</p> <p><br /></p> <p>DBD::mysql requires MySQL 8.0 (released in 2018) or newer. Strawberry Pe= rl was shipping with a libmysqlclient from MySQL 5.7 (which is now EOL). Ne= wer versions don't seem to include a libmysqlclient at all. When combining = a recent version of Strawberry Perl with a MySQL downloaded from mysql.com = things work until you try to use SSL/TLS as both MySQL and Perl include Ope= nSSL, but with different versions.</p> <p><br /></p> <p>I think DBD::mysql would work fine on Windows if both Perl and MySQL are= compiled with the same compiler and OpenSSL version. But compiling from so= urce isn't common on Windows and it looks like MySQL on Windows might not s= upport compiling with GCC.</p> <p><br /></p> <p>While I haven't tested this, I think WSL (Windows Subsystem for Linux) m= ight be an alternative for running MySQL and Perl on a Windows machine. But= as I don't use Windows myself I don't know if this is an acceptable workar= ound.</p> <p><br /></p> <p>More info on this:</p> <p>- <a href=3D"https://github.com/perl5-dbi/DBD-mysql/pull/384#issuecommen= t-2548585132">https://github.com/perl5-dbi/DBD-mysql/pull/384#issuecomment-= 2548585132</a></p> <p><br /></p> <p>For anyone with the right permissions on github.com/perl5-dbi, I think i= t would be good to disable/remove appveyor for DBD-mysql as that now always= results in failing checks for PRs and there isn't any short (or medium) te= rm fix for this.</p> <p><br /></p> <p>I anyone has a good suggestion about how to move forward, please let me = know.</p> <p><br /></p> <p>Daniël</p> </body></html> --=_c8eac02b32cabef84e08e9ed955b1b9e--