Bug #100898 for DBD-mysql: compiling fails with mariadb-10.0.14-winx64 on windows 7 (64)

Sat Dec 13 12:23:39 2014 valkoles [...] gmail.com - Ticket created

Subject:	compiling fails with mariadb-10.0.14-winx64 on windows 7 (64)
Date:	Sat, 13 Dec 2014 12:23:24 -0500
To:	bug-dbd-mysql [...] rt.cpan.org
From:	val <valkoles [...] gmail.com>

Message body is not shown because it is too large.

Sun Nov 20 07:47:17 2016 pali [...] cpan.org - Cc PALI added

Sun Nov 20 07:47:26 2016 pali [...] cpan.org - Correspondence added

On Sob Dec 13 12:23:39 2014, valkoles@gmail.com wrote: Show quoted text

> Warning (mostly harmless): No library found for -lmysql

It means that you did not installed mysql library and header files. Without it DBD::mysql cannot be compiled.

Sun Nov 20 07:47:26 2016 The RT System itself - Status changed from 'new' to 'open'

Sun Nov 20 14:27:35 2016 val [...] cpan.org - Correspondence added

But it is installed: C:\Users\val>mysql_config Usage: C:\soft\mariadb\bin\mysql_config.pl [OPTIONS] Options: --cflags ["-IC:\soft\mariadb/include/mysql"] --include ["-IC:\soft\mariadb/include/mysql"] --libs ["C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib"] --libs_r ["C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib" "-lmysqlclient ws2_32 IPHLPAPI "] --socket [/tmp/mysql.sock] --port [0] --version [10.1.19] --libmysqld-libs ["C:\soft\mariadb/lib/mysqlserver.lib" "wsock32.lib" "advapi32.lib" "user32.lib" "-lmysqlclient ws2_32 IPHLPAPI "] this is unpacked mariadb-10.1.19-winx64.zip and I believe it has all required headers and libs though 4.039 is still failing. 'libs' somehow is empty in the attached log libs (mysql_config) =

Subject:

DBD-mysql-4.039-1479588415.log

Download DBD-mysql-4.039-1479588415.log
application/octet-stream 26.1k

Message body not shown because it is not plain text.

Sun Nov 20 15:07:20 2016 pali [...] cpan.org - Correspondence added

On Ned Nov 20 14:27:35 2016, VAL wrote: Show quoted text

> But it is installed: > > C:\Users\val>mysql_config > Usage: C:\soft\mariadb\bin\mysql_config.pl [OPTIONS] > Options: > --cflags ["-IC:\soft\mariadb/include/mysql"] > --include ["-IC:\soft\mariadb/include/mysql"] > --libs ["C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib"] > --libs_r ["C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib" "-lmysqlclient ws2_32 IPHLPAPI "] > --socket [/tmp/mysql.sock] > --port [0] > --version [10.1.19] > --libmysqld-libs ["C:\soft\mariadb/lib/mysqlserver.lib" "wsock32.lib" "advapi32.lib" "user32.lib" "-lmysqlclient ws2_32 IPHLPAPI "] > > this is unpacked mariadb-10.1.19-winx64.zip and I believe it has all > required headers and libs > > though 4.039 is still failing. 'libs' somehow is empty in the > attached log > libs (mysql_config) =

Hmm... In log I see: Show quoted text

> cflags (mysql_config) = "-IC:\soft\mariadb/include/mysql" > > embedded (mysql_config) = > > ldflags (guessed ) = "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib" > > libs (mysql_config) =

It means that either Makefile.PL incorrectly parsed mysql_config output, or mysql_config output is in some wrong format. Please provide output from commands: mysql_config --libs mysql_config --cflags mysql_config --include As a quick looks it looks like that Makefile.PL expect that library param starts with -l or -L. In above case with absolute paths it looks like that libraries are without hyphen l/L. Can you try attached patch?

Subject:

0001-Fix-parsing-configure-libs-from-mysql_config-libs-ou.patch

