Re: DBD::mysql and Windows

Hi Dani=C3=ABl!

> 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) ter=
m fix for this.

I was not aware that you were only 'collaborator' on the repo and not
'admin'. I just made you admin and removed the web hooks as well.

It's a pity that MySQL on Windows is this difficult again.
Thanks for your efforts keeping DBD::mysql going!

--
Michiel

On Fri, Apr 4, 2025 at 10:10=E2=80=AFAM Dani=C3=ABl van Eeden
<[email protected]> wrote:
>
> Hi All,
>
>
> In the last few years I've been trying a few times to get the latest vers=
ions 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 Per=
l was shipping with a libmysqlclient from MySQL 5.7 (which is now EOL). New=
er 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 t=
hings work until you try to use SSL/TLS as both MySQL and Perl include Open=
SSL, 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 sou=
rce isn't common on Windows and it looks like MySQL on Windows might not su=
pport compiling with GCC.
>
>
> While I haven't tested this, I think WSL (Windows Subsystem for Linux) mi=
ght 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 workaro=
und.
>
>
> 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) ter=
m fix for this.
>
>
> I anyone has a good suggestion about how to move forward, please let me k=
now.
>
>
> Dani=C3=ABl