On Friday 03 August 2018 21:53:15 sushrut pajai wrote: > Hi Dev, > > I am trying to install DBD::MySQL driver on windows 10 64-bit machine. But > unable install due to following error. > > dmake > "C:\Perl64\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- mysql.bs > blib\arch\auto\DBD\mysql\mysql.bs 644 > C:\Perl64\site\bin\gcc.exe -c -IC:\Perl64\lib\auto\DBI -IC:\conn\include > -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g > -s -O2 -DWIN32 -DWIN64 -DCONSERVATIVE -DPERL_TEXTMODE_SCRIPTS > -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fwrapv > -fno-strict-aliasing -mms-bitfields -s -O2 -DVERSION=\"4.046\" > -DXS_VERSION=\"4.046\" "-IC:\Perl64\lib\CORE" dbdimp.c > In file included from C:\conn\include/mysql.h:48:0, > from dbdimp.h:21, > from dbdimp.c:20: > c:\perl64\site\lib\auto\mingw\bin\../lib/gcc/x86_64-w64-mingw32/4.6.3/../../../../x86_64-w64-mingw32/include/winsock2.h:15:2: > warning: #warning Please include winsock2.h before windows.h [-Wcpp] > In file included from C:\conn\include/mysql.h:48:0, > from dbdimp.h:21, > from dbdimp.c:20: > c:\perl64\site\lib\auto\mingw\bin\../lib/gcc/x86_64-w64-mingw32/4.6.3/../../../../x86_64-w64-mingw32/include/winsock2.h:59:19: > error: conflicting types for '__WSAFDIsSet' > c:\perl64\site\lib\auto\mingw\bin\../lib/gcc/x86_64-w64-mingw32/4.6.3/../../../../x86_64-w64-mingw32/include/winsock.h:40:19: > note: previous declaration of '__WSAFDIsSet' was here > dmake.exe: Error code 129, while making 'dbdimp.o' > > > Command Ran:- perl Makefile.PL --libs=-L"C:\conn\lib" > > > Not sure why but the Generated Makefile.pl was unable to get following path. > Also was unable to detect mysql_config.pl although I have set env variables. > Hence manually set the path in script and let it proceed but it again got > failed for detecting .h files and .lib files hence set manually. > Autogenerated makefile was unable open Windows path due to space in it. Hence > as a remedy I renamed the folder to conn and moved to root. > Got above error. > > > d----- 8/4/2018 2:46 AM conn > d----- 8/3/2018 11:15 PM Connector ODBC 8.0 > d----- 8/3/2018 11:15 PM MySQL Connector C 6.1 > d----- 8/3/2018 11:15 PM MySQL Server 5.7 > d----- 7/29/2018 12:47 PM MySQL Server 8.0 > d----- 8/3/2018 11:17 PM MySQL Shell 8.0 > d----- 8/3/2018 11:16 PM MySQL Utilities 1.6 > d----- 8/3/2018 11:21 PM MySQL Workbench 8.0 CE > > Can some help me with how Can I get it working. > I have attached the auto generated Makefile as well.
Hi! Can you try to build DBD::MariaDB driver? https://metacpan.org/pod/DBD::MariaDB It is a fork of DBD::mysql, compatible with both MySQL and MariaDB servers/clients. I tried to fix in DBD::MariaDB problems with specifying paths and detection of include files and libraries. So maybe this can help you.