From 844f827363f89331bba60bc97388dc9e2640d65b Mon Sep 17 00:00:00 2001 From: Pali <pali@cpan.org> Date: Sun, 20 Nov 2016 21:04:27 +0100 Subject: [PATCH] Fix parsing configure libs from mysql_config --libs output in Makefile.PL Libraries in mysql_config --libs output can be specified by library name with -l prefix or by absolute path to library name without any prefix. Parameters must start with a hyphen, so treat all options without leading hyphen in mysql_config --libs output as libraries with full path. --- Makefile.PL | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Makefile.PL b/Makefile.PL index 0e78f00..a2202a3 100644 --- a/Makefile.PL +++ b/Makefile.PL @@ -578,7 +578,7 @@ sub Configure { if ($param eq 'libs') { my (@libs, @ldflags); for (split ' ', $str) { - if (/^-[Ll]/) { push @libs, $_ } + if (/^-[Ll]/ || /^[^\-]/) { push @libs, $_ } else { push @ldflags, $_ } } $str = "@libs"; -- 1.7.9.5

Sun Nov 20 15:23:04 2016 val [...] cpan.org - Correspondence added

I was blaming Makefile.PL too. C:\Users\val>mysql_config --libs "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib" C:\Users\val>mysql_config --cflags "-IC:\soft\mariadb/include/mysql" C:\Users\val>mysql_config --include "-IC:\soft\mariadb/include/mysql" Applied patch. perl Makefile.PL > p_m_stdout 2> p_m_sderr # output in attached files dmake.exe > d_stdout 2> d_stderr # output in attached files before I was trying similar approach with adding -l / -L for the in the line you changed. No luck

Subject:

d_stderr

Download d_stderr
application/octet-stream 87.6k

Message body not shown because it is not plain text.

Subject:

d_stdout

Download d_stdout
application/octet-stream 1.8k

Message body not shown because it is not plain text.

Subject:

p_m_sderr

Download p_m_sderr
application/octet-stream 2.3k

Message body not shown because it is not plain text.

Subject:

p_m_stdout

Download p_m_stdout
application/octet-stream 1.8k

Message body not shown because it is not plain text.

Sun Nov 20 15:46:03 2016 pali [...] cpan.org - Correspondence added

On Ned Nov 20 15:23:04 2016, VAL wrote: Show quoted text

> I was blaming Makefile.PL too. > > C:\Users\val>mysql_config --libs > "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" "user32.lib"

First one is OK, it is file specified with full path without any leading hyphen. gcc and gnu linker can handle it. But I doubt that other 3 files can be located properly with gcc or gnu linker, as it can search for libraries only with -l param (in this case without "lib" prefix and ".lib" or ".a" suffix). Which compiler and linker are you using for compiling DBD::mysql? Show quoted text

> C:\Users\val>mysql_config --cflags > "-IC:\soft\mariadb/include/mysql" > > C:\Users\val>mysql_config --include > "-IC:\soft\mariadb/include/mysql"

Those are OK. Show quoted text

> Applied patch. > perl Makefile.PL > p_m_stdout 2> p_m_sderr > # output in attached files > > dmake.exe > d_stdout 2> d_stderr > # output in attached files > > > before I was trying similar approach with adding -l / -L for the in > the line you changed. No luck

Looks like my patch really fix problem with determinating if output from mysql_config --libs is library (either specified by -l syntax or by full path) or ordinary flag. Now there are problems with undefined references to internal windows symbols which are probably in those not found libraries... If you want to compile DBD::mysql I would suggest you to manually play with "perl Makefile.PL --libs=...". And specify all needed libs (ideally with full path). Maybe you need to link against some other windows libraries... But I do not know, I do not use windows system.

Sun Nov 20 16:58:59 2016 val [...] cpan.org - Correspondence added

On Sun Nov 20 15:46:03 2016, PALI wrote: Show quoted text

> On Ned Nov 20 15:23:04 2016, VAL wrote:

> > I was blaming Makefile.PL too. > > > > C:\Users\val>mysql_config --libs > > "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" > > "user32.lib"

> > First one is OK, it is file specified with full path without any > leading hyphen. gcc and gnu linker can handle it. > > But I doubt that other 3 files can be located properly with gcc or gnu > linker, as it can search for libraries only with -l param (in this > case without "lib" prefix and ".lib" or ".a" suffix).

Found G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a G:\soft\mingw64\x86_64-w64-mingw32\lib\libadvapi32.a G:\soft\mingw64\x86_64-w64-mingw32\lib\libuser32.a Show quoted text

> Which compiler and linker are you using for compiling DBD::mysql?

x86_64-4.9.0-release-win32-seh-rt_v3-rev2.7z Show quoted text

> Looks like my patch really fix problem with determinating if output > from mysql_config --libs is library (either specified by -l syntax or > by full path) or ordinary flag. Now there are problems with undefined > references to internal windows symbols which are probably in those not > found libraries...

Show quoted text

> If you want to compile DBD::mysql I would suggest you to manually play > with "perl Makefile.PL --libs=...". And specify all needed libs > (ideally with full path). Maybe you need to link against some other > windows libraries... But I do not know, I do not use windows system.

What's the syntax for few args for --libs? --libs="c:/full/path/lib1" --libs="c:/another/lib2" or --libs="c:/full/path/lib1 c:/another/lib2" ? is there a way to define few paths to lib dirs and provide to --libs only filenames (without common path)? I'm just surprised that with same perl, build system it's possible to compile DBD::mysql against mysql, but not mariadb. And even mysql_config.pl in mariadb needs small fix to get it working at all (in sub get_full_path). Thanks for your help.

Sun Nov 20 17:13:29 2016 pali [...] cpan.org - Correspondence added

On Ned Nov 20 16:58:59 2016, VAL wrote: Show quoted text

> On Sun Nov 20 15:46:03 2016, PALI wrote:

> > On Ned Nov 20 15:23:04 2016, VAL wrote:

> > > I was blaming Makefile.PL too. > > > > > > C:\Users\val>mysql_config --libs > > > "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" "advapi32.lib" > > > "user32.lib"

> > > > First one is OK, it is file specified with full path without any > > leading hyphen. gcc and gnu linker can handle it. > > > > But I doubt that other 3 files can be located properly with gcc or > > gnu > > linker, as it can search for libraries only with -l param (in this > > case without "lib" prefix and ".lib" or ".a" suffix).

> > Found > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > G:\soft\mingw64\x86_64-w64-mingw32\lib\libadvapi32.a > G:\soft\mingw64\x86_64-w64-mingw32\lib\libuser32.a > >

> > Which compiler and linker are you using for compiling DBD::mysql?

> > x86_64-4.9.0-release-win32-seh-rt_v3-rev2.7z

So you are using gcc from 64bit mingw. In this case make sure that your libmysqlclient is also 64bit! Show quoted text

> > Looks like my patch really fix problem with determinating if output > > from mysql_config --libs is library (either specified by -l syntax or > > by full path) or ordinary flag. Now there are problems with undefined > > references to internal windows symbols which are probably in those > > not > > found libraries...

> > If you want to compile DBD::mysql I would suggest you to manually > > play > > with "perl Makefile.PL --libs=...". And specify all needed libs > > (ideally with full path). Maybe you need to link against some other > > windows libraries... But I do not know, I do not use windows system.

> > What's the syntax for few args for --libs? > --libs="c:/full/path/lib1" --libs="c:/another/lib2" > or > --libs="c:/full/path/lib1 c:/another/lib2" ? > > is there a way to define few paths to lib dirs and provide to --libs > only filenames (without common path)?

IIRC syntax is space separated arguments passed to gcc when linking. When specifying more libs do not forget to properly quote (and espace) params which is needed on windows. If you have a library with full path G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a then you can tell gcc to use it as: -LG:\soft\mingw64\x86_64-w64-mingw32\lib -lwsock32 or G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a (maybe backslash needs to be escaped... \ will probably be \\, but I'm not sure) libsomething.a is specified by -lsomething If you have more libraries in some path, then you just need to specify -Lpath only once. try: --libs="\"C:\\soft\\mariadb/lib/mysqlclient.lib\" -L\"G:\\soft\\mingw64\\x86_64-w64-mingw32\\lib\" "-lwsock32" "-ladvapi32" "-luser32" (and play with escaping with \ and quoting with ") Show quoted text

> I'm just surprised that with same perl, build system it's possible to > compile DBD::mysql against mysql, but not mariadb. And even > mysql_config.pl in mariadb needs small fix to get it working at all > (in sub get_full_path).

If you have exactly same build system, then problem is only in mysql_config application. That one (which comes from either mysql or mariadb) is responsible for telling DBD::mysql where to find libmysqlclient and which flags needs to be passed to compiler and linker. Maybe you should report this problem to mariadb if with mysql you do not have any problem.

Wed Jan 18 09:16:07 2017 pali [...] cpan.org - Correspondence added

On Sun Nov 20 17:13:29 2016, PALI wrote: Show quoted text

> On Ned Nov 20 16:58:59 2016, VAL wrote:

> > On Sun Nov 20 15:46:03 2016, PALI wrote:

> > > On Ned Nov 20 15:23:04 2016, VAL wrote:

> > > > I was blaming Makefile.PL too. > > > > > > > > C:\Users\val>mysql_config --libs > > > > "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" > > > > "advapi32.lib" > > > > "user32.lib"

> > > > > > First one is OK, it is file specified with full path without any > > > leading hyphen. gcc and gnu linker can handle it. > > > > > > But I doubt that other 3 files can be located properly with gcc or > > > gnu > > > linker, as it can search for libraries only with -l param (in this > > > case without "lib" prefix and ".lib" or ".a" suffix).

> > > > Found > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libadvapi32.a > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libuser32.a > > > >

> > > Which compiler and linker are you using for compiling DBD::mysql?

> > > > x86_64-4.9.0-release-win32-seh-rt_v3-rev2.7z

> > So you are using gcc from 64bit mingw. In this case make sure that > your libmysqlclient is also 64bit! >

> > > Looks like my patch really fix problem with determinating if output > > > from mysql_config --libs is library (either specified by -l syntax > > > or > > > by full path) or ordinary flag. Now there are problems with > > > undefined > > > references to internal windows symbols which are probably in those > > > not > > > found libraries...

> >

> > > If you want to compile DBD::mysql I would suggest you to manually > > > play > > > with "perl Makefile.PL --libs=...". And specify all needed libs > > > (ideally with full path). Maybe you need to link against some other > > > windows libraries... But I do not know, I do not use windows > > > system.

> > > > What's the syntax for few args for --libs? > > --libs="c:/full/path/lib1" --libs="c:/another/lib2" > > or > > --libs="c:/full/path/lib1 c:/another/lib2" ? > > > > is there a way to define few paths to lib dirs and provide to --libs > > only filenames (without common path)?

> > IIRC syntax is space separated arguments passed to gcc when linking. > When specifying more libs do not forget to properly quote (and espace) > params which is needed on windows. > > If you have a library with full path G:\soft\mingw64\x86_64-w64- > mingw32\lib\libwsock32.a then you can tell gcc to use it as: > > -LG:\soft\mingw64\x86_64-w64-mingw32\lib -lwsock32 > > or > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > > (maybe backslash needs to be escaped... \ will probably be \\, but I'm > not sure) > > libsomething.a is specified by -lsomething > > If you have more libraries in some path, then you just need to specify > -Lpath only once. > > try: --libs="\"C:\\soft\\mariadb/lib/mysqlclient.lib\" > -L\"G:\\soft\\mingw64\\x86_64-w64-mingw32\\lib\" "-lwsock32" "- > ladvapi32" "-luser32" > > (and play with escaping with \ and quoting with ") >

> > I'm just surprised that with same perl, build system it's possible to > > compile DBD::mysql against mysql, but not mariadb. And even > > mysql_config.pl in mariadb needs small fix to get it working at all > > (in sub get_full_path).

> > If you have exactly same build system, then problem is only in > mysql_config application. That one (which comes from either mysql or > mariadb) is responsible for telling DBD::mysql where to find > libmysqlclient and which flags needs to be passed to compiler and > linker. Maybe you should report this problem to mariadb if with mysql > you do not have any problem.

Hi! Have you resolved this building problem? Or are there any others?

Tue Jan 24 00:56:34 2017 val [...] cpan.org - Correspondence added

On Wed Jan 18 09:16:07 2017, PALI wrote: Show quoted text

> On Sun Nov 20 17:13:29 2016, PALI wrote:

> > On Ned Nov 20 16:58:59 2016, VAL wrote:

> > > On Sun Nov 20 15:46:03 2016, PALI wrote:

> > > > On Ned Nov 20 15:23:04 2016, VAL wrote:

> > > > > I was blaming Makefile.PL too. > > > > > > > > > > C:\Users\val>mysql_config --libs > > > > > "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" > > > > > "advapi32.lib" > > > > > "user32.lib"

> > > > > > > > First one is OK, it is file specified with full path without any > > > > leading hyphen. gcc and gnu linker can handle it. > > > > > > > > But I doubt that other 3 files can be located properly with gcc or > > > > gnu > > > > linker, as it can search for libraries only with -l param (in this > > > > case without "lib" prefix and ".lib" or ".a" suffix).

> > > > > > Found > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libadvapi32.a > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libuser32.a > > > > > >

> > > > Which compiler and linker are you using for compiling DBD::mysql?

> > > > > > x86_64-4.9.0-release-win32-seh-rt_v3-rev2.7z

> > > > So you are using gcc from 64bit mingw. In this case make sure that > > your libmysqlclient is also 64bit! > >

> > > > Looks like my patch really fix problem with determinating if output > > > > from mysql_config --libs is library (either specified by -l syntax > > > > or > > > > by full path) or ordinary flag. Now there are problems with > > > > undefined > > > > references to internal windows symbols which are probably in those > > > > not > > > > found libraries...

> > >

> > > > If you want to compile DBD::mysql I would suggest you to manually > > > > play > > > > with "perl Makefile.PL --libs=...". And specify all needed libs > > > > (ideally with full path). Maybe you need to link against some other > > > > windows libraries... But I do not know, I do not use windows > > > > system.

> > > > > > What's the syntax for few args for --libs? > > > --libs="c:/full/path/lib1" --libs="c:/another/lib2" > > > or > > > --libs="c:/full/path/lib1 c:/another/lib2" ? > > > > > > is there a way to define few paths to lib dirs and provide to --libs > > > only filenames (without common path)?

> > > > IIRC syntax is space separated arguments passed to gcc when linking. > > When specifying more libs do not forget to properly quote (and espace) > > params which is needed on windows. > > > > If you have a library with full path G:\soft\mingw64\x86_64-w64- > > mingw32\lib\libwsock32.a then you can tell gcc to use it as: > > > > -LG:\soft\mingw64\x86_64-w64-mingw32\lib -lwsock32 > > > > or > > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > > > > (maybe backslash needs to be escaped... \ will probably be \\, but I'm > > not sure) > > > > libsomething.a is specified by -lsomething > > > > If you have more libraries in some path, then you just need to specify > > -Lpath only once. > > > > try: --libs="\"C:\\soft\\mariadb/lib/mysqlclient.lib\" > > -L\"G:\\soft\\mingw64\\x86_64-w64-mingw32\\lib\" "-lwsock32" "- > > ladvapi32" "-luser32" > > > > (and play with escaping with \ and quoting with ") > >

> > > I'm just surprised that with same perl, build system it's possible to > > > compile DBD::mysql against mysql, but not mariadb. And even > > > mysql_config.pl in mariadb needs small fix to get it working at all > > > (in sub get_full_path).

> > > > If you have exactly same build system, then problem is only in > > mysql_config application. That one (which comes from either mysql or > > mariadb) is responsible for telling DBD::mysql where to find > > libmysqlclient and which flags needs to be passed to compiler and > > linker. Maybe you should report this problem to mariadb if with mysql > > you do not have any problem.

> > Hi! Have you resolved this building problem? > > Or are there any others?

No, I have not. :-( I'd appreciate if Strawberry perl folks could share their way of getting this module working with MariaDB.

Thu Jan 26 09:26:12 2017 pali [...] cpan.org - Correspondence added

On Tue Jan 24 00:56:34 2017, VAL wrote: Show quoted text

> On Wed Jan 18 09:16:07 2017, PALI wrote:

> > On Sun Nov 20 17:13:29 2016, PALI wrote:

> > > On Ned Nov 20 16:58:59 2016, VAL wrote:

> > > > On Sun Nov 20 15:46:03 2016, PALI wrote:

> > > > > On Ned Nov 20 15:23:04 2016, VAL wrote:

> > > > > > I was blaming Makefile.PL too. > > > > > > > > > > > > C:\Users\val>mysql_config --libs > > > > > > "C:\soft\mariadb/lib/mysqlclient.lib" "wsock32.lib" > > > > > > "advapi32.lib" > > > > > > "user32.lib"

> > > > > > > > > > First one is OK, it is file specified with full path without > > > > > any > > > > > leading hyphen. gcc and gnu linker can handle it. > > > > > > > > > > But I doubt that other 3 files can be located properly with gcc > > > > > or > > > > > gnu > > > > > linker, as it can search for libraries only with -l param (in > > > > > this > > > > > case without "lib" prefix and ".lib" or ".a" suffix).

> > > > > > > > Found > > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libadvapi32.a > > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libuser32.a > > > > > > > >

> > > > > Which compiler and linker are you using for compiling > > > > > DBD::mysql?

> > > > > > > > x86_64-4.9.0-release-win32-seh-rt_v3-rev2.7z

> > > > > > So you are using gcc from 64bit mingw. In this case make sure that > > > your libmysqlclient is also 64bit! > > >

> > > > > Looks like my patch really fix problem with determinating if > > > > > output > > > > > from mysql_config --libs is library (either specified by -l > > > > > syntax > > > > > or > > > > > by full path) or ordinary flag. Now there are problems with > > > > > undefined > > > > > references to internal windows symbols which are probably in > > > > > those > > > > > not > > > > > found libraries...

> > > >

> > > > > If you want to compile DBD::mysql I would suggest you to > > > > > manually > > > > > play > > > > > with "perl Makefile.PL --libs=...". And specify all needed libs > > > > > (ideally with full path). Maybe you need to link against some > > > > > other > > > > > windows libraries... But I do not know, I do not use windows > > > > > system.

> > > > > > > > What's the syntax for few args for --libs? > > > > --libs="c:/full/path/lib1" --libs="c:/another/lib2" > > > > or > > > > --libs="c:/full/path/lib1 c:/another/lib2" ? > > > > > > > > is there a way to define few paths to lib dirs and provide to > > > > --libs > > > > only filenames (without common path)?

> > > > > > IIRC syntax is space separated arguments passed to gcc when > > > linking. > > > When specifying more libs do not forget to properly quote (and > > > espace) > > > params which is needed on windows. > > > > > > If you have a library with full path G:\soft\mingw64\x86_64-w64- > > > mingw32\lib\libwsock32.a then you can tell gcc to use it as: > > > > > > -LG:\soft\mingw64\x86_64-w64-mingw32\lib -lwsock32 > > > > > > or > > > > > > G:\soft\mingw64\x86_64-w64-mingw32\lib\libwsock32.a > > > > > > (maybe backslash needs to be escaped... \ will probably be \\, but > > > I'm > > > not sure) > > > > > > libsomething.a is specified by -lsomething > > > > > > If you have more libraries in some path, then you just need to > > > specify > > > -Lpath only once. > > > > > > try: --libs="\"C:\\soft\\mariadb/lib/mysqlclient.lib\" > > > -L\"G:\\soft\\mingw64\\x86_64-w64-mingw32\\lib\" "-lwsock32" "- > > > ladvapi32" "-luser32" > > > > > > (and play with escaping with \ and quoting with ") > > >

> > > > I'm just surprised that with same perl, build system it's > > > > possible to > > > > compile DBD::mysql against mysql, but not mariadb. And even > > > > mysql_config.pl in mariadb needs small fix to get it working at > > > > all > > > > (in sub get_full_path).

> > > > > > If you have exactly same build system, then problem is only in > > > mysql_config application. That one (which comes from either mysql > > > or > > > mariadb) is responsible for telling DBD::mysql where to find > > > libmysqlclient and which flags needs to be passed to compiler and > > > linker. Maybe you should report this problem to mariadb if with > > > mysql > > > you do not have any problem.

> > > > Hi! Have you resolved this building problem? > > > > Or are there any others?

> > No, I have not. :-( I'd appreciate if Strawberry perl folks could > share their way of getting this module working with MariaDB.

Currently MariaDB 10.2.2 and newer have bug in mysql_config which cause that DBD::mysql cannot be compiled with those MariaDB versions. Michiel already reported this bug in MariaDB bug tracker: https://jira.mariadb.org/browse/MDEV-11872 But MariaDB 10.2.1 and older seems to work fine with DBD::mysql from git on Linux. This pull request https://github.com/perl5-dbi/DBD-mysql/pull/85 adds support for automatically check if DBD::mysql unit tests pass on different MySQL & MariaDB versions on Linux You can see result (everything pass) and tested versions: https://travis-ci.org/perl5-dbi/DBD-mysql/builds/194603464 Those tests are running on Travis and therefore only Linux versions are tested. I would suggest you to report this bug either directly Strawberry perl bug tracker or to MariaDB bug tracker. As Linux versions are working fine, problem is somewhere in Windows code (perl/mariadb/scripts/setup) and therefore cannot help you more.

Wed Nov 15 02:53:07 2017 MICHIELB [...] cpan.org - Correspondence added

Ticket migrated to github as https://github.com/perl5-dbi/DBD-mysql/issues/199

Wed Nov 15 02:53:09 2017 MICHIELB [...] cpan.org - Status changed from 'open' to 'resolved